步骤：
1、choose a unique instance and database name
2、choose a database character set
| ORACLE_NLS33=/u01/oracle/ocommon/nls/admin/data |
3、set operation system variable
|
ORACLE_BASE=/u01/ ORACLE_HOME=/u01/oracle/ PATH=/u01/oracle/bin:$PATH |
4、create the initialization parameter file
可由已有dbca创建的spfile->生成所需initial file,还需按照参数文件创建好目录
一为/u01/oracle/admin/NEWSID/中各种dump文件存放目录
二为/u01/oracle/oradata/NEWSID/中数据文件目录
| strings existedSIDspfile > initnewSID.ora |
生成spfile
|
conn / as sysdba create spfile from pfile; |
还需创建口令文件
| #orapwd file=orapwNEWSID password=oracle entries=10 |
5、start the instance in nomount stage
6、create and execute the CREATE DATABASE command
SAVE AS 'CREATESID.SQL'
|
CREATE DATABASE "NEWSID" MAXDATAFILES 500 MAXINSTANCES 8 MAXLOGFILES 32 CHARACTER SET "UTF8" NATIONAL CHARACTER SET AL16UTF16 ARCHIVELOG DATAFILE '/u01/oradata/NEWSID/system01.dbf' SIZE 300M EXTENT MANAGEMENT LOCAL DEFAULT TEMPORARY TABLESPCAE temp TEMPFILE '/u01/oradata/NEWSID/tempts01.dbf' SIZE 100M EXTENT MANAGEMENT LOCAL UNDO TABLESPACE "UNDOTBS1" DATAFILE 'u01/oradata/NEWSID/undotbs01.dbf' SIZE 200M LOGFILE GROUP1( 'u01/oradata/NEWSID/redo01a.rdo', 'u01/oradata/NEWSID/redo01b.rdo' )SIZE 100M, GROUP2( 'u01/oradata/NEWSID/redo02a.rdo', 'u01/oradata/NEWSID/redo02b.rdo' )SIZE 100M, GROUP3( 'u01/oradata/NEWSID/redo03a.rdo', 'u01/oradata/NEWSID/redo03b.rdo' )SIZE 100M; |
| SQL>@$ORACLE_HOME/oracle/dbs/CREATESID.SQL |
7、run script. to generate data dictionary and accomplish post-create steps
|
SQL>SPOOL log1.log SQL>@?/rdbms/admin/catalog.sql SQL>@?/rdbms/admin/catproc.sql SQL>@?/rdbms/admin/pupbld.sql --? means $ORALCE_HOME |
catalog.sql generate data dictionary
catproc.sql related to plsql
pupbld.sql related to sqlplus
8、create additional tablespace as needed
9、run scripts to install addtional option
many of scripts availiable are described in
_________________________________
that'all
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/24419958/viewspace-671995/ ，如需转载，请注明出处，否则将追究法律责任。
