Xref: alice comp.databases.oracle.misc:49125
Path: alice!news-feed.fnsi.net!netnews.com!newshub.northeast.verio.net!verio!news-peer.gip.net!news-fw.gip.net!news.gsl.net!gip.net!news!not-for-mail
From: Harlin Setiadarma <harlins@bigfoot.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: interMedia Clipboard TNS error on set procedure.  Help!!!
Message-ID: <c3u85s0r71etoho5e8hb5q1ms95v1ah16b@4ax.com>
References: <MPG.12bb04de317c472989682@news.pacbell.net>
X-Newsreader: Forte Agent 1.7/32.534
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 65
Date: Mon, 13 Dec 1999 11:49:43 +0700
X-Trace: news 945085609 202.154.8.244 (Mon, 13 Dec 1999 04:46:49 GMT)
NNTP-Posting-Date: Mon, 13 Dec 1999 04:46:49 GMT
Organization: RADnet

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@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