摘要: oracle 本来可以用,新建了个库后,新库不能用,我把它删了,原来的库ORCL用sqlplus ,plsql 以及用oralce 的net manager 测试都登录报错误,
ORA-27101 Shared memory realm does not exist
ORA-01034 ORACLE not available
怎样解决呀?
set ORACLE_SID=orcl 实例也从新设置了。服务,监听重新启动了!
CMD 中tnstping orcl 也可以成功。
-------------------------------
我的tnsnames.ora 文件也没看出什么问题
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(
阅读全文