Oracle DBA

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 running Check if listener is listening to database services. Look for tnsnames.ora file. database entry needs to be available there Syntax error in …

ORA-12154: TNS could not resolve service name specified 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 command to create new pluggable database Open the newly created pluggable database Create pluggable database using seed database create pluggable database PDBCDB admin …

How To Create Pluggable Database In Oracle 12c 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 to apply redo log on standby. Following command useful for real time apply ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE; To …

Oracle Dataguard Important Command 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 192.168.0.60 192.168.0.61 DB Unique Name PRIM STAND We are assuming that primary database is ready with database installation and we have copied the …

Oracle 12C dataguard installation using Active Duplicate Method 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 remove this problem Oracle come up real application cluster where by using Real application cluster software we can join multiple host and will …

What is RAC (Real Application cluster in Oracle) Read More »