In Oracle 10g/11g, LOCAL_LISTENER is the parameter for specifying a listener and used for dynamic instance registration. This listener enables the listener to connect client to the correct instance. According to the Oracle documents, the default value of LOCAL_LISTENER is (ADDRESS = (PROTOCOL=TCP)(HOST=hostname)(PORT=1521)) where hostname is the network name of the local host.
SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=yourhostname)(PORT=1521))'
The common causes of this error during the database startup is Oracle cannot find your in the hosts file, probably because you have changed the hostname of the server recently or you have set the LOCAL_LISTENER incorrectly
If the error is caused by changed hostname, then you need to check the hosts file, that is, /etc/hosts in Uinx platform or
xxx.xxx.xxx.xxx yourhostname
For incorrect LOCAL_LISTENER, you should modify the parameter LOCAL_LISTENER in the init.ora file to appropriate one or set it to null or ''.
Post a Comment