Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

shutdown gracefully oracle database using oracle-database-operator #154

Open
gserpentino opened this issue Oct 30, 2024 · 1 comment
Open
Assignees

Comments

@gserpentino
Copy link

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.

@gserpentino
Copy link
Author

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants