Database Networking (MOSC)

MOSC Banner

RAC one node connect string

edited May 8, 2011 6:56PM in Database Networking (MOSC) 7 commentsAnswered
 Hi ,

Am using RAC one node feature. I am able to connect to the database using the connect string:-

sqlplus sys/password@racone as sysdba

But am not able to connect to the database if i use the instance name as in:-

sqlplus sys/password@racone_1 as sysdba

I have tried the following changes in tnsnames.ora :-

1. RACONE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = SCAN-host)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = racone)
 (SID = racone_1)
    )
  )
 

2.  RACONE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = SCAN-host)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = racone)
 (INSTANCE_NAME= racone_1)
    )
  )

3.  RACONE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = SCAN-host)(PORT = 1521))

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center