Posted by Mir Sayeed Hassan on June 23rd, 2019
How to export the Conatiner (CDB) Full DB using expdp utility in Oracle 18c
Check the database status
SQL> select INSTANCE_NAME, STATUS, VERSION from V$instance;
INSTANCE_NAME STATUS VERSION
---------------------------------------------------------
ora18c OPEN 18.0.0.0.0
Posted in Datapump (Expdp/Impdp) | Comments Off on How to export the Conatiner (CDB) Full DB using expdp utility in Oracle 18c
Posted by Mir Sayeed Hassan on May 13th, 2019
Re-configuration of the Enterprise Manager in RAC Database for 11gR2
Get the current status of the enterprise manager of RAC database
Check the status of the Enterprise Manager in database
Error:
[oracle(rac_1)@trac1 bin$./emctl status dbconsole
OC4J Configuration issue. /u01/app/oracle/product/11.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_An...
Read more..
Posted in RAC | Comments Off on Re-configuration of the Enterprise Manager in RAC Database for 11gR2
Posted by Mir Sayeed Hassan on May 13th, 2019
Oracle RAC Database fails to start with error ORA-12547/ORA-17503/CRS-5017/CRS-2674
The below error occur while startup of the RAC Database
[oracle(rac_1)@trac1:/u01/app/oracle]$ srvctl start instance -d rac -i rac_1
PRCR-1013 : Failed to start resource ora.rac.db
PRCR-1064 : Failed...
Read more..
Posted in ORA-Error | Comments Off on Oracle RAC Database fails to start with error ORA-12547/ORA-17503/CRS-5017/CRS-2674
Posted by Mir Sayeed Hassan on April 15th, 2019
How to perform manual switchover for RAC DB in Oracle 11gR2 (11.2.0.4)
In brief – The below switchover is to perform manual switchover for RAC DB – Here the primary will act as standby & standby will act as primary.
My current RAC Test DB Resources are – 2 Node of Primary Database & 1 Single Node of Standby Database
Posted in RAC | Comments Off on How to perform manual switchover for RAC DB in Oracle 11gR2 (11.2.0.4)
Posted by Mir Sayeed Hassan on March 18th, 2019
Oracle 18c – Unplug/Plug Pluggable Database (PDB) with RMAN restore & recover
The given scenario tested with Oracle 18c(18.3) DB with Preplugin backup, restore & recover, In this case the backup is taken from the PDB before they plugged into a target DB and we are unplugging it form the target DB & plugging into the target DB with RMAN method,...
Read more..
Posted in Oracle 12C & 18C | Comments Off on Oracle 18c – Unplug/Plug Pluggable Database (PDB) with RMAN restore & recover
Posted by Mir Sayeed Hassan on March 14th, 2019
INSTALLATION OF ORACLE 18C SOFTWARE Only
[root@oracle18c_db ~]# cat /etc/oracle-release
Oracle Linux Server release 7.5
Oracle Linux Software is installed in this machine.
Download Oracle 18c (18.3) Software from below link:
https://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
File:...
Read more..
Posted in DB Install & Create | Comments Off on INSTALL & CREATE ORACLE 18C (18.3) on Oracle Linux
