今天在执行数据库其用归档模式时,执行语句<!--StartFragment-->
SQL> startup mount时报错:
<!--StartFragment--> <!--StartFragment-->
ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务解决<!--StartFragment-->
改文件:
D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora:增加红色部分
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = jqwlscl)
(ORACLE_HOME =D:\app\Administrator\product\11.2.0\dbhome_1)
(SID_NAME = jqwlscl)
)
(SID_DESC =
(GLOBAL_DBNAME = jqwldb)
(ORACLE_HOME =D:\app\Administrator\product\11.2.0\dbhome_1)
(SID_NAME = jqwldb)
)
(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")
)
)
Cmd>lsnrctl stop
Cmd>lsnrctl start
Cmd>.....
<!--EndFragment-->数据库是双实例,因此配置文件上要做修改
<!--EndFragment-->