ORA-00604, ORA-01882 While Connecting With SQL Developer

Sometime when you try to connect to oracle database using sql developer tool, you will see the below error message Problem Statement An error was encountered performing the requested operations: ORA-00604: error... Read more »

ORA-12560: TNS:protocol adaptor error

This is the common error in oracle database related to oracle database connection Problem Statement ORA-12560: TNS:protocol adaptor error Solutions Check if your database is up and running Make sure listener is... Read more »

ora-01722 invalid number in oracle

In this blog, We will try to understand how to resolve the ORA-01722 error. Problem Statement ora-01722 invalid number in oracle Solution First describe the table and check for data types by... Read more »

ora-03113 end-of-file on communication channel

This is common error which will occur on oracle database. ora-03113 end-of-file on communication channel Following are the reason to get the error Database goes down abruptly Server goes down and there... Read more »

ORA-12154: TNS could not resolve service name specified

Sometimes you will see the error message related to tns. Error message will be like this. ORA-12154: TNS could not resolve service name specified Solutions Check if your listener is up and... Read more »

How To Create Pluggable Database In Oracle 12c

In this blog, We will see the command to create the pluggable database in oracle 12c multitenent architecture. Create the required directory Put the source database in closed status Fire the following... Read more »

How to start standby database

In this blog, we will learn about how to start the standby database in dataguard environment. First we need to start the primary database and also start the listener services Primary Side... Read more »

Oracle Dataguard Important Command

In this blog, We will look some important oracle dataguard command.Following command will be useful for dataguard administration Check the Dataguard database status on primary and standby select status,instance_name,database_role,protection_mode from v$database,v$instance; Query... Read more »

Oracle 12C dataguard installation using Active Duplicate Method

In this blog , we will learn about the oracle 12c dataguard installation using active duplicate method. We are using oracle enterprise linux as database server Primary Standby Hostname prim.oracle.com stand.oracle.com IP... Read more »

What is RAC (Real Application cluster in Oracle)

Oracle RAC is the high availability concept of Oracle database administration. In the single instance database if one of the cluster goes down then application will also goes down. in order to... Read more »