MTS, External Proc & ORA-28575

From: Адаменко Сергей <adamenko_at_i.com.ua>
Date: Sat, 13 Apr 2002 00:44:05 +0300
Message-ID: <a97kef$1rhe$3@news.dg.net.ua>

Hi All!

I have the following problem:
Oracle running in MTS, raises "ORA-28575: unable to open RPC connection to external procedure agent" when I'm trying to execute an external procedure. Tuning off MTS or using SERVER=DEDICATED in corresponding for corresponding TNS-name - and everything works fine.
How need I to setup the exemplar, LISTENER, or TNSNAMES, so that I didn't care is it DEDICATED or SHARED server dispatches the session?

Here follows my current configuration:
OS: W2000 SP2
Oracle EE 8.1.7

---

• initoraSID ******************************

  ---

  db_name = "oraasv" instance_name = oraasv service_names = oraasv db_files = 1024 control_files = ("C:\oracle\oradata\oraasv\control01.ctl", "C:\oracle\oradata\oraasv\control02.ctl", "C:\oracle\oradata\oraasv\control03.ctl") open_cursors = 300 max_enabled_roles = 30 db_file_multiblock_read_count = 8 db_block_buffers = 5120 shared_pool_size = 96M large_pool_size = 614400 java_pool_size = 0 log_checkpoint_interval = 10000 log_checkpoint_timeout = 1800 processes = 32 parallel_max_servers = 5 log_buffer = 32768 max_dump_file_size = 10240 # limit trace file size to 5M each global_names = true oracle_trace_collection_name = "" background_dump_dest = C:\oracle\admin\oraasv\bdump user_dump_dest = C:\oracle\admin\oraasv\udump db_block_size = 8192 remote_login_passwordfile = exclusive

MTS_DISPATCHERS="(PROTOCOL = TCP)(DISPATCHERS=4)(SESSIONS=16)" os_authent_prefix = ""
distributed_transactions = 10
compatible = 8.1.0
sort_area_size = 524288
sort_area_retained_size = 65536

---

• LISTENER.ORA ************************

  ---

  LISTENER = (DESCRIPTION_LIST = (DESCRIPTION =
  (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = asv)(PORT = 1521)) )
  (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) ) )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora81)
(PROGRAM = extproc)

    )
    (SID_DESC =
(GLOBAL_DBNAME = oraasv)
(ORACLE_HOME = C:\oracle\ora81)
(SID_NAME = oraasv)

    )
  )

---

• TNSNAMES.ORA ************************

  ---

  ORA_ASV = (DESCRIPTION = (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
  ) (CONNECT_DATA =
  (SERVICE_NAME = oraasv)
  ) )

ORA_ASV_DEDICATED =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = oraasv)
(SERVER=DEDICATED)

    )
  )

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

    )
  )

With respect,
Serget Adamenko
E-Mail: asv_at_softline.kiev.ua Received on Fri Apr 12 2002 - 16:44:05 CDT