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
Oracle Database 12c
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 a PDB From Another PDB in Different CDB
The step 1, and 2 are same as How to Clone a PDB From Another PDB in Same CDB, so we skip them and directly go… Read More »How to Clone a PDB From Another PDB in Different CDB
How to Clone a PDB From Another PDB in Same CDB
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; … Read More »How to Clone a PDB From Another PDB in Same CDB
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
How to Unplug and Plug a PDB in Same Host
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 More »How to Unplug and Plug a PDB in Same Host