看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