当操作系统升级后、操作系统打完补丁后、安装完Oracle补丁之后和relink过程中出现问题时,都会用到relink方法来保证Oracle软件的正常使用。
如果遇到个别或大量可执行程序无法正常使用时也可以考虑使用relink重新初始化Oracle软件。
SQL*Plus: Release 11.2.0.3.0 Production on Tue Nov 10 09:22:08 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ERROR:
ORA-12547: TNS:lost contact
检查了很久监听正常,但是就是无法找到连接数据库的原因
[oracle@localhost admin]$ relink all
writing relink log to: /u01/app/oracle/product/11.2.0/db_1/install/relink.log
[oracle@localhost admin]$ ll $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 oracle oinstall 232399123 Nov 10 09:26 /u01/app/oracle/product/11.2.0/db_1/bin/oracle
[oracle@localhost admin]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue Nov 10 09:26:14 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.