Welcome back, recently I have shared how to change local listener port in Oracle 19c, Similarly today I will cover how to modify scan listener port in Oracle RAC 19c. To be honest with you, I never got such request from application team / Any team as of now. But recently my colleague forgot to…
Category: oracle dba
Multiplex Control file in Oracle RAC database 19c
If you are working for Financial/Banking domain, you will have a Guidelines given by the Auditors and doesn’t matter if you are restoring a fresh database or making a copy of it. You need to follow it. So recently we had a request to restore a database for PUC purpose, but since it was on…
How to Create a Service Request (SR) in My Oracle Support
Today, I was wondering let me create a blog which will have all the basic points which are needed for a L1 Oracle DBA to know. It will be based on my experience so far. So if you think I need to add any post under L1ORACLEDBA category. Do let me know in comment section…
Oracle Database and Server Reboot Request
Let’s discuss about Oracle Database and Server Reboot Request. When Oracle Database services / cluster services are running on the server which is scheduled for server reboot then you will be asked to stop the database services. It’s always recommended to shutdown your database before releasing your database server for reboot. There are various reasons…
crsctl stop cluster -all vs crsctl stop crs in Oracle 19c
What is the difference between crsctl stop cluster -all vs crsctl stop crs. What all process will be running. Today we will share all the details about it. Crsctl stop cluster -all Honestly so far I haven’t got chance to use this command though Oracle says this will be used in Maintenance. Please note you…
How to Clear Socket Files in Oracle RAC 19c
Hello Readers, You might be thinking why we are clearing network socket files in oracle 19c RAC configuration. How to Clear Socket Files in Oracle RAC. How often we need to clear it. What are the location of the socket files. How to clear socket files in Oracle RAC 19c. What happens if you clear…
How to Kill Session in Oracle 19c | ALTER SYSTEM KILL SESSION / ALTER SYSTEM DISCONNECT SESSION /ALTER SYSTEM CANCEL SQL
Hey Readers, Welcome to the blog once again, Being an Oracle DBA, you might receive a request for killing a session. For Instance Application developer fired a Update/Delete statement two times and now He want to kill the session or Since pandemic most of us are working from home and due to network fluctuation at…
How to Install Oracle 19c Binaries along with RU
Hey readers, if you remember, last post was about how to create physical standby database in Oracle 19c And there I mentioned that you have to install the binaries on your DR server. And apply same patch as that of production. Earlier when we were on 11g we used to download the Oracle Binaries and…
How to Create Physical Standby Database in Oracle 19c
Hey Reader, today we will be covering how to create physical standby database in oracle 19c. This won’t be a regular request coming into your email unless you work in Project team where you create Primary database for new application and based on business request you will create it’s Physical standby database. I will try…
How to Manually downgrade a database (Non CDB) from 19c to 11g
I have been told that, there are lot of blogs on How to manually upgrade a database from 11g to 19c but there are very few blogs which has action plan about how to downgrade a database from 19c to 11g. I would like create one for you. Along with that I have seen many…