看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