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.