Upgrading Oracle Database with a Physical Standby Database

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: […]

Read More

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 […]

Read More

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 […]

Read More

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 […]

Read More

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 […]

Read More

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 […]

Read More

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 […]

Read More

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 […]

Read More