Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Infamous ORA-06553

Re: Infamous ORA-06553

From: Hemant K Chitale <hkchital_nospam_at_singnet_nospam.com.sg>
Date: Tue, 5 Mar 2002 22:14:38 +0800
Message-ID: <a62k2f$rrb$1@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 Tue Mar 05 2002 - 08:14:38 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US