From: Warnke Wittrock Subject: Re: OAS: Cannot create a PL/SQL Application - Please help! Date: 2000/05/05 Message-ID: <8eu3fg$apc$1@nnrp1.deja.com>#1/1 References: <8es8dr$8e2$1@nnrp1.deja.com> <09d2b6c0.a8cff011@usw-ex0105-036.remarq.com> X-Http-Proxy: 1.0 CLEOPATRA.DBITCONSULTING:3128 (Squid/2.2.STABLE3), 1.0 x37.deja.com:80 (Squid/1.1.22) for client 192.168.255.4, 149.228.43.30 Organization: Deja.com - Before you buy. X-Article-Creation-Date: Fri May 05 09:15:36 2000 GMT X-MyDeja-Info: XMYDJUIDwwittrock Newsgroups: comp.databases.oracle.misc X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt) In article <09d2b6c0.a8cff011@usw-ex0105-036.remarq.com>, Van Messner 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.