Re: Oracle 9i client 10g database

On Sun, 11 Apr 2004 23:17:53 -0500, Jay <me_at_heyjay.com> wrote:

> Hi,
>
> I looked for a thread (and I'd think this would have been a common one),
> can
> you connect a 9i sqlnet client to a 10g database?

Yes you can.

> From my 9i client box I keep getting :
>
>> sqlplus jstrauss/jstrauss_at_tsprd
>
> SQL*Plus: Release 9.0.1.0.0 - Production on Sun Apr 11 23:15:33 2004
>
> (c) Copyright 2001 Oracle Corporation. All rights reserved.
>
> ERROR:
> ORA-12541: TNS:no listener
>
> Whereas the same thing works on the 10g box
>
> ~$ sqlplus jstrauss/jstrauss_at_tsprd
>
> SQL*Plus: Release 10.1.0.2.0 - Production on Sun Apr 11 23:15:37 2004
>
> Copyright (c) 1982, 2004, Oracle. All rights reserved.

Irrelevant really, that it works on one box and not on another. Are the tnsnames on both boxes identical?

Does your tnsnames on the box that doesn't work correctly reference the right server, use the right protocol and talk to the right port? 12541 means that somewhere along the line, your client is not actually finding a listener whenever it ends up at wherever it's been directed to end up.

Regards
HJR

-- 
-------------------------------------------
Dizwell Informatics: http://www.dizwell.com
  -A mine of useful Oracle information-
          -Windows Laptop Rac-
    -Oracle Installations on Linux-
===========================================