Log on to Oracle ora-12154:tns with PL/SQL: Unable to resolve the specified connection identifier
Sqlplus/nolog
Connect/as SYSDBA
Startup
The following error is reported:
ORA-00119:INVALID specification for system parameter Local_listener
Ora-00132:syntax error or unresolved network name ' LISTENER_ORCL '
Local_listener for D:\app\Administrator\product\11.2.0\dbhome_1\database\SPFILEORCL. *.local_listener parameters in Ora file
LISTENER_ORCL is the *.local_listener parameter value, such as: *.local_listener= ' LISTENER_ORCL '
Ora-00119,ora-00132 is because of the value of *.local_listener= ' LISTENER_ORCL ', which is LISTENER_ORCL in D:\app\Administrator\product\11.2.0\ It is not stated in the Dbhome_1\network\admin\listener.ora file that the requirement modifies the configuration file.
LISTENER_ORCL =
(Description_list =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.2) (PORT = 1521))
)
)
Oracle ORA-00119, ORA-00132 problem solving