# Problem with configuring TOAD for Oracle 10g database.

**URL:** <https://forums.toadworld.com/t/problem-with-configuring-toad-for-oracle-10g-database/9521>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [May 18, 2010, 1:58am UTC](https://forums.toadworld.com/t/problem-with-configuring-toad-for-oracle-10g-database/9521 "2010-05-18T01:58:02Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![MohammedP](https://avatars.discourse-cdn.com/v4/letter/m/8baadc/32.png) [@MohammedP](https://forums.toadworld.com/u/MohammedP)\
**Post date:** [May 18, 2010, 1:58am UTC](https://forums.toadworld.com/t/problem-with-configuring-toad-for-oracle-10g-database/9521/1 "2010-05-18T01:58:02Z")

</div>

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.
