Installation and Upgrade

How to Install Oracle Database 11.2.0.4 on Oracle Linux 7.2

Posted on
First of all, I take a short cut to prepare almost all required packages by installing oracle-rdbms-server-11gR2-preinstall. [root@db1 ~]# yum -y install oracle-rdbms-server-11gR2-preinstall Loaded plugins: ulninfo Resolving Dependencies –> Running transaction check —> Package oracle-rdbms-server-11gR2-preinstall.x86_64 0:1.0-4.el7 will be installed –> Processing Dependency: gcc for package: oracle-rdbms-server-11gR2-preinstall-1.0-4.el7.x86_64 –> Processing Dependency: sysstat for package: oracle-rdbms-server-11gR2-preinstall-1.0-4.el7.x86_64 –> Processing […]
Network

How to Change Subnet of Grid

Posted on
Oracle 12c uses 4 types of IP addresses to configure network of RAC:Public IPPrivate IPVirtual IPSCAN IPIn which, Public IP, Virtual IP and SCAN IP are in the same subnet. Up to 4 pairs of Private IP can be set in RAC, which should be in another subnet and used for interconnect redundancy to secure […]
Multitenant

How to Clone a PDB From Another PDB in Same CDB

Posted on
This time, we’d like to clone a PDB for testing purpose in the same CDB on DB level.[oracle@test1 ~]$ sqlplus / as sysdba…SQL> show pdbs;    CON_ID CON_NAME                     OPEN MODE  RESTRICTED———- —————————— ———- ———- 2 PDB$SEED  READ ONLY  NO 3 FINANPDB  READ WRITE NO Just remember, […]
Multitenant

How to Unplug and Plug a PDB in Different Hosts

Posted on
The step 1, 2, 3 are same as How to Unplug and Plug a PDB in Same Host, so we skip those steps and directly go to step 4.4. Zip and compress the entire PDB directory to a zip file.[oracle@test1 ~]$ cd /u01/app/oracle/oradata/orcl/[oracle@test1 orcl]$ tar -zcf /tmp/finance_pdb.gz.tar Finance_PDB/[oracle@test1 orcl]$ ll /tmp…-rw-rw-r– 1 oracle oracle 161246549 Oct […]
Multitenant

How to Unplug and Plug a PDB in Same Host

Posted on
First of all, check the status of the target PDB to unplug.SQL> show pdbs;    CON_ID CON_NAME  OPEN MODE  RESTRICTED———- —————————— ———- ———-… 4 FINANCE_PDB  READ WRITE NOIt’s in READ WRITE mode. So we need to close it before unplugging it.1. Close the PDB.SQL> alter pluggable database finance_pdb close immediate;Pluggable database altered.SQL> show pdbs;    […]