您当前的位置: 首页 >  ar

qq_34412985

暂无认证

  • 0浏览

    0关注

    1061博文

    0收益

  • 0浏览

    0点赞

    0打赏

    0留言

私信
关注
热门博文

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

qq_34412985 发布时间:2020-08-28 18:07:59 ,浏览量: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

关注
打赏
1653291990
查看更多评论
立即登录/注册

微信扫码登录

2.1572s