ora-12537 遇到的问题解决

今日安装数据库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