Oracle 9i listener vs Oracle 8i extproc

From: Frederic Payant <fpayant_at_club-internet.fr>
Date: Mon, 15 Jul 2002 22:29:36 +0200
Message-ID: <0kb6juspvvookau2vuqipcjgu73n5immjd@4ax.com>

Hi,

We are trying to install Oracle 9i/Oracle reports on a solaris 8 server where Oracle 817 instances are already runing

Oracle doc says that we must use Oracle 9i listener what we've done but since we install this listener, our external procedures on 8.1.7 databases don't work anymore, falling with a "ORA-28576: lost RPC connection to external procedure agent" error.

You'll find below my .ora files.
My main question is : is there any issue in using oracle 9i "extproc" with 8i database ?

Are there specific entries to add to .ora files ?

Thanks you all for your help

Frederic PAYANT

NOTA :
-> I'm sure to use these files (there is no other one on my server)
-> I can run manually extproc from oracle 8i or from oracle 9i user but only from themselves (if I run oracle 9i extproc from oracle 8i user i get a core dump)

$ cat sqlnet.ora
# SQLNET.ORA Network Configuration
File: /product/oracle/moteur/8.1.7/network/admin/sqlnet.ora # Generated by Oracle configuration tools.

NAMES.DEFAULT_DOMAIN = boulot.com

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) $ cat tnsnames.ora

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

PINDB999.boulot.com =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ride)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = PINDB999.ride.boulot.com)
    )
  )

EXTPROC_CONNECTION_DATA.boulot.com =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)

    )
  )

$ cat listener.ora

# LISTENER.ORA Network Configuration 
# File: /product/oracle/moteur/9.0.2/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ride.boulot.com)
(PORT = 1521))
    )
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ride.boulot.com)
(PORT = 2481))
(PROTOCOL_STACK =

        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )

)
)

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /product/oracle/moteur/9.0.2)
(PROGRAM = extproc)

    )
    (SID_DESC =
(GLOBAL_DBNAME = PINDB999.ride.boulot.com)
(ORACLE_HOME = /product/oracle/moteur/8.1.7)
(SID_NAME = PINDB999)

    )
  )

Regards
Frederic PAYANT - junior DBA ;-) Received on Mon Jul 15 2002 - 15:29:36 CDT