Oracle Database Express Edition (XE)

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!

Connect to Oracle XE from Toad

787371Jul 26 2010 — edited Jul 27 2010

Hi,

I installed Oracle 10g XE and Toad 10.5 freeware in my home system. I am able to connect to Oracle from Oracle XE homepage and XE SQL command line but when I try to connect to Oracle from toad 10.5 I am getting the error 'TNS: could not resolve the connect identifier specified (XE)' .

From toad I tried both TNS and direct options but it did not work. My tns ora file looks like below.

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Anu-PC)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

Can you please suggest me how to go about this problem?

Thanks,
Ravi

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 24 2010

Added on Jul 26 2010

5 comments

3,480 views