-
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
-
-
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
-
Help PLS
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|