• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 529
  • Last Modified:

All objects invalid in ORACLE

All the stored procedures, functions etc in the Oracle is now invalid. Not sure why...

Whenever I logged on there is this error

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

When I do a compile on the object, like alter procedure xxx compile, it gives me the following.

ORA-06554: package DBMS_STANDARD must be created before using PL/SQL

I read about running some scripts in the ADMIN directory. So farm I have tried standard.sql and a few others using the SYS user but its still the same.

Any help is much appreciated. Thanks.
0
davidnlt
Asked:
davidnlt
  • 2
1 Solution
 
jrb1Commented:
Was the DB working before?  What version are you on?
0
 
davidnltAuthor Commented:
It was working before this. I have loaded 4 schemas insides. Not sure why its invalid now.

Version : 7.3.3.0.0
0
 
geotigerCommented:

Did you run catproc.sql after you build your database?

You can rebuild all the packages by running catproc.sql while logging in as internal or sys. The catproc.sql is under $ORACLE_HOME/rdbms/admin.


0
 
davidnltAuthor Commented:
Its okay now after I run standard.sql and dbmsstd.sql (as recommended from Oracle). It did not work previously because there was 2 version of Oracle on the server and I ran the wrong scripts.

Anyway, thanks for the reply.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now