Re: interMedia Clipboard TNS error on set procedure. Help!!!

From: Harlin Setiadarma <harlins_at_bigfoot.com>
Date: Mon, 13 Dec 1999 11:49:43 +0700
Message-ID: <c3u85s0r71etoho5e8hb5q1ms95v1ah16b@4ax.com>

Do you have setup the EXTPROC_CONNECTION_DATA in TNSNAMES.ORA ? And EXTPROC listener service + its SID in LISTENER.ORA ?

You can find that information in documentations.

Sample (from my db):
In LISTENER.ORA add this in LISTENER=

    (DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(PROTOCOL_STACK =

        (PRESENTATION = TTC)
        (SESSION = NS)
      )

    )

an add this in SID_LIST_LISTENER =

    (SID_DESC =
(GLOBAL_DBNAME = extproc)
(PROGRAM = extproc)
(SID_NAME = extproc)
(ORACLE_HOME = /u01/app/oracle/product/8.1.5)
    )

then in TNSNAMES.ORA add this :
EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (SOURCE_ROUTE = OFF)
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(Key = EXTPROC0))
    )
    (CONNECT_DATA =
(SID = extproc)

    )
  )

(the key "EXTPROC0" must be the same with key in LISTENER.ORA

Hope it helps.

Regards,
Harlin Setiadarma
Perkasa Pilar Utama, PT.
Technical Support Division

On Fri, 10 Dec 1999 12:39:33 -0000, rmcatlin_at_netpull.com (Richard Catlin) wrote:

>Upon updating an image into the database, I get this error:
>ORA-28575: unable to open RPC Connection to external procedure agent
>ORA-12154: TNS: could not resolve service name
>ORA-06512: at "ORDSYS.ORDIMG_PKG", line 420
>ORA-06512: at "ORDSYS.ORDIMAGE", line 25
>ORA-06512: at "SET_PRODUCT_PIC", line 23
>ORA-06512: at line 1
>
>any ideas?  It obviously had to connect to the database to display the 
>image which is being updated.
>
>Any ideas?

• Harlin

You see but you do not observe,
You hear but you do not observe.
-- Thomas Sherlock Scott Holmes Received on Sun Dec 12 1999 - 22:49:43 CST