文档介绍：DBA never sleep-DBA,永不眠
Focus on Oracle Database, GodenGate and Unix
[置顶] How to create Oracle 11g R2 database manually in ASM?
分类: Oracle 11g OCP Certification 2013-12-18 22:40 242人阅读评论(0) 收藏举报
Oracle 11g手工建库create databasemanuallyOMF
Step 1: Specify an Instance Identifier (SID)
export ORACLE_SID=maomi
Step 2: Ensure That the Required Environment Variables Are Set
export ORACLE_HOME=/u01/app/oracle/product/
export ORACLE_BASE=/u01/app/oracle
mkdir -p /u01/app/oracle/admin/maomi/adump
Step 3: Choose a Database Administrator Authentication Method
orapwd file=orapwmaomi password=oracle entries=5 force=y
Step 4: Create the Initialization Parameter File
db_name='maomi'
memory_target=400m
processes = 150
audit_file_dest='/u01/app/oracle/admin/maomi/adump'
audit_trail ='db'
db_block_size=8192
db_domain=''
log_archive_dest_1='location=+FRA'
DB_CREATE_ONLINE_LOG_DEST_1='+DATA'
DB_CREATE_ONLINE_LOG_DEST_2='+FRA'
db_create_file_dest='+DATA'
db_recovery_file_dest='+FRA'
db_recovery_file_dest_size=2G
diagnostic_dest='/u01/app/oracle'
dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
open_cursors=300
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
undo_management='AUTO'
local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521))))'
remote_listener='rac-scan:1521'
# You may want to ens