Mir Sayeed Hassan – Oracle Blog

Data Guard Physical Standby Setup in Oracle Database 18c

SQL> select instance_name,status,version from V$instance;
INSTANCE_NAME    STATUS       VERSION
---------- ------------ -----------------
ora18c           OPEN         18.0.0.0.0

PRIMARY DATABASE CONFIGURATION

Check the archivelog status

RMAN Backup of Container Database (CDB) & Pluggable Database (PDB), Partial PDB

Connect to the CDB Database

Connect to the RMAN Root Container Database (CDB) by using rman target sys/<password>@<dbname> or rman target /
Example: rman target sys/******@ora18c or rman target /  - The result will be same

Connect... 
Read more..			

How to export Schema from Pluggable (PDB) 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

Check...
Read more..

How to export the Pluggable 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

Check the number of PDB’S exist in CDB

[oracle@oracle18cdb... 
Read more..			

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

Create...
Read more..

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..