My Oracle Support Community - Forums

MOSC Banner

Discussions

11gR2 Connect to ASM via SCAN

edited Jan 5, 2011 9:09AM in Database - RAC/Scalability (MOSC) 2 commentsAnswered
Hi,
I am able to connect to ASM instance from  remote client by adding a TNS entry in the tnsnames.ora

ORAVMASM1 =
   (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = oravm1)(PORT = 1521))
      (CONNECT_DATA =
         (SERVER = DEDICATED)
         (SERVICE_NAME = +ASM)
         (UR=A)
      )
   )
However if I use scan name like (HOST = oravm-scan) it stops working and give ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.

I read [ID 340277.1]. but it did not mention using scan name.

Any idea on how to connect to ASM from remote client using SCAN name?

Thanks,
Sha



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.

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center