Issue: ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_ORCL'
Solution: There are two methods by which this error can be removed.
Method 1:
Step 1: Make a entry in the tnsnames.ora as mentioned below
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = linux01.com)(PORT = 1521))
Where LISTENER_ORCL is the parameter value for LOCAL_LISTENER which is mentioned in pfile/spfile
PORT is the listener port you are using.
Also there is no need to modify the pfile/spfile.
Step 2: start the database
Method 2:
Step 1: If you are using a spfile for starting up your database, create a pfile from it.
Step 2: Edit the pfile and remove the parameter LOCAL_LISTENER
Step 3: Create spfile from the pfile and start the database
ORA-00132: syntax error or unresolved network name 'LISTENER_ORCL'
Solution: There are two methods by which this error can be removed.
Method 1:
Step 1: Make a entry in the tnsnames.ora as mentioned below
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = linux01.com)(PORT = 1521))
Where LISTENER_ORCL is the parameter value for LOCAL_LISTENER which is mentioned in pfile/spfile
PORT is the listener port you are using.
Also there is no need to modify the pfile/spfile.
Step 2: start the database
Method 2:
Step 1: If you are using a spfile for starting up your database, create a pfile from it.
Step 2: Edit the pfile and remove the parameter LOCAL_LISTENER
Step 3: Create spfile from the pfile and start the database
