今日安装数据库rac ,在节点1 使用sqlplus / as sysdba 登陆数据库 提示 ora-12537 错误
[oracle@eimgdb1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Tue Jun 20 05:25:09 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-12547: TNS:lost contact
Enter user-name: e
Enter password:
ERROR:
ORA-12547: TNS:lost contact
Enter user-name:
ERROR:
ORA-12547: TNS:lost contact
使用各种招 chmod 6751 $ORACLE_HOME/bin/oracle 还是不行,
检查发现少了一个文件 $ORACLE_HOME/bin/oracleO 的文件,
[oracle@eimgdb1 trace]$ du -sh /u02/app/oracle/product/11.2.0/dbhome_1/bin/oracle*
0 /u02/app/oracle/product/11.2.0/dbhome_1/bin/oracle
0 /u02/app/oracle/product/11.2.0/dbhome_1/bin/oracleO
从节点2 拷贝过来还是不行
后来检查权限 发现 oracle 文件变size 变 0 了,节点2 是正常的
[oracle@eimgdb2 ~]$ du -sh /u02/app/oracle/product/11.2.0/dbhome_1/bin/oracle*
218M /u02/app/oracle/product/11.2.0/dbhome_1/bin/oracle
0 /u02/app/oracle/product/11.2.0/dbhome_1/bin/oracleO
从节点2 拷贝一个 oracle 文件到节点1 后测试正常
scp /u02/app/oracle/product/11.2.0/dbhome_1/bin/oracle eimgdb1:/u02/app/oracle/product/11.2.0/dbhome_1/bin/oracle
oracle 100% 218MB 108.9MB/s 00:02
sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Tue Jun 20 05:33:40 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> exit
Disconnected
今日建库又遇到的ora-12547 错误 以此记一下,错误日志:
[main] [ 2017-06-21 09:51:31.671 EDT ] [SQLEngine.initialize:366] Starting Reader Thread...
[main] [ 2017-06-21 09:51:41.735 EDT ] [SQLEngine.done:2189] Done called
[main] [ 2017-06-21 09:51:41.735 EDT ] [ASMUtils.validateASMConnection:265] can not connect ORA-09925: Unable to create audit trail file
[main] [ 2017-06-21 09:51:41.736 EDT ] [SQLEngine.done:2189] Done called
[main] [ 2017-06-21 09:51:41.736 EDT ] [Host.cleanup:3682] Dbca exit status is: 0
[main] [ 2017-06-21 09:51:41.737 EDT ] [Host.cleanup:3685] check point context null
[main] [ 2017-06-21 09:51:41.740 EDT ] [InventoryUtil.getOUIInvSession:347] setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS
[main] [ 2017-06-21 09:51:41.740 EDT ] [InventoryUtil.getHomeName:111] homeName = OraDb11g_home1
[main] [ 2017-06-21 09:51:41.740 EDT ] [OsUtilsBase.copyFile:1565] OsUtilsBase.copyFile:
[main] [ 2017-06-21 09:51:41.741 EDT ] [OsUtilsBase.copyFile:1613] **write of file at destination complete...
[main] [ 2017-06-21 09:51:41.741 EDT ] [OsUtilsBase.copyFile:1648] **file copy status:= true
[main] [ 2017-06-21 09:51:41.742 EDT ] [OsUtilsBase.deleteFile:1863] OsUtilsBase.deleteFile: /u02/app/oracle/cfgtoollogs/dbca/silent.log_2017-06-21_09-50-43-AM
[Thread-5] [ 2017-06-21 09:51:41.743 EDT ] [DbcaCleanupHook.run:44] Cleanup started
[Thread-5] [ 2017-06-21 09:51:41.743 EDT ] [OracleHome.cleanupDBOptionsIntance:1482] DB Options dummy instance sid=n
[main] [ 2017-06-21 20:53:41.940 EDT ] [OracleHome.getVersion:960] Current Version From Inventory: 11.2.0.4.0
[main] [ 2017-06-21 20:53:41.940 EDT ] [SQLPlusEngine.getCmmdParams:222] m_home 11.2.0.4.0
[main] [ 2017-06-21 20:53:41.940 EDT ] [SQLPlusEngine.getCmmdParams:223] version > 112 true
[main] [ 2017-06-21 20:53:41.941 EDT ] [SQLEngine.getEnvParams:565] NLS_LANG: AMERICAN_AMERICA.AL32UTF8
[main] [ 2017-06-21 20:53:41.941 EDT ] [SQLEngine.initialize:325] Execing SQLPLUS/SVRMGR process...
[main] [ 2017-06-21 20:53:41.947 EDT ] [SQLEngine.initialize:362] m_bReaderStarted: false
[main] [ 2017-06-21 20:53:41.948 EDT ] [SQLEngine.initialize:366] Starting Reader Thread...
[main] [ 2017-06-21 20:53:42.211 EDT ] [SQLEngine.done:2189] Done called
[main] [ 2017-06-21 20:53:42.212 EDT ] [ASMUtils.validateASMConnection:265] can not connect ORA-12547: TNS:lost contact
[main] [ 2017-06-21 20:53:42.213 EDT ] [SQLEngine.done:2189] Done called
[main] [ 2017-06-21 20:53:42.213 EDT ] [Host.cleanup:3682] Dbca exit status is: 0
[main] [ 2017-06-21 20:53:42.214 EDT ] [Host.cleanup:3685] check point context null
[main] [ 2017-06-21 20:53:42.217 EDT ] [InventoryUtil.getOUIInvSession:347] setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS
[main] [ 2017-06-21 20:53:42.217 EDT ] [InventoryUtil.getHomeName:111] homeName = OraDb11g_home1
[main] [ 2017-06-21 20:53:42.218 EDT ] [OsUtilsBase.copyFile:1565] OsUtilsBase.copyFile:
[main] [ 2017-06-21 20:53:42.218 EDT ] [OsUtilsBase.copyFile:1613] **write of file at destination complete...
[main] [ 2017-06-21 20:53:42.219 EDT ] [OsUtilsBase.copyFile:1648] **file copy status:= true
[main] [ 2017-06-21 20:53:42.219 EDT ] [OsUtilsBase.deleteFile:1863] OsUtilsBase.deleteFile: /u02/app/oracle/cfgtoollogs/dbca/silent.log_2017-06-21_08-52-58-PM
[Thread-5] [ 2017-06-21 20:53:42.220 EDT ] [DbcaCleanupHook.run:44] Cleanup started
[Thread-5] [ 2017-06-21 20:53:42.220 EDT ] [OracleHome.cleanupDBOptionsIntance:1482] DB Options dummy instance sid=null
[Thread-5] [ 2017-06-21 20:53:42.221 EDT ] [DbcaCleanupHook.run:49] Cleanup ended
检查 $ORACLE_HOME/bin/oracle 权限都是正常的,都是6751,看到有文章说属主权限应该是 oracle.oinstall ,修改了属主,问题还是一样
下面是正常running dbca 后,权限详细,属主变为 asmadmin了,应该是正常的。
-rwsr-s--x 1 oracle asmadmin 228607254 6月 21 20:45 /u02/app/oracle/product/11.2.0/dbhome_1/bin/oracle
-rwsr-s--x 1 oracle asmadmin 228607254 6月 21 07:58 /u02/app/oracle/product/11.2.0/dbhome_1/bin/oracleO_bak
这里oracleO 文件是干啥的,是不是被备份的 ?
老外修改了 oracle home,grid home 的挂载模式 导致dbca 报12547 错误
修改了为default 之后就正常了
#/dev/gridvol/u01 /u01 ext4 user,auto,rw,exec 0 2
#/dev/gridvol/u02 /u02 ext4 user,auto,rw,exec 0 2
/dev/gridvol/u01 /u01 ext4 defaults 0 2
/dev/gridvol/u02 /u02 ext4 defaults 0 2