Skip to Main Content

SQL & PL/SQL

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!

Host String for SQL Plus

637632May 6 2008 — edited May 6 2008
Hi,

I am trying to connect to SQL Plus.

What should I specify in host string.

tnsnames.ora has following contents:
apcl.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IP_ADDR)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = apcl)
)
)

If use apcl.world as host string it gives me following error:
TNS Could not resolve service name.

How do I resolve this,
Thanks in advance,
Raja
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 3 2008
Added on May 6 2008
2 comments
776 views