Results 1 to 9 of 9
  1. #1
    Join Date
    Jul 2009
    Posts
    7

    Question Unanswered: Connecting to 9i database using 10g Client

    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

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    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_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Jul 2009
    Posts
    7
    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

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    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
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jul 2009
    Posts
    7
    >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

  6. #6
    Join Date
    Jul 2009
    Posts
    7
    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

  7. #7
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Just curious, why are you using non standard ports for your oracle listeners?
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  8. #8
    Join Date
    Jul 2009
    Posts
    7
    It was a security requirement after an audit

  9. #9
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >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.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •