1. Migrating Non-CDBs to New Hardware with the Same Operating System and Release
  2. Preparing the Auxiliary Instance on the Destination Host
  3. Configuring the Network Between Source and Target Oracle Databases
  4. Checking SQL*Net Configuration

Checking SQL*Net Configuration

Run the tnsping command from the source and destination servers. 

[oracle @ ora12c-prm admin] $ tnsping standby-db-unique-name
[oracle @ ora12c-dup admin] $ tnsping primary-db-unique-name

Oracle recommends that you connect remotely as sysdba to ensure that the communication is established properly.

Start SQL*Plus using a command in the following format:

sqlplus {username | /} [as sysdba]

For example:

$ sqlplus / AS SYSDBA
Enter password: password

Alternatively, to start SQL*Plus connected to a database other than the default, enter the SQL*Plus command in the format:

$> sqlplus username/password@connect_identifier

Parent topic: Configuring the Network Between Source and Target Oracle Databases