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

Updated

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
        
    

Was this page helpful?