2019獨(dú)角獸企業(yè)重金招聘Python工程師標(biāo)準(zhǔn)>>>

1.手動(dòng)建庫(kù)大致步驟

設(shè)置環(huán)境變量.bash_profile

創(chuàng)建目錄結(jié)構(gòu)

創(chuàng)建參數(shù)文件(位置:$ORACLE_HOME/dbs)

生成密碼文件

執(zhí)行建庫(kù)腳本

創(chuàng)建數(shù)據(jù)字典

其他設(shè)置

2.DBCA 腳本創(chuàng)建

2.1設(shè)置系統(tǒng)環(huán)境變量

ORACLE_HOME=/app/oracle/11g/11.2.4.2;export ORACLE_HOME ORACLE_BASE=/app/oracle/11g;export ORACLE_BASE ORACLE_SID=dw; export ORACLE_SID PATH=/usr/sbin:$PATH; export $PATH PATH=$ORACLE_HOME/bin:$PATH; export $PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

2.2創(chuàng)建相應(yīng)的目錄

cd $ORACLE_BASE cd admin mkdir $ORACLE_SID cd $ORACLE_SID mkdir adump bdump cdump dpdump pfile udump ps:確認(rèn)相應(yīng)的目錄 echo??$ORACLE_SID echo??$ORACLE_BASE echo??$ORACLE_HOME

2.3修改pfile參數(shù)

具體情況而定修改相應(yīng)的參數(shù)如：audit_file_dest，background_dump_dest，control_files，core_dump_dest，log_archive_dest_1，user_dump_dest等

2.4生成密碼文件

cd $ORACLE_HOME/dbs orapwd file=orapw$ORACLE_SID password=&pwd entries=8

2.5 連接到數(shù)據(jù)庫(kù)，啟動(dòng)到nomount狀態(tài)

sqlplus / as sysdba startup nomount

2.6執(zhí)行建庫(kù)腳本?

ASM 磁盤(pán)組 Cat create_db.sql CREATE DATABASE dw USER SYS IDENTIFIED BY oracle USER SYSTEM IDENTIFIED BY oracle LOGFILE GROUP 1 '+DATA_DG' size 300m, GROUP 2 '+DATA_DG' size 300m, GROUP 3 '+DATA_DG' size 300m MAXLOGFILES 32 MAXLOGMEMBERS 3 MAXLOGHISTORY 1 MAXDATAFILES 300 CHARACTER SET AL32UTF8 NATIONAL CHARACTER SET AL16UTF16 EXTENT MANAGEMENT LOCAL DATAFILE '+DATA_DG' SIZE 800M REUSE SYSAUX DATAFILE '+DATA_DG' SIZE 800M REUSE DEFAULT TABLESPACE users DATAFILE '+DATA_DG' SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT TEMPORARY TABLESPACE temp TEMPFILE '+data_dg' SIZE 5120M REUSE UNDO TABLESPACE UNDOTBS1 DATAFILE '+DATA_DG' SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED; 文件系統(tǒng) CREATE DATABASE dw USER SYS IDENTIFIED BY oracle USER SYSTEM IDENTIFIED BY oracle LOGFILE GROUP 1 ('/u01/app/oracle/oradata/dw/redo01a.log','/u01/app/oracle/oradata/dw/redo01b.log') SIZE 512M), GROUP 2 ('/u01/app/oracle/oradata/dw/redo02a.log','/u01/app/oracle/oradata/dw/redo02b.log') SIZE 512M), GROUP 3 ('/u01/app/oracle/oradata/dw/redo01a.log','/u01/app/oracle/oradata/dw/redo01b.log') SIZE 512M), MAXLOGFILES 32 MAXLOGMEMBERS 3 MAXLOGHISTORY 1 MAXDATAFILES 300 CHARACTER SET AL32UTF8 NATIONAL CHARACTER SET AL16UTF16 EXTENT MANAGEMENT LOCAL DATAFILE '/u01/app/oracle/oradata/dw/system01.dbf' SIZE 800M REUSE SYSAUX DATAFILE '/u01/app/oracle/oradata/dw/sysaux01.dbf' SIZE 800M REUSE DEFAULT TABLESPACE users DATAFILE '/u01/app/oracle/oradata/dw/user01.dbf SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT TEMPORARY TABLESPACE temp TEMPFILE '/u01/app/oracle/oradata/dw/temp01.dbf' SIZE 5120M REUSE UNDO TABLESPACE UNDOTBS1 DATAFILE '+DATA_DG' SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;Ps:相應(yīng)的路徑與屬性根據(jù)相應(yīng)的需求進(jìn)行修改

2.6執(zhí)行創(chuàng)建數(shù)據(jù)字典腳本

@?/rdbms/admin/catalog.sql @?/rdbms/admin/catproc.sql @?/sqlplus/admin/pupbld.sql #需使用system用戶執(zhí)行

3.DBCA靜默建庫(kù)

vmhost:oracle > dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName dw -sid dw -sysPassword oracle -systemPassword oralce -storageType ASM -diskGroupName data_dg -nationalCharacterSet "AL16UTF16" -characterSet "AL32UTF8" -nodeinfo cnlf081000 -sampleSchema false -asmSysPassword oracle -variablesFile /app /oracle/11g/11.2.4.2/dbs/initdw.ora -recoveryAreaDestination +fra_dg?? -databaseType? DATA_WAREHOUSINGCopying database files1% complete3% complete9% complete15% complete21% complete27% complete30% completeCreating and starting Oracle instance32% complete36% complete40% complete44% complete45% complete48% complete50% completeCreating cluster database views52% complete70% completeCompleting Database Creation73% complete76% complete85% complete94% complete100% completeLook at the log file "/app/oracle/11g/cfgtoollogs/dbca/dw/dw.log" for further details.vmhost:oracle>

?

轉(zhuǎn)載于:https://my.oschina.net/zhiyonghe/blog/905183

總結(jié)

以上是生活随笔為你收集整理的oracle dba 手动创建数据实例的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。