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!

tns name for oracle 9i

718177Aug 29 2009 — edited Aug 31 2009

Hi all,

I have installed 9i on my laptop, n configured tns entry as follows. But getting an error while connecting " TNS could not resolve the service name"
Please help.

abhi.oracle=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = abhi.oracle)
)
)

abhi.oracle was the database file name i gave while installing 9i database.
Please let me know what should be the service name for the tns entry???
Using Scott/tiger as username n pwd.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 28 2009

Added on Aug 29 2009

6 comments

784 views