| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: External Procedures and Linux
Looks good... The only difference is that in the listener.ora we have
the full path for the PROGRAM parameter, e. g.=20
PROGRAM =3D /u01/app/oracle/product/9.2/bin/extproc=20
I wouldn't think it would make a difference so barking up the wrong tree and probably an HPUX to Linux compile issue. You may need to set some obtuse compiler flag or more likely there's a not too obvious library dependency. For example, according to our C guru dweeb, we often need to include libpthread even if we're not doing threads. Sounds like a C bit twiddling exercise is in the making.=20
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Goulet, Dick
Sent: Friday, June 25, 2004 9:19 AM
To: oracle-l_at_freelists.org
Subject: RE: External Procedures and Linux
Steve,
TNSNAMES:
EXTPROC_CONNECTION_DATA.WORLD =3D3D
(DESCRIPTION =3D3D
(ADDRESS =3D3D(PROTOCOL =3D3D IPC)(KEY =3D3D extkey))
(CONNECT_DATA =3D3D (SID =3D3D 12))
)
Listener:
LISTENER =3D3D
(DESCRIPTION_LIST =3D3D
(DESCRIPTION =3D3D
(ADDRESS =3D3D (PROTOCOL =3D3D IPC)(KEY =3D3D 02))
)
(DESCRIPTION =3D3D
(ADDRESS=3D3D(PROTOCOL =3D3D IPC)(KEY =3D3D extkey))
)
(DESCRIPTION =3D3D
(ADDRESS =3D3D (PROTOCOL =3D3D TCP)(HOST =3D3D pelton)(PORT =3D3D =
1521))
)
)
SID_LIST_LISTENER =3D3D
(SID_LIST =3D3D
(SID_DESC =3D3D
(SDU =3D3D 4096)
(TDU =3D3D 4096)
(GLOBAL_DBNAME =3D3D pelton2.world)
(SID_NAME =3D3D 02)
(ORACLE_HOME =3D3D /ora1/oracle/ora92)
(PRESPAWN_MAX =3D3D 10)
)
(SID_DESC=3D3D
(SID_NAME =3D3D 12)
(ORACLE_HOME =3D3D /ora1/oracle/ora92)
(PROGRAM =3D3D extproc)
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: Orr, Steve [mailto:sorr_at_rightnow.com]
Sent: Friday, June 25, 2004 10:27 AM
To: oracle-l_at_freelists.org
Subject: RE: External Procedures and Linux
We had an external C program running on O 8.1.7 / RH 7.2 but now we're on O 9.2 / AS 3.0 and we're not using it any more. I recall there were problems getting it working. Can you post the salient entries in your tnsnames.ora and listener.ora so I can compare them?=3D3D20
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Goulet, Dick
Sent: Friday, June 25, 2004 8:17 AM
To: Oracle DBA List (E-mail)
Subject: External Procedures and Linux
Is there anyone running Oracle 9.2.0.4 on Red Hat AS 3.0 and using =
=3D3D3D
external procedure calls? I'm having one heck of a time with it & am =
=3D
=3D3D =3D3D3D sure I messed something simple up. I use them a lot on =
HP-UX,
but I =3D =3D3D3D just can't get Linux running, always end up with:
select oracheck_functions.ext_proc_up from dual
*
ERROR at line 1:
ORA-28575: unable to open RPC connection to external procedure agent ORA-06512: at "SYSTEM.ORACHECK_FUNCTIONS", line 23 ORA-06512: at line 1
Looks like a listener or tnsnames config problem, but those are =3D3D3D identical to what I use on HP. Any ideas??
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Fri Jun 25 2004 - 11:09:40 CDT
 |
 |