![pl sql developer tnsnames ora pl sql developer tnsnames ora](https://www.databasestar.com/wp-content/uploads/2017/04/04.png)
# tnsnames.ora Network Configuration File: c:\10gDB\network\admin\tnsnames.oraĪny idea what I am doing wrong? TNS_ADMIN is also set to c:\9idb2\network\admin # tnsnames.ora Network Configuration File: c:\9idb2\network\admin\tnsnames.ora My tnsnames.ora at both oracle home looks like as follows: ORA-12514: TNS:listener does not currently know of service requested in connect My problem is I can connect to 9idb service but when I try to connect to 10G database I am getting following error: Instance "taha", status READY, has 1 handler(s) for this service. Instance "taha", status UNKNOWN, has 1 handler(s) for this service. Instance "orc10g", status READY, has 1 handler(s) for this service. Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service. (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sumbul)(PORT=2100))(Presentation=FTP (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sumbul)(PORT=8080))(Presentation=HTT (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sumbul)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc))) Listener Log File c:\9idb2\network\log\listener.log Listener Parameter File c:\9idb2\network\admin\listener.ora Version TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Produc All rights reserved.Ĭonnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))) When I checked the status of listener, both the listeners are running : (ADDRESS = (PROTOCOL = TCP)(HOST = SUMBUL)(PORT = 1525)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) (ADDRESS = (PROTOCOL = TCP)(HOST = sumbul)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) # Generated by Oracle configuration tools. # LISTENER.ORA Network Configuration File: c:\9idb2\network\admin\listener.ora I have added the 10G listener to 9idb oracle home and here is how my listener.ora file looks like.
![pl sql developer tnsnames ora pl sql developer tnsnames ora](https://img-blog.csdnimg.cn/2020080510221140.png)
My 9i oracle home points to c:\9idb2 and 10G to c:\10gdb. I have Oracle 9i and Oracle 10G running on a windows2000 machine.