Advertisement
netdiver

Untitled

Jul 16th, 2014
387
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.07 KB | None | 0 0
  1. (grid@db1)(02:38:55) ~$ crsctl stat res ora.crmsdb.db -p
  2. NAME=ora.crmsdb.db
  3. TYPE=ora.database.type
  4. ACL=owner:oracle:rwx,pgrp:oinstall:rwx,other::r--
  5. ACTION_FAILURE_TEMPLATE=
  6. ACTION_SCRIPT=
  7. ACTIVE_PLACEMENT=1
  8. AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
  9. AUTO_START=restore
  10. CARDINALITY=2
  11. CHECK_INTERVAL=1
  12. CHECK_TIMEOUT=30
  13. CLUSTER_DATABASE=true
  14. DATABASE_TYPE=RAC
  15. DB_UNIQUE_NAME=CRMSDB
  16. DEFAULT_TEMPLATE=PROPERTY(RESOURCE_CLASS=database) PROPERTY(DB_UNIQUE_NAME= CONCAT(PARSE(%NAME%, ., 2), %USR_ORA_DOMAIN%, .)) ELEMENT(INSTANCE_NAME= %GEN_USR_ORA_INST_NAME%) ELEMENT(DATABASE_TYPE= %DATABASE_TYPE%)
  17. DEGREE=1
  18. DESCRIPTION=Oracle Database resource
  19. ENABLED=1
  20. FAILOVER_DELAY=0
  21. FAILURE_INTERVAL=60
  22. FAILURE_THRESHOLD=1
  23. GEN_AUDIT_FILE_DEST=/u01/app/oracle/admin/CRMSDB/adump
  24. GEN_START_OPTIONS=
  25. GEN_START_OPTIONS@SERVERNAME(tamp20-crms-db1)=open
  26. GEN_START_OPTIONS@SERVERNAME(tamp20-crms-db2)=open
  27. GEN_USR_ORA_INST_NAME=
  28. GEN_USR_ORA_INST_NAME@SERVERNAME(tamp20-crms-db1)=CRMSDB1
  29. GEN_USR_ORA_INST_NAME@SERVERNAME(tamp20-crms-db2)=CRMSDB2
  30. HOSTING_MEMBERS=
  31. INSTANCE_FAILOVER=0
  32. LOAD=1
  33. LOGGING_LEVEL=1
  34. MANAGEMENT_POLICY=AUTOMATIC
  35. NLS_LANG=
  36. NOT_RESTARTING_TEMPLATE=
  37. OFFLINE_CHECK_INTERVAL=0
  38. ONLINE_RELOCATION_TIMEOUT=0
  39. ORACLE_HOME=/u01/app/oracle/product/11.2
  40. ORACLE_HOME_OLD=
  41. PLACEMENT=restricted
  42. PROFILE_CHANGE_TEMPLATE=
  43. RESTART_ATTEMPTS=2
  44. ROLE=PRIMARY
  45. SCRIPT_TIMEOUT=60
  46. SERVER_POOLS=ora.CRMSDB
  47. SPFILE=/u02/oradata/crmsdb/CRMSDB/spfileCRMSDB.ora
  48. START_DEPENDENCIES=weak(type:ora.listener.type,global:type:ora.scan_listener.type,uniform:ora.ons,global:ora.gns)
  49. START_TIMEOUT=600
  50. STATE_CHANGE_TEMPLATE=
  51. STOP_DEPENDENCIES=
  52. STOP_TIMEOUT=600
  53. TYPE_VERSION=3.2
  54. UPTIME_THRESHOLD=1h
  55. USR_ORA_DB_NAME=CRMSDB
  56. USR_ORA_DOMAIN=
  57. USR_ORA_ENV=
  58. USR_ORA_FLAGS=
  59. USR_ORA_INST_NAME=
  60. USR_ORA_INST_NAME@SERVERNAME(tamp20-crms-db1)=CRMSDB1
  61. USR_ORA_INST_NAME@SERVERNAME(tamp20-crms-db2)=CRMSDB2
  62. USR_ORA_OPEN_MODE=open
  63. USR_ORA_OPI=false
  64. USR_ORA_STOP_MODE=immediate
  65. VERSION=11.2.0.3.0
  66.  
  67.  
  68.  
  69.  
  70. Opatch info:
  71. (grid@db1)(02:48:21) /u01/app/grid/product/11.2/OPatch$ ./opatch lsinventory
  72. Oracle Interim Patch Installer version 11.2.0.3.0
  73. Copyright (c) 2012, Oracle Corporation. All rights reserved.
  74.  
  75.  
  76. Oracle Home : /u01/app/grid/product/11.2
  77. Central Inventory : /u01/app/oraInventory
  78. from : /u01/app/grid/product/11.2/oraInst.loc
  79. OPatch version : 11.2.0.3.0
  80. OUI version : 11.2.0.3.0
  81. Log file location : /u01/app/grid/product/11.2/cfgtoollogs/opatch/opatch2014-07-16_02-48-30AM_1.log
  82.  
  83. Lsinventory Output file location : /u01/app/grid/product/11.2/cfgtoollogs/opatch/lsinv/lsinventory2014-07-16_02-48-30AM.txt
  84.  
  85. --------------------------------------------------------------------------------
  86. Installed Top-level Products (1):
  87.  
  88. Oracle Grid Infrastructure 11.2.0.3.0
  89. There are 1 products installed in this Oracle Home.
  90.  
  91.  
  92. Interim patches (2) :
  93.  
  94. Patch 14275605 : applied on Mon May 26 11:41:43 EDT 2014
  95. Unique Patch ID: 15379762
  96. Patch description: "Database Patch Set Update : 11.2.0.3.4 (14275605)"
  97. Created on 3 Oct 2012, 18:38:19 hrs PST8PDT
  98. Sub-patch 13923374; "Database Patch Set Update : 11.2.0.3.3 (13923374)"
  99. Sub-patch 13696216; "Database Patch Set Update : 11.2.0.3.2 (13696216)"
  100. Sub-patch 13343438; "Database Patch Set Update : 11.2.0.3.1 (13343438)"
  101. Bugs fixed:
  102. 14480676, 13566938, 13419660, 10350832, 13632717, 14063281, 12919564
  103. 13624984, 13430938, 13467683, 13588248, 13420224, 14548763, 13080778
  104. 12646784, 13804294, 12861463, 12834027, 13377816, 13036331, 12880299
  105. 14664355, 13499128, 14409183, 12998795, 12829021, 13492735, 12794305
  106. 13503598, 10133521, 12718090, 13742433, 12905058, 12401111, 13742434
  107. 13257247, 12849688, 13362079, 12950644, 13742435, 13464002, 12917230
  108. 13923374, 12879027, 14613900, 12585543, 12535346, 14480675, 12588744
  109. 11877623, 14480674, 13916709, 12847466, 13773133, 14076523, 13649031
  110. 13340388, 13366202, 13528551, 13981051, 12894807, 13343438, 12582664
  111. 12748240, 12797765, 13385346, 12923168, 13384182, 13612575, 13466801
  112. 13484963, 12971775, 11063191, 13772618, 13070939, 12797420, 13035804
  113. 13041324, 12976376, 11708510, 13742437, 13737746, 14062795, 13035360
  114. 12693626, 13742438, 13326736, 13332439, 14038787, 14062796, 12913474
  115. 13001379, 14390252, 13099577, 13370330, 13059165, 14062797, 14275605
  116. 9873405, 13742436, 9858539, 14062794, 13358781, 12960925, 13699124
  117. 12662040, 9703627, 12617123, 13338048, 12938841, 12658411, 12620823
  118. 12845115, 12656535, 14062793, 12678920, 12764337, 13354082, 13397104
  119. 14062792, 13250244, 12594032, 9761357, 12612118, 13742464, 13550185
  120. 13457582, 13527323, 12780983, 12583611, 13502183, 12780098, 13705338
  121. 13696216, 13476583, 11840910, 13903046, 13572659, 13718279, 13554409
  122. 13657605, 13103913, 14063280
  123.  
  124. Patch 14275572 : applied on Mon May 26 11:36:17 EDT 2014
  125. Unique Patch ID: 15379762
  126. Patch description: "Grid Infrastructure Patch Set Update : 11.2.0.3.4 (14275572)"
  127. Created on 12 Oct 2012, 00:27:42 hrs PST8PDT
  128. Bugs fixed:
  129. 14275572, 13919095, 13696251, 13348650, 12659561, 13039908, 13825231
  130. 13036424, 12794268, 13011520, 13569812, 12758736, 13000491, 13498267
  131. 13077654, 13001901, 13550689, 13430715, 13806545, 11675721, 14082976
  132. 12771830, 12538907, 13947200, 13066371, 13483672, 12594616, 13540563
  133. 12897651, 12897902, 13241779, 12896850, 12726222, 12829429, 12728585
  134. 13079948, 12876314, 13090686, 12925041, 12995950, 13251796, 12650672
  135. 12398492, 12848480, 13582411, 13652088, 12990582, 13857364, 12975811
  136. 12917897, 13082238, 12947871, 13037709, 13371153, 12878750, 10114953
  137. 11772838, 13058611, 13001955, 11836951, 12965049, 13440962, 12765467
  138. 13727853, 13425727, 12885323, 13965075, 13339443, 12784559, 13332363
  139. 13074261, 12971251, 13811209, 12709476, 13460353, 13523527, 12857064
  140. 13719731, 13396284, 12899169, 13111013, 13323698, 12867511, 12639013
  141. 12959140, 13085732, 12829917, 10317921, 13843080, 12934171, 12849377
  142. 12349553, 13924431, 13869978, 12680491, 12914824, 13789135, 12730342
  143. 13334158, 12950823, 10418841, 13355963, 13531373, 13776758, 12720728
  144. 13620816, 13002015, 13023609, 13024624, 12791719, 13886023, 13255295
  145. 13821454, 12782756, 14625969, 14152875, 14186070, 12873909, 14214257
  146. 12914722, 13243172, 12842804, 13045518, 12765868, 12772345, 12663376
  147. 13345868, 14059576, 13683090, 12932852, 13889047, 12695029, 13146560
  148. 13038806, 14251904, 14070200, 13820621, 14304758, 13396356, 13697828
  149. 13258062, 12834777, 12996572, 13941934, 13657366, 13019958, 12810890
  150. 13888719, 13502441, 13726162, 13880925, 14153867, 13506114, 12820045
  151. 13604057, 12823838, 13877508, 12823042, 14494305, 13582706, 13617861
  152. 12825835, 13263435, 13025879, 13853089, 14009845, 13410987, 13570879
  153. 13637590, 12827493, 13247273, 13068077
  154.  
  155.  
  156.  
  157. Rac system comprising of multiple nodes
  158. Local node = tamp20-crms-db1
  159. Remote node = tamp20-crms-db2
  160.  
  161. --------------------------------------------------------------------------------
  162.  
  163. OPatch succeeded.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement