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