解析:
电脑装完oracle后重启电脑,连接plsql提示监听找不到
1、修改监听文件:
E:\app\zyz\product\11.2.0\dbhome_1\NETWORK\ADMIN
可参考监听bak文件中的信息,修改信息
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = D:\oracle\product\11.2.0\dbhome_1)
(SID_NAME = ORCL)
)
(SID_DESC =
(PROGRAM = extproc)
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\11.2.0\dbhome_1)
)
)
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = D:\oracle\product\11.2.0\dbhome_1)
(SID_NAME = ORCL)
)
(SID_DESC =
(PROGRAM = extproc)
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\11.2.0\dbhome_1)
)
)
2、连接plsql,提示
1、首先看一下 ORACLE_BASE\ORACLE_HOME\DATABASE 下面的 ORADIM.LOG 文件
E:\app\psun\product\11.2.0\dbhome_1\database:
看日志才发现原来报的下面的错误!!
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_ORCL'
E:\app\psun\product\11.2.0\dbhome_1\database:
看日志才发现原来报的下面的错误!!
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_ORCL'
2、在tnsnames.ora文件中增加下述语句,其中ORCL是你的数据库实例名,localhost可修改为计算机名称
进过查找该错误,发现是tnsnames.ora文件中少了如下语句的原因
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))