Oracle异常处理—ORA-12514:监听程序当前无法识别连接描述符中请求的服务
(SID_DESC = (GLOBAL_DBNAME = ORCL) (ORACLE_HOME = D:\oracle\product\11.2.0\dbhome_1) (SID_NAME = ORCL) )
如果在listener.ora文件中指定监听的实例名,则即使数据库处于关闭状态,仍然可以连接。
# listener.ora Network Configuration File: C:\app\NanT\product\11.2.0\dbhome_2\NETWORK\ADMIN\listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = C:\app\NanT\product\11.2.0\dbhome_2) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:C:\app\NanT\product\11.2.0\dbhome_2\bin\oraclr11.dll") ) (SID_DESC = (GLOBAL_DBNAME = ORCL2) (ORACLE_HOME = C:\app\NanT\product\11.2.0\dbhome_2) (SID_NAME = ORCL02) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.1)(PORT = 1521)) ) ) ADR_BASE_LISTENER = C:\app\NanT