По дефолту при вводе простого пароля MySQL ругается следующей ошибкой:
ERROR 1819 (HY000) at line 10: Your password does not satisfy the current policy requirements

Отключаем эту фигню так:
# cat /etc/my.cnf.d/passw_policy.cnf
## SHOW VARIABLES LIKE 'validate_password%';

[mysqld]

## password validation
#validate_password.check_user_name=ON
validate_password.length=0
validate_password.mixed_case_count=0
validate_password.number_count=0
validate_password.policy=0
validate_password.special_char_count=0

# disable password lifetime
default_password_lifetime=0

There are two ways to create a new database on existing oracle db server. One is using 'CREATE DATABASE' sql statement[this is too long,hard for me]. Another is using DBCA(Database Confguration Assistance), GUI Base Program. This way is more easy and I choose this way:). One note here is DBCA need X to run and I want to remote login to db server and run dbca from ssh, so ssh need '-X' for X11 forward[assume that DISPLAY variable on server is set, if not try 'export DISPLAY=localhost:0.0' on the server].

[san@acer ~]$ ssh -X -l oracle 10.42.80.39
Warning: No xauth data; using fake authentication data for X11 forwarding.
Last login: Tue Jun 2 13:28:48 2015 from 10.0.2.2
/usr/bin/xauth: creating new authority file /home/oracle/.Xauthority

[oracle@crmdev ]$ cd $ORACLE_HOME/bin

[oracle@crmdev bin]$ ./dbca

Приконнектиться как sysdba:
sqlplus "sys/PASSWORD@SID as sysdba"

Показать список заблокированных пользователей:
select username,account_status from dba_users where account_status like '%LOCK%';

Посмотреть парольные политики:
SELECT resource_name, limit
FROM dba_profiles 
WHERE profile = 'DEFAULT'
AND resource_type = 'PASSWORD';
Изменить парольную политику:
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
Отключить лимит на количество попыток ввода неправильного пароля:
ALTER PROFILE DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED;

Разблокировать пользователя:
alter user SA account unlock;

Изменить пароль для пользователя:
alter user SA identified by SA;

Посмотреть лог удачных/неудачных попыток входа:
select
os_username,
username,
terminal,
to_char(timestamp,'MM-DD-YYYY HH24:MI:SS')
from
dba_audit_trail;

Посмотреть invalid-объекты:
select * from all_objects where status='INVALID';

Перекомпилировать invalid-объекты:
exec dbms_utility.compile_schema(schema => 'ИМЯ', compile_all => false, reuse_settings => true);

Посмотреть параметры NLS, например кодировку:
select * from nls_database_parameters;

The user you are logged in as doesn't have the right privileges, so check what it does have access to:

 

-- list system privileges for the user or role

SELECT * FROM dba_sys_privs

WHERE grantee IN (&user_role, 'PUBLIC');

 

-- list object privileges for the user or role

SELECT grantee, owner||'.'||table_name object, privilege, grantable

FROM dba_tab_privs

WHERE grantee IN (&user_role)

ORDER BY grantee, owner||'.'||table_name, privilege;

SELECT file_name, CEIL (blocks * t.block_size / 1024 / 1024) current_mb,
CEIL ((NVL (hwm, 1) * t.block_size) / 1024 / 1024) smallest_mb
FROM dba_data_files a,
dba_tablespaces t,
(SELECT file_id, MAX (block_id + blocks - 1) hwm
FROM dba_extents
GROUP BY file_id) b
WHERE t.tablespace_name = a.tablespace_name
AND a.file_id = b.file_id(+);

ALTER DATABASE DATAFILE '/app/oracle/db/product/11.2.0/dbhome_1/dbs/poolData01.dbf' RESIZE 3000M;