We are moving to 10g databases and client. During the upgrade we want to start using the 10g client to connect to the 9i databases that have not yet been upgraded.

I included the tnsnames entry for the 9i database into the tnsnames file for 10g but continue to get the ORA-12514 TNS:Listener does not currently know of service requested

What is different in using the 10g client for the 9i database. Can anyone please provide some information or samples of entries

Thanks
Manjit

10g client on the same server as the 9i database?
make sure all your environment variables point to the 10G binaries.
personally i have never had an issue doing this exact same thing.

perhaps you should:
post an "ENV"
cut/paste your connect and error
post a: lsnrctl stat (for the 9i listener)
post the tnsnames.ora entry

The 9i database is on a Unix server, the 10g is on a Windows server. I am trying to connect to both using the 10g client on my PC
The tnsnames.ora file under the 10g client has the following entry for the 10g database which works fine
pm10d.world =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxxxxx.yyyyy.zzzzzzzzz.on.ca)(PORT = 3512))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pm10d)
)
)


The entry for the 9i databases is as follows - this connection via 10g SQLPLUS is giving error ORA-12514

eimstest.world =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxxx.yyyyyy.zzzzzzz.on.ca)(PORT = 2261))
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = eimstest)
)
)


I have tried the above with SID = eimstest without luck

Thanks

From The 9i database is on a Unix server issue following commands as oracle user

lsnrctl status
lsnrctl service

CUT commands above & PASTE results back here.

From your PC what results from

tnsping eimstest

>lsnrctl stat listener23

LSNRCTL for HPUX: Version 9.2.0.6.0 - Production on 17-JUL-2009 11:30:14

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC23 )))
STATUS of the LISTENER
------------------------
Alias listener23
Version TNSLSNR for HPUX: Version 9.2.0.6.0 - Production
Start Date 13-FEB-2009 08:54:46
Uptime 154 days 1 hr. 35 min. 27 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /oracle/product/v92060/network/admin/listener.ora
Listener Log File /oracle/product/v92060/network/log/listener23.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC23 )))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxxxxx.y yyyy.zzzzzzzz.on.ca)(PORT=2257)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "eimsaim" has 1 instance(s).
Instance "eimsaim", status UNKNOWN, has 1 handler(s) for this service...
Service "eimsaim.world" has 1 instance(s).
Instance "eimsaim", status READY, has 3 handler(s) for this service...
Service "eimstest" has 1 instance(s).
Instance "eimstest", status UNKNOWN, has 1 handler(s) for this service...
Service "eimstest.world" has 1 instance(s).
Instance "eimstest", status READY, has 6 handler(s) for this service...
The command completed successfully

>lsnrctl service listener23

LSNRCTL for HPUX: Version 9.2.0.6.0 - Production on 17-JUL-2009 11:32:56

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC23 )))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "eimsaim" has 1 instance(s).
Instance "eimsaim", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "eimsaim.world" has 1 instance(s).
Instance "eimsaim", status READY, has 3 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
"D001" established:890 refused:0 current:0 max:2026 state:ready
DISPATCHER <machine: cmisux02, pid: 23510>
(ADDRESS=(PROTOCOL=tcp)(HOST=xxxxxx.yyyy.zzzzz.on. ca)(PORT=60398))
"D000" established:1027 refused:0 current:1 max:2026 state:ready
DISPATCHER <machine: cmisux02, pid: 23508>
(ADDRESS=(PROTOCOL=tcp)(HOST=xxxxx.yyyy.zzzzz.on.c a)(PORT=60396))
Service "eimstest" has 1 instance(s).
Instance "eimstest", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "eimstest.world" has 1 instance(s).
Instance "eimstest", status READY, has 6 handler(s) for this service...
Handler(s):
"D004" established:120 refused:0 current:16 max:2026 state:ready
DISPATCHER <machine: cmisux02, pid: 6353>
(ADDRESS=(PROTOCOL=tcp)(HOST=xxxxx.yyyy.zzzzz.on.c a)(PORT=49626))
"D003" established:198 refused:0 current:16 max:2026 state:ready
DISPATCHER <machine: cmisux02, pid: 6351>
(ADDRESS=(PROTOCOL=tcp)(HOST=xxxxx.yyyy.zzzzz.on.c a)(PORT=49625))
"D002" established:202 refused:0 current:16 max:2026 state:ready
DISPATCHER <machine: cmisux02, pid: 6349>
(ADDRESS=(PROTOCOL=tcp)(HOST=xxxxx.yyyy.zzzzz.on.c a)(PORT=49624))
"D001" established:530 refused:0 current:1 max:2026 state:ready
DISPATCHER <machine: cmisux02, pid: 6347>
(ADDRESS=(PROTOCOL=tcp)(HOST=xxxxx.yyyy.zzzzz.on.c a)(PORT=49623))
"D000" established:489 refused:0 current:0 max:2026 state:ready
DISPATCHER <machine: cmisux02, pid: 6345>
(ADDRESS=(PROTOCOL=tcp)(HOST=xxxxx.yyyy.zzzzz.on.c a)(PORT=49621))
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
The command completed successfully

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\manjit>tnsping eimstest

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 17-JUL-2
009 11:37:54

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
C:\Ora1020\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = xxxxx.yyyy.zzzzz.on.ca)(PORT = 2261)) (CONNECT_DATA = (SERVER = SHARED) (SID = eimstest)))
OK (160 msec)

Thanks

I just figured it out.....port number was out of sync between the listener and the tnsnames files. We had switched it recently

Thanks for your help as it guided me to the right path

Just curious, why are you using non standard ports for your oracle listeners?

It was a security requirement after an audit

>It was a security requirement after an audit
Security by obscurity only slows down the most lazy.

Windows
Utility above will identify listener port in 1 execution.