Skip to Main Content

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!

Oracle Discoverer - Oracle Connection

lastw0nd3rSep 26 2010 — edited Sep 29 2010
Hello everyone,

I have installed both oracle 10g and oracle desktop discoverer successfully. My initial screen of desktop discoverer which looks like this:
http://i56.tinypic.com/nn70xj.jpg

and i have entered the following details:

username: system
password: sairam
connect: mydb

But i get the following error:

unable to connect to*: system@mydb*

failed to connect to database - ORA - *12154: TNS: could not resolve service name*


CONTENTS OF TNSNAMES.ORA

# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

MYDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = OMSAIRAM-8F47AE)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mydb)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

Please help.

Thanks & Regards

Lucky
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 27 2010
Added on Sep 26 2010
31 comments
4,697 views