In this article, we can upgrade the 11g database to 12c with the help of DataGaurd Primary DB Name Standby DB Name Database Version Upgrade Version UPGDB UPGDB 11.2.0.4.0 12.1.0.2.0 Step 1: Install 12.1.0.2 binaries on both Primary and Standby Server. Step 2: Shut down Primary Database. Step 3: Shut down Standby Database. Step 4: […]
Monthly Archives: August 2018
Recover Datafile in Standby Database in Data Guard Environment
In the previous article, we have to seen Recovering Primary Database Datafile using Standby Database if it’s not deleted from Standby Database. Recover Data File in Primary Database in Data Guard Environment Here we will see what if datafile gets corrupted or deleted from Standby Database. Step 1: In the below code, we can see […]
ORA-12516:TNS protocol stack in Oracle
Let’s start the series of Oracle listener. Now are going to focus over the issue for the following errors. Let’s have looked over the steps and solve the issues. TNS-12516 TNS: listener could not find an instance with the matching protocol stack ORA-12516 TNS: listener could not find available handler with the matching protocol stack […]
ORA-12505: TNS:listener in Oracle
Being human being we have a lot of unlimited qualities. Listening is one of them. Normally we ignore it but it is most important for all. Good listing keeps us away from 99% problems away and life makes us simple but if we don’t listen properly we invite unlimited problem in our life. In same […]
How to Purge Listener Log in Oracle
Being DBA we all are aware that Oracle Database makes a connection with a client with the help of listener. Oracle provides the facility to have look over the status of Oracle listen. Being a part of IT we must be aware that 24*7 We require database live but due to some unfortunate conditions database […]
ORA-12162: TNS:net service name is incorrectly specified
Let’s have look on some listener issues in the database. Cause: The connect descriptor corresponding to the net service name in TNSNAMES.ORA or in the directory server (Oracle Internet Directory) is incorrectly specified. Action: If using local naming make sure there are no syntax errors in the corresponding connect descriptor in the TNSNAMES.ORA file. If […]
MAXDATAFILES and other files in Oracle
This Post is about the trick by which we can use to monitor the CRDs of Oracle Database. Monitoring is the most important and common task in RDBMS. Without monitoring CDR Let’s have look on the query which we use to monitor main elements of Oracle Database CDRs. — MAXDATAFILES Select ‘MAXDATAFILES ‘ || records_total […]
Oracle Cloud Infrastructure (1Z0-932)
Hi Readers Finally, I’ve successfully passed 1Z0-932, Oracle Cloud Infrastructure 2018 Architect Associate. It was almost more than 8-10 months that I’ve been preparing for this. The Exam contains 70 questions related to OCI which includes storage, VCN, Terraform, Knife, DNS etc.. To earn this certification you need to get 68% marks. This was the result of […]