after db creation
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: after db creation

  1. #1
    Join Date
    Mar 2001
    Posts
    78
    Hai friends,
    I have created a new database and when trying to login thro' sql*plus it gives the folowing error.But the login succeeds.
    ERROR:
    ORA-06553: PLS-213: package STANDARD not accessible


    Error accessing package DBMS_APPLICATION_INFO
    ERROR:
    ORA-06553: PLS-213: package STANDARD not accessible

    what should I do.Please let me know.

    Thanks and regards.

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    How did you create your database. Looks like you haven't executed the catlog.sql and catproc.sql scripts.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Mar 2001
    Posts
    78
    Hai Sam,
    I ran those 2 scripts as internal immediately after creating the database.
    SELECT * FROM DBA_OBJECTS WHERE OWNER = 'SYS'
    AND OBJECT_NAME = 'STANDARD';
    the above query returns no rows.Should I run those 2 scripts again.

    Thanks .

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Try re-executing them, first the catlog.sql and then the catproc.sql

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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