Oracle Database Startup: ORA-00119:INVALID specification for system parameter Local_listener; ORA-00132 Error Resolution

Problem Description:

1. Prompt in em open

Https://localhost:1158/em/console/database/instance/repDown?target=orclweng&type=oracle_database

Ora-12505:tns: The listener currently does not recognize the SID given in the connection descriptor (DBD Error:ociserverattach)

2. failed to start Oracle database

There is no obvious hint of starting the Oracle database, and you can see the following error message on the command line.

C:\users\murphy>sqlplus/as Sysdba;
Sql*plus:release 11.2.0.1.0 Production on Sunday October 23 10:24:01 2016
Copyright (c) 1982, Oracle. All rights reserved.
Connected to the idle routine.
Sql> startup;
ORA-00119:INVALID specification for system parameter Local_listener
Ora-00132:syntax error or unresolved network name ' Listener_orclweng '

3. Test the connection in the net Configuration assistant of the database with the following error.

ORA-12505

4. Platform

Win7 64-bit, Oracle database server 11GR2 64-bit, the corresponding client is 32-bit, 32-bit PL/SQL.

Solution:

As prompted on the command line above, establish a "Listener_orclweng" local Network Service name configuration in the net configuration assistant.

Also see if the contents of Tnsnames.ora in the following two directories have the same items.

E:\Files\Oracle\product\11.2.0\client_1\network\admin

E:\Files\Oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN

PS: It is not recommended to use the registry to modify the automatic starting mode of the database, and then start "Sql> startup;" on the command line.

Oracle Database Startup: ORA-00119:INVALID specification for system parameter Local_listener; ORA-00132 Error Resolution