How to Purge Recycle Bin in Oracle
Since 10g, we have recycle bin that can store dropped tables and indexes. Whenever we need them, we can flashback the dropped tables or indexes… Read More »How to Purge Recycle Bin in Oracle
Oracle Database 12c
How to Migrate Data from 9i to 12c via DB Link
Migrate 9i to 12c As I said in How to Resolve ORA-03134, you cannot directly access an Oracle 9i database from an Oracle 12c or… Read More »How to Migrate Data from 9i to 12c via DB Link
How to Install Oracle Database 12.2 on Windows Server
The goal in this post is to install an Oracle database 12.2 on windows server 2012. Here we separate our job into 2 major steps:… Read More »How to Install Oracle Database 12.2 on Windows Server
How to Resolve ORA-28040: No matching authentication protocol
ORA-28040: No matching authentication protocol When I tried to connect to a 12.1 database from an Oracle client 9.2, it failed with ORA-28040: No matching… Read More »How to Resolve ORA-28040: No matching authentication protocol
How to Access Enterprise Manager Database Express 12c
After installing 12c database, you may want to enable dbconsole just like 10g and 11g, but in fact, there's no emctl command to operate with.… Read More »How to Access Enterprise Manager Database Express 12c
How to Install Oracle Database 11.2.0.4 on Oracle Linux 7.2
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:… Read More »How to Install Oracle Database 11.2.0.4 on Oracle Linux 7.2
How to Change Subnet of Grid
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… Read More »How to Change Subnet of Grid
How to Clone Remote PDB
Clone Remote PDB The step 1, and 2 are same as How to Clone a PDB From Another PDB in Same CDB, so we skip… Read More »How to Clone Remote PDB
How to Clone Local PDB
Clone Local PDB This time, we'd like to clone a PDB for testing purpose in the same CDB on DB level. [oracle@test1 ~]$ sqlplus /… Read More »How to Clone Local PDB
How to Unplug and Plug a PDB in Different Hosts
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… Read More »How to Unplug and Plug a PDB in Different Hosts