问题描述：
ommbb无法连接oracle，不停的重启。手动连接oracle，发现可以在本地连接：
oracle@OMM1:~> export ORACLE_SID=ommbb
oracle@OMM1:~> sqlplus system/oracle
SQL*Plus: Release 11.2.0.1.0 Production on Fri Apr 18 15:26:15 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
SQL>
但远程连接失败：
OMM2:~ # sqlplus system/oracle@ommbb
SQL*Plus: Release 11.2.0.1.0 Production on Fri Apr 18 14:01:44 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0
执行tnsping ommbb可以成功，说明tnsname配置没有问题。
执行lsnrctl status LISTENER_OMMBB，可以看到监听已经启动。
Enter user-name:
ERROR:
ORA-12162: TNS:net service name is incorrectly specified
Enter user-name:
ERROR:
ORA-12162: TNS:net service name is incorrectly specified
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
OMM2:~ #
阅读(1239) | 评论(0) | 转发(0) |
