Get Information About the Application Databases

Gather information about the Oracle Cloud Infrastructure Database instances that your target Oracle Java Cloud Service instance will use to access your application schemas. You will use this information to perform the migration.

f the Application Database is running Oracle Cloud Infrastructure, then complete the following steps:

1. Access the Oracle Cloud Infrastructure console.
2. Click the menu icon, and under Database, select Bare Metal, VM, and Exadata
3. Select the Region and Compartment where your database resides.
4. Click the name of your database.
5. From the DB System Details page, record these values.
   • The public IP address of the first database node
   • The host name prefix for the database (for example, myappdb)
   • The domain name for the database (for example, mydbsubnet.myvcn.oraclevcn.com)
   • The database port number
   • The database name and unique name (for example, ORCL and ORCL_iad1zj)
6. If your database is running Oracle Database 12c or later, then identify the pluggable database (PDB) that contains your application schemas.
   1. Use a Secure Shell (SSH) client to connect to the database node as the opc user.

      ssh -i <privatekey> opc@<database_IP>

   2. Switch to the oracle user.

      sudo su - oracle

   3. Locate the ORACLE_HOME directory for the database on the file system.
      Example:

      /u01/app/oracle/product/12.1.0.2/dbhome_1

   4. If you are accessing this database node for the first time, run the oraenv command to configure the environment.

      source oraenv

      When prompted, enter the database name (SID) and the ORACLE_HOME directory.

      Example:

      ORACLE_SID = ORCL
      ORACLE_HOME = /u01/app/oracle/product/12.1.0.2/dbhome_1

   5. Start sqlplus as the sysdba role.

      sqlplus / as sysdba

   6. Print the list of PDBs in this database.

      SELECT PDB, NETWORK_NAME, CON_ID FROM CDB_SERVICES;

   7. In the command output, identify the PDB name.
      Example:

      MYPDB  mypdb.mydbsubnet.myvcn.oraclevcn.com

7. Repeat step 1 through step 6 for any other application databases to which the target instance will connect.