Toad World® Forums

Problem with configuring TOAD for Oracle 10g database.


#1

Hi all,

I have installed Oracle 10g database and also a client for 10g, both on the same machine.
Then I installed Toad for Oracle(version 10.5). Am using Windows - 7.

When I start toad with the below mentioned details, I get the message " ORA-12154: TNS:could not resolve connect identifier specified(XE)"
The details which i used are as below:

User/Schema : system
Password : ********
Database : XE

Connect as : Normal
Connect using(drop down) : XE

The other options in “connect using” dropdown was XE, OraClient10g_home1, OraHome92, OraHome92(Oracle Root) and Oracle.
Of these listing only XE and OraClient10g_home1 are in normal colours.
But OraHome92, OraHome92(Oracle Root) and Oracle are displayed in red.

My tnsnames.ora file has the following contents :

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Mohammed)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

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

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

Can you people please help me in resolving this issue …?

Thanks in advance,
Mohammed P.