| ORA-06553 - PLS-213 : Package Standard not Accessible. [message #55402] |
Wed, 22 January 2003 19:11  |
PRAMOD KUMAR
Messages: 5
Registered: January 2003
|
Junior Member |
|
|
Hello,
I need help from some one who are expertise to solve my problem. I will explain the scenario:
We have a Oracle database of version 9.2.0.1.0 in HP/UX version 11.0 . Day before yesterday I installed a new patch 'p2632931_9202_HP64' based on the recommandation of Oracle support to solve our swap memory problem. Day before yesterday evening only I installed this patch. Yesterday morning while running PL/SQL procedure, a message like "ORA-18008: "cannot find OUTLN schema" is displayed. So from documentation reference I understood that the user OUTLN is not available. So I executed the script 'C0800050.sql' for recreating OUTLN user. But after that I got another message like 'ora-06553 PL-213 package standard is not available'. So I executed the scripts 'catalog.sql' and 'catproc.sql. But the execution of catalog also with more errors and catproc execution not responding after some time.
As recommanded by Oracle, I tried to execute utlrp.sql. But this execution also not successful and it showing the errors like :
SQL> @/u01/app/oracle/product/9.2.0/rdbms/admin/utlrp.sql
declare
*
ERROR at line 1:
ORA-06553: PLS-213: package STANDARD not accessible
CREATE TABLE utl_recomp_invalid(obj# number)
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE utl_recomp_sorted(obj# number, depth number)
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE utl_recomp_compiled(obj# number)
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX utl_recomp_comp_idx1 ON utl_recomp_compiled(obj#)
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE utl_recomp_backup_jobs(job number)
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE utl_recomp_log(command varchar2(100), status varchar2(1000))
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
View created.
View created.
CREATE OR REPLACE PACKAGE utl_recomp IS
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_STANDARD
ORA-06553: PLS-213: package STANDARD not accessible
ORA-06553: PLS-213: package STANDARD not accessible
No errors.
CREATE OR REPLACE PACKAGE BODY utl_recomp is
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_STANDARD
ORA-06553: PLS-213: package STANDARD not accessible
ORA-06553: PLS-213: package STANDARD not accessible
No errors.
BEGIN utl_recomp.recomp_serial(); END;
*
ERROR at line 1:
ORA-06553: PLS-213: package STANDARD not accessible
BEGIN dbms_registry.validate_components; END;
*
ERROR at line 1:
ORA-06553: PLS-213: package STANDARD not accessible
SQL>
The following query output I seened that owner of STANDARD package is SYS :
SQL> select owner,object_name from dba_objectS where object_name like 'STANDARD';
OWNER OBJECT_NAME
------------------------------
-----------------------------------------------------
SYS STANDARD
SYS STANDARD
SQL>
But many object status now also in INVALID state.
SQL> select owner,object_name, status from dba_objectS where object_name like 'STANDARD';
OWNER OBJECT_NAME STATUS
------------------------------ --------------- -------
SYS STANDARD INVALID
SYS STANDARD INVALID
Current shared_pool_size of our server is :112mb.
Our many important works are still on pending. So please give a solution to solve our problem.
Regards
Pramod Kumar.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
