How often you see archive missing from production which is not shipped to Standby database ? Rare right? But you will come across this situation once for sure when due to re-org you were forced to delete archives / due to network disconnection archive didn’t got shipped properly and due to automation job archive got…
How to convert Physical Standby database to Snapshot Standby
From oracle 11g we have one more feature enabled to help ourselves. “Snapshot Standby”. This way you can open a physical database in read write mode and revert back to physical standby. So what Option was available for 10g database ? We will discuss it in another blog. Lets start with how to convert Physical…
How to Resize Online Redo Logs in Oracle
There is no command to resize online redo logs in oracle as of now. So to achieve our goal of “How to Resize Online redo logs in oracle” we will do Drop and create online redo logs groups. Sorry to confuse you with title. It’s How to Re-create Online Redo Logs in Oracle. As promised…
How to Recreate Standby Redo logs on Standby Database
Hello, Today we were increasing the size of redo logs. And since we had standby redologs as well. So we had to resize the standby redo logs too. I will create a detailed blog post on how to resize redo log groups. Before that, let me tell you what happened today. For now lets talk…
Scan Listener – Not All Endpoints Registered
Hello Readers, today we faced a new issue where one of our scan listener after reboot were giving us error. Resource was in Intermediate state. Rest all the scan listener were online. Scan Listener – Not All Endpoints Registered And there was no services were registered to Scan listener 1 . We have changed the…
How to recreate Central Inventory in Oracle
Recently, we upgraded the database, as part of upgrade and which gave us error. The issue was additional “/” which caused the problem for us. Database connect failed with: ORA-12547: TNS:lost contact (DBD ERROR: OCIServerAttach) Here we had to recreate central inventory before upgrading the database. Here we are “How to recreate Central Inventory in…
Database Upgrade : Database connect failed with: ORA-12547: TNS:lost contact (DBD ERROR: OCIServerAttach)
Today, we we were doing database upgrade from 11.2.0.4 to 19c. 19c binaries installation was clean, while upgrade 107 phases was clean to until we got error during datapatch. Let me provide the error reported – Database connect failed with: ORA-12547: TNS:lost contact (DBD ERROR: OCIServerAttach) ISSUE Error: prereq checks failed! is known issue when…
How to Install Oracle 12c Release 2 on Redhat Linux
Hello Reader :), Welcome back to my Blog . In this post, we will learn how to install Oracle 12c on Redhat Linux Server. We will learn how to Install oracle 12c Release 2 on redhat linux in 3 different ways which will come handy to you when you are installing it at client site….
How to Install Linux on Oracle Virtual Box
If you are searching for How to Install Linux on Windows System without disturbing windows system or How to Install linux System on Oracle Virtual Box. Then you are at right place. AS promised in earlier post where we explained how to install Linux on VMWARE. If you haven’t gone through the post there here…
Diskgroup name with a Special Character
Today, one issue was reported where diskgroup got created successfully but disk group had a special character in it. Diskgroup name with special character caused an issue for us as no operation were allowed Later we could identify diskgroup name with special character. Here is how we found it out. When we fired select we…