解决办法:首先查看一下listener是否启动,开启cmd,输入命令 Lsnrctl,如下 输入status,查看状态
我们看到没有orcl实例,需要到listener.org中配置信息 D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN 找到listenr.org,用记事本打开 #listener.oraNetworkConfiguration File: D:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora # Generated by Oracle configuration tools.
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:D:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll") ) (SID_DESC = (GLOBAL_DBNAME = orcl) (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1) (SID_NAME = orcl) ) )
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) )
ADR_BASE_LISTENER = D:\app\Administrator 红色字体为增加的实例内容。 这时再重启一下监听器,在cmd中输入reload即可。
这时看到orcl实例,这时再在Oracle SQL Developer中连接就可以了。 |
转载于:https://my.oschina.net/u/987955/blog/112486