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 =
   (DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = dbserverac)(PORT = 1521))
   (CONNECT_DATA = 
   (SERVER = DEDICATED)
   (SERVICE_NAME = mymagic)
   )
   )
       
   

5. Make a connection.

   sqlplus scott/tiger@mymagic