[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 524
  • 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.
  • 2
1 Solution
Was the DB working before?  What version are you on?
davidnltAuthor Commented:
It was working before this. I have loaded 4 schemas insides. Not sure why its invalid now.

Version :

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.

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.

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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