ORA-28575 on 10g on win 2000

From: Chris Martin <cmartin97_at_hotmail.com>
Date: Sun, 19 Sep 2004 18:06:59 -0500
Message-ID: <oMCdndPj4cuBjNPcRVn-uw@comcast.com>

We upgraded from 8.1.7 to 10g and I can't get this issue resolved. I saw that in 9.2 there was a change where ext proc dlls must be in the ORACLE_HOME\bin directory. I did that and still can't get it running. Any help would be greatly appreciated.

Thanks

Chris

Error:

ORA-28575: unable to open RPC connection to external procedure agent

listener.ora:

# listener.ora Network Configuration File: C:\oracle\product\10.1.0\Db_1\network\admin\listener.ora # Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ENVS="EXTPROC_DLLS='C:\Oracle\product\10.1.0\Db_1\BIN\oraGMTPackage.dll'")
(ORACLE_HOME = C:\Oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)

    )
  )

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =

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


      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = FlightOps.bitwise.com)(PORT = 
1521))
      )

)
)

tnsnames.ora:

# tnsnames.ora Network Configuration File: C:\oracle\product\10.1.0\Db_1\network\admin\tnsnames.ora # Generated by Oracle configuration tools.

FLIGHTOPS =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = FlightOps.bitwise.com)(PORT = 1521))     (CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)

    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)

    )
  )

sqlnet.ora

# sqlnet.ora Network Configuration File: C:\oracle\product\10.1.0\Db_1\network\admin\sqlnet.ora # Generated by Oracle configuration tools.

#SQLNET.AUTHENTICATION_SERVICES= (NONE) #NAMES.DIRECTORY_PATH= (TNSNAMES) Received on Sun Sep 19 2004 - 18:06:59 CDT