Xref: alice comp.databases.oracle.server:65117
Path: alice!news-feed.fnsi.net!newsfeed.direct.ca!newspeer.monmouth.com!nntp2.deja.com!nnrp1.deja.com!not-for-mail
From: Ed Stevens <Ed.Stevens@nmm.nissan-usa.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: configuring 8i for remote procedure calls
Date: Thu, 09 Sep 1999 13:22:29 GMT
Organization: Deja.com - Share what you know. Learn what you don't.
Lines: 95
Message-ID: <7r8ca9$b4n$1@nnrp1.deja.com>
References: <7r6t3f$q2r$1@brinkley.rutgers.edu>
X-Article-Creation-Date: Thu Sep 09 13:22:29 1999 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 4.01; Windows NT)
X-Http-Proxy: 1.0 NMMSIT02, 1.0 x23.deja.com:80 (Squid/1.1.22) for client 209.64.87.68
X-MyDeja-Info: XMYDJUIDnmmc

What are the failure symptoms you're getting?  We have an open TAR w/
Oracle on this issue.  Specifically, there is an identified bug with
RPC's that link to other sids.  I'm still trying to get a grasp on all
of the details because I'm picking up the issue after another DBA here
discovered the problem, opened the TAR, then took another job.  E-mail
me and I will give you some more detail.

In article <7r6t3f$q2r$1@brinkley.rutgers.edu>,
  "Niels Voorhoeve" <nvoorhoeve@ftpoint.com> wrote:
> Hi,
>
> I'm having a hell of a time figuring out how to edit the listener.ora
and
> tnsnames.ora files to support remote procedure calls (can't use
intermedia
> w/o this ).  Can anyone spot the problem with my files?
>
> # LISTENER.ORA Configuration
> File:/opt/oracle/product/8.1.5/network/admin/listener.ora
> # Generated by Oracle Net8 Assistant
>
> LISTENER2 =
>  (DESCRIPTION_LIST =
>   (DESCRIPTION =
>     (ADDRESS_LIST =
>       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
>     )
>     (ADDRESS_LIST =
>       (ADDRESS = (PROTOCOL = TCP)(HOST = minime)(PORT = 1521))
>     (PROTOCOL_STACK =
>       (PRESENTATION = TTC)
>       (SESSION = NS)
>     )
>    )
>   )
>  )
> STARTUP_WAIT_TIME_LISTENER = 0
> CONNECT_TIMEOUT_LISTENER = 10
> TRACE_LEVEL_LISTENER = 0
>
> SID_LIST_LISTENER2 =
>   (SID_LIST =
>     (SID_DESC =
>       (GLOBAL_DBNAME = arden.domain)
>       (ORACLE_HOME = /opt/oracle/product/8.1.5)
>       (SID_NAME = ARDEN)
>     )
>     (SID_DESC =
>       (GLOBAL_DBNAME = Oracle8.)
>       (ORACLE_HOME = /opt/oracle/product/8.1.5)
>       (SID_NAME = ORCL)
>     )
>     (SID_DESC =
>  (SID_NAME = PLSExtProc)
>  (ORACLE_HOME = /opt/oracle/product/8.1.5)
>  (PROGRAM = extproc)
>     )
>   )
>
> # TNSNAMES.ORA Configuration
> File:/opt/oracle/product/8.1.5/network/admin/tnsnames.ora
> # Generated by Oracle Net8 Assistant
>
> ARDEN =
>   (DESCRIPTION =
>     (SOURCE_ROUTE = OFF)
>     (ADDRESS_LIST =
>       (ADDRESS = (PROTOCOL = TCP)(HOST = minime)(PORT = 1521))
>     )
>     (CONNECT_DATA =
>       (SERVICE_NAME = arden.domain)
>     )
>   )
>
> EXTPROC_CONNECTION_DATA =
>   (DESCRIPTION =
>     (ADDRESS_LIST =
>       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
>     )
>     (CONNECT_DATA =
>       (SID = PLSExtProc)
>       (PRESENTATION = RO)
>     )
>   )
>
>

--
Ed Stevens
(Opinions are not necessarily those of my
employer)


Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.