当前位置: 代码迷 >> 综合 >> ORA-06553: PLS-213: package STANDARD not accessible
  详细解决方案

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

热度:36   发布时间:2023-09-19 21:28:08.0

看tom说简单地create database就可以创建数据库,于是小试了一把

SYS>create database;
ERROR:
ORA-06553: PLS-213: package STANDARD not accessible

Database created.

--查询视图发现数据文件、日志文件和控制文件都创建好了

SYS>select NAME,bytes/1024/1024 from v$datafile;

NAME                                                         BYTES/1024/1024
------------------------------------------------------------ ---------------
/u01/app/oracle/product/11.2.0/dbhome_1/dbs/dbs1abc.dbf               78.125
/u01/app/oracle/product/11.2.0/dbhome_1/dbs/dbx1abc.dbf              39.0625
/u01/app/oracle/product/11.2.0/dbhome_1/dbs/dbu1abc.dbf                   10

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

SYS>select MEMBER from v$logfile;

MEMBER
--------------------------------------------------------------------------------
/u01/app/oracle/product/11.2.0/dbhome_1/dbs/log1abc.dbf
/u01/app/oracle/product/11.2.0/dbhome_1/dbs/log2abc.dbf

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

SYS>select name from v$controlfile;

NAME
------------------------------------------------------------
/u01/app/oracle/product/11.2.0/dbhome_1/dbs/cntrlabc.dbf

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

--惟一让人感到不爽的地方是,每次查询完都会跟个小尾巴,到网上查了一下,说可能是没执行以下几个脚本,但当时我已经把数据库删了,于是重新来了一把,没想到这次我还没执行脚本,小尾巴就自动没了,奇了怪了

--这是网上给的解决办法


sqlplus /nolog
SQL> connect / as sysdba
SQL> $ORACLE_HOME/rdbms/admin/catalog.sql
SQL> $ORACLE_HOME/rdbms/admin/catproc.sql
SQL> $ORACLE_HOME/rdbms/admin/catexp.sql

  相关解决方案