Today, we faced an issue while changing the user’s password. Oracle Version Reported – 19.14. Generally it is recommended to raise an SR just to confirm if ORA-600 matches with your error dump. You have option provided by Oracle Support named Ora-600 lookup tool, You can always try it. It is quite fast in listing…
srvctl start database Fails with CRS-5802: Unable to start the agent process in Oracle 19c
Today, We faced above issue where srvctl start database was failing on one node. It was failing with “CRS-5802: Unable to start the agent process” . There was no clue in database alert log what was causing the problem. Following issue was reported on Sun Solaris OS / 19.11 Binary Version If you check database’s…
ORA-00059: Maximum Number Of DB_FILES Exceeded
Known issues:When using Pluggable Database (PDB)/Container in 12c, create and drop of a single PDB might repeatedly fail with ORA-59.If ORA-59 error is reported even when the total number of files is less than the value of db_files, then this could be due to Bug 17461374.Download and apply the interim patch if it exists for your…
How to Add Datafile in Tablespace in Oracle 19c
When I started as L1 Oracle Database Administrator, it was my regular task to check free space at tablespace level and maintain enough space to avoid application downtime because of “Unable to extend <tablespace> by XX Bytes” error. That’s the reason I brought this post. How to add datafile in tablespace in oracle 19c, We…
How to Change Scan Listener Port in Oracle RAC 19c | Modify Scan Listener Port in Oracle RAC 19c
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…
How to Change Listener Port in Oracle 19c
Changing of Listener Port is not a regular activity. But Application team can request you to change it. Today, we are going to learn how to change Local listener port in Oracle 19c RAC and Non Rac. Why to Change Local Listener Port in Oracle 19c You might be wondering what makes application team to…
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 make OPATCHAUTO Simplified in Oracle 19c
Hey Readers, Today I am going to share all the checks we do before patching Oracle RAC / ASM Standalone oracle 19c database server. Some of the steps may not be required if you are doing manual patching. GI and RDBMS owner – Password shouldn’t be lock or expired As we know that analyze command…
root.sh – CLSRSC-196: ACFS driver install actions failed in Oracle 19c
Yesterday, one of my colleague reported an issue where we were doing HAS installation. It was an AIX 7.1 OS on which were trying to install 19.14 Grid Infra and Oracle Binary. All prechecks were completed. And everything was looking good. But when we executed root.sh it failed with – CLSRSC-196: ACFS driver install actions…
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…