Configuring the Oracle RAC Connect String with a Physical Hostname and Service Name

The following configuration is needed to make SCAN connect work.

  1. Create the service as a Oracle user.  In the example it is "magic".

    $ srvctl add service -d magic -s mymagic -r magic1

  2. Start the service.

    $ srvctl start service -d magic -s mymagic

  3. Check to see if the service is registered with the listener.

    $lsnrctl status LISTENER_SCAN1
    $lsnrctl status LISTENER

  4. Add the entry in the tnsnames.ora file on the server and client sides.

    mymagic =
    (ADDRESS = (PROTOCOL = TCP)(HOST = dbserverac)(PORT = 1521))
    (SERVICE_NAME = mymagic)

  5. Make a connection.

    sqlplus scott/tiger@mymagic

Last modified: 10/29/2018 1:20:05 PM