Unable to Start Database Listener Due to Wrong VIP On /etc/hosts file

Unable to Start Database Listener Due to Wrong VIP On /etc/hosts file

1. When We tried to start the Database Listeber which was not starting on node1 and reporting below error message:

[oracle@oraclenode1 admin]$ lsnrctl start LISTENER_RACSB

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 01-SEP-2021 02:37:44

Copyright (c) 1991, 2016, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/12.2.0.1/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 12.2.0.1.0 - Production

System parameter file is /u01/app/oracle/product/12.2.0.1/dbhome_1/network/admin/listener.ora

Log messages written to /u01/app/oracle/diag/tnslsnr/oraclenode1/listener_racsb/alert/log.xml

Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oraclenode1-vip.localdomain.com)(PORT=1523)))

TNS-12545: Connect failed because target host or object does not exist

 TNS-12560: TNS:protocol adapter error

  TNS-00515: Connect failed because target host or object does not exist

   Linux Error: 99: Cannot assign requested address

Listener failed to start. See the error message(s) above...

[oracle@oraclenode1 admin]$

2. When I checked on /etc/hosts file where node1 VIP was wrongly mentioned (10.38.4.168)

[root@oraclenode1 ~]# cat /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

############################################################################################

# Public

10.38.4.110 oraclenode1.localdomain.com oraclenode1

10.38.4.115 oraclenode2.localdomain.com oraclenode2

# Private

10.38.9.110 oraclenode1-priv.localdomain.com oraclenode1-priv

10.38.9.115 oraclenode2-priv.localdomain.com oraclenode2-priv

# Virtual

10.38.4.168 oraclenode1-vip.localdomain.com oraclenode1-vip

10.38.4.170 oraclenode2-vip.localdomain.com oraclenode2-vip

# SCAN

10.38.4.126 orclscan.localdomain.com orclscan

10.38.4.154 orclscan.localdomain.com orclscan

10.38.4.162 orclscan.localdomain.com orclscan

[root@oraclenode1 ~]#

3. When I checked node VIP using srvctl config found that correct VIP was 10.38.4.138

[root@oraclenode1 named]# srvctl config  vip -n oraclenode1

VIP exists: network number 1, hosting node oraclenode1

VIP IPv4 Address: 10.38.4.138

VIP IPv6 Address:

VIP is enabled.

VIP is individually enabled on nodes:

VIP is individually disabled on nodes:

[root@oraclenode1 named]#

4. I have modified the /etc/hosts file and updated the correct VIP for node1

[root@oraclenode1 ~]# cat /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

############################################################################################

# Public

10.38.4.110 oraclenode1.localdomain.com oraclenode1

10.38.4.115 oraclenode2.localdomain.com oraclenode2

# Private

10.38.9.110 oraclenode1-priv.localdomain.com oraclenode1-priv

10.38.9.115 oraclenode2-priv.localdomain.com oraclenode2-priv

# Virtual

10.38.4.138 oraclenode1-vip.localdomain.com oraclenode1-vip

10.38.4.170 oraclenode2-vip.localdomain.com oraclenode2-vip

# SCAN

10.38.4.126 orclscan.localdomain.com orclscan

10.38.4.154 orclscan.localdomain.com orclscan

#10.38.4.165 orclscan.localdomain.com orclscan

10.38.4.162 orclscan.localdomain.com orclscan

[root@oraclenode1 ~]#

5. I was able to start the Database listener successfully

[oracle@oraclenode1 ~]$ cd /u01/app/oracle/product/12.2.0.1/dbhome_1/network/admin/

[oracle@oraclenode1 admin]$ lsnrctl start LISTENER_RACSB

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 01-SEP-2021 02:41:26

Copyright (c) 1991, 2016, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/12.2.0.1/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 12.2.0.1.0 - Production

System parameter file is /u01/app/oracle/product/12.2.0.1/dbhome_1/network/admin/listener.ora

Log messages written to /u01/app/oracle/diag/tnslsnr/oraclenode1/listener_racsb/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.38.4.138)(PORT=1523)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oraclenode1-vip.localdomain.com)(PORT=1523)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER_RACSB

Version                   TNSLSNR for Linux: Version 12.2.0.1.0 - Production

Start Date                01-SEP-2021 02:41:26

Uptime                    0 days 0 hr. 0 min. 0 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/app/oracle/product/12.2.0.1/dbhome_1/network/admin/listener.ora

Listener Log File         /u01/app/oracle/diag/tnslsnr/oraclenode1/listener_racsb/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.38.4.138)(PORT=1523)))

Services Summary...

Service "RACSB" has 1 instance(s).

  Instance "RACSB", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

[oracle@oraclenode1 admin]$

Regards,

Mallik