三, rdbms安装
1, vi .bash_profile 两边节点
[oracle@huy1 ~]$ vi .bash_profile 追加
节点二 export ORACLE_SID=prod1 调整成 prod2
2,编辑 response文件
安装文件解压后,模板在 response目录下的 db_install.rsp
我的rdbms安装的response文件(/home/oracle/db.rsp)。( 图形安装 配置结束后,能保存当前配置成 response文件)
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
反馈信息
2, 验证数据库创建好,实例已经启动
在 crs资源里验证数据库资源已经注册
打完收工
1, vi .bash_profile 两边节点
[oracle@huy1 ~]$ vi .bash_profile 追加
点击(此处)折叠或打开
-
export EDITOR=vi
-
export ORACLE_SID=prod1
-
export ORACLE_BASE=/u01/app/oracle
-
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
-
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
-
export PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/bin
- umask 022
2,编辑 response文件
安装文件解压后,模板在 response目录下的 db_install.rsp
我的rdbms安装的response文件(/home/oracle/db.rsp)。( 图形安装 配置结束后,能保存当前配置成 response文件)
点击(此处)折叠或打开
-
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0
-
oracle.install.option=INSTALL_DB_SWONLY
-
ORACLE_HOSTNAME=huy1
-
UNIX_GROUP_NAME=oinstall
-
INVENTORY_LOCATION=/u01/app/oraInventory
-
SELECTED_LANGUAGES=en
-
ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
-
ORACLE_BASE=/u01/app/oracle
-
oracle.install.db.InstallEdition=EE
-
oracle.install.db.isCustomInstall=false
-
oracle.install.db.customComponents=
-
oracle.install.db.DBA_GROUP=dba
-
oracle.install.db.OPER_GROUP=oper
-
oracle.install.db.CLUSTER_NODES=huy1,huy2
-
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
-
oracle.install.db.config.starterdb.globalDBName=
-
oracle.install.db.config.starterdb.SID=
-
oracle.install.db.config.starterdb.characterSet=
-
oracle.install.db.config.starterdb.memoryLimit=
-
oracle.install.db.config.starterdb.memoryOption=false
-
oracle.install.db.config.starterdb.installExampleSchemas=false
-
oracle.install.db.config.starterdb.enableSecuritySettings=true
-
oracle.install.db.config.starterdb.password.ALL=
-
oracle.install.db.config.starterdb.password.SYS=
-
oracle.install.db.config.starterdb.password.SYSTEM=
-
oracle.install.db.config.starterdb.password.SYSMAN=
-
oracle.install.db.config.starterdb.password.DBSNMP=
-
oracle.install.db.config.starterdb.control=DB_CONTROL
-
oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=
-
oracle.install.db.config.starterdb.dbcontrol.enableEmailNotification=false
-
oracle.install.db.config.starterdb.dbcontrol.emailAddress=
-
oracle.install.db.config.starterdb.dbcontrol.SMTPServer=
-
oracle.install.db.config.starterdb.automatedBackup.enable=false
-
oracle.install.db.config.starterdb.automatedBackup.osuid=
-
oracle.install.db.config.starterdb.automatedBackup.ospwd=
-
oracle.install.db.config.starterdb.storageType=
-
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=
-
oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=
-
oracle.install.db.config.asm.diskGroup=
-
oracle.install.db.config.asm.ASMSNMPPassword=
-
MYORACLESUPPORT_USERNAME=
-
MYORACLESUPPORT_PASSWORD=
-
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
-
DECLINE_SECURITY_UPDATES=true
-
PROXY_HOST=
- PROXY_PORT=
[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
反馈信息
点击(此处)折叠或打开
-
Copying database files
-
1% complete
-
3% complete
-
9% complete
-
15% complete
-
21% complete
-
27% complete
-
30% complete
-
Creating and starting Oracle instance
-
32% complete
-
36% complete
-
40% complete
-
44% complete
-
45% complete
-
48% complete
-
50% complete
-
Creating cluster database views
-
52% complete
-
70% complete
-
Completing Database Creation
-
73% complete
-
76% complete
-
85% complete
-
94% complete
-
100% complete
- Look at the log file \"/u01/app/oracle/cfgtoollogs/dbca/prod/prod.log\" for further details.
点击(此处)折叠或打开
-
[oracle@huy1 ~]$ sqlplus \'/as sysdba\'
-
-
SQL*Plus: Release 11.2.0.1.0 Production on Sun Sep 14 17:20:52 2014
-
-
Copyright (c) 1982, 2009, Oracle. All rights reserved.
-
-
-
Connected to:
-
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
-
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
-
Data Mining and Real Application Testing options
-
-
SQL> select instance_name, host_name, status from gv$instance;
-
-
INSTANCE_NAME
-
----------------
-
HOST_NAME STATUS
-
---------------------------------------------------------------- ------------
-
prod1
-
huy1 OPEN
-
-
prod2
- huy2 OPEN
点击(此处)折叠或打开
-
[grid@huy1 ~]$ crs_stat -t
-
Name Type Target State Host
-
------------------------------------------------------------
-
ora.DATA.dg ora....up.type ONLINE ONLINE huy1
-
ora....ER.lsnr ora....er.type ONLINE ONLINE huy1
-
ora....N1.lsnr ora....er.type ONLINE ONLINE huy2
-
ora....VOTE.dg ora....up.type ONLINE ONLINE huy1
-
ora.RCY.dg ora....up.type ONLINE ONLINE huy1
-
ora.asm ora.asm.type ONLINE ONLINE huy1
-
ora.eons ora.eons.type ONLINE ONLINE huy1
-
ora.gsd ora.gsd.type OFFLINE OFFLINE
-
ora....SM1.asm application ONLINE ONLINE huy1
-
ora....Y1.lsnr application ONLINE ONLINE huy1
-
ora.huy1.gsd application OFFLINE OFFLINE
-
ora.huy1.ons application ONLINE ONLINE huy1
-
ora.huy1.vip ora....t1.type ONLINE ONLINE huy1
-
ora....SM2.asm application ONLINE ONLINE huy2
-
ora....Y2.lsnr application ONLINE ONLINE huy2
-
ora.huy2.gsd application OFFLINE OFFLINE
-
ora.huy2.ons application ONLINE ONLINE huy2
-
ora.huy2.vip ora....t1.type ONLINE ONLINE huy2
-
ora....network ora....rk.type ONLINE ONLINE huy1
-
ora.oc4j ora.oc4j.type OFFLINE OFFLINE
-
ora.ons ora.ons.type ONLINE ONLINE huy1
- ora.prod.db ora....se.type ONLINE ONLINE huy1
-
ora....ry.acfs ora....fs.type ONLINE ONLINE huy1
- ora.scan1.vip ora....ip.type ONLINE ONLINE huy2
打完收工
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12238525/viewspace-1290687/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/12238525/viewspace-1290687/
本文详细介绍了如何在Linux环境下使用静默安装方式部署Oracle RAC数据库集群,包括环境配置、响应文件编辑及数据库创建过程。
1065

被折叠的 条评论
为什么被折叠?



