Oracle Database Discussions

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!

Service name <name> vs <name>.<hostname>

user135274Oct 5 2007 — edited Oct 5 2007

I am trying to connect to my sample orcl database using

sqlplus hr/hr@TNS:orcl

After many tries and getting ORA-12594 error I finally got this to work. The trick was to update tnsnames.ora file and change

SERVICE_NAME = orcl

to

SERVICE_NAME = orcl.<hostname>

Does anyone know why this is like that? How can I get this to work with SERVICE_NAME = orcl

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 2 2007

Added on Oct 5 2007

#general-database-discussions

2 comments

808 views