Re: OAS: Cannot create a PL/SQL Application

From: Warnke Wittrock <warnke.wittrock_at_dbitc.de>
Date: 2000/05/05
Message-ID: <8eu3fg$apc$1@nnrp1.deja.com>#1/1

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

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