Oracle cannot find the listener
Oracle Server File app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN \ listener. ora
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 \ lrlr11.dll ")
)
)
To:
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 \ lrlr11.dll ")
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL.172.17.6.xxx)
(ORACLE_HOME = D: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1)
(SID_NAME = ORCL)
)
)
Dynamic and Static monitoring features of Oracle listeners
Non-default listeners and port configurations for placing an instance in the Oracle 11g RAC Environment
Configure and manage Oracle listener logs
Oracle error-ORA-12514: TNS: No listener
ORA-12514 listening error solved
Six connection problems and solutions for Oracle listeners
Oracle LISTENER does not listen to Oracle instances. Problem solved