Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Difficulty in configuring SQL connect connect string for ASM instance

user7741973Feb 22 2017 — edited Feb 22 2017

We use Microsoft Active Directory to store oracle database connect strings at central place and use Oracle Net Manager to manage them.

I am trying to define SQL net connect string in there like below -

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp) (HOST=myhost) (PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=+ASM)(UR=A)))

I have tested this connect string as following works -

sqlplus asmsnmp/mypwd@'(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp) (HOST=myhost) (PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=+ASM)))' as sysasm

Oracle Net manager is giving error that "A valid Service Name is required" on the service name field for the value of "+ASM".

Anybody have suggestion/guidence around this error?

Thanks in advance for the help,

Jay

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 22 2017

Added on Feb 22 2017

#performance-availability, #real-application-clusters

1 comment

438 views