C:\Documents and Settings\test>sqlplusjustin/justin@justin
SQL*Plus: Release 10.2.0.1.0 - Production on 星期五 10月 21 10:10:24 2011
Copyright (c) 1982, 2005, 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
C:\Documents and Settings\test>tnsping testdb2
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 21-10月-2011 10:05:26
Copyright (c) 1997, 2005, Oracle. All rights reserved.
已使用的参数文件:
c:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = *.*.*.*)(PORT = 1521)))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = justin)))
OK (40 毫秒)
经过一番仔细查看，发现listener.ora配置有误
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = /home/oracle/product/11.2.0/db1)
(SID_NAME = justin)
)
)
目前系统使用11203版本，但是ORACLE_HOME却还是指向原来的11202修改一下ORACLE_HOME即可
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = /home/oracle/product/11.2.0/db1)
(SID_NAME = justin)
)
)
当前位置：
论坛首页 »
自由讨论区 »
MySQL, Oracle及数据库讨论区
»
发起投票
技术讨论
加好友
发消息
2011-10-27 13:56:47 |
赞(
操作
