Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
Oracle数据库数据恢复、性能优化»论坛 › Oracle › Oracle数据库管理 › RAC slient 安装时指定节点无效？
发新帖
oradbguy

55

积分

0

好友

4

主题

RAC slient 安装时指定节点无效？

1#
发表于 2012-6-8 20:46:09 | 查看: 6276| 回复: 2
无论是在安装crs 的时候指定sl_tableList={"yunrac1:yunrac1-priv:yunrac1-vip:N:Y","yunrac2:yunrac2-priv:yunrac2-vip:N:Y"}
\
还是在 安装DB的时候指定CLUSTER_NODES={"yunrac1","yunrac2"}




在runInstaller -silent 执行的时候都没有有效的读取到这个值，结果导致只在本地安装了，没有复制到remote节点去。而通过修改rsp 文件可以正确识别node的参数。


在节点yunrac1安装DB执行命令为：
runInstaller -silent   -responseFile $DISTRIB/response/enterprise.rsp  ORACLE_HOME=/opt/oracle/product/10.2.0/db  ORACLE_HOME_NAME=OraDb10g_Home1  CLUSTER_NODES={"yunrac1","yunrac2"}    n_configurationOption=3




附上安装DB的时候的log，其中看到有
CLUSTER_NODES=yunrac1
CLUSTER_NODES=yunrac2
但是在里面同样还是会看到remote_node 错误的取到yunrac1 去了，正确的应该是yunrac2
INFO: Setting variable 'LOCAL_NODE' to 'yunrac1'. Received the value from a code block.
INFO: Setting variable 'REMOTE_NODES' to 'yunrac1,'. Received the value from a code block.
INFO: isRollingUpgradeEnabled():false
INFO: Setting the 'ClusterInstallDescription' property to 'Select nodes (in addition to the local node) in the hardware cluster where the installer should install products that you select in this installation.'.
INFO: Setting the 'SingleInstanceDescription' property to 'Select this option if you want to perform a single node non-cluster installation even though the local node is part of a hardware cluster.'.
INFO: Setting the 'InvalidNodes' property to 'null'.
INFO: Setting the 'AllowRemoteNodeSelection' property to 'true'.
INFO: Setting the 'ShowCRSSoftwareVersion' property to 'false'.
INFO: Setting the 'NewHome' property to 'true'.
INFO: Setting the 'ClusterNodes ( CLUSTER_NODES )' property to ''. Received the value from the default settings.
INFO: Setting the 'LocalNode ( LOCAL_NODE )' property to 'yunrac1'. Received the value from a code block.
INFO: Setting the 'RemoteNodes ( REMOTE_NODES )' property to 'yunrac1,'. Received the value from a code block.
INFO: Setting variable 'REMOTE_NODES' to ''. Received the value from a code block.
INFO: Setting variable 'LOCAL_NODE' to ''. Received the value from a code block.


想知道这个通病，还是我自己的某地方设置导致。thanks  maclean

installActions2012-06-08_08-08-26PM.log.txt

688.99 KB, 下载次数: 804
3#
发表于 2012-6-8 22:54:00
sorry ,忘记帖版本了

跟着http://www.pythian.com/news/1042 ... ation-of-a-102-rac/

这个文档装的

回复 只看该作者 道具 举报

2#
发表于 2012-6-8 21:42:07
提问至少说明白版本！

/data/ora_setup/database/install/unzip -qqq ../stage/Components/oracle.swd.oui/10.2.0.1.0/1/DataFiles/\*.jar -d /tmp/OraInstall2012-06-08_08-08-26PM

就日志看 安装的是 10.2.0.1


silent install rac 10gR2  你follow   的是哪一个文档？


是否有参考 以下文档
  1. Silent Installation of Oracle 10g RAC Database on Unix Platform

  3. [Callout Text]
  4. This article describes a practical way of Oracle 10g RAC Database silent Installation on Unix Platform. The detailed installation steps with response files and logs have been given.
  5. Silent Installation of Oracle 10g RAC Database on Unix Platform.. 1
  6. 1. The Advantage of Silent Installation. 1
  7. 2. Silent Installation With Response File. 1
  8. A. Create New Response File. 1
  9. B. Edit the Response File. 1
  10. C. Perform Silent Installation. 1
  11. 3. Oracle RAC Silent Installation Practice. 2
  12. A. Oracle Clusterware Silent Installation. 2
  13. B. Oracle RDBMS Software Silent Installation. 9
  14. C. Database and Instances Silent Creation. 14
  15. 4. References. 17

  17. 1. The Advantage of Silent Installation


  20. The way most DBA perform the installation is to load a CD, select options from the GUI interface and then click "Next". However, sometime GUI is slow, clicking on a few buttons and sitting back to watch a progress bar is just a wasting of time. Situation become even worse when some Unix servers do not have a GUI interface available. With the silent installation and response files, you can load the media once and practically eliminate any user input, just to start and switch to other work and then come back to check the installation log. This art discuss about the detailed steps for Oracle 10g RAC silent installation.



  24. 2. Silent Installation With Response File


  27. The first step to perform a silent installation is to create the response files. There are sample response files come with the Oracle installation CDs of almost every release, however, you can create your own response file based on your own installation options using the -record option of runInstaller.

  29. A. Create New Response File

  31. We can record the response file in a GUI available server, and then use the response file for the installation on other server if the installation options are the same, as using the command below:

  33. ./runInstaller -record -destinationFile
  34. where the is the complete path for the new response file[1].

  36. The OUI then shows up the welcome page. Follow the same installation step as usual and just before the actual installation started the OUI will generate the response file with the option you selected.



  40. B. Edit the Response File

  42. If the response files are used for the installation on other servers, edit the response file for IP address, hostname and cluster settings;


  45. C. Perform Silent Installation

  47. The silent installation is performed by start Oracle Universal Installer with the response file specified as below :

  49. ./runInstaller -responseFile
  50. where are the options such as -force or -ignoreSysPrereqs.


  53. Upon successful installation, OUI will prompt you to run the oraInstRoot.sh script with root privileges




  58. 3. Oracle RAC Silent Installation Practice

  60. A. Oracle Clusterware Silent Installation

  62. After executing of CDROM/disk2/clusterware/rootpre/rootpre.sh,
  63. we run CDROM/disk2/clusterware/runInstaller -record -destinationFile /tmp/install_crs.rsp

  65. The installation GUI comes out and we following the same steps as usual:









  75. On the confirmation page, before click the "install" button , the OUI will generated the response file as below:


  78. With the response file we can apply the silent installation on other server , with the command
  79. ./runInstaller -silent -responseFile /tmp/install_crs.rsp



  83. If the VIP configuration need to be modified, we can invoke the vipca in silent mode with "root" user using command as below:

  85. as root use,
  86. cd $CRS_HOME/bin
  87. ./vipca -silent -nodelist node1,node2 -nodevips node1/node1-vip-addr/netmask/interface,node2/node2-vip-addr/netmask/interface.. -orahome


  90. # ./vipca -silent -nodelist SGEPRDDB1A,SGEPRDDB2A -nodevips SGEPRDDB1A/203.117.80.58/255.255.255.0/en4,SGEPRDDB2A/203.117.80.59/255.255.255.0/en4 -orahome /software/app/oracle/product/10.2.0/db

  92. Creating VIP application resource on (0) nodes.
  93. Creating GSD application resource on (0) nodes.
  94. Creating ONS application resource on (0) nodes.
  95. Starting VIP application resource on (2) nodes...
  96. Starting GSD application resource on (2) nodes...
  97. Starting ONS application resource on (2) nodes...

  99. Done.
  100. B. Oracle RDBMS Software Silent Installation


  103. After executing of CDROM/disk1/database/rootpre/rootpre.sh,
  104. we run CDROM/disk1/database/runInstaller -record -destinationFile /tmp/install_10g.rsp with the following steps:







  112. Just before the actual installation , the OUI will generate the response file as below:



  116. Now with the response file we can apply the silent installation on other server as below

  118. ./runInstaller -silent -responseFile /tmp/install_10g.rsp

  120. SGEPRDDB1A>$ ./runInstaller -record -destinationFile /tmp/install_10g.rsp
  121. **************************************************************************
  122. ******

  124. Your platform requires the root user to perform certain pre-installation
  125. OS preparation. The root user should run the shell script 'rootpre.sh' is
  126. fore
  127. you proceed with Oracle installation. rootpre.sh can be found at the top
  128. level
  129. of the CD or the stage area.

  131. Answer 'y' if root has run 'rootpre.sh' so you can proceed with Oracle
  132. installation.
  133. Answer 'n' to abort installation and then ask root to run 'rootpre.sh'.

  135. **************************************************************************
  136. ******

  138. Has 'rootpre.sh' been run by root? [y/n] (n)
  139. y

  141. Starting Oracle Universal Installer...

  143. No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.
  144. Preparing to launch Oracle Universal Installer from /software/app/oracle/OraInstall2007-01-31_08-33-14AM. Please wait ...oracle@SGEPRDDB1A:/cdrom/disk1/database#Oracle Universal Installer, Version 10.2.0.1.0 Production
  145. Copyright (C) 1999, 2005, Oracle. All rights reserved.

  147. You can find a log of this install session at:
  148. /software/app/oracle/oraInventory/logs/installActions2007-01-31_08-33-14AM.log
  149. .................................................................................................... 100% Done.


  152. Loading Product Information
  153. .................................................................................................................... 100% Done.


  156. Performing tests to see whether nodes are available
  157. ............................................................... 100% Done.


  160. Analyzing dependencies
  161. .........................................................................
  162. Starting execution of Prerequisites...
  163. Total No of checks: 8

  165. Performing check for CertifiedVersions
  166. Checking operating system requirements ...
  167. Expected result: One of 5200.004,5300.002
  168. Actual Result: 5200.004
  169. Check complete. The overall result of this check is: Passed


  172. Check complete: Passed
  173. =======================================================================
  174. Performing check for Packages
  175. Checking operating system package requirements ...
  176. Checking for bos.adt.base(0.0); found bos.adt.base(5.2.0.50). Passed
  177. Checking for bos.adt.lib(0.0); found bos.adt.lib(5.2.0.50). Passed
  178. Checking for bos.adt.libm(0.0); found bos.adt.libm(5.2.0.75). Passed
  179. Checking for bos.perf.libperfstat(0.0); found bos.perf.libperfstat(5.2.0.60). Passed
  180. Checking for bos.perf.perfstat(0.0); found bos.perf.perfstat(5.2.0.60). Passed
  181. .....
  182. =======================================================================
  183. PrereqChecks complete

  185. ........................................... 100% Done.


  188. -----------------------------------------------------------------------------
  189. Summary
  190. Global Settings
  191. Source: /cdrom/disk1/database/stage/products.xml
  192. Oracle Home: /software/app/oracle/product/10.2.0 (Oracle10gr2)
  193. Node Name: SGEPRDDB1A
  194. Installation Type: Enterprise Edition
  195. Product Languages
  196. English
  197. Space Requirements
  198. /software/ Required 3.66GB (includes 200MB temporary) : Available 17.89GB
  199. /tmp/ Required 9MB (only as temporary space) : Available 36MB
  200. New Installations (107 products)
  201. Oracle Database 10g 10.2.0.1.0
  202. Enterprise Edition Options 10.2.0.1.0
  203. .....
  204. -----------------------------------------------------------------------------


  207. Installation in progress (Wed Jan 31 08:33:39 GMT+08:00 2007)
  208. ............................................................... 6% Done.
  209. ............................................................... 13% Done.
  210. ............................................................... 20% Done.
  211. ............................................................... 26% Done.
  212. ............................................................... 33% Done.
  213. ............................................................... 40% Done.
  214. ............................................................... 46% Done.
  215. ............................................................... 53% Done.
  216. ............................................................... 60% Done.
  217. ............................................................... 66% Done.
  218. Install successful

  220. Linking in progress (Wed Jan 31 08:36:30 GMT+08:00 2007)
  221. ..................................... 66% Done.
  222. Link successful

  224. Setup in progress (Wed Jan 31 08:38:55 GMT+08:00 2007)
  225. ..................................... 100% Done.
  226. Setup successful

  228. End of install phases.(Wed Jan 31 08:39:04 GMT+08:00 2007)
  229. WARNING:A new inventory has been created on one or more nodes in this session. However, it has not yet been registered as the central inventory of this system.
  230. To register the new inventory please run the script at '/software/app/oracle/oraInventory/orainstRoot.sh' with root privileges on nodes 'SGEPRDDB1A','SGEPRDDB2A'.
  231. If you do not register the inventory, you may not be able to update or patch the products you installed.

  233. The following configuration scripts
  234. /software/app/oracle/product/10.2.0/root.sh
  235. need to be executed as root in the nodes: SGEPRDDB1A,SGEPRDDB2A for configuring the system(s). If you skip the execution of the configuration tools, the configuration will not be complete and the product wont function properly. In order to get the product to function properly, you will be required to execute the scripts and the configuration tools after exiting the OUI.
  236. The installation of Oracle Database 10g was successful.
  237. Please check '/software/app/oracle/oraInventory/logs/silentInstall2007-01-31_08-33-14AM.log' for more details.



  241. We need to run the follow scripts as root user in both nodes to complete the installation:
  242. /software/app/oracle/oraInventory/orainstRoot.sh
  243. /software/app/oracle/product/10.2.0/root.sh



  247. The Oracle clusterware and RDBMS patches can also be installed silently with similar method.




  252. C. Database and Instances Silent Creation

  254. The DBCA utility do not have the -record option, however, we can use the creating script function of DBCA to generate database creation scripts as below:


  257. The script will create the database on first node only and then create the instances on other node(s).

  259. On the 1st node:

  261. SGEPRDDB1A>$ cd /software/app/oracle/admin/proddb/scripts
  262. SGEPRDDB1A>$ ls
  263. CreateClustDBViews.sql CreateDBFiles.sql proddb1.sql postDBCreation.sql
  264. CreateDB.sql JServer.sql emRepository.sql
  265. CreateDBCatalog.sql proddb1.sh init.ora
  266. SGEPRDDB1A>$ cat proddb1.sh
  267. #!/bin/sh
  268. mkdir -p /software/app/oracle/admin/proddb/adump
  269. mkdir -p /software/app/oracle/admin/proddb/bdump
  270. mkdir -p /software/app/oracle/admin/proddb/cdump
  271. mkdir -p /software/app/oracle/admin/proddb/dpdump
  272. mkdir -p /software/app/oracle/admin/proddb/hdump
  273. mkdir -p /software/app/oracle/admin/proddb/pfile
  274. mkdir -p /software/app/oracle/admin/proddb/udump
  275. mkdir -p /software/app/oracle/product/10.2.0/db/cfgtoollogs/dbca/proddb
  276. mkdir -p /db/proddb/ctrl
  277. ORACLE_SID=proddb1; export ORACLE_SID
  278. echo You should Add this entry in the /etc/oratab: proddb:/software/app/oracle/product/10.2.0/db:Y
  279. /software/app/oracle/product/10.2.0/db/bin/sqlplus /nolog @/software/app/oracle/admin/proddb/scripts/proddb1.sql
  280. SGEPRDDB1A>$
  281. SGEPRDDB1A>$ cat proddb1.sql
  282. set verify off
  283. PROMPT specify a password for sys as parameter 1;
  284. DEFINE sysPassword = &1
  285. PROMPT specify a password for system as parameter 2;
  286. DEFINE systemPassword = &2
  287. PROMPT specify a password for sysman as parameter 3;
  288. DEFINE sysmanPassword = &3
  289. PROMPT specify a password for dbsnmp as parameter 4;
  290. DEFINE dbsnmpPassword = &4
  291. host /software/app/oracle/product/10.2.0/db/bin/orapwd file=/software/app/oracle/product/10.2.0/db/dbs/orapwproddb1 password=&&sysPassword force=y
  292. @/software/app/oracle/admin/proddb/scripts/CreateDB.sql
  293. @/software/app/oracle/admin/proddb/scripts/CreateDBFiles.sql
  294. @/software/app/oracle/admin/proddb/scripts/CreateDBCatalog.sql
  295. @/software/app/oracle/admin/proddb/scripts/JServer.sql
  296. @/software/app/oracle/admin/proddb/scripts/emRepository.sql
  297. @/software/app/oracle/admin/proddb/scripts/CreateClustDBViews.sql
  298. host echo "SPFILE='/db/proddb/ctrl/spfileproddb.ora'" > /software/app/oracle/product/10.2.0/db/dbs/initproddb1.ora
  299. @/software/app/oracle/admin/proddb/scripts/postDBCreation.sql

  301. On the 2nd node:

  303. SGEPRDDB2A>$ cd /software/app/oracle/admin/proddb/scripts
  304. SGEPRDDB2A>$ ls
  305. CreateClustDBViews.sql CreateDBFiles.sql proddb2.sql postDBCreation.sql
  306. CreateDB.sql JServer.sql emRepository.sql
  307. CreateDBCatalog.sql proddb2.sh init.ora
  308. SGEPRDDB2A>$ cat proddb2.sh
  309. #!/bin/sh
  310. mkdir -p /software/app/oracle/admin/proddb/adump
  311. mkdir -p /software/app/oracle/admin/proddb/bdump
  312. mkdir -p /software/app/oracle/admin/proddb/cdump
  313. mkdir -p /software/app/oracle/admin/proddb/dpdump
  314. mkdir -p /software/app/oracle/admin/proddb/hdump
  315. mkdir -p /software/app/oracle/admin/proddb/pfile
  316. mkdir -p /software/app/oracle/admin/proddb/udump
  317. mkdir -p /software/app/oracle/product/10.2.0/db/cfgtoollogs/dbca/proddb
  318. mkdir -p /db/proddb/ctrl
  319. ORACLE_SID=proddb2; export ORACLE_SID
  320. echo You should Add this entry in the /etc/oratab: proddb:/software/app/oracle/product/10.2.0/db:Y
  321. /software/app/oracle/product/10.2.0/db/bin/sqlplus /nolog @/software/app/oracle/admin/proddb/scripts/proddb2.sql
  322. SGEPRDDB2A>$ cat proddb2.sql
  323. set verify off
  324. PROMPT specify a password for sys as parameter 1;
  325. DEFINE sysPassword = &1
  326. PROMPT specify a password for system as parameter 2;
  327. DEFINE systemPassword = &2
  328. PROMPT specify a password for sysman as parameter 3;
  329. DEFINE sysmanPassword = &3
  330. PROMPT specify a password for dbsnmp as parameter 4;
  331. DEFINE dbsnmpPassword = &4
  332. host /software/app/oracle/product/10.2.0/db/bin/orapwd file=/software/app/oracle/product/10.2.0/db/dbs/orapwproddb2 password=&&sysPassword force=y
  333. REM @/software/app/oracle/admin/proddb/scripts/CreateDB.sql
  334. REM @/software/app/oracle/admin/proddb/scripts/CreateDBFiles.sql
  335. REM @/software/app/oracle/admin/proddb/scripts/CreateDBCatalog.sql
  336. REM @/software/app/oracle/admin/proddb/scripts/JServer.sql
  337. REM @/software/app/oracle/admin/proddb/scripts/emRepository.sql
  338. REM @/software/app/oracle/admin/proddb/scripts/CreateClustDBViews.sql
  339. host echo SPFILE='/db/proddb/ctrl/spfileproddb.ora' > /software/app/oracle/product/10.2.0/db/dbs/initproddb2.ora
  340. host echo Run script "/software/app/oracle/admin/proddb/scripts/proddb1.sh" from node "SGEPRDDB1A" if you have not already run it.
  341. REM @/software/app/oracle/admin/proddb/scripts/postDBCreation.sql


  344. We can edit the scripts with database name and parameters, and then apply on other servers.




  349. 4. References

  351. [1] Oracle® Universal Installer and OPatch User's Guide
  352. 10g Release 2 (10.2) for Windows and UNIX
  353. http://download-west.oracle.com/docs/cd/B16240_01/doc/em.102/b16227/toc.htm
复制代码
FROM http://oracledbaforum.blogspot.c ... oracle-10g-rac.html

回复 只看该作者 道具 举报

返回列表
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-11-15 21:50 , Processed in 0.061470 second(s), 25 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569