RHEL5 Oracle 11G R2 RAC 静默安装 （三） rdbms安装 dbca 建库

三， 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\'
   
2. 
   
3. SQL*Plus: Release 11.2.0.1.0 Production on Sun Sep 14 17:20:52 2014
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle. All rights reserved.
   
6. 
   
7. 
   
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
    
12. 
    
13. SQL> select instance_name, host_name, status from gv$instance;
    
14. 
    
15. INSTANCE_NAME
    
16. ----------------
    
17. HOST_NAME STATUS
    
18. ---------------------------------------------------------------- ------------
    
19. prod1
    
20. huy1 OPEN
    
21. 
    
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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12238525/viewspace-1290687/