ORA-12547: TNS:lost contact故障一例
惜分飞发表于 2022-11-16 04:22:56
联系：手机/微信(+86 17813235971) QQ(107644445)
标题：ORA-12547: TNS:lost contact故障一例
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
一个朋友安装好aix平台11.2.0.4 rac，dbca创建库报ORA-12547错误.
尝试sqlplus 登录数据库
$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Thu Nov 17 11:45:33 2022 Copyright (c) 1982, 2013, Oracle. All rights reserved. ERROR: ORA-12547: TNS:lost contact Enter user-name: ERROR: ORA-12547: TNS:lost contact Enter user-name: ERROR: ORA-12547: TNS:lost contact SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
使用truss跟踪sqlplus 执行过程,卡在kfork上面
检查oracle二进制文件权限,正常
$ ls -l $ORACLE_HOME/bin/oracle -rwsr-s--x 1 oracle oinstall 309671362 Nov 17 03:13 /u01/app/oracle/product/11.2.0/db/bin/oracle
经过分析确认是oracle home权限异常
$ ls -ld $ORACLE_HOME drwxrwxr-x 74 grid oinstall 4096 Nov 17 02:59 /u01/app/oracle/product/11.2.0/db $ exit # chown oracle:oinstall /u01/app/oracle/product/11.2.0/db
sqlplus和dbca都正常
$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Thu Nov 17 11:46:32 2022 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to an idle instance. SQL> exit Disconnected