connect as SYS or SYSTEM ??
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: connect as SYS or SYSTEM ??

Hybrid View

  1. #1
    Join Date
    Sep 2001
    Posts
    76
    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




  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    as sys always, sys is the data dictionary owner

  3. #3
    Join Date
    Sep 2001
    Posts
    76
    Thanks Pando

  4. #4
    Join Date
    Sep 2001
    Posts
    76
    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







  5. #5
    Join Date
    Sep 2001
    Posts
    76

    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



  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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


  7. #7
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372
    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

  8. #8
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    Hi,

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

  9. #9
    Join Date
    Sep 2001
    Posts
    76
    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

  10. #10
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    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
  •  


Click Here to Expand Forum to Full Width