My Oracle Support Banner

[OCI] VMDB: /etc/hosts was modified and listener is unable to start after os rebooting (Doc ID 2871702.1)

Last updated on APRIL 11, 2023

Applies to:

Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

For the recently launched OCI DB system, after OS rebooting /etc/hosts was modified, the vip and scan IP address lost as below. listener is unable to start due to that.

pre os reboot:

[opc@<hostname> ~]$ sudo -s
[root@<hostname> opc]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.0.0.217 <hostname>.<subnet>.<vcn>.oraclevcn.com <hostname>
192.0.0.217 <hostname>.<subnet>.<vcn>.oraclevcn.com <hostname>
192.168.16.18 <hostname>-priv.<subnet>.<vcn>.oraclevcn.com <hostname>-priv
192.0.0.217 <hostname>-vip.<subnet>.<vcn>.oraclevcn.com <hostname>-vip
192.0.0.217 <hostname>-scan.<subnet>.<vcn>.oraclevcn.com <hostname>-scan

[root@<hostname> opc]# stat /etc/hosts
File: ‘/etc/hosts’
Size: 506 Blocks: 8 IO Block: 4096 regular file
Device: fc06h/64518d Inode: 1052081 Links: 1
Access: (0644/-rw-r--r--) Uid: ( 0/ root) Gid: ( 0/ root)
Access: 2022-05-23 02:38:54.606000000 +0000
Modify: 2022-05-23 02:46:27.342610448 +0000
Change: 2022-05-23 02:46:27.342610448 +0000
Birth: -

 

 post os reboot:

[opc@<hostname> ~]$ sudo -s
[root@<hostname> opc]# last reboot
reboot system boot 4.14.35-2047.510 Mon May 23 04:50 - 04:52 (00:01)
......

[root@<hostname> opc]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.16.18 <hostname>-priv.<subnet>.<vcn>.oraclevcn.com <hostname>-priv
192.0.0.217 <hostname>.<subnet>.<vcn>.oraclevcn.com <hostname>
=> Here, VIP and SCAN IP lost

[root@<hostname> opc]# stat /etc/hosts
File: ‘/etc/hosts’
Size: 290 Blocks: 8 IO Block: 4096 regular file
Device: fc06h/64518d Inode: 1048583 Links: 1
Access: (0644/-rw-r--r--) Uid: ( 0/ root) Gid: ( 0/ root)
Access: 2022-05-23 04:50:53.057002050 +0000
Modify: 2022-05-23 04:50:53.069007978 +0000
Change: 2022-05-23 04:50:53.069007978 +0000
Birth: -

 

Listener is unable to start automatically and fail to start manually as well.

# su - grid

[grid@<hostname> ~]$ crsctl status resource -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
......
ora.LISTENER.lsnr
ONLINE OFFLINE <hostname> STABLE

ora.<hostname>.vip
1 ONLINE OFFLINE  STABLE

[grid@<hostname> ~]$ srvctl start listener -listener listener
PRCR-1079 : Failed to start resource ora.LISTENER.lsnr
CRS-5052: invalid host name or IP address '<hostname>-vip.<subnet>.<vcn>.oraclevcn.com'
CRS-2674: Start of 'ora.<hostname>.vip' on '<hostname>' failed

 

 

Changes

the OCI DB system launched recently.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.