Re: Infamous ORA-06553

From: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Wed, 6 Mar 2002 10:15:55 +0300
Message-ID: <a64fki$ei1$1@babylon.agtel.net>

You should also set _system_trig_enabled=false in init.ora and bounce the db and then

ALTER SESSION SET EVENTS '10520 TRACE NAME CONTEXT FOREVER, LEVEL 10'; before running catXXX scripts (if you're on 8i or later).

create or replace java system
/

is also due after you're done with catXXX and before you reset _system_trig_enabled back to true (or remove it from init.ora) and bounce the db again (if you need the JVM that is).

--
Vladimir Zakharychev (bob@dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.


"Hemant K Chitale" <hkchital_nospam_at_singnet_nospam.com.sg> wrote in message
news:a62k2f$rrb$1_at_coco.singnet.com.sg...


>

> Why are you doing the "get" ?

> The script files have multiple statements.

> You should execute them directly.

>

> sqlplus "/ as sysdba"  (or internal)

> SQL>@catalog

> SQL>@catproc

>

> Hemant K Chitale

>

> "Alvaro Fuentes" <alvarof2_at_hotmail.com> wrote in message

> news:dW_g8.52862$6j2.2993889_at_typhoon.austin.rr.com...

> >

> >

> > Fellow Oracle Netters:

> >

> > I am getting the ORA-06553, despite of the suggestions

> > from several members of this News Group of running:

> >

> > $ORACLE_HOME/rdbms/admin/standard.sql

> >

> > and

> >

> > $ORACLE_HOME/rdbms/admin/catproc.sql

> >

> > (The Platform is a SUN Ultra running the latest solaris 8 release, and

> > Oracle 9i Enterprise Server)

> >

> > An "Image" is woth thousand words:

> >

> >

> >

> > SQL> get standard.sql

> >

> > 1 @@stdspec.sql

> >

> > 2 @@stdbody.sql

> >

> > 3* grant execute on STANDARD to public;

> >

> > SQL> /

> >

> >

> >

> > ERROR at line 1:

> >

> > ORA-00900: invalid SQL statement

> >

> >

> >

> > SQL>

> >

> >

> >

> >

> >

> > Then I try to run individually the components of standard.sql:

> >

> >

> >

> >

> >

> > SQL> get stdspec.sql

> >

> > .........

> >

> > .........

> >

> > .........

> >

> > wn code as it may in future interfere with the package

> >

> > 2358 -- consistency maintenance mechanisms and could have dire results.

> >

> > 2359 --#### timestamp pragma (please keep this last)

> >

> > 2360 pragma TIMESTAMP('1999-08-25:00:00:00');

> >

> > 2361* end;

> >

> > 2362

> >

> > SQL> /

> >

> > ERROR at line 1:

> >

> > ORA-04045: errors during recompilation/revalidation of

> >

> > SYS.CDC_CREATE_CTABLE_BEFORE

> >

> > ORA-06508: PL/SQL: could not find program unit being called

> >

> > ORA-06512: at line 2

> >

> > ORA-06508: PL/SQL: could not find program unit being called

> >

> > ORA-06512: at line 2

> >

> >

> >

> >

> >

> >

> >

> > The same EXACT message after attempting to run the second (and last)

> >

> > standard.sql script: stdbody.sql.

> >

> >

> >

> >

> >

> > Now, if I try to run catproc.sql:

> >

> >

> >

> >

> >

> >

> >

> > SQL> get catproc.sql

> >

> > 407 @@dbmssjty.sql

> >

> > 408 @@prvtsjty.plb

> >

> > 409 Rem Data Guard recovery framework support (dbms_drs)

> >

> > 410 @@dbmsdrs.sql

> >

> > 411 @@prvtdrs.plb

> >

> > 412 Rem Replication catalog installation

> >

> > 413* @@catrep.sql

> >

> > 414

> >

> > SQL> /

> >

> > Enter value for prvttypu:

> >

> >

> >

> >

> >

> > And the script wont let you continue unless a "reasonable" value

> >

> > for prvttypu is entered. Any idea of what value may be appropriate here?

> >

> >

> >

> > Any light about these issues will be greatly appreciated.

> >

> >

> >

> > Regards,

> >

> >

> >

> > A. Fuentes

> >

> > afuentes_at_goodpremises.com

> >

> > 512-297-9937

> >

> >

> >

> >

> >

> >

> >

>

>

Received on Wed Mar 06 2002 - 01:15:55 CST