Skip to content

Oracle DB Pod not coming UP after restart or patch with new image for active/standby or cloned cases. #232

@alinaqvion-hash

Description

@alinaqvion-hash

Once we deploy active and standby sidb with dataguard and restart any pod, pod didn't coming up.
same is happening when we trying to restart oracle db pod, which is created as clone.

logs...

[root@master-node-02 ~]# kubectl logs -f ch-oracle-db-ch-clone-2-ndq7x -n ch
Defaulted container "ch-oracle-db-ch-clone-2" out of: ch-oracle-db-ch-clone-2, init-wallet (init)
[2026:04:08 09:29:48]: Acquiring lock .PSMF22.create_lck with heartbeat 30 secs
[2026:04:08 09:29:48]: Lock acquired
[2026:04:08 09:29:48]: Starting heartbeat
[2026:04:08 09:29:48]: Lock held .PSMF22.create_lck
ORACLE EDITION: ENTERPRISE

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Apr 8 09:29:48 2026
Version 19.30.0.0.0

Copyright (c) 1982, 2025, Oracle. All rights reserved.

Connected to an idle instance.

SQL> ORACLE instance shut down.
SQL> ORACLE instance started.

Total System Global Area 1.6106E+10 bytes
Fixed Size 18663088 bytes
Variable Size 2181038080 bytes
Database Buffers 1.3892E+10 bytes
Redo Buffers 14888960 bytes
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.30.0.0.0
[2026:04:08 09:30:02]: Releasing lock .PSMF22.create_lck
[2026:04:08 09:30:02]: Lock released .PSMF22.create_lck
[2026:04:08 09:30:02]: Acquiring lock .PSMF22.exist_lck with heartbeat 30 secs
[2026:04:08 09:30:02]: Lock acquired
[2026:04:08 09:30:02]: Starting heartbeat
[2026:04:08 09:30:03]: Lock held .PSMF22.exist_lck

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 08-APR-2026 09:30:03

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

Starting /opt/oracle/product/19c/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora
Log messages written to /opt/oracle/diag/tnslsnr/ch-oracle-db-ch-clone-2-ndq7x/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER

Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 08-APR-2026 09:30:03
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora
Listener Log File /opt/oracle/diag/tnslsnr/ch-oracle-db-ch-clone-2-ndq7x/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
The listener supports no services
The command completed successfully

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Apr 8 09:30:03 2026
Version 19.30.0.0.0

Copyright (c) 1982, 2025, Oracle. All rights reserved.

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.30.0.0.0

SQL> SQL>
Database altered.

SQL>
Database altered.

SQL>
System altered.

SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.30.0.0.0
The Oracle base remains unchanged with value /opt/oracle
Waiting for 1 sec(s) before restarting Oracle processes and opening the database

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Apr 8 09:30:10 2026
Version 19.30.0.0.0

Copyright (c) 1982, 2025, Oracle. All rights reserved.

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.30.0.0.0

SQL> SQL> alter database mount
*
ERROR at line 1:
ORA-01100: database already mounted

SQL> alter database open
*
ERROR at line 1:
ORA-01531: a database already open by the instance

SQL>
System altered.

SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.30.0.0.0
The Oracle base remains unchanged with value /opt/oracle
Waiting for 2 sec(s) before restarting Oracle processes and opening the database

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Apr 8 09:30:13 2026
Version 19.30.0.0.0

Copyright (c) 1982, 2025, Oracle. All rights reserved.

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.30.0.0.0

SQL> SQL> alter database mount
*
ERROR at line 1:
ORA-01100: database already mounted

SQL> alter database open
*
ERROR at line 1:
ORA-01531: a database already open by the instance

SQL>
System altered.

SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.30.0.0.0
The Oracle base remains unchanged with value /opt/oracle
Waiting for 3 sec(s) before restarting Oracle processes and opening the database

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Apr 8 09:30:16 2026
Version 19.30.0.0.0

Copyright (c) 1982, 2025, Oracle. All rights reserved.

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.30.0.0.0

SQL> SQL> alter database mount
*
ERROR at line 1:
ORA-01100: database already mounted

SQL> alter database open
*
ERROR at line 1:
ORA-01531: a database already open by the instance

SQL>
System altered.

SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.30.0.0.0
The Oracle base remains unchanged with value /opt/oracle
Waiting for 4 sec(s) before restarting Oracle processes and opening the database

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions