External Procedures

From: Murali <hatwarm_at_yahoo.com>
Date: 12 Aug 2002 14:04:26 -0700
Message-ID: <e918b233.0208121304.50efce60@posting.google.com>

Hello There,
I am trying to call external procedures from within PL/SQL on Oracle 8.1.7 on Linux.

I was successful in doing this on a development machine which hosts only one instance and one database.

But when I tried to do the same on the production machine which has three databases on the same instance of Oracle I get a ORA-28575 error.

I am including the Listener.ora and tnsnames.ora. Can someone give me an insight as to why I am getting this error..

TNSNAMES.ORA
EXTPROC_CONNECTION_DATA.MYCO.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)

    )
  )

INST1_HTTP.MYCO.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = asp1)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = asp.myco)
(PRESENTATION = http://admin)

    )
  )

ASP.MYCO.COM=
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = asp1)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = asp.myco)

    )
  )

STARS.MYCO.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = asp1)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = stars.myco)

    )
  )

STARS_D.MYCO.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = asp1)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = stars_d.myco)

    )
  )

LISTENER.ORA LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = asp1)(PORT = 1521))
      )


      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )

)
)

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/8.1.7)
(PROGRAM = extproc)

    )
    (SID_DESC =
(GLOBAL_DBNAME = asp.myco)
(ORACLE_HOME = /oracle/8.1.7)
(SID_NAME = asp)

    )
   (SID_DESC =

     (GLOBAL_DBNAME = stars.myco)
     (ORACLE_HOME = /oracle/8.1.7)
     (SID_NAME = stars)

)
(SID_DESC =

     (GLOBAL_DBNAME = stars_d.myco)
     (ORACLE_HOME = /oracle/8.1.7)
     (SID_NAME = stars_d)

)
)

Thanks in advance......... Received on Mon Aug 12 2002 - 16:04:26 CDT