oradim -new -sid east -intpwd oracle -startmode manual -pfile 'd:oracleora92databaseinitEAST.ora'
set oracle_home=d:oracleora92
set oracle_sid=east
sqlplus/nolog
--操作系统验证
connect / as sysdba;
--或者
connect SID/password as sysdba;
connect east/oracle as sysdba;
CREATE DATABASE "EAST"
CONTROLFILE REUSE
LOGFILE GROUP 1
('d:oracleoradataEASTredo0101.log',
'd:oracleoradataEASTredo0102.log') SIZE 5M REUSE,
GROUP 2
('d:oracleoradataEASTredo0201.log',
'd:oracleoradataEASTredo0202.log') SIZE 5M REUSE
MAXLOGFILES 4
MAXLOGMEMBERS 2
MAXLOGHISTORY 0
MAXDATAFILES 254
MAXINSTANCES 1
NOARCHIVELOG
CHARACTER SET "US7ASCII"
NATIONAL CHARACTER SET "AL16UTF16"
DATAFILE 'd:oracleoradataEASTsystem01.dbf' SIZE 80M
AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED
UNDO TABLESPACE UNDOTBS
DATAFILE 'd:oracleoradataEASTundo01.dbf' SIZE 35M
AUTOEXTEND ON NEXT 5M MAXSIZE 200M
DEFAULT TEMPORARY TABLESPACE TEMP
TEMPFILE 'd:oracleoradataEASTtemp01.dbf' SIZE 20M
AUTOEXTEND ON NEXT 5M MAXSIZE 200M;
--建立数据字典:
@%ORACLE_HOME%rdbmsadmincatalog.sql;
@%ORACLE_HOME%rdbmsadmincatproc.sql;
$ORACLE_HOME/rdbms/admin/catexp.sql
初始化参数文件和建库脚本如下:
[@more@]