ORA-00130: invalid listener address
Error
SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=RAC1.oracle.com)(PORT=1521))'
Cause
Difference in the name of the host-name specified in /etc/hosts file or listener file.
Solution
When you change the name of the system, you must change in hosts file of system also.
1. Location of host file:
Windows: C:\Windows\System32\drivers\etc\hosts
Linux: /etc/hosts
2. Edit the host file.
[oracle@oracle bin]$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
Change to
[oracle@oracle bin]$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
127.0.0.1 RAC1.oracle.com RAC1
::1 localhost6.localdomain6 localhost6
3. Check the ping command name is resolved.
Ping RAC1
4. Check the Environmental Setting like oracle_home, tns_admin , path etc.
5. Startup the database.
SQL> startup
ORACLE instance started.
Total System Global Area 1610609744 bytes
Fixed Size 9028688 bytes
Variable Size 1207959552 bytes
Database Buffers 385875968 bytes
Redo Buffers 7745536 bytes
Database mounted.
Database opened.
6. If its not work, check the parameter LOCAL_LISTENER is set correct in pfile.
yes, it’s working.
thanks you very very much…!!!!
LikeLiked by 1 person