oracle 手工建库脚本,oracle手动建库脚本

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@]