shutdown gracefully oracle database using oracle-database-operator
Opened this issue · 1 comments
Hello all,
I have a simple question about the oracle-database-operator.
I have up & running a test oracle database under kubernetes.
The only way I know actually to stop/shutdown the database gracefully is to login into pod and execute
the classic shutdown from sqlplus.
I woluld like to know if there is a way to shutdown gracefully using the oracle-database-operator.
I have the same "issue" with oraclerestdataservice.
I tried to patch is with replicas: 0 but with no luck.
Many thank to who can help me.
I found this documentation about shutdown and startup:
Note:
Maintence shutdown/startup can be executed using the scripts /home/oracle/shutDown.sh and /home/oracle/startUp.sh
Another "issue" that it is not clear to me is when a worker node became unavailable. The pod switch into the other node but for example, this morning it dowsn'e start due to following error:
SQL> ORACLE instance shut down.
SQL> ORACLE instance started.
Total System Global Area 4999607184 bytes
Fixed Size 9696144 bytes
Variable Size 905969664 bytes
Database Buffers 4076863488 bytes
Redo Buffers 7077888 bytes
SQL> Disconnected from Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0
[2024:11:04 13:25:59]: Releasing lock .ORCL1.create_lck
[2024:11:04 13:25:59]: Acquiring lock .ORCL1.exist_lck with heartbeat 30 secs