ORA-00130: invalid listener address

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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.