DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: STANDARD package is missing

  1. 06-22-2001, 04:20 PM #1
    dragon99
    dragon99 is offline Member
    Join Date
    Feb 2000
    Location
    New York,U.S.A.
    Posts
    245
    Hi,
    I have one database, when I log in it gives the following errors:

    SQL*Plus: Release 8.1.7.0.0 - Production on Fri Jun 22 16:18:20 2001

    (c) Copyright 2000 Oracle Corporation. All rights reserved.

    ERROR:
    ORA-06553: PLS-213: package STANDARD not accessible


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

    Then I tried to run the package located in $ORACLE_HOME/rdbms/admin/standard.sql
    It is hanging there forever, what should I do ? Thanks for help.

    Dragon
    Reply With Quote Reply With Quote
  2. 06-22-2001, 06:00 PM #2
    DBAtrix
    DBAtrix is offline Member
    Join Date
    Oct 2000
    Location
    Cambridge, MA (Boston)
    Posts
    144
    trying running catalog. if you're missing STANDARD, who knows what else is missing. be sure to run them as SYS, *not* SYSTEM or any other user.
    Reply With Quote Reply With Quote
  3. 06-23-2001, 01:10 AM #3
    santoshym
    santoshym is offline Advisor
    Join Date
    Mar 2001
    Posts
    635
    Hi Dragon,

    The best thing is connect as Internal from svmrgl and run

    1) catlog.sql (This wil create the standard package)

    This file will surely in turn call standard package.

    That should solve your problem all togther

    Regards
    Santosh
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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