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
Thank you so much...Its very help full for me..
ReplyDeleteThanx for posting the solution.
ReplyDeleteThis comment has been removed by the author.
ReplyDeletei have changed my hostname in /etc/hosts file.
ReplyDeleteworked for me