RHEL5 Oracle 11G R2 RAC 靜默安裝 （三） rdbms安裝 dbca 建庫

huyi_tony發表於2014-10-07
Oracle
三， rdbms安裝
1， vi .bash_profile 兩邊節點
[oracle@huy1 ~]$ vi .bash_profile   追加

點選(此處)摺疊或開啟

  1. export EDITOR=vi
  2. export ORACLE_SID=prod1
  3. export ORACLE_BASE=/u01/app/oracle
  4. export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
  5. export LD_LIBRARY_PATH=$ORACLE_HOME/lib
  6. export PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/bin
  7. umask 022
節點二 export ORACLE_SID=prod1  調整成 prod2

2，編輯 response檔案
安裝檔案解壓後，模板在 response目錄下的 db_install.rsp
我的rdbms安裝的response檔案（/home/oracle/db.rsp）。（ 圖形安裝 配置結束後，能儲存當前配置成 response檔案）

點選(此處)摺疊或開啟

  1. oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0
  2. oracle.install.option=INSTALL_DB_SWONLY
  3. ORACLE_HOSTNAME=huy1
  4. UNIX_GROUP_NAME=oinstall
  5. INVENTORY_LOCATION=/u01/app/oraInventory
  6. SELECTED_LANGUAGES=en
  7. ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
  8. ORACLE_BASE=/u01/app/oracle
  9. oracle.install.db.InstallEdition=EE
  10. oracle.install.db.isCustomInstall=false
  11. oracle.install.db.customComponents=
  12. oracle.install.db.DBA_GROUP=dba
  13. oracle.install.db.OPER_GROUP=oper
  14. oracle.install.db.CLUSTER_NODES=huy1,huy2
  15. oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
  16. oracle.install.db.config.starterdb.globalDBName=
  17. oracle.install.db.config.starterdb.SID=
  18. oracle.install.db.config.starterdb.characterSet=
  19. oracle.install.db.config.starterdb.memoryLimit=
  20. oracle.install.db.config.starterdb.memoryOption=false
  21. oracle.install.db.config.starterdb.installExampleSchemas=false
  22. oracle.install.db.config.starterdb.enableSecuritySettings=true
  23. oracle.install.db.config.starterdb.password.ALL=
  24. oracle.install.db.config.starterdb.password.SYS=
  25. oracle.install.db.config.starterdb.password.SYSTEM=
  26. oracle.install.db.config.starterdb.password.SYSMAN=
  27. oracle.install.db.config.starterdb.password.DBSNMP=
  28. oracle.install.db.config.starterdb.control=DB_CONTROL
  29. oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=
  30. oracle.install.db.config.starterdb.dbcontrol.enableEmailNotification=false
  31. oracle.install.db.config.starterdb.dbcontrol.emailAddress=
  32. oracle.install.db.config.starterdb.dbcontrol.SMTPServer=
  33. oracle.install.db.config.starterdb.automatedBackup.enable=false
  34. oracle.install.db.config.starterdb.automatedBackup.osuid=
  35. oracle.install.db.config.starterdb.automatedBackup.ospwd=
  36. oracle.install.db.config.starterdb.storageType=
  37. oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=
  38. oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=
  39. oracle.install.db.config.asm.diskGroup=
  40. oracle.install.db.config.asm.ASMSNMPPassword=
  41. MYORACLESUPPORT_USERNAME=
  42. MYORACLESUPPORT_PASSWORD=
  43. SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
  44. DECLINE_SECURITY_UPDATES=true
  45. PROXY_HOST=
  46. PROXY_PORT=
3， 開始安裝rdbms
[oracle@huy1 database]$ ./runInstaller -ignorePrereq -silent -responseFile /home/oracle/db.rsp
安裝過程中，在兩邊節點用root使用者執行/u01/app/oracle/product/11.2.0/db_1/root.sh 指令碼，和圖形安裝相同

四，dbca 靜默建立資料庫
1，執行dbca 節點一上操作
[oracle@huy1 ~]$ dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName prod -sid prod -sysPassword oracle -systemPassword manager -storageType ASM -diskGroupName DATA -datafileJarLocation $ORACLE_HOME/assistants/dbca/templates -nodeinfo huy1,huy2 -characterset ZHS16GBK -asmSysPassword oracle_123
反饋資訊

點選(此處)摺疊或開啟

  1. Copying database files
  2. 1% complete
  3. 3% complete
  4. 9% complete
  5. 15% complete
  6. 21% complete
  7. 27% complete
  8. 30% complete
  9. Creating and starting Oracle instance
  10. 32% complete
  11. 36% complete
  12. 40% complete
  13. 44% complete
  14. 45% complete
  15. 48% complete
  16. 50% complete
  17. Creating cluster database views
  18. 52% complete
  19. 70% complete
  20. Completing Database Creation
  21. 73% complete
  22. 76% complete
  23. 85% complete
  24. 94% complete
  25. 100% complete
  26. Look at the log file \"/u01/app/oracle/cfgtoollogs/dbca/prod/prod.log\" for further details.
2， 驗證資料庫建立好，例項已經啟動

點選(此處)摺疊或開啟

  1. [oracle@huy1 ~]$ sqlplus \'/as sysdba\'

  3. SQL*Plus: Release 11.2.0.1.0 Production on Sun Sep 14 17:20:52 2014

  5. Copyright (c) 1982, 2009, Oracle. All rights reserved.


  8. Connected to:
  9. Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
  10. With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
  11. Data Mining and Real Application Testing options

  13. SQL> select instance_name, host_name, status from gv$instance;

  15. INSTANCE_NAME
  16. ----------------
  17. HOST_NAME STATUS
  18. ---------------------------------------------------------------- ------------
  19. prod1
  20. huy1 OPEN

  22. prod2
  23. huy2 OPEN
在 crs資源裡驗證資料庫資源已經註冊

點選(此處)摺疊或開啟

  1. [grid@huy1 ~]$ crs_stat -t
  2. Name Type Target State Host
  3. ------------------------------------------------------------
  4. ora.DATA.dg ora....up.type ONLINE ONLINE huy1
  5. ora....ER.lsnr ora....er.type ONLINE ONLINE huy1
  6. ora....N1.lsnr ora....er.type ONLINE ONLINE huy2
  7. ora....VOTE.dg ora....up.type ONLINE ONLINE huy1
  8. ora.RCY.dg ora....up.type ONLINE ONLINE huy1
  9. ora.asm ora.asm.type ONLINE ONLINE huy1
  10. ora.eons ora.eons.type ONLINE ONLINE huy1
  11. ora.gsd ora.gsd.type OFFLINE OFFLINE
  12. ora....SM1.asm application ONLINE ONLINE huy1
  13. ora....Y1.lsnr application ONLINE ONLINE huy1
  14. ora.huy1.gsd application OFFLINE OFFLINE
  15. ora.huy1.ons application ONLINE ONLINE huy1
  16. ora.huy1.vip ora....t1.type ONLINE ONLINE huy1
  17. ora....SM2.asm application ONLINE ONLINE huy2
  18. ora....Y2.lsnr application ONLINE ONLINE huy2
  19. ora.huy2.gsd application OFFLINE OFFLINE
  20. ora.huy2.ons application ONLINE ONLINE huy2
  21. ora.huy2.vip ora....t1.type ONLINE ONLINE huy2
  22. ora....network ora....rk.type ONLINE ONLINE huy1
  23. ora.oc4j ora.oc4j.type OFFLINE OFFLINE
  24. ora.ons ora.ons.type ONLINE ONLINE huy1
  25. ora.prod.db ora....se.type ONLINE ONLINE huy1 
  26. ora....ry.acfs ora....fs.type ONLINE ONLINE huy1
  27. ora.scan1.vip ora....ip.type ONLINE ONLINE huy2

打完收工

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/12238525/viewspace-1290687/，如需轉載，請註明出處，否則將追究法律責任。

相關文章