Re: OAS: Cannot create a PL/SQL Application - Please help!

Since OAS is in a seperate home, it will need it's own .ora files to establish connections. Copy the SQLNET.ORA and TNSNAMES.ORA file from the main Oracle Home's Network\Admin directory into the corresponding directory under the OAS home. You should be able to use the connect string from that point forward.

In article <8eu3fg$apc$1_at_nnrp1.deja.com>,   Warnke Wittrock <warnke.wittrock_at_dbitc.de> wrote:
> In article <09d2b6c0.a8cff011_at_usw-ex0105-036.remarq.com>,
> Van Messner <vmessnerNOvmSPAM_at_discovernet.com.invalid> wrote:
> > Using the OAS Utilities from the OAS home page you need to
> > install the PL/SQL toolkit and the logger tables. It doesn't
> > hurt to do the log analyzer and database browser while you're
> > there.
> > Have you done this?
> >
> > Van
> >
>
> Well, I installed the PL/SQL Toolkit using the ORACLE_SID instead of a
> connect string, and it seemed to work though the OAS is in a different
> ORACLE_HOME than Oracle8i. Trying to use a connect string leads to
 ORA-
> 12203 ("TNS:unable to connect to destination"). In sqlnet.log, this is
> followed by TNS-12538, 12560, and 508.
> Trying to create a new DAD for the logger tables using a connect
 string
> leads to the same TNS error messages. I succeeded creating a DAD
> specifying only the ORACLE_SID. But trying to install the logger
 tables
> using this DAD leads to ORA-12203 again. In sqlnet.log I find 21 times
> TNS-12203, 12560, and 530 reported within 2 seconds, as it's trying to
> create tables without being connected. It says "Fatal NI connect error
> 12203, connecting to:
> (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)
> (ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=
> (PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=
> (PROGRAM=E:\Oracle\Oasnt\bin\SVRMGR30.EXE)(HOST=ACHILLES)
> (USER=SYSTEM))))", which contains the wrong protocol (beq instead of
> TCP), the wrong SID (ORCL instead of smpl) and Oracle 8.0 instead of
 8i.
>
> Can you help?
> Thanks
> Warnke
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue May 09 2000 - 00:00:00 CDT