Re: configuring 8i for remote procedure calls

From: Ed Stevens <Ed.Stevens_at_nmm.nissan-usa.com>
Date: Thu, 09 Sep 1999 13:22:29 GMT
Message-ID: <7r8ca9$b4n$1@nnrp1.deja.com>

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_at_brinkley.rutgers.edu>, "Niels Voorhoeve" <nvoorhoeve_at_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. Received on Thu Sep 09 1999 - 08:22:29 CDT