Hello,
I have installed PL/SQL developer 10.0.2. And already Oracle 10g Express is installed in my machine (Windows 7). Now when I am trying o connect Oracle 10g to Pl/Sql developer its not getting me connected. Its giving error as: "ORA-12154: TNS: could not resolve the connect identifier specified".
I tried the following resolutions to solve this issue:
1). Checked 'OracleXETNSListner' service, its up and running.
2). Checked the file 'tnsnames.ora' it consist of:
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = madhu-PC)(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)
)
)
3). And in combo box three database its showing: xE, EXTPROC_CONNECTION_DATA and ORACLR_CONNECTION_DATA.
and I am trying to connect it to xE...but showing same error.
4). From Tool->preferences. In connection, the oracle home was empty..so I selected xE, but then also I am not able to connect.
I have tried all the above resolutions but not able to connect, can anyone help me out with this??