Hi,
While bringing up the database during linux OS patching, I got below errors in the database.
ORA-00119: Invalid specification for system parameter LOCAL LISTENER.
ORA-00132: syntax error or unresolved network name 'LISTENER_DRINO'
Then I added below tns entry in the tnsnames.ora file and database have started.
LISTENER_DRINO =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = server1)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DRINO)
)
)
But I was told that we should not be adding tns entry as local listener parameter.
Before adding this tns entry, local listener was set blank. After adding it, local listener was set as below in the database.
SQL> show parameter local
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string LISTENER_DRINO
Could you please tell me what would have caused this issue?
Oracle - 11.2.0.3.0
OS - Linux
This is Development database.
This is standalone database.
Regards,
Bala