Oracle 9i listener vs Oracle 8i extproc 
Author Message
 Oracle 9i listener vs Oracle 8i extproc

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 ;-)



Sat, 01 Jan 2005 04:29:36 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Oracle 8i Listener and Oracle 8i Listener

2. HELP: Oracle 8i vs 9i vs MS SQL 2000

3. Netcool issue: Oracle 8i TNS listener vulnerabality fixed on 9i

4. Oracle 8i or 9i vs SQL Server

5. Oracle 8i Standard vs. Oracle 8i Enterprise edition

6. Should I study Oracle 8i/9i or 9i directly/

7. Oracle 9i screwing up Oracle 8i?

8. Oracle 8i and Oracle 9i

9. Building Oracle 8i database with Oracle 9i

10. US-GA-ORACLE DEVELOPER WITH 8I+9I WITH ORACLE FORMS

11. Oracle 9i R2 vs Oracle Express 6.3

12. Oracle 8 vs Oracle 9i


 
Powered by phpBB® Forum Software