centos 7 : oracle listener config & log Hint with /etc/hosts

# vi /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora ———————– LISTENER =   (DESCRIPTION_LIST =     (DESCRIPTION =       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))       (ADDRESS = (PROTOCOL = TCP)(HOST = owl)(PORT = 1521))     )   )   ADR_BASE_LISTENER = /home/oracle/app/oracle ———————–   # vi /etc/hosts ———————– 127.0.0.1    owl ———————–   […]

Read More

oracle : move & relocate dbf datafile Hint

Manual Online SQL> SELECT name FROM v$datafile WHERE name LIKE ‘%test%’; SQL> ALTER TABLESPACE test OFFLINE NORMAL; SQL> HOST mv /oracle0/test0.dbf /oracle1/test1.dbf SQL> ALTER TABLESPACE test RENAME DATAFILE ‘/oracle0/test0.dbf’ TO ‘/oracle1/test1.dbf’; SQL> ALTER TABLESPACE test ONLINE; SQL> SELECT name FROM v$datafile; SQL> SHUTDOWN IMMEDIATE   Manual Offline SQL> HOST MOVE /oracle0/test0.dbf /oracle1/test1.dbf  SQL> STARTUP MOUNT […]

Read More

oracle : the password has expried to unlimited Hint

Conn as sysdba $ sqlplus /nolog SQL> conn /as sysdba Change password first! SQL> ALTER USER [USERID] IDENTIFIED by [PASSWORD]; Check password life time SQL> select * from dba_profiles where profile=’DEFAULT’ and resource_name=’PASSWORD_LIFE_TIME’; PROFILE        RESOURCE_NAME RESOURCE —————————— ——————————– ——– LIMIT —————————————- DEFAULT        PASSWORD_LIFE_TIME PASSWORD 180 Set password life time to […]

Read More