response方式安装database

 

response安装database

 

上一次已经通过response装好了grid，现在开始安装database

编辑response文件，最终结果：

 

[oracle@node1 ~]$ pwd
/home/oracle
[oracle@node1 ~]$ ls
.bash_history  .bash_profile  db_env    grid_env                 .kshrc     .ssh/   .Xauthority
.bash_logout   .bashrc        .gnome2/  grid_install_config.rsp  .mozilla/  .vimrc
[oracle@node1 ~]$ 
[oracle@node1 ~]$ db_env 
[oracle@node1 ~]$ wget ftp://10.101.0.17/pub/kik/ora11203_rac_conf/db_install.rsp --2013-06-04 17:18:50--  ftp://10.101.0.17/pub/kik/ora11203_rac_conf/db_install.rsp => “db_install.rsp”
Connecting to 10.101.0.17:21... connected.
Logging in as anonymous ... Logged in!
==> SYST ... done.    ==> PWD ... done.
==> TYPE I ... done.  ==> CWD (1) /pub/kik/ora11203_rac_conf ... done.
==> SIZE db_install.rsp ... 25308
==> PASV ... done.    ==> RETR db_install.rsp ... done.
Length: 25308 (25K) (unauthoritative)

100%[===================================================================================>] 25,308      --.-K/s in 0.002s  

2013-06-04 17:18:50 (15.3 MB/s) - “db_install.rsp” saved [25308]

[oracle@node1 ~]$ 
[oracle@node1 ~]$ cd /nfs/oracle11G/i386/database/
[oracle@node1 database]$ ls
doc/  install/  readme.html*  response/  rpm/  runInstaller*  sshsetup/  stage/  welcome.html*
[oracle@node1 database]$ 

[oracle@node1 database]$ more ~/db_install.rsp |grep ^[^#$]
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0
oracle.install.option=INSTALL_DB_AND_CONFIG
ORACLE_HOSTNAME=node1.momo.org
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/u01/app/oracle/oraInventory
SELECTED_LANGUAGES=en,zh_CN
ORACLE_HOME=/u01/app/oracle/product/11.2.3/db_1
ORACLE_BASE=/u01/app/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.EEOptionsSelection=true oracle.install.db.optionalComponents=oracle.rdbms.partitioning:11.2.0.3.0,oracle.oraolap:11.2.0.3.0,oracle.rdbms.lbac:11.2.0.3.0,oracle.rdbms.dm:11.2.0.3.0,oracle.rdbms.dv:11.2.0.3.0,oracle.rdbms.rat:11.2.0.3.0
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=oper
oracle.install.db.CLUSTER_NODES=node1,node2,node3
oracle.install.db.isRACOneInstall=false oracle.install.db.racOneServiceName=
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
oracle.install.db.config.starterdb.globalDBName=momorac.momo.org
oracle.install.db.config.starterdb.SID=node1
oracle.install.db.config.starterdb.characterSet=AL32UTF8
oracle.install.db.config.starterdb.memoryOption=true oracle.install.db.config.starterdb.memoryLimit=357
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.automatedBackup.enable=false oracle.install.db.config.starterdb.automatedBackup.osuid=
oracle.install.db.config.starterdb.automatedBackup.ospwd=
oracle.install.db.config.starterdb.storageType=ASM_STORAGE
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=
oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=
oracle.install.db.config.asm.diskGroup=ASM1
oracle.install.db.config.asm.ASMSNMPPassword=
MYORACLESUPPORT_USERNAME=
MYORACLESUPPORT_PASSWORD=
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false DECLINE_SECURITY_UPDATES=true PROXY_HOST=
PROXY_PORT=
PROXY_USER=
PROXY_PWD=
PROXY_REALM=
COLLECTOR_SUPPORTHUB_URL=
oracle.installer.autoupdates.option=SKIP_UPDATES
oracle.installer.autoupdates.downloadUpdatesLoc=
AUTOUPDATES_MYORACLESUPPORT_USERNAME=
AUTOUPDATES_MYORACLESUPPORT_PASSWORD=
[oracle@node1 database]$ 

 

开始安装

 

[oracle@node1 database]$ ./runInstaller -showProgress -ignoreSysPrereqs -ignorePrereq \ 

-silent "oracle.install.db.config.starterdb.password.ALL=333333" \ "oracle.install.db.config.asm.ASMSNMPPassword=444444" \ 

-responseFile /home/oracle/db_install.rsp

Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 8312 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 7930 MB    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2013-06-04_05-26-31PM. Please wait ...
[oracle@node1 database]$ 
[oracle@node1 database]$ No protocol specified

Prepare in progress.

Prepare successful.
[oracle@node1 database]$ [WARNING] [INS-30011] The ADMIN password entered does not conform to the Oracle recommended standards.
   CAUSE: Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
   ACTION: Provide a password that conforms to the Oracle recommended standards.
You can find the log of this install session at:
 /u01/app/oracle/oraInventory/logs/installActions2013-06-04_05-26-31PM.log

Prepare in progress.
..................................................   8% Done.

Prepare successful.

Copy files in progress.
[oracle@node1 database]$ ....................   13% Done.
..................................................   18% Done.
..................................................   23% Done.
..................................................   28% Done.
..................................................   33% Done.
..................................................   38% Done.
..................................................   43% Done.
..............................
Copy files successful.

Link binaries in progress.

Link binaries in progress.
..........
Link binaries successful.
..................................................   53% Done.

Setup files in progress.

Setup files successful.
..................................................   65% Done.

Perform remote operations in progress.
..................................................   76% Done.

Perform remote operations successful.
The installation of Oracle Database 11g was successful.
Please check '/u01/app/oracle/oraInventory/logs/silentInstall2013-06-04_05-26-31PM.log' for more details.

Oracle Database Configuration Assistant in progress.

[oracle@node1 database]$ 

[oracle@node1 database]$ more /u01/app/oracle/oraInventory/logs/silentInstall2013-06-04_05-26-31PM.log
silentInstall2013-06-04_05-26-31PM.log
sNativeVolName:/u01/app/oracle/product/11.2.3/db_1/
m_asNodeArray:node1,node2,node3
m_sLocalNode:node1
sNativeVolName:/u01/app/oracle/oraInventory/
m_asNodeArray:node1,node2,node3
m_sLocalNode:node1
sNativeVolName:/tmp/
m_asNodeArray:node1,node2,node3
m_sLocalNode:node1
sNativeVolName:/u01/app/oracle/
m_asNodeArray:node1,node2,node3
m_sLocalNode:node1
The installation of Oracle Database 11g was successful.
[oracle@node1 database]$ 

竟然没有提示执行root.sh脚本？

[root@node1 ~]# /u01/app/oracle/product/11.2.3/db_1/root.sh
Check /u01/app/oracle/product/11.2.3/db_1/install/root_node1_2013-06-05_16-33-53.log for the output of root script
[root@node1 ~]# more /u01/app/oracle/product/11.2.3/db_1/install/root_node1_2013-06-05_16-33-53.log

Performing root user operation for Oracle 11g

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/product/11.2.3/db_1
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
[root@node1 ~]# 


[root@node2 ~]#  /u01/app/oracle/product/11.2.3/db_1/root.sh
Check /u01/app/oracle/product/11.2.3/db_1/install/root_node2_2013-06-05_16-36-46.log for the output of root script
[root@node2 ~]# more /u01/app/oracle/product/11.2.3/db_1/install/root_node2_2013-06-05_16-36-46.log

Performing root user operation for Oracle 11g

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/product/11.2.3/db_1
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
[root@node2 ~]#

[root@node3 ~]#  /u01/app/oracle/product/11.2.3/db_1/root.sh
Check /u01/app/oracle/product/11.2.3/db_1/install/root_node3_2013-06-05_16-36-50.log for the output of root script

[root@node3 ~]#
[root@node3 ~]# more /u01/app/oracle/product/11.2.3/db_1/install/root_node3_2013-06-05_16-36-50.log

Performing root user operation for Oracle 11g

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/product/11.2.3/db_1
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
[root@node3 ~]#

 
        

    

run the utlrp.sql

[root@node1 ~]# su - oracle

[oracle@node1 ~]$ db_env

ORACLE_SID= node1

[oracle@node1 ~]$ export ORACLE_SID=node11

[oracle@node1 ~]$

[oracle@node1 ~]

[oracle@node1 ~]$ sqlplus / as sysdba

 

 

检查

[oracle@node1 patch]$ srvctl config database -d momorac
Database unique name: momorac
Database name: momorac
Oracle home: /u01/app/oracle/product/11.2.3/db_1
Oracle user: oracle
Spfile: +ASM1/momorac/spfilenode1.ora
Domain: momo.org
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: momorac
Database instances: node11,node12,node13
Disk Groups: ASM1
Mount point paths: 
Services: 
Type: RAC
Database is administrator managed

[oracle@node1 patch]$ srvctl status database -d momorac
Instance node11 is running on node node1
Instance node12 is running on node node2
Instance node13 is running on node node3
[oracle@node1 patch]$
[oracle@node1 patch]$ export ORACLE_SID=node11
[oracle@node1 patch]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Wed Jun 5 16:20:44 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining, Oracle Database Vault and Real Application Testing options

SQL> select inst_name from v$active_instances;

INST_NAME
--------------------------------------------------------------------------------
node1:node11
node2:node12
node3:node13

#END

有空继续测试rac环境下修改SID.