Re: MTS, External Proc/Oracle COM Automation Feature & ORA-28575

From: Адаменко Сергей <adamenko_at_i.com.ua>
Date: Wed, 17 Apr 2002 22:23:11 +0300
Message-ID: <a9ki6i$9fq$4@news.dg.net.ua>

Hi to all!
Finally I was told the solution on news:fido7.ru.rdbms.oracle . Special thanks to Stas Antonov <hcat_at_hypersoft.ru>

The solution is to configure a separate listener that will handle external calls. Protocol of the listener could be IPC or TCP - as to my testing. Although Stas has sad there were problems again using IPC and the second listener he set up to use TCP.

The steps to configure the second listener: Stop any listener running.
1. Modify LISTENER.ORA:

     add EXTPROCLISTENER and   SID_LIST_EXTPROCLISTENER
     (see below);  comment out in SID_LIST_LISTENER strings regarding
     PLSExtProc;

2. Modify TNSNAMES.ORA, replacing

    EXTPROC_CONNECTION_DATA with appropriate setting (see below) 3. Run LSNRCTL and issue command "start EXTPROCLISTENER"; 4. Run "start LISTENER"

Best regards,
Sergey Adamenko
E-Mail: asv_at_softline.kiev.ua or adamenko_at_i.com.ua ICQ: 71407143

---

---

---------------------------------#
LISTENER.ORA------------------------------------
 ---------------------------------------------------------------------------

---

# LISTENER.ORA Network Configuration File: C:\oracle\ora81\network\admin\listener.ora # Generated by Oracle configuration tools.

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)

    )
  )

EXTPROCLISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(HOST = asv)(PORT = 1529))
    )
  )
SID_LIST_EXTPROCLISTENER =
  (SID_LIST =
    (SID_DESC =
(PROGRAM = ExtProc)
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora81)

    )
  )

---

-
---------------------  TNSNAMES.ORA  --------------------------------
----------------------------------------------------------------------------
-

# TNSNAMES.ORA Network Configuration File: C:\Oracle\ora81\NETWORK\ADMIN\tnsnames.ora # Generated by Oracle configuration tools.

ORAASV =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = asv)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = oraasv)

    )
  )

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

    )
  )

INST1_HTTP =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = asv)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = oraasv)
(PRESENTATION = http://admin)

    )
  )

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

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = asv)(PORT = 1529))
    )
    (CONNECT_DATA =
(SID = PLSExtProc)

    )
  )

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

    )
  ) Received on Wed Apr 17 2002 - 14:23:11 CDT