connect as SYS or SYSTEM ??

Hi Friends,

to run catalog.sql,catproc.sql,catexp7.sql in the newly created 8.1.7 database ,should i connect as SYS or SYSTEM and run them?

i ran them connected as system, and i got the error
ORA-06553: PLS-213: package STANDARD not accessible


thanks

as sys always, sys is the data dictionary owner

Thanks Pando

I still get that error

ora-06553, PLS-213 package STANDARD not accessible

i blew up the 8.1.7 database, recreated it again
went to,

sqlplus SYS/passwd

from there i ran the catalog.sql and catproc.sql

or should i run it from svrmgrl>@/u01/oracle/prodora/8.0.6/rdbms/admin/catalog.sql


Thanks

I still get that error

ora-06553, PLS-213 package STANDARD not accessible

i blew up the 8.1.7 database, recreated it again
went to,

svrmgrl>

from there i ran the catalog.sql and catproc.sql
svrmgrl>@/u01/oracle/prodora/8.0.6/rdbms/admin/catalog.sql

well dont run catalog then, run standard.sql first and see what error do you get.

set echo on
@$ORACLE_HOME/rdbms/admin/standard.sql

Did you upgrade your database from another version? If so, you need to re-run the appropriate upgrade script (for example, u0801060.sql if upgrading from 8.1.6) and make sure to set _system_trig_enabled=false before running the script.
Hope this help.
Jean Richard

Hi,

Why not let the CD installer complete your installation?
specificically the DB creation.

I ran the rapid install in oracle applications 11.5.5 . I have to manually create the 8.1.7 database, which I did. Now i had to run those 3 cat... scripts.
after that i had to import 7.3.4 database into this 8.1.7

Hi,

I guess you have to go detail or low level debugging by checking those catalog scripts and run them line by line(by program) until you hit the exact program that gives you
that specific error

this time before running catalog.sql,
i blew up the 8.1.7 database, recreated it again
went to
@$ORACLE_HOME/rdbms/admin/standard.sql


i still get ora-06553, PLS-213 package STANDARD not accessible

what to do ?

thanks