三, 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/