RE: External Procedures and Linux

Steve,

TNSNAMES:

EXTPROC_CONNECTION_DATA.WORLD =3D
(DESCRIPTION =3D
   (ADDRESS =3D(PROTOCOL =3D IPC)(KEY =3D extkey))
   (CONNECT_DATA =3D (SID =3D 12))
)

Listener:

LISTENER =3D
  (DESCRIPTION_LIST =3D
    (DESCRIPTION =3D
      (ADDRESS =3D (PROTOCOL =3D IPC)(KEY =3D 02))
    )
    (DESCRIPTION =3D
       (ADDRESS=3D(PROTOCOL =3D IPC)(KEY =3D extkey))
    )
    (DESCRIPTION =3D
      (ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D pelton)(PORT =3D 1521))
    )
  )

SID_LIST_LISTENER =3D
  (SID_LIST =3D
    (SID_DESC =3D
      (SDU =3D 4096)
      (TDU =3D 4096)
      (GLOBAL_DBNAME =3D pelton2.world)
      (SID_NAME =3D 02)
      (ORACLE_HOME =3D /ora1/oracle/ora92)
      (PRESPAWN_MAX =3D 10)
    )
    (SID_DESC=3D
        (SID_NAME =3D 12)
        (ORACLE_HOME =3D /ora1/oracle/ora92)
        (PROGRAM =3D extproc)
    )
  )

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
From: Orr, Steve [mailto:sorr@xxxxxxxxxxxx]
Sent: Friday, June 25, 2004 10:27 AM
To: oracle-l@xxxxxxxxxxxxx
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?=3D20



-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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 =3D3D
external procedure calls?  I'm having one heck of a time with it & am =
=3D
=3D3D
sure I messed something simple up.  I use them a lot on HP-UX, but I =
=3D3D
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 =3D3D
identical to what I use on HP.  Any ideas??

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx 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@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: