如题错误,我装的oracle11g,操作系统是XP,以前没遇到过这个问题,最近出现两次了,第一次修改的是listener.ora里面加了这个
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = LBDMS)
(ORACLE_HOME = C:\db\oracle\product\11.1.0\db_1)
(SID_NAME = LBDMS)
)
)
就好了,但是不晓得是不是我IP常常换的原因,好了没两天就不行,然后再改错误频出,这个好了又出新错误了,只能重新安装,但是才装没两天,又出现如题错误,这次想用老办法修改,但是不行了,网上看了好多资料,都不行,对了,我机器上oracle的监听程序和实例服务都是手动启,不晓得是不是这个导致的,拜托了,我qq443017457,请高人留下qq号或者群号,在线请教
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = LBDMS)
(ORACLE_HOME = C:\db\oracle\product\11.1.0\db_1)
(SID_NAME = LBDMS)
)
)
就好了,但是不晓得是不是我IP常常换的原因,好了没两天就不行,然后再改错误频出,这个好了又出新错误了,只能重新安装,但是才装没两天,又出现如题错误,这次想用老办法修改,但是不行了,网上看了好多资料,都不行,对了,我机器上oracle的监听程序和实例服务都是手动启,不晓得是不是这个导致的,拜托了,我qq443017457,请高人留下qq号或者群号,在线请教
Fatal NI connect error 12514, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=jc-liubing.jc2.jcascorp.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=lbdms)(SERVER=DEDICATED)(CID=(PROGRAM=C:\db\oracle\product\11.1.0\db_1\jdk\jre\bin\java.exe)(HOST=jc-liubing)(USER=liubing)))) VERSION INFORMATION:
TNS for 32-bit Windows: Version 11.1.0.7.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 11.1.0.7.0 - Production
Time: 01-11月-2011 21:31:12
Tracing not turned on.
Tns error struct:
ns main err code: 12564
TNS-12564: TNS: 拒绝连接
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist没玩没了啊
sql>alte database open;