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

I'd start by checking ALL my tnsnames.ora and sqlnet.ora files. When installed in its own Oracle home, as it should be, OAS brings a lot of Oracle stuff along with it. OAS has its own RMAN for example. But what is important, is that OAS has its own tnsnames.ora and sqlnet.ora. These have to be configured like you did for your Oracle tnsnanmes.ora and sqlnet.ora. The OAS versions are probably version 8.0 so you may want to fall back on SIDs rather than service names.

Van

Warnke Wittrock <warnke.wittrock_at_dbitc.de> wrote in message news:8eu3fg$apc$1_at_nnrp1.deja.com...
> 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.
Received on Fri May 05 2000 - 00:00:00 CDT