我在同台机器上装了oracle 9.0.1.1.1版本的两个实例whcj/testszdb,全部从服务里面启动,停掉testszdb,再次启动,显示已启动。
从命令行连接到testszdb:
C:/Documents and Settings/Administrator>set ORACLE_SID=TESTSZDB
C:/Documents and Settings/Administrator>sqlplus whcj_11/abc
SQL*Plus: Release 9.0.1.0.1 - Production on 星期一 5月 16 13:51:01 2011
(c) Copyright 2001 Oracle Corporation. All rights reserved.
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
刚开始看到这个错误还以为是内存设置的有问题,查看系统内存够用,网上查阅发现与内存无关。
查看sqlnet.log日志
D:/oracle/ora90/database/sqlnet.log
***********************************************************************
Fatal NI connect error 12560, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracletestszdb)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=