Oracle 手工建库步骤
#SID=welson
1、在$ORACLE_BASE/SID/ 创建dump文件夹,设置日志存放目录
????
$cd $ORACLE_BASE/$mkdir welson$cd welson$mkdir adump$mkdir bdump$mkdir cdump$mkdir udump
?2、设置数据文件存放目录：
?
???
$cd $ORACLE_BASE/oradata/$mkdir welson
?3、创建密码文件，设为oracle
?
?
$cd $ORACLE_HOME/dbs$orapwd file=orapwwelson password=oracle
?
?
3、创建$ORACLE_HOME/dbs/initSID.ora文件，其中，SID为实例名称
内容：
?
*.control_files='/u01/app/oradata/welson/control01.ctl','/u01/app/oradata/welson/control02.ctl'*.db_name='welson'*.db_block_size=8192*.undo_management='AUTO'*.undo_tablespace='UNDOTBS1'*.sga_target=285212672
?可根据实际情况对文件内容进行修改。
?
4、根据3中创建的参数文件创建spfile，启动数据库实例，执行建库脚本
?
$export ORACLE_SID=welson$sqlplus "/as sysdba"SQL>create spfile from pfile;File createdSQL>startup nomount...
?
create database welsonuser sys identified by oracleuser system identified by oraclelogfile group 1 ('/u01/app/oradata/welson/redo01.log') size 50M,group 2 ('/u01/app/oradata/welson/redo02.log') size 50M,group 3 ('/u01/app/oradata/welson/redo03.log') size 50Mmaxlogfiles 5maxlogmembers 5maxloghistory 1maxdatafiles 500maxinstances 1character set AL32UTF8national character set UTF8datafile '/u01/app/oradata/welson/system.dbf' size 500Mextent management localsysaux datafile '/u01/app/oradata/welson/sysaux01.dbf' size 500Mdefault tablespace users01 datafile '/u01/app/oradata/welson/user01.dbf' size 100Mdefault temporary tablespace temptempfile '/u01/app/oradata/welson/temp01.dbf' size 50Mundo tablespace undotbs1datafile '/u01/app/oradata/welson/undo.dbf' size 50M;?5、执行脚本
????? @?/rdbms/admin/catalog.sql
????? @?/rdbms/admin/catproc.sql
?
???