Infamous ORA-06553

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,

1. Fuentes

afuentes_at_goodpremises.com

512-297-9937 Received on Tue Mar 05 2002 - 02:00:09 CST