Re: Oracle 9i client 10g database

From: Jay <me_at_heyjay.com>
Date: Sun, 11 Apr 2004 23:55:34 -0500
Message-ID: <j76cnRyj2q_Gvufd3cwC-g@speakeasy.net>

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:opr6bt1lmv3d8uqx_at_news.optusnet.com.au...
> 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-
> ===========================================

Well, I know that I'm at least doing my names resolution, but I'm not finding my listener at the other end. Here is a listing of the files:

# on the server
SQL> select * from global_name;

GLOBAL_NAME

---

---

TSPRD $ cat listener.ora

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/oracle/product/10.1.0.2)
      (PROGRAM = extproc)

    )
    (SID_DESC =

      (GLOBAL_DBNAME = tsprd)
      (ORACLE_HOME = /opt/oracle/product/10.1.0.2)
      (SID_NAME = tsprd)

    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))     )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = abba)(PORT = 1521))     )
  )

$ cat tnsnames.ora
# Generated by Oracle configuration tools.

TSPRD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = abba)(PORT = 1521))     (CONNECT_DATA =

      (SERVER = DEDICATED)
      (SERVICE_NAME = tsprd)

    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))     )
    (CONNECT_DATA =

      (SID = PLSExtProc)
      (PRESENTATION = RO)

    )
  )

## now on the client

cat tnsnames.ora
# TNSNAMES.ORA Network Configuration File: /opt/oracle/product/901/network/admin/tnsnames.ora # Generated by Oracle configuration tools.

tsprd =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = abba)(PORT = 1521))     )
    (CONNECT_DATA =
      (SERVICE_NAME = tsprd)
    )
  ) Received on Sun Apr 11 2004 - 23:55:34 CDT