Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- (grid@db1)(02:38:55) ~$ crsctl stat res ora.crmsdb.db -p
- NAME=ora.crmsdb.db
- TYPE=ora.database.type
- ACL=owner:oracle:rwx,pgrp:oinstall:rwx,other::r--
- ACTION_FAILURE_TEMPLATE=
- ACTION_SCRIPT=
- ACTIVE_PLACEMENT=1
- AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
- AUTO_START=restore
- CARDINALITY=2
- CHECK_INTERVAL=1
- CHECK_TIMEOUT=30
- CLUSTER_DATABASE=true
- DATABASE_TYPE=RAC
- DB_UNIQUE_NAME=CRMSDB
- 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%)
- DEGREE=1
- DESCRIPTION=Oracle Database resource
- ENABLED=1
- FAILOVER_DELAY=0
- FAILURE_INTERVAL=60
- FAILURE_THRESHOLD=1
- GEN_AUDIT_FILE_DEST=/u01/app/oracle/admin/CRMSDB/adump
- GEN_START_OPTIONS=
- GEN_START_OPTIONS@SERVERNAME(tamp20-crms-db1)=open
- GEN_START_OPTIONS@SERVERNAME(tamp20-crms-db2)=open
- GEN_USR_ORA_INST_NAME=
- GEN_USR_ORA_INST_NAME@SERVERNAME(tamp20-crms-db1)=CRMSDB1
- GEN_USR_ORA_INST_NAME@SERVERNAME(tamp20-crms-db2)=CRMSDB2
- HOSTING_MEMBERS=
- INSTANCE_FAILOVER=0
- LOAD=1
- LOGGING_LEVEL=1
- MANAGEMENT_POLICY=AUTOMATIC
- NLS_LANG=
- NOT_RESTARTING_TEMPLATE=
- OFFLINE_CHECK_INTERVAL=0
- ONLINE_RELOCATION_TIMEOUT=0
- ORACLE_HOME=/u01/app/oracle/product/11.2
- ORACLE_HOME_OLD=
- PLACEMENT=restricted
- PROFILE_CHANGE_TEMPLATE=
- RESTART_ATTEMPTS=2
- ROLE=PRIMARY
- SCRIPT_TIMEOUT=60
- SERVER_POOLS=ora.CRMSDB
- SPFILE=/u02/oradata/crmsdb/CRMSDB/spfileCRMSDB.ora
- START_DEPENDENCIES=weak(type:ora.listener.type,global:type:ora.scan_listener.type,uniform:ora.ons,global:ora.gns)
- START_TIMEOUT=600
- STATE_CHANGE_TEMPLATE=
- STOP_DEPENDENCIES=
- STOP_TIMEOUT=600
- TYPE_VERSION=3.2
- UPTIME_THRESHOLD=1h
- USR_ORA_DB_NAME=CRMSDB
- USR_ORA_DOMAIN=
- USR_ORA_ENV=
- USR_ORA_FLAGS=
- USR_ORA_INST_NAME=
- USR_ORA_INST_NAME@SERVERNAME(tamp20-crms-db1)=CRMSDB1
- USR_ORA_INST_NAME@SERVERNAME(tamp20-crms-db2)=CRMSDB2
- USR_ORA_OPEN_MODE=open
- USR_ORA_OPI=false
- USR_ORA_STOP_MODE=immediate
- VERSION=11.2.0.3.0
- Opatch info:
- (grid@db1)(02:48:21) /u01/app/grid/product/11.2/OPatch$ ./opatch lsinventory
- Oracle Interim Patch Installer version 11.2.0.3.0
- Copyright (c) 2012, Oracle Corporation. All rights reserved.
- Oracle Home : /u01/app/grid/product/11.2
- Central Inventory : /u01/app/oraInventory
- from : /u01/app/grid/product/11.2/oraInst.loc
- OPatch version : 11.2.0.3.0
- OUI version : 11.2.0.3.0
- Log file location : /u01/app/grid/product/11.2/cfgtoollogs/opatch/opatch2014-07-16_02-48-30AM_1.log
- Lsinventory Output file location : /u01/app/grid/product/11.2/cfgtoollogs/opatch/lsinv/lsinventory2014-07-16_02-48-30AM.txt
- --------------------------------------------------------------------------------
- Installed Top-level Products (1):
- Oracle Grid Infrastructure 11.2.0.3.0
- There are 1 products installed in this Oracle Home.
- Interim patches (2) :
- Patch 14275605 : applied on Mon May 26 11:41:43 EDT 2014
- Unique Patch ID: 15379762
- Patch description: "Database Patch Set Update : 11.2.0.3.4 (14275605)"
- Created on 3 Oct 2012, 18:38:19 hrs PST8PDT
- Sub-patch 13923374; "Database Patch Set Update : 11.2.0.3.3 (13923374)"
- Sub-patch 13696216; "Database Patch Set Update : 11.2.0.3.2 (13696216)"
- Sub-patch 13343438; "Database Patch Set Update : 11.2.0.3.1 (13343438)"
- Bugs fixed:
- 14480676, 13566938, 13419660, 10350832, 13632717, 14063281, 12919564
- 13624984, 13430938, 13467683, 13588248, 13420224, 14548763, 13080778
- 12646784, 13804294, 12861463, 12834027, 13377816, 13036331, 12880299
- 14664355, 13499128, 14409183, 12998795, 12829021, 13492735, 12794305
- 13503598, 10133521, 12718090, 13742433, 12905058, 12401111, 13742434
- 13257247, 12849688, 13362079, 12950644, 13742435, 13464002, 12917230
- 13923374, 12879027, 14613900, 12585543, 12535346, 14480675, 12588744
- 11877623, 14480674, 13916709, 12847466, 13773133, 14076523, 13649031
- 13340388, 13366202, 13528551, 13981051, 12894807, 13343438, 12582664
- 12748240, 12797765, 13385346, 12923168, 13384182, 13612575, 13466801
- 13484963, 12971775, 11063191, 13772618, 13070939, 12797420, 13035804
- 13041324, 12976376, 11708510, 13742437, 13737746, 14062795, 13035360
- 12693626, 13742438, 13326736, 13332439, 14038787, 14062796, 12913474
- 13001379, 14390252, 13099577, 13370330, 13059165, 14062797, 14275605
- 9873405, 13742436, 9858539, 14062794, 13358781, 12960925, 13699124
- 12662040, 9703627, 12617123, 13338048, 12938841, 12658411, 12620823
- 12845115, 12656535, 14062793, 12678920, 12764337, 13354082, 13397104
- 14062792, 13250244, 12594032, 9761357, 12612118, 13742464, 13550185
- 13457582, 13527323, 12780983, 12583611, 13502183, 12780098, 13705338
- 13696216, 13476583, 11840910, 13903046, 13572659, 13718279, 13554409
- 13657605, 13103913, 14063280
- Patch 14275572 : applied on Mon May 26 11:36:17 EDT 2014
- Unique Patch ID: 15379762
- Patch description: "Grid Infrastructure Patch Set Update : 11.2.0.3.4 (14275572)"
- Created on 12 Oct 2012, 00:27:42 hrs PST8PDT
- Bugs fixed:
- 14275572, 13919095, 13696251, 13348650, 12659561, 13039908, 13825231
- 13036424, 12794268, 13011520, 13569812, 12758736, 13000491, 13498267
- 13077654, 13001901, 13550689, 13430715, 13806545, 11675721, 14082976
- 12771830, 12538907, 13947200, 13066371, 13483672, 12594616, 13540563
- 12897651, 12897902, 13241779, 12896850, 12726222, 12829429, 12728585
- 13079948, 12876314, 13090686, 12925041, 12995950, 13251796, 12650672
- 12398492, 12848480, 13582411, 13652088, 12990582, 13857364, 12975811
- 12917897, 13082238, 12947871, 13037709, 13371153, 12878750, 10114953
- 11772838, 13058611, 13001955, 11836951, 12965049, 13440962, 12765467
- 13727853, 13425727, 12885323, 13965075, 13339443, 12784559, 13332363
- 13074261, 12971251, 13811209, 12709476, 13460353, 13523527, 12857064
- 13719731, 13396284, 12899169, 13111013, 13323698, 12867511, 12639013
- 12959140, 13085732, 12829917, 10317921, 13843080, 12934171, 12849377
- 12349553, 13924431, 13869978, 12680491, 12914824, 13789135, 12730342
- 13334158, 12950823, 10418841, 13355963, 13531373, 13776758, 12720728
- 13620816, 13002015, 13023609, 13024624, 12791719, 13886023, 13255295
- 13821454, 12782756, 14625969, 14152875, 14186070, 12873909, 14214257
- 12914722, 13243172, 12842804, 13045518, 12765868, 12772345, 12663376
- 13345868, 14059576, 13683090, 12932852, 13889047, 12695029, 13146560
- 13038806, 14251904, 14070200, 13820621, 14304758, 13396356, 13697828
- 13258062, 12834777, 12996572, 13941934, 13657366, 13019958, 12810890
- 13888719, 13502441, 13726162, 13880925, 14153867, 13506114, 12820045
- 13604057, 12823838, 13877508, 12823042, 14494305, 13582706, 13617861
- 12825835, 13263435, 13025879, 13853089, 14009845, 13410987, 13570879
- 13637590, 12827493, 13247273, 13068077
- Rac system comprising of multiple nodes
- Local node = tamp20-crms-db1
- Remote node = tamp20-crms-db2
- --------------------------------------------------------------------------------
- OPatch succeeded.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement