oracle本地登陆成功,远程登陆失败的解决办法

1250阅读 0评论2014-11-20 taohorse
分类:Oracle

问题描述:
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:~ #
上一篇:更改终端 提示符颜色和终端默认大小(xfce4)
下一篇:Linux run level