8i external procedures and 9i listener configuration issues

pts.
Tags:
Oracle
I currently have 2 versions of Oracle, 81740 and 92050, on an HP unix box (11.11 64bit). Callouts to 8i external procedures have been working fine with the 8i listener. Recently the 9i listener was brought up. In the 8i listener.ora, we were able to define 2 seperate external procedure SIDs, PLS81740 and PLS81720, and successfully execute the external procs from 2 different $OH. When switching over to the 9i listener, trying to point to 2 $OH (81740, 92050)for the external procedures; the 8i external procedures no longer work resulting in an ORA-28575 and ORA-12500 errors. Does anyone know why this might be happening? Is it a difference between 64bit and 32bit Oracle? Any thoughts to a solution? I have also opened a TAR with Oracle regarding this issue. Regards, Kathy

Answer Wiki

Thanks. We'll let you know when a new response is added.

The resolution to this issue was to use 2 listeners (8i,9i)using 2 different ports. This allowed each version of extproc to find the corresponding executables.

Here is a sample of the listener.ora for 9i; 8i listener.ora is the same except for the ENVS clause and the extproc executables defined. A tnsnames.ora file is also needed.

17:57, 31 July 2007 (CDT)17:57, 31 July 2007 (CDT)17:57, 31 July 2007 (CDT)17:57, 31 July 2007 (CDT)17:57, 31 July 2007 (CDT)17:57, 31 July 2007 (CDT)[[User:12.148.252.66|12.148.252.66]]
LSNR9.2.0.5.0=
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL = TCP)(HOST = tickets)(PORT = 1522))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = IPC)(KEY = V9205))
)
SID_LIST_LSNR9.2.0.5.0 =
(SID_LIST =
(SID_DESC =
(SID_NAME = V9205)
(ORACLE_HOME = /d01/app/oracle/product/9.2.0.5.0)
)
(SID_DESC =
(SID_NAME = PLS92050)
(ORACLE_HOME = /d01/app/oracle/product/9.2.0.5.0)
(PROGRAM = extproc32)
(ENVS = ‘EXTPROC_DLLS=ANY,SHLIB_PATH=/d01/app/oracle/product/9.2.0.5.0/lib
32,SSABIN=/usr/local/ssatop/bin18200/bin,SSALIB=/usr/local/ssatop/bin18200/lib,S
SATOP=/usr/local/ssatop/bin18200,PERLHOME=/usr/local/perl,PERL5LIB=/usr/local/pe
rl/lib,PATH=.:/home/users/ext_proc:/d01/app/oracle/product/9.2.0.5.0/bin:/usr/bi
n:/usr/local/bin:/usr/lib’)
)
)

Tnsnames
# TNSNAMES.ORA Network Configuration File: /d01/app/oracle/product/9.2.0.5.0/net
work/admin/tnsnames.ora
# Generated by Oracle configuration tools.
EXTPROC_CONNECTION_DATA.adpc.purdue.edu =
(DESCRIPTION =
(ADDRESS_LIST=
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLS92050)
(PRESENTATION= RO)
)
)
V9205.adpc.prudue.edu
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = tickets)(PORT=1522))
(CONNECT_DATA = (SID = V9205))
)

Regards,
Kathy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following