Mir Sayeed Hassan – Oracle Blog

Delete the Oracle database 11gR2 (11.2.0.4) using DBCA Silent mode

Database status

[oracle@testdb ~]$ sqlplus / as sysdba

SQL> select instance_name,status,version from V$instance;

INSTANCE_NAME        STATUS       VERSION
------------- -----------------------------------------
testdb               OPEN        ... 
Read more..			

Create the Oracle database 11gR2 (11.2.0.4) using DBCA Silent mode

Set the bash profile or you can run the environment variable

[oracle@testdb ~]$ cat .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi
# User specific environment and startup programs

PATH=$PATH:$HOME/.local/bin:$HOME/bin
export... 
Read more..			

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