'오라클' 카테고리의 글 목록 (40 Page)

2014. 3. 25. 13:33 오라클

11gR2 RAC parameter 권장값

11gR2 RAC 권장 파라미터 정리

############# For Single ##############

alter system set Audit_trail=NONE scope=spfile;
alter system set db_files=1000 scope=spfile;
alter system set db_cache_advice=ON scope=spfile;
alter system set deferred_segment_creation=false scope=spfile;
alter system set fast_start_mttr_target=240 scope=spfile;
alter system set sec_case_sensitive_logon=false scope=spfile;
alter system set open_links_per_instance=40 scope=spfile;
alter system set open_links=40 scope=spfile;
alter system set optimizer_connect_by_cost_based=false scope=spfile;
#alter system set optimizer_dynamic_sampling=0 scope=spfile; #OLTP 0 DW 2
alter system set optimizer_secure_view_merging=false scope=spfile;
alter system set parallel_adaptive_multi_user=false scope=spfile;
alter system set resource_manager_plan='FORCE:' scope=spfile;

alter system set "_add_col_optim_enabled"=false scope=spfile;
alter system set "_datafile_write_errors_crash_instance"=false scope=spfile;
alter system set "_b_tree_bitmap_plans"=false scope=spfile;
alter system set "_bloom_filter_enabled=false scope=spfile;
alter system set "_cleanup_rollback_entries"=500 scope=spfile;
alter system set "_db_mttr_advice"=OFF scope=spfile;
#alter system set _enqueue_hash_chain_latches= scope=spfile; #CPU core*3
alter system set "_index_partition_large_extents"=false scope=spfile;
alter system set "_in_memory_undo"=false scope=spfile;
alter system set "_library_cache_advice"=false scope=spfile;
alter system set "_nlj_batching_enabled"=0 scope=spfile;
alter system set "_nlj_batching_misses_enabled"=0 scope=spfile;
alter system set "_optim_peek_user_binds"=false scope=spfile;
alter system set "_optimizer_adaptive_cursor_sharing"=false scope=spfile;
alter system set "_optimizer_connect_by_cost_based"=false scope=spfile;
alter system set "_optimizer_extended_cursor_sharing"=NONE scope=spfile;
alter system set "_optimizer_extended_cursor_sharing_rel"=NONE scope=spfile;
alter system set "_optimizer_use_feedback"=false scope=spfile;
alter system set "_optimizer_null_aware_antijoin"=false scope=spfile;
alter system set "_partition_large_extents"=false scope=spfile;
alter system set "_PX_use_large_pool"=true scope=spfile;
alter system set "_rollback_segment_count=1000" scope=spfile;
alter system set "_row_cr"=false scope=spfile;
alter system set "_undo_autotune"=false scope=spfile;
alter system set "_use_adaptive_log_file_sync"=false scope=spfile;
alter system set "_memory_imm_mode_without_autosga"=false scope=spfile;

============ For RAC ####################

alter system set Audit_trail=NONE scope=spfile;
alter system set db_files=1000 scope=spfile;
alter system set db_cache_advice=ON scope=spfile;
alter system set deferred_segment_creation=false scope=spfile;
alter system set fast_start_mttr_target=240 scope=spfile;
alter system set sec_case_sensitive_logon=false scope=spfile;
alter system set open_links_per_instance=40 scope=spfile;
alter system set open_links=40 scope=spfile;
alter system set optimizer_connect_by_cost_based=false scope=spfile;
#alter system set optimizer_dynamic_sampling=0 scope=spfile; #OLTP 0 DW 2
alter system set optimizer_secure_view_merging=false scope=spfile;
alter system set parallel_adaptive_multi_user=false scope=spfile;
alter system set parallel_force_local=true scope=spfile;
alter system set resource_manager_plan='FORCE:' scope=spfile;

alter system set "_add_col_optim_enabled"=false scope=spfile;
alter system set "_datafile_write_errors_crash_instance"=false scope=spfile;
alter system set "_b_tree_bitmap_plans"=false scope=spfile;
alter system set "_bloom_filter_enabled=false scope=spfile;
alter system set "_cleanup_rollback_entries"=500 scope=spfile;
alter system set "_clusterwide_global_transactions"=false scope=spfile;
alter system set "_db_mttr_advice"=OFF scope=spfile;
#alter system set _enqueue_hash_chain_latches= scope=spfile; #CPU core*3
alter system set "_index_partition_large_extents"=false scope=spfile;
alter system set "_in_memory_undo"=false scope=spfile;
alter system set "_gc_bypass_readers"=FALSE scope=spfile;
alter system set "_gc_integrity_checks"=0 scope=spfile;
alter system set "_gc_maximum_bids"=8 scope=spfile;
alter system set "_gc_policy_time"=0 scope=spfile;
alter system set "_gc_read_mostly_locking"=FALSE scope=spfile;
alter system set "_gc_undo_affinity"=false scope=spfile;
alter system set "_library_cache_advice"=false scope=spfile;
alter system set "_nlj_batching_enabled"=0 scope=spfile;
alter system set "_nlj_batching_misses_enabled"=0 scope=spfile;
alter system set "_optim_peek_user_binds"=false scope=spfile;
alter system set "_optimizer_adaptive_cursor_sharing"=false scope=spfile;
alter system set "_optimizer_connect_by_cost_based"=false scope=spfile;
alter system set "_optimizer_extended_cursor_sharing"=NONE scope=spfile;
alter system set "_optimizer_extended_cursor_sharing_rel"=NONE scope=spfile;
alter system set "_optimizer_use_feedback"=false scope=spfile;
alter system set "_optimizer_null_aware_antijoin"=false scope=spfile;
alter system set "_partition_large_extents"=false scope=spfile;
alter system set "_px_execution_services_enabled"=false scope=spfile;
alter system set "_PX_use_large_pool"=true scope=spfile;
alter system set "_rollback_segment_count=1000" scope=spfile;
alter system set "_row_cr"=false scope=spfile;
alter system set "_undo_autotune"=false scope=spfile;
alter system set "_use_adaptive_log_file_sync"=false scope=spfile;
alter system set "_memory_imm_mode_without_autosga"=false scope=spfile;

자세한 설명은 생략한다.

저작자표시 비영리 변경금지

Posted by pat98

2014. 3. 17. 10:23 오라클

exadata flashcache 모드 변경

Exadata FlashCache 모드를 write-through 에서 write-back 모드로 바꾸어 보자.

- 온라인중 플래쉬캐쉬 writeback 모드로 변경하기 (DB & ASM Up 상태)

1. 플래쉬캐쉬 drop

# cellcli -e drop flashcache

2. offlne된 디스크가 있는지 확인

# cellcli -e list griddisk attributes name,asmmodestatus,asmdeactivationoutcome

3. 그리드디스크 비활성화

# cellcli ?e alter griddisk all inactive

4. 셀서비스 내리기

# cellcli -e alter cell shutdown services cellsrv

5. writeback 모드로 변경

# cellcli -e "alter cell flashCacheMode=writeback"

6. 셀서비스 재시작

# cellcli -e alter cell startup services cellsrv

7. 그리드디스크 재활성화

# cellcli ?e alter griddisk all active

8. 그리드디스크가 성공적으로 온라인 되었는지 확인

# cellcli -e list griddisk attributes name, asmmodestatus

9. 플래쉬캐쉬 재성성

# cellcli -e create flashcache all

10. WriteBack 모드인지 확인

# cellcli -e list cell detail | grep flashCacheMode

11. 다음 셀에 동일한 작업 반복 (작업전 'asmdeactivationoutcome' 이 YES 인지 반드시 확인)

# cellcli -e list griddisk attributes name,asmmodestatus,asmdeactivationoutcome

- 오프라인 플래쉬캐쉬 writeback 모드로 변경하기 (DB & ASM Down 상태)

1. 플래쉬캐쉬 drop

# cellcli -e drop flashcache

2. 셀서비스 내리기

# cellcli -e alter cell shutdown services cellsrv

3. writeback 모드로 변경

# cellcli -e "alter cell flashCacheMode=writeback"

4. 셀서비스 재시작

# cellcli -e alter cell startup services cellsrv

5. 플래쉬캐쉬 재성성

# cellcli -e create flashcache all

저작자표시 비영리 변경금지

Posted by pat98

2014. 2. 27. 01:32 오라클

RAC Database 에 Exadata Bundle Patch (Patch Set 11.2.0.4.3)

흔하지는 않은 경우인데 일반 RAC Database 에 Exadata Bundle Patch 를 적용해 본다. (Exadata 의 DB 를 일반 RAC DB 로 Migration 해야하는 작업 때문에 진행함)

현재 RAC 11.2.0.4 버전이고 bundle patch 가 적용되어 있지 않은 상태이다. 적용시킬 Exadata 패치는 11.2.0.4.3 이다.

(본래 Patchset 2 11.2.0.3.22 BP 테스트 하여야 하나 준비된 시스템이 11.2.0.4 이여서 이대로 진행함)

=> 일단 결론, 비 Exadata DB 에도 Exadata Bundle Patch 적용가능하다.

자세한 사항은 MOS 888828.1 및 Patch화일 내 README 화일 참고

1. CRS 구동중 확인

[root:/root]#ps -ef |grep d.bin
root      2470     1 0 Feb26 ?        00:00:09 /oraclegrid/product/11.2.0.4/bin/ohasd.bin reboot
oracle    3056     1 0 Feb26 ?        00:00:00 /oraclegrid/product/11.2.0.4/bin/mdnsd.bin
oracle    3069     1 0 Feb26 ?        00:00:01 /oraclegrid/product/11.2.0.4/bin/gpnpd.bin
oracle    3081     1 0 Feb26 ?        00:00:07 /oraclegrid/product/11.2.0.4/bin/gipcd.bin
root      3097     1 1 Feb26 ?        00:00:25 /oraclegrid/product/11.2.0.4/bin/osysmond.bin
oracle    3150     1 0 Feb26 ?        00:00:09 /oraclegrid/product/11.2.0.4/bin/ocssd.bin
root      3295     1 0 Feb26 ?        00:00:05 /oraclegrid/product/11.2.0.4/bin/octssd.bin reboot
oracle    3319     1 0 Feb26 ?        00:00:04 /oraclegrid/product/11.2.0.4/bin/evmd.bin
root      4006     1 0 Feb26 ?        00:00:10 /oraclegrid/product/11.2.0.4/bin/crsd.bin reboot
root      9032 6225 0 00:09 pts/1    00:00:00 grep d.bin

2. Patch 화일 압축해제

[root:/oraclegrid]#unzip p17904156_112040_Linux-x86-64.zip
Archive: p17904156_112040_Linux-x86-64.zip
   creating: 17904156/
inflating: 17904156/README.txt
   creating: 17904156/17839474/
   creating: 17904156/17839474/etc/
   creating: 17904156/17839474/etc/xml/
inflating: 17904156/17839474/etc/xml/GenericActions.xml
inflating: 17904156/17839474/etc/xml/ShiphomeDirectoryStructure.xml
   creating: 17904156/17839474/etc/config/
inflating: 17904156/17839474/etc/config/actions.xml
inflating: 17904156/17839474/etc/config/deploy.xml
inflating: 17904156/17839474/etc/config/inventory.xml
   creating: 17904156/17839474/files/
   creating: 17904156/17839474/files/bin/

[oracle:/oraclegrid/17904156]#ls -al
total 172
drwxr-xr-x 5 root root 4096 Jan 10 00:20 .
drwxr-xr-x 9 root dba 4096 Feb 27 00:10 ..
drwxr-xr-x 4 root root 4096 Jan 10 00:18 17839474
drwxr-xr-x 5 root root 4096 Jan 10 00:18 17943261
drwxr-xr-x 5 root root 4096 Jan 10 00:20 17984784
-rw-r--r-- 1 root root 645 Jan 10 00:18 bundle.xml
-rw-rw-r-- 1 root root 99200 Feb 21 00:47 README.html
-rw-rw-r-- 1 root root 41943 Feb 21 00:47 README.txt

3. 권한 변경

chown -R oracle:oinstall /oraclegrid/17904156

4. OPatch 충돌 Check

(For Grid Home)
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oraclegrid/17904156/17943261
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oraclegrid/17904156/17984784
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oraclegrid/17904156/17839474

(For Database home)
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oraclegrid/17904156/17943261
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oraclegrid/17904156/17984784/custom/server/17984784

5. OPatch 여유공간 Check

(For Grid Home)
$ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /oraclegrid/17904156/17943261
$ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /oraclegrid/17904156/17984784
$ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /oraclegrid/17904156/17839474

(For Database home)
$ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /oraclegrid/17904156/17943261
$ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /oraclegrid/17904156/17984784/custom/server/17984784

6. 진행시작 (조신하게 기다리도록 한다)

[root:/oraclegrid/17904156]#opatch auto /oraclegrid/17904156
Executing /oraclegrid/product/11.2.0.4/perl/bin/perl /oraclegrid/product/11.2.0.4/OPatch/crs/patch11203.pl -patchdir /oraclegrid -patchn 17904156 -paramfile /oraclegrid/product/11.2.0.4/crs/install/crsconfig_params
/oraclegrid/product/11.2.0.4/crs/install/crsconfig_params
/oraclegrid/product/11.2.0.4/crs/install/s_crsconfig_defs

This is the main log file: /oraclegrid/product/11.2.0.4/cfgtoollogs/opatchauto2014-02-27_00-17-47.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system: /oraclegrid/product/11.2.0.4/cfgtoollogs/opatchauto2014-02-27_00-17-47.report.log

2014-02-27 00:17:47: Starting Clusterware Patch Setup
Using configuration parameter file: /oraclegrid/product/11.2.0.4/crs/install/crsconfig_params
patch /oraclegrid/17904156/17943261 apply successful for home /oracle/product/11.2.0.4
patch /oraclegrid/17904156/17984784/custom/server/17984784 apply successful for home /oracle/product/11.2.0.4
patch /oraclegrid/17904156/17839474 apply successful for home /oracle/product/11.2.0.4
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac1'
CRS-2673: Attempting to stop 'ora.crsd' on 'rac1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac1'
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'rac1'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac1'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac1'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'rac1'
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'rac1'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.rac1.vip' on 'rac1'
CRS-2677: Stop of 'ora.registry.acfs' on 'rac1' succeeded
CRS-2677: Stop of 'ora.scan1.vip' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.scan1.vip' on 'rac2'
CRS-2677: Stop of 'ora.rac1.vip' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.rac1.vip' on 'rac2'
CRS-2676: Start of 'ora.scan1.vip' on 'rac2' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'rac2'
CRS-2676: Start of 'ora.rac1.vip' on 'rac2' succeeded
CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'rac2' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'rac1'
CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'rac1'
CRS-2677: Stop of 'ora.ons' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'rac1'
CRS-2677: Stop of 'ora.net1.network' on 'rac1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac1' has completed
CRS-2677: Stop of 'ora.crsd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'rac1'
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac1'
CRS-2673: Attempting to stop 'ora.evmd' on 'rac1'
CRS-2673: Attempting to stop 'ora.asm' on 'rac1'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac1'
CRS-2677: Stop of 'ora.evmd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'rac1'
CRS-2677: Stop of 'ora.drivers.acfs' on 'rac1' succeeded
CRS-2677: Stop of 'ora.cssd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.crf' on 'rac1'
CRS-2677: Stop of 'ora.crf' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'rac1'
CRS-2677: Stop of 'ora.gipcd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac1'
CRS-2677: Stop of 'ora.gpnpd' on 'rac1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
Successfully unlock /oraclegrid/product/11.2.0.4
patch /oraclegrid/17904156/17943261 apply successful for home /oraclegrid/product/11.2.0.4
patch /oraclegrid/17904156/17984784 apply successful for home /oraclegrid/product/11.2.0.4
patch /oraclegrid/17904156/17839474 apply successful for home /oraclegrid/product/11.2.0.4
Installing Trace File Analyzer
CRS-4123: Oracle High Availability Services has been started.

7. 패치 확인

[oracle:/home/oracle]#opatch lsinventory -detail
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation. All rights reserved.

Oracle Home       : /oracle/product/11.2.0.4
Central Inventory : /oraclegrid/oraInventory
   from           : /oracle/product/11.2.0.4/oraInst.loc
OPatch version    : 11.2.0.3.4
OUI version       : 11.2.0.4.0
Log file location : /oracle/product/11.2.0.4/cfgtoollogs/opatch/opatch2014-02-27_01-13-08AM_1.log

Lsinventory Output file location : /oracle/product/11.2.0.4/cfgtoollogs/opatch/lsinv/lsinventory2014-02-27_01-13-08AM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Database 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.

Installed Products (136):

Agent Required Support Files                                         10.2.0.4.5
Assistant Common Files                                               11.2.0.4.0
Bali Share                                                           1.1.18.0.0
Buildtools Common Files                                              11.2.0.4.0
Character Set Migration Utility                                      11.2.0.4.0
Cluster Verification Utility Common Files                            11.2.0.4.0
Database Configuration and Upgrade Assistants                        11.2.0.4.0
Database SQL Scripts                                                 11.2.0.4.0
Database Workspace Manager                                           11.2.0.4.0
Deinstallation Tool                                                  11.2.0.4.0
Enterprise Edition Options                                           11.2.0.4.0
Enterprise Manager Agent                                             10.2.0.4.5
Enterprise Manager Agent Core Files                                  10.2.0.4.5
Enterprise Manager Common Core Files                                 10.2.0.4.5
Enterprise Manager Common Files                                      10.2.0.4.5
Enterprise Manager Database Plugin -- Agent Support                  11.2.0.4.0
Enterprise Manager Database Plugin -- Repository Support             11.2.0.4.0
Enterprise Manager Grid Control Core Files                           10.2.0.4.5
Enterprise Manager plugin Common Files                               11.2.0.4.0
Enterprise Manager Repository Core Files                             10.2.0.4.5
Exadata Storage Server                                               11.2.0.1.0
Expat libraries                                                       2.0.1.0.1
Generic Connectivity Common Files                                    11.2.0.4.0
HAS Common Files                                                     11.2.0.4.0
HAS Files for DB                                                     11.2.0.4.0
Installation Common Files                                            11.2.0.4.0
Installation Plugin Files                                            11.2.0.4.0
Installer SDK Component                                              11.2.0.4.0
JAccelerator (COMPANION)                                             11.2.0.4.0
Java Development Kit                                                1.5.0.51.10
LDAP Required Support Files                                          11.2.0.4.0
OLAP SQL Scripts                                                     11.2.0.4.0
Oracle 11g Warehouse Builder Required Files                          11.2.0.4.0
Oracle Advanced Security                                             11.2.0.4.0
Oracle Application Express                                           11.2.0.4.0
Oracle Call Interface (OCI)                                          11.2.0.4.0
Oracle Clusterware RDBMS Files                                       11.2.0.4.0
Oracle Code Editor                                                   1.2.1.0.0I
Oracle Configuration Manager                                         10.3.8.1.0
Oracle Configuration Manager Client                                  10.3.2.1.0
Oracle Configuration Manager Deconfiguration                         10.3.1.0.0
Oracle Containers for Java                                           11.2.0.4.0
Oracle Core Required Support Files                                   11.2.0.4.0
Oracle Data Mining RDBMS Files                                       11.2.0.4.0
Oracle Database 11g                                                  11.2.0.4.0
Oracle Database 11g                                                  11.2.0.4.0
Oracle Database 11g Multimedia Files                                 11.2.0.4.0
Oracle Database Deconfiguration                                      11.2.0.4.0
Oracle Database Gateway for ODBC                                     11.2.0.4.0
Oracle Database User Interface                                       2.2.13.0.0
Oracle Database Utilities                                            11.2.0.4.0
Oracle Database Vault J2EE Application                               11.2.0.4.0
Oracle Database Vault option                                         11.2.0.4.0
Oracle DBCA Deconfiguration                                          11.2.0.4.0
Oracle Display Fonts                                                  9.0.2.0.0
Oracle Enterprise Manager Console DB                                 11.2.0.4.0
Oracle Extended Windowing Toolkit                                    3.4.47.0.0
Oracle Globalization Support                                         11.2.0.4.0
Oracle Globalization Support                                         11.2.0.4.0
Oracle Help For Java                                                  4.2.9.0.0
Oracle Help for the Web                                             2.0.14.0.0
Oracle Ice Browser                                                    5.2.3.6.0
Oracle Internet Directory Client                                     11.2.0.4.0
Oracle Java Client                                                   11.2.0.4.0
Oracle JDBC Server Support Package                                   11.2.0.4.0
Oracle JDBC/OCI Instant Client                                       11.2.0.4.0
Oracle JDBC/THIN Interfaces                                          11.2.0.4.0
Oracle JFC Extended Windowing Toolkit                                4.2.36.0.0
Oracle JVM                                                           11.2.0.4.0
Oracle Label Security                                                11.2.0.4.0
Oracle LDAP administration                                           11.2.0.4.0
Oracle Locale Builder                                                11.2.0.4.0
Oracle Message Gateway Common Files                                  11.2.0.4.0
Oracle Multimedia                                                    11.2.0.4.0
Oracle Multimedia Annotator                                          11.2.0.4.0
Oracle Multimedia Client Option                                      11.2.0.4.0
Oracle Multimedia Java Advanced Imaging                              11.2.0.4.0
Oracle Multimedia Locator                                            11.2.0.4.0
Oracle Multimedia Locator RDBMS Files                                11.2.0.4.0
Oracle Net                                                           11.2.0.4.0
Oracle Net Listener                                                  11.2.0.4.0
Oracle Net Required Support Files                                    11.2.0.4.0
Oracle Net Services                                                  11.2.0.4.0
Oracle Netca Client                                                  11.2.0.4.0
Oracle Notification Service                                          11.2.0.3.0
Oracle Notification Service (eONS)                                   11.2.0.4.0
Oracle ODBC Driver                                                   11.2.0.4.0
Oracle ODBC Driverfor Instant Client                                 11.2.0.4.0
Oracle OLAP                                                          11.2.0.4.0
Oracle OLAP API                                                      11.2.0.4.0
Oracle OLAP RDBMS Files                                              11.2.0.4.0
Oracle One-Off Patch Installer                                       11.2.0.3.4
Oracle Partitioning                                                  11.2.0.4.0
Oracle Programmer                                                    11.2.0.4.0
Oracle Quality of Service Management (Client)                        11.2.0.4.0
Oracle RAC Deconfiguration                                           11.2.0.4.0
Oracle RAC Required Support Files-HAS                                11.2.0.4.0
Oracle Real Application Testing                                      11.2.0.4.0
Oracle Recovery Manager                                              11.2.0.4.0
Oracle Security Developer Tools                                      11.2.0.4.0
Oracle Spatial                                                       11.2.0.4.0
Oracle SQL Developer                                                 11.2.0.4.0
Oracle Starter Database                                              11.2.0.4.0
Oracle Text                                                          11.2.0.4.0
Oracle Text Required Support Files                                   11.2.0.4.0
Oracle UIX                                                           2.2.24.6.0
Oracle Universal Connection Pool                                     11.2.0.4.0
Oracle Universal Installer                                           11.2.0.4.0
Oracle USM Deconfiguration                                           11.2.0.4.0
Oracle Wallet Manager                                                11.2.0.4.0
Oracle XML Development Kit                                           11.2.0.4.0
Oracle XML Query                                                     11.2.0.4.0
Parser Generator Required Support Files                              11.2.0.4.0
Perl Interpreter                                                     5.10.0.0.2
Perl Modules                                                         5.10.0.0.1
PL/SQL                                                               11.2.0.4.0
PL/SQL Embedded Gateway                                              11.2.0.4.0
Platform Required Support Files                                      11.2.0.4.0
Precompiler Common Files                                             11.2.0.4.0
Precompiler Required Support Files                                   11.2.0.4.0
Provisioning Advisor Framework                                       10.2.0.4.3
RDBMS Required Support Files                                         11.2.0.4.0
RDBMS Required Support Files for Instant Client                      11.2.0.4.0
RDBMS Required Support Files Runtime                                 11.2.0.4.0
regexp                                                                2.1.9.0.0
Required Support Files                                               11.2.0.4.0
Sample Schema Data                                                   11.2.0.4.0
Secure Socket Layer                                                  11.2.0.4.0
SQL*Plus                                                             11.2.0.4.0
SQL*Plus Files for Instant Client                                    11.2.0.4.0
SQL*Plus Required Support Files                                      11.2.0.4.0
SQLJ Runtime                                                         11.2.0.4.0
SSL Required Support Files for InstantClient                         11.2.0.4.0
XDK Required Support Files                                           11.2.0.4.0
XML Parser for Java                                                  11.2.0.4.0
XML Parser for Oracle JVM                                            11.2.0.4.0
There are 136 products installed in this Oracle Home.

Interim patches (3) :

Patch 17839474     : applied on Thu Feb 27 00:22:02 KST 2014
Unique Patch ID: 17071278
Patch description: "DISKMON PATCH FOR EXADATA (JAN2014 - 11.2.0.4.3) : (17839474)"
   Created on 22 Dec 2013, 21:51:42 hrs PST8PDT
   Bugs fixed:
     17839474
   Files Touched:
     diskmon.bin --> ORACLE_HOME/bin/diskmon.bin
   Patch Location in Inventory:
     /oracle/product/11.2.0.4/inventory/oneoffs/17839474
   Patch Location in Storage area:
     /oracle/product/11.2.0.4/.patch_storage/17839474_Dec_22_2013_21_51_42

Patch 17984784     : applied on Thu Feb 27 00:21:41 KST 2014
Unique Patch ID: 17154638
Patch description: "CRS PATCH FOR EXADATA (JAN2014 - 11.2.0.4.3) : (17984784)"
   Created on 8 Jan 2014, 22:53:15 hrs PST8PDT
   Bugs fixed:
     16613232, 14525998, 17065496, 17551223, 16346413
   Files Touched:
     cluvfyrac.sh --> ORACLE_HOME/bin/cluvfyrac.sh
     crsdiag.pl --> ORACLE_HOME/bin/crsdiag.pl
     gnsd --> ORACLE_HOME/bin/gnsd
     lsnodes --> ORACLE_HOME/bin/lsnodes
     racgwrap --> ORACLE_HOME/bin/racgwrap
     racgwrap.sbs --> ORACLE_HOME/bin/racgwrap.sbs
     srvconfig --> ORACLE_HOME/bin/srvconfig
     rootofs.sh --> ORACLE_HOME/crs/install/rootofs.sh
     s_crsconfig_defs --> ORACLE_HOME/crs/install/s_crsconfig_defs
     env_has.mk --> ORACLE_HOME/crs/lib/env_has.mk
     crsar.msb --> ORACLE_HOME/crs/mesg/crsar.msb
     crscs.msb --> ORACLE_HOME/crs/mesg/crscs.msb
     crsd.msb --> ORACLE_HOME/crs/mesg/crsd.msb
     crsdk.msb --> ORACLE_HOME/crs/mesg/crsdk.msb
     crse.msb --> ORACLE_HOME/crs/mesg/crse.msb
     crsel.msb --> ORACLE_HOME/crs/mesg/crsel.msb
     crsf.msb --> ORACLE_HOME/crs/mesg/crsf.msb
     crshu.msb --> ORACLE_HOME/crs/mesg/crshu.msb
     crsi.msb --> ORACLE_HOME/crs/mesg/crsi.msb
     crsiw.msb --> ORACLE_HOME/crs/mesg/crsiw.msb
     crsja.msb --> ORACLE_HOME/crs/mesg/crsja.msb
     crsko.msb --> ORACLE_HOME/crs/mesg/crsko.msb
     crsn.msb --> ORACLE_HOME/crs/mesg/crsn.msb
     crsnl.msb --> ORACLE_HOME/crs/mesg/crsnl.msb
     crspl.msb --> ORACLE_HOME/crs/mesg/crspl.msb
     crspt.msb --> ORACLE_HOME/crs/mesg/crspt.msb

중간 생략

     sclcus.msg --> ORACLE_HOME/srvm/mesg/sclcus.msg
     sclsus.msg --> ORACLE_HOME/srvm/mesg/sclsus.msg
     srvm.jar --> ORACLE_HOME/oui/jlib/srvm.jar
     srvmasm.jar --> ORACLE_HOME/oui/jlib/srvmasm.jar
     libsrvm11.so --> ORACLE_HOME/oui/lib/linux/libsrvm11.so
     ins_srvm.mk --> ORACLE_HOME/srvm/lib/install_srvm
     ins_has.mk --> ORACLE_HOME/racg/lib/install
   Patch Location in Inventory:
     /oracle/product/11.2.0.4/inventory/oneoffs/17984784
   Patch Location in Storage area:
     /oracle/product/11.2.0.4/.patch_storage/17984784_Jan_8_2014_22_53_15

Patch 17943261     : applied on Thu Feb 27 00:20:05 KST 2014
Unique Patch ID: 17071278
Patch description: "DATABASE PATCH FOR EXADATA (JAN2014 - 11.2.0.4.3) : (17943261)"
   Created on 1 Jan 2014, 21:20:56 hrs PST8PDT
Sub-patch 17741631; "DATABASE PATCH FOR EXADATA (DEC 2013 - 11.2.0.4.2) : (17741631)"
Sub-patch 17628006; "DATABASE PATCH FOR EXADATA (NOV 2013 - 11.2.0.4.1) : (17628006)"
   Bugs fixed:
     17288409, 13944971, 16450169, 17265217, 16180763, 16220077, 17465741
     17614227, 16069901, 14010183, 16285691, 17726838, 13364795, 17088068
     17612828, 17443671, 17080436, 17761775, 16721594, 16043574, 16837842
     17446237, 16863422, 17332800, 13609098, 17610798, 17501491, 17239687
     17468141, 17752121, 17602269, 16850630, 17346671, 17313525, 14852021
     17783588, 17437634, 13866822, 12905058, 17546761
   Files Touched:
     /lpxm.o --> ORACLE_HOME/lib/libxml11.a
     /lpxfsm.o --> ORACLE_HOME/lib/libxml11.a
     xsl --> ORACLE_HOME/bin/xsl
     xmlcg --> ORACLE_HOME/bin/xmlcg
     xvm --> ORACLE_HOME/bin/xvm
     ins_emagent.mk --> ORACLE_HOME/sysman/lib/e2eme
     lxinst --> ORACLE_HOME/bin/lxinst
     sdodbmig.sql --> ORACLE_HOME/md/admin/sdodbmig.sql
     catmd10i.sql --> ORACLE_HOME/md/admin/catmd10i.sql
     sdopatch.sql --> ORACLE_HOME/md/admin/sdopatch.sql
     sdodbmig.sql --> ORACLE_HOME/md/admin/sdodbmig.sql
     catmd10i.sql --> ORACLE_HOME/md/admin/catmd10i.sql
     /pkv.o --> ORACLE_HOME/lib/libpls11.a
     /kopt.o --> ORACLE_HOME/lib/libgeneric11.a
     /qcd.o --> ORACLE_HOME/lib/libgeneric11.a

중간 생략

     ins_rdbms.mk --> ORACLE_HOME/rdbms/lib/irman
     libcell11.so --> ORACLE_HOME/lib/libcell11.so
     orion.o --> ORACLE_HOME/rdbms/lib/orion.o
     spawrio.sql --> ORACLE_HOME/rdbms/admin/spawrio.sql
     utlu112i.sql --> ORACLE_HOME/rdbms/admin/utlu112i.sql
     utlu112x.sql --> ORACLE_HOME/rdbms/admin/utlu112x.sql
   Patch Location in Inventory:
     /oracle/product/11.2.0.4/inventory/oneoffs/17943261
     /oracle/product/11.2.0.4/inventory/oneoffs/17741631
     /oracle/product/11.2.0.4/inventory/oneoffs/17628006
   Patch Location in Storage area:
     /oracle/product/11.2.0.4/.patch_storage/17943261_Jan_1_2014_21_20_56

Rac system comprising of multiple nodes
Local node = rac1
Remote node = rac2

--------------------------------------------------------------------------------

OPatch succeeded.

[oracle:/home/oracle]#crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [11.2.0.4.0]

[oracle:/home/oracle]#crsctl query crs releaseversion
Oracle High Availability Services release version on the local node is [11.2.0.4.0]

[oracle:/home/oracle]#crsctl query crs softwareversion
Oracle Clusterware version on node [rac1] is [11.2.0.4.0]

패치 해봤으니 롤백하자..

[root:/root]#opatch auto /oraclegrid/17904156 -rollback
Executing /oraclegrid/product/11.2.0.4/perl/bin/perl /oraclegrid/product/11.2.0.4/OPatch/crs/patch11203.pl -patchdir /oraclegrid -patchn 17904156 -rollback -paramfile /oraclegrid/product/11.2.0.4/crs/install/crsconfig_params
/oraclegrid/product/11.2.0.4/crs/install/crsconfig_params
/oraclegrid/product/11.2.0.4/crs/install/s_crsconfig_defs

This is the main log file: /oraclegrid/product/11.2.0.4/cfgtoollogs/opatchauto2014-02-27_01-57-19.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system: /oraclegrid/product/11.2.0.4/cfgtoollogs/opatchauto2014-02-27_01-57-19.report.log

2014-02-27 01:57:19: Starting Clusterware Patch Setup
Using configuration parameter file: /oraclegrid/product/11.2.0.4/crs/install/crsconfig_params
patch 17943261 rollback successful for home /oracle/product/11.2.0.4
patch 17984784 rollback successful for home /oracle/product/11.2.0.4
patch 17839474 rollback successful for home /oracle/product/11.2.0.4
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac1'
CRS-2673: Attempting to stop 'ora.crsd' on 'rac1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac1'
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'rac1'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac1'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac1'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.rac1.vip' on 'rac1'
CRS-2677: Stop of 'ora.registry.acfs' on 'rac1' succeeded
CRS-2677: Stop of 'ora.rac1.vip' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.rac1.vip' on 'rac2'
CRS-2676: Start of 'ora.rac1.vip' on 'rac2' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'rac1'
CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'rac1'
CRS-2677: Stop of 'ora.ons' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'rac1'
CRS-2677: Stop of 'ora.net1.network' on 'rac1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac1' has completed
CRS-2677: Stop of 'ora.crsd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac1'
CRS-2673: Attempting to stop 'ora.evmd' on 'rac1'
CRS-2673: Attempting to stop 'ora.asm' on 'rac1'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'rac1'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac1'
CRS-2677: Stop of 'ora.ctssd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.evmd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'rac1'
CRS-2677: Stop of 'ora.drivers.acfs' on 'rac1' succeeded
CRS-2677: Stop of 'ora.cssd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.crf' on 'rac1'
CRS-2677: Stop of 'ora.crf' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'rac1'
CRS-2677: Stop of 'ora.gipcd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac1'
CRS-2677: Stop of 'ora.gpnpd' on 'rac1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
Successfully unlock /oraclegrid/product/11.2.0.4
patch 17943261 rollback successful for home /oraclegrid/product/11.2.0.4
patch 17984784 rollback successful for home /oraclegrid/product/11.2.0.4
patch 17839474 rollback successful for home /oraclegrid/product/11.2.0.4
Installing Trace File Analyzer
CRS-4123: Oracle High Availability Services has been started.

[oracle:/home/oracle]#opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation. All rights reserved.

Oracle Home       : /oracle/product/11.2.0.4
Central Inventory : /oraclegrid/oraInventory
   from           : /oracle/product/11.2.0.4/oraInst.loc
OPatch version    : 11.2.0.3.4
OUI version       : 11.2.0.4.0
Log file location : /oracle/product/11.2.0.4/cfgtoollogs/opatch/opatch2014-02-27_02-16-28AM_1.log

Lsinventory Output file location : /oracle/product/11.2.0.4/cfgtoollogs/opatch/lsinv/lsinventory2014-02-27_02-16-28AM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Database 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

Rac system comprising of multiple nodes
Local node = rac1
Remote node = rac2

--------------------------------------------------------------------------------

저작자표시 비영리 변경금지

Posted by pat98

2014. 2. 20. 22:48 오라클

Exadata scrub 기능

위 자료에 소개된 disk scrubbing 에 대한 추가 설명인데 구글링하다가 자료가 없어 답답해서 직접 포스팅한다.

Automatic harddisk scrubbing 이 Grid Infrastructure 11.2.0.4 와 Image version 11.2.3.3 에서 지원되는 듯 하다.

최근 나온 X4-2 에 적용된것 같고..

설정값을 조회해 보면

CELLCLI> list cell attributes harddiskscrubinterval detail

harddiskscrubinterval : biweekly

기본으로 2주에 한번씩 수행되도록 설정되어 있으며, biweekly, weekly, daily , none 4개의 설정값을 가지고 있다.

none 으로 하면 scrub 을 수행하지 않는다.

CELLCLI> alter cell hardDiskScrubInterval=none

Idle 한 디스크 1개를 scrubbing 하는데 소요되는 시간은 아래와 같다.

2023. 3 Update

scrub 작동 시간도 수동으로 설정할수 있는데 아래와 같이 조회하고 실행시간도 변경할 수 있다.

CELLCLI> list cell attributes harddiskscrubstarttime detail

harddiskscrubstarttime 1970-01-01T09:00:00+09:00

CELLCLI> alter cell harddiskscrubstarttime='2013-08-07T21"19:22-07:00'

or

alter cell harddiskscrubstarttime=now

참고로 hardDiskScrubInterval,harddiskscrubstarttime 속성은

CELLCLI> list cell attributes detail 해도 조회가 되지 않는다.

저작자표시 비영리 변경금지

Posted by pat98

2014. 2. 19. 22:54 오라클

Exadata user guide

엑사데이타의 User manual 은 onecommand 안에 꽁꽁 숨겨져(?) 있습니다.

필요하신 분들을 위해 같이 공유하고자 합니다.

Oracle® Exadata Database Machine owners guide (E13874-30)

Oracle® Exadata Storage Server Software users guide(E13861-19)

Posted by pat98

2014. 2. 6. 14:54 오라클

exadata cellcli 명령어

1. check cell status

CellCLI> list cell
CellCLI> list cell detail

2. Physical Disk Information

CellCLI> list physicaldisk
CellCLI> list physicaldisk E15SBS detail

3. LUN Disks Detail

CellCLI> list lun
CellCLI> list lun 0_0 detail
CellCLI> list lun 5_3 detail

4. Cell Disks Report

CellCLI> list celldisk
CellCLI> list celldisk CD_08_exadatalcel10 detail
CellCLI>list celldisk attributes name, devicePartition where size>200g;
CellCLI> list celldisk attributes name,status,size

5. Grid Disk Knowledge

CellCLI> list griddisk
CellCLI> list celldisk CD_02_exadatalcel10 detail
CellCLI> list griddisk DATA_DMORL_CD_02_exadatalcel10 detail
CellCLI> list griddisk DBFS_DG_CD_02_exadatalcel10 detail
CellCLI> list griddisk RECO_DMORL_CD_02_exadatalcel10 detail

6. Display Exadate Alerts

CellCLI> list alerthistory
CellCLI> list alerthistory 8_1 detail
CellCLI> list alerthistory where severity like '[warning|critical]'
CellCLI> list alertdefinition detail

7. Restart Cell Services

CellCLI> list cell detail
CellCLI> alter cell restart services rs
CellCLI> alter cell restart services ms
CellCLI> alter cell restart services cellsrv
CellCLI> alter cell restart services all

CellCLI> alter cell shutdown services rs
CellCLI> alter cell shutdown services ms
CellCLI> alter cell shutdown services cellsrv

저작자표시 비영리 변경금지

Posted by pat98

2013. 12. 26. 17:49 오라클

11g rac resource 제거

기존의 ASM 및 Diskgroup, SCAN IP 제거 등은 많이 해 보았을 것이다.

눈에 거슬리는 거의 사용하지 않는 그 외의 항목을 제거해 보자.

제거하고 싶은 리소스는 ora.gsd, ora.oc4j, ora.cvu,ora.registry.acfs 이렇게 4가지 놈들이다.

구글링 해도 잘 나와있지 않은 방법이다...답답해서 내가 직접 ..ㅋㅋ

[root:/root]#crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE ONLINE       test1
               ONLINE ONLINE       test2
ora.LISTENER.lsnr
               ONLINE ONLINE       test1
               ONLINE ONLINE       test2
ora.asm
               ONLINE ONLINE       test1                    Started
               ONLINE ONLINE       test2                    Started
ora.gsd
               OFFLINE OFFLINE      test1
               OFFLINE OFFLINE      test2
ora.net1.network
               ONLINE ONLINE       test1
               ONLINE ONLINE       test2
ora.ons
               ONLINE ONLINE       test1
               ONLINE ONLINE       test2
ora.registry.acfs
               ONLINE ONLINE       test1
               ONLINE ONLINE       test2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE ONLINE       test1
ora.cvu
      1        ONLINE ONLINE       test1
ora.oc4j
      1        ONLINE ONLINE       test1
ora.scan1.vip
      1        ONLINE ONLINE       test1
ora.test.db
      1        ONLINE ONLINE       test1                    Open
      2        ONLINE ONLINE       test2                    Open
ora.test1.vip
      1        ONLINE ONLINE       test1
ora.test2.vip
      1        ONLINE ONLINE       test2

제거해 보자

1. crsctl delete resource ora.gsd

2. crsctl delete resource ora.oc4j -f or srvctl remove oc4j

3. crsctl delete resource ora.cvu or srvctl remove cvu

4. crsctl delete resource ora.registry.acfs -f

확인해 보면 다 날라가 있다..

[root:/root]#crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE ONLINE       test1
               ONLINE ONLINE       test2
ora.LISTENER.lsnr
               ONLINE ONLINE       test1
               ONLINE ONLINE       test2
ora.asm
               ONLINE ONLINE       test1                    Started
               ONLINE ONLINE       test2                    Started

ora.net1.network
               ONLINE ONLINE       test1
               ONLINE ONLINE       test2
ora.ons
               ONLINE ONLINE       test1
               ONLINE ONLINE       test2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE ONLINE       test1
ora.scan1.vip
      1        ONLINE ONLINE       test1
ora.test.db
      1        ONLINE ONLINE       test1                    Open
      2        ONLINE ONLINE       test2                    Open
ora.test1.vip
      1        ONLINE ONLINE       test1
ora.test2.vip
      1        ONLINE ONLINE       test2

추가해 보자..

1. crsctl add resource ora.gsd -type ora.gsd.type
2. crsctl add resource ora.oc4j -type ora.oc4j.type or srvctl add oc4j

3. crsctl add resource ora.cvu -type ora.cvu.type or srvctl add cvu

4. crsctl add resource ora.registry.acfs -type ora.registry.acfs.type

다시 확인해 보면 추가되어 있다...

끝...

저작자표시 비영리 변경금지

Posted by pat98

2013. 12. 10. 14:15 오라클

oracle profile

* Oracle 환경변수 (for 11g RAC)
umask 022
export ORACLE_OWNER=oracle
export ORACLE_BASE=/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0
export GRID_HOME=/oragrid/product/11.2.0
export ORACLE_SID=RAC1
export ORACLE_TERM=vt100
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_NLS10=$ORACLE_HOME/nls/data
export NLS_LANG=American_America.KO16KSC5601
export PATH=$ORACLE_HOME/bin:/bin:/sbin:.:$PATH:$ORACLE_HOME/OPatch
export SHLIB_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:/usr/lib:/lib:$ORACLE_HOME/rdbms/lib
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:/usr/lib:/lib
export PS1=[`whoami`:'$PWD']#
export AIXTHREAD_SCOPE=S
alias ss='sqlplus "/as sysdba"'
stty erase ^H

-----------------------------------------

* Oracle 환경변수 (HP-UX)
umask 022
export ORACLE_OWNER=oracle
export ORACLE_BASE=/oracle
export ORACLE_HOME=$ORACLE_BASE/ora10
export ORACLE_SID=ORA10
export ORACLE_TERM=vt100
#export TMPDIR=$ORACLE_BASE/tmp
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export NLS_LANG=American_America.KO16KSC5601
export PATH=$ORACLE_HOME/bin:/bin:/sbin:.:$PATH:$ORACLE_HOME/OPatch/bin
export SHLIB_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:/usr/lib:/lib:$ORACLE_HOME/rdbms/lib
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:/usr/lib:/lib
export PS1=[`whoami`:'$PWD']#
alias ss='sqlplus "/as sysdba"'
stty erase ^H

-----------------------------------------
* Oracle 환경변수 (Linux)
umask 022
export ORACLE_OWNER=oracle
export ORACLE_BASE=/oracle/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/db
export GRID_HOME=/oragrid/app/grid
export ORACLE_SID=TEST1
export ORACLE_TERM=vt100
#export TMPDIR=$ORACLE_BASE/tmp
export TNS_ADMIN=$ORACLE_HOME/network/admin
#export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export NLS_LANG=American_America.UTF8
export PATH=$ORACLE_HOME/bin:/bin:/sbin:.:$PATH:$ORACLE_HOME/OPatch
export SHLIB_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:/usr/lib:/lib:$ORACLE_HOME/rdbms/lib
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:/usr/lib:/lib
export PS1=[`whoami`:'$PWD']#
export LANG=C
#export LD_ASSUME_KERNEL=2.4.1
alias sp='sqlplus "/as sysdba"'
stty erase ^H

-----------------------------------------

* Oracle 환경변수 (AIX)
umask 022
export ORACLE_OWNER=oracle
export ORACLE_BASE=/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0
export ORACLE_SID=ILMOA
export ORACLE_TERM=vt100
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export NLS_LANG=AMERICAN_AMERICA.UTF8
export PATH=$ORACLE_HOME/bin:/bin:/sbin:.:$PATH:$ORACLE_HOME/OPatch
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:/usr/lib:/lib
export PS1="`whoami`@`hostname`:[\${PWD}]#>"
export LIBPATH=$ORACLE_HOME/lib:/usr/lib
export AIXTHREAD_SCOPE=S
export LANG=en_US
stty erase ^H
alias ss='sqlplus "/as sysdba"'

저작자표시 비영리 변경금지

Posted by pat98

2013. 12. 10. 11:10 오라클

Vendor별 Clusterware 상태확인

Veritas Clusterware
# /opt/VRTSvcs/bin/hastatus -summary

-- SYSTEM STATE
-- System State Frozen

A node01 RUNNING 0
A node02 RUNNING 0

-- GROUP STATE
-- Group System Probed AutoDisabled State

B ClusterService node01 Y N ONLINE
B ClusterService node02 Y N ONLINE
B cvm node01 Y N ONLINE
B cvm node02 Y N ONLINE
B oradatacfs node01 Y N ONLINE
B oradatacfs node02 Y N ONLINE
B oraraw_vols node01 Y N ONLINE
B oraraw_vols node02 Y N ONLINE

AIX HACMP Clusterware
# /usr/sbin/cluster/clstat -a
clstat - HACMP Cluster Status Monitor
-------------------------------------

Cluster: aixclu34 (1214048368)
Thu Mar 26 22:05:42 GMT 2009
State: UP Nodes: 2
SubState: STABLE

Node: aixclu3 State: UP
Interface: aixclu3 (0) Address: 132.22.11.80
State: UP
Interface: aixclu3-prv (1) Address: 132.22.5.55
State: UP
Resource Group: ora_clu34 State: On line

Node: aixclu4 State: UP
Interface: aixclu4 (0) Address: 132.22.11.82
State: UP
Interface: aixclu4-prv (1) Address: 132.22.5.56
State: UP
Resource Group: ora_clu34 State: On line

HP MC Service Guard Clusterware
Utility cmviewcl will provide cluster status but the location of this may
vary. You will first need to check the location of the variable 'SGSBIN'
in /etc/cmcluster.conf.
The /usr/local/cmcluster/bin directory is the default location of the
cmviewcl command. However this might be different so do check /etc/cmcluster.conf

$ /usr/sbin/cmviewcl

CLUSTER STATUS
hpclu02 up

NODE STATUS STATE
hpclu6 up running

PACKAGE STATUS STATE AUTO_RUN NODE
11gnode1 up running enabled hpclu6

NODE STATUS STATE
hpclu7 up running

PACKAGE STATUS STATE AUTO_RUN NODE
11gnode2 up running enabled hpclu7

NODE STATUS STATE
hpclu8 up running

PACKAGE STATUS STATE AUTO_RUN NODE
11gnode3 up running enabled hpclu8

UNOWNED_PACKAGES

Sun Clusterware For SPARC

chipset implementations we will need to install the Oracle UDLM
package. Oracle provides a UDLM patch that you must install onto each node in
the cluster from the /udlm directory on the clusterware directory before
installing and configuring RAC.
For x86 64-bit systems, the skgxn libraries are included as part of the
SUNWscucm x86 package, UDLM is not required.

In earlier versions prior to Sun Cluster 3.2 please use
'/usr/cluster/bin/clnode -show'

# /usr/cluster/bin/cluster status

=== Cluster Nodes ===

--- Node Status ---

Node Name Status
--------- ------
solclu2 Online
solclu1 Online

=== Cluster Transport Paths ===

Endpoint1 Endpoint2 Status
--------- --------- ------
solclu2:rge1 solclu1:rge1 Path online
solclu2:rge0 solclu1:rge0 faulted

=== Cluster Quorum ===

--- Quorum Votes Summary ---

Needed Present Possible
------ ------- --------
3 5 5

--- Quorum Votes by Node ---

Node Name Present Possible Status
--------- ------- -------- ------
solclu2 1 1 Online
solclu1 1 1 Online

--- Quorum Votes by Device ---

Device Name Present Possible Status
----------- ------- -------- ------
d11 1 1 Online
d12 1 1 Online
d13 1 1 Online
=== Cluster Resources ===

Resource Name Node Name State Status Message
------------- --------- ----- --------------
rac_framework        solclu2 Online Online
                                  solclu1 Online Online
crs_framework-rs     solclu2 Online Online
                                  solclu1 Online Online

저작자표시 비영리 변경금지

Posted by pat98

2013. 12. 5. 00:05 오라클

opatch auto 의 이해

ORACLE_HOME, GRID_HOME 에 최신 OPatch 파일을 풀어 주고..

테스트에 사용된 Patchset LInux x86_64 11.2.0.3.7 GI Patch set 이다.

패치과정을 살펴보고 어떤식으로 진행되는지 Review 해보도록 한다.

여기서 혼동하지 말아야할 것은 1번, 2번 서버가 있다고 하면..

opatch auto 를 실행한 서버만 auto 로 Patch 가 적용된다고 하는것이다. 절대 2번 서버도 같이 패치되지 않는다.

2번도 별도로 진행해 주어야 한다.

순서

1. 1번 node down

2. 패치적용

3. 1번 node up

4. 2번 node down

5. 패치적용

6. 2번 node up

[root:/oragrid/product/11.2.0/OPatch]#./opatch auto /oragrid -oh /oragrid/product/11.2.0 -ocmrf /oragrid/product/11.2.0/ocm.rsp
Executing /oragrid/product/11.2.0/perl/bin/perl ./crs/patch11203.pl -patchdir / -patchn oragrid -oh /oragrid/product/11.2.0 -ocmrf /oragrid/product/11.2.0/ocm.rsp -paramfile /oragrid/product/11.2.0/crs/install/crsconfig_params
/oragrid/product/11.2.0/crs/install/crsconfig_params
/oragrid/product/11.2.0/crs/install/s_crsconfig_defs

This is the main log file: /oragrid/product/11.2.0/cfgtoollogs/opatchauto2013-12-04_23-29-49.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system: /oragrid/product/11.2.0/cfgtoollogs/opatchauto2013-12-04_23-29-49.report.log

2013-12-04 23:29:49: Starting Clusterware Patch Setup
Using configuration parameter file: /oragrid/product/11.2.0/crs/install/crsconfig_params
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac1'
CRS-2673: Attempting to stop 'ora.crsd' on 'rac1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac1'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac1'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'rac1'
CRS-2673: Attempting to stop 'ora.rac.db' on 'rac1'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac1'
CRS-2677: Stop of 'ora.rac.db' on 'rac1' succeeded
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.rac1.vip' on 'rac1'
CRS-2677: Stop of 'ora.rac1.vip' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.rac1.vip' on 'rac2'
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'rac1'
CRS-2677: Stop of 'ora.scan1.vip' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.scan1.vip' on 'rac2'
CRS-2676: Start of 'ora.rac1.vip' on 'rac2' succeeded
CRS-2676: Start of 'ora.scan1.vip' on 'rac2' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'rac2'
CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'rac2' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'rac1'
CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'rac1'
CRS-2677: Stop of 'ora.net1.network' on 'rac1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac1' has completed
CRS-2677: Stop of 'ora.crsd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac1'
CRS-2673: Attempting to stop 'ora.crf' on 'rac1'
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac1'
CRS-2673: Attempting to stop 'ora.evmd' on 'rac1'
CRS-2673: Attempting to stop 'ora.asm' on 'rac1'
CRS-2677: Stop of 'ora.mdnsd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.evmd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.crf' on 'rac1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'rac1'
CRS-2677: Stop of 'ora.cssd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'rac1'
CRS-2677: Stop of 'ora.gipcd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac1'
CRS-2677: Stop of 'ora.gpnpd' on 'rac1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
Successfully unlock /oragrid/product/11.2.0
patch //oragrid/16619898 apply successful for home /oragrid/product/11.2.0
patch //oragrid/16619892 apply failed for home /oragrid/product/11.2.0
CRS-4123: Oracle High Availability Services has been started.

패치 Step을 살펴보자..

cat /oragrid/product/11.2.0/cfgtoollogs/opatchauto2013-12-04_23-29-49.report.log

*********** Configuration Data ***********
* It shows only those targets that will be patched in this session *

crs_home=/oragrid/product/11.2.0 owner=oracle opatch_ver=11.2.0.3.5

*********** Steps to be executed as owner unless specified as root ***********

1: /oragrid/product/11.2.0/OPatch/opatch prereq CheckComponents -ph //oragrid/16619898 -oh /oragrid/product/11.2.0

2: /oragrid/product/11.2.0/OPatch/opatch prereq CheckComponents -ph //oragrid/16619892 -oh /oragrid/product/11.2.0

3: /oragrid/product/11.2.0/OPatch/opatch prereq CheckConflictAgainstOH -ph //oragrid/16619898 -oh /oragrid/product/11.2.0

4: /oragrid/product/11.2.0/OPatch/opatch prereq CheckConflictAgainstOH -ph //oragrid/16619892 -oh /oragrid/product/11.2.0

5: /oragrid/product/11.2.0/bin/emctl stop dbconsole

6: /oragrid/product/11.2.0/crs/install/rootcrs.pl -unlock : run as root

7: /sbin/fuser -k /oragrid/product/11.2.0/bin/crsctl.bin : run as root

8: /oragrid/product/11.2.0/OPatch/opatch prereq CheckApplicable -ph //oragrid/16619898 -oh /oragrid/product/11.2.0

9: /oragrid/product/11.2.0/OPatch/opatch prereq CheckApplicable -ph //oragrid/16619892 -oh /oragrid/product/11.2.0

10: /oragrid/product/11.2.0/OPatch/opatch napply //oragrid/16619898 -local -silent -ocmrf /oragrid/product/11.2.0/ocm.rsp -oh /oragrid/product/11.2.0 -invPtrLoc /oragrid/product/11.2.0/oraInst.loc

11: /oragrid/product/11.2.0/OPatch/opatch napply //oragrid/16619892 -local -silent -ocmrf /oragrid/product/11.2.0/ocm.rsp -oh /oragrid/product/11.2.0 -invPtrLoc /oragrid/product/11.2.0/oraInst.loc

12: /oragrid/product/11.2.0/bin/emctl start dbconsole

자세하게 패치 로그를 살펴보자..

[root:/root]#vi /oragrid/product/11.2.0/cfgtoollogs/opatchauto2013-12-04_23-29-49.log

2013-12-04 23:29:49: Using Oracle CRS home /oragrid/product/11.2.0
2013-12-04 23:29:49: Checking parameters from paramfile /oragrid/product/11.2.0/crs/install/crsconfig_params to validate installer variables
2013-12-04 23:29:49: The configuration parameter file /oragrid/product/11.2.0/crs/install/crsconfig_params is valid
2013-12-04 23:29:49: ### Printing the configuration values from files:
2013-12-04 23:29:49: /oragrid/product/11.2.0/crs/install/crsconfig_params
2013-12-04 23:29:49: /oragrid/product/11.2.0/crs/install/s_crsconfig_defs
2013-12-04 23:29:49: ASM_AU_SIZE=1
2013-12-04 23:29:49: ASM_DISCOVERY_STRING=
2013-12-04 23:29:49: ASM_DISKS=/dev/raw/raw1
2013-12-04 23:29:49: ASM_DISK_GROUP=DATA
2013-12-04 23:29:49: ASM_REDUNDANCY=EXTERNAL
2013-12-04 23:29:49: ASM_SPFILE=
2013-12-04 23:29:49: ASM_UPGRADE=false
2013-12-04 23:29:49: CLSCFG_MISSCOUNT=
2013-12-04 23:29:49: CLUSTER_GUID=
2013-12-04 23:29:49: CLUSTER_NAME=rac-cluster
2013-12-04 23:29:49: CRFHOME="/oragrid/product/11.2.0"
2013-12-04 23:29:49: CRS_LIMIT_CORE=unlimited
2013-12-04 23:29:49: CRS_LIMIT_MEMLOCK=unlimited
2013-12-04 23:29:49: CRS_LIMIT_OPENFILE=65536
2013-12-04 23:29:49: CRS_LIMIT_STACK=2048
2013-12-04 23:29:49: CRS_NODEVIPS='rac1-vip/255.255.255.0/eth0,rac2-vip/255.255.255.0/eth0'
2013-12-04 23:29:49: CRS_STORAGE_OPTION=1
2013-12-04 23:29:49: CSS_LEASEDURATION=400
2013-12-04 23:29:49: DIRPREFIX=
2013-12-04 23:29:49: DISABLE_OPROCD=0
2013-12-04 23:29:49: EXTERNAL_ORACLE=/opt/oracle
2013-12-04 23:29:49: EXTERNAL_ORACLE_BIN=/opt/oracle/bin
2013-12-04 23:29:49: GNS_ADDR_LIST=
2013-12-04 23:29:49: GNS_ALLOW_NET_LIST=
2013-12-04 23:29:49: GNS_CONF=false
2013-12-04 23:29:49: GNS_DENY_ITF_LIST=
2013-12-04 23:29:49: GNS_DENY_NET_LIST=
2013-12-04 23:29:49: GNS_DOMAIN_LIST=
2013-12-04 23:29:49: GPNPCONFIGDIR=/oragrid/product/11.2.0
2013-12-04 23:29:49: GPNPGCONFIGDIR=/oragrid/product/11.2.0
2013-12-04 23:29:49: GPNP_PA=
2013-12-04 23:29:49: HOST_NAME_LIST=rac1,rac2
2013-12-04 23:29:49: ID=/etc/init.d
2013-12-04 23:29:49: INIT=/sbin/init
2013-12-04 23:29:49: INITCTL=/sbin/initctl
2013-12-04 23:29:49: ISROLLING=true
2013-12-04 23:29:49: IT=/etc/inittab
2013-12-04 23:29:49: JLIBDIR=/oragrid/product/11.2.0/jlib
2013-12-04 23:29:49: JREDIR=/oragrid/product/11.2.0/jdk/jre/
2013-12-04 23:29:49: LANGUAGE_ID=AMERICAN_AMERICA.AL32UTF8
2013-12-04 23:29:49: MSGFILE=/var/adm/messages
2013-12-04 23:29:49: NETWORKS="eth0"/192.168.56.0:public,"eth1"/10.10.10.0:cluster_interconnect
2013-12-04 23:29:49: NEW_HOST_NAME_LIST=
2013-12-04 23:29:49: NEW_NODEVIPS='rac1-vip/255.255.255.0/eth0,rac2-vip/255.255.255.0/eth0'
2013-12-04 23:29:49: NEW_NODE_NAME_LIST=
2013-12-04 23:29:49: NEW_PRIVATE_NAME_LIST=
2013-12-04 23:29:49: NODELIST=rac1,rac2
2013-12-04 23:29:49: NODE_NAME_LIST=rac1,rac2
2013-12-04 23:29:49: OCFS_CONFIG=
2013-12-04 23:29:49: OCRCONFIG=/etc/oracle/ocr.loc
2013-12-04 23:29:49: OCRCONFIGDIR=/etc/oracle
2013-12-04 23:29:49: OCRID=
2013-12-04 23:29:49: OCRLOC=ocr.loc
2013-12-04 23:29:49: OCR_LOCATIONS=NO_VAL
2013-12-04 23:29:49: OLASTGASPDIR=/etc/oracle/lastgasp
2013-12-04 23:29:49: OLD_CRS_HOME=
2013-12-04 23:29:49: OLRCONFIG=/etc/oracle/olr.loc
2013-12-04 23:29:49: OLRCONFIGDIR=/etc/oracle
2013-12-04 23:29:49: OLRLOC=olr.loc
2013-12-04 23:29:49: OPROCDCHECKDIR=/etc/oracle/oprocd/check
2013-12-04 23:29:49: OPROCDDIR=/etc/oracle/oprocd
2013-12-04 23:29:49: OPROCDFATALDIR=/etc/oracle/oprocd/fatal
2013-12-04 23:29:49: OPROCDSTOPDIR=/etc/oracle/oprocd/stop
2013-12-04 23:29:49: ORACLE_BASE=/oracle
2013-12-04 23:29:49: ORACLE_HOME=/oragrid/product/11.2.0
2013-12-04 23:29:49: ORACLE_OWNER=oracle
2013-12-04 23:29:49: ORA_ASM_GROUP=dba
2013-12-04 23:29:49: ORA_DBA_GROUP=dba
2013-12-04 23:29:49: PRIVATE_NAME_LIST=
2013-12-04 23:29:49: RCALLDIR=/etc/rc.d/rc0.d /etc/rc.d/rc1.d /etc/rc.d/rc2.d /etc/rc.d/rc3.d /etc/rc.d/rc4.d /etc/rc.d/rc5.d /etc/rc.d/rc6.d
2013-12-04 23:29:49: RCKDIR=/etc/rc.d/rc0.d /etc/rc.d/rc1.d /etc/rc.d/rc2.d /etc/rc.d/rc3.d /etc/rc.d/rc4.d /etc/rc.d/rc6.d
2013-12-04 23:29:49: RCSDIR=/etc/rc.d/rc3.d /etc/rc.d/rc5.d
2013-12-04 23:29:49: RC_KILL=K15
2013-12-04 23:29:49: RC_KILL_OLD=K96
2013-12-04 23:29:49: RC_KILL_OLD2=K19
2013-12-04 23:29:49: RC_START=S96
2013-12-04 23:29:49: REUSEDG=false
2013-12-04 23:29:49: SCAN_NAME=rac-scan
2013-12-04 23:29:49: SCAN_PORT=1521
2013-12-04 23:29:49: SCRBASE=/etc/oracle/scls_scr
2013-12-04 23:29:49: SILENT=false
2013-12-04 23:29:49: SO_EXT=so
2013-12-04 23:29:49: SRVCFGLOC=srvConfig.loc
2013-12-04 23:29:49: SRVCONFIG=/var/opt/oracle/srvConfig.loc
2013-12-04 23:29:49: SRVCONFIGDIR=/var/opt/oracle
2013-12-04 23:29:49: TZ=Asia/Seoul
2013-12-04 23:29:49: UPSTART_INIT_DIR=/etc/init
2013-12-04 23:29:49: USER_IGNORED_PREREQ=true
2013-12-04 23:29:49: VNDR_CLUSTER=false
2013-12-04 23:29:49: VOTING_DISKS=NO_VAL
2013-12-04 23:29:49: ### Printing other configuration values ###
2013-12-04 23:29:49: CLSCFG_EXTRA_PARMS=
2013-12-04 23:29:49: HAS_GROUP=dba
2013-12-04 23:29:49: HAS_USER=root
2013-12-04 23:29:49: HOST=rac1
2013-12-04 23:29:49: OLR_DIRECTORY=/oragrid/product/11.2.0/cdata
2013-12-04 23:29:49: OLR_LOCATION=/oragrid/product/11.2.0/cdata/rac1.olr
2013-12-04 23:29:49: ORA_CRS_HOME=/oragrid/product/11.2.0
2013-12-04 23:29:49: SUPERUSER=root
2013-12-04 23:29:49: VF_DISCOVERY_STRING=
2013-12-04 23:29:49: crscfg_trace=1
2013-12-04 23:29:49: crscfg_trace_file=/oragrid/product/11.2.0/cfgtoollogs/opatchauto2013-12-04_23-29-49.log
2013-12-04 23:29:49: hosts=
2013-12-04 23:29:49: osdfile=/oragrid/product/11.2.0/crs/install/s_crsconfig_defs
2013-12-04 23:29:49: parameters_valid=1
2013-12-04 23:29:49: paramfile=/oragrid/product/11.2.0/crs/install/crsconfig_params
2013-12-04 23:29:49: platform_family=unix
2013-12-04 23:29:49: srvctl_trc_suff=0
2013-12-04 23:29:49: user_is_superuser=1
2013-12-04 23:29:49: ### Printing of configuration values complete ###
2013-12-04 23:29:49: INC is /oragrid/16619898/files/crs/install /oragrid/product/11.2.0/perl/lib/5.10.0/x86_64-linux-thread-multi /oragrid/product/11.2.0/perl/lib/5.10.0 /oragrid/product/11.2.0/perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi /oragrid/product/11.2.0/perl/lib/site_perl/5.10.0 /oragrid/product/11.2.0/perl/lib/5.10.0/x86_64-linux-thread-multi /oragrid/product/11.2.0/perl/lib/5.10.0/x86_64-linux-thread-multi /oragrid/product/11.2.0/perl/lib/5.10.0 /oragrid/product/11.2.0/perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi /oragrid/product/11.2.0/perl/lib/site_perl/5.10.0 /oragrid/product/11.2.0/perl/lib/site_perl .

2013-12-04 23:29:49: No -patchfile specified, assuming the patch is already uncompressed
2013-12-04 23:29:49: Oracle user for /oragrid/product/11.2.0 is oracle
2013-12-04 23:29:49: The patch ids are 16619898 16619892
2013-12-04 23:29:49: The patch ids are 16619898 16619892
2013-12-04 23:29:49: Running as user oracle: /oragrid/product/11.2.0/OPatch/opatch query -get_patch_type //oragrid/16619898 -oh /oragrid/product/11.2.0
2013-12-04 23:29:49: s_run_as_user2: Running /bin/su oracle -c ' /oragrid/product/11.2.0/OPatch/opatch query -get_patch_type //oragrid/16619898 -oh /oragrid/product/11.2.0 '
2013-12-04 23:29:52: Removing file /tmp/fileV1NRL2
2013-12-04 23:29:52: Successfully removed file: /tmp/fileV1NRL2
2013-12-04 23:29:52: /bin/su successfully executed

2013-12-04 23:29:52: output is This patch is a "legacy_bundle_top" patch.

2013-12-04 23:29:52: Patch type is "legacy_bundle_top"
2013-12-04 23:29:52: Running as user oracle: /oragrid/product/11.2.0/OPatch/opatch query -get_patch_type //oragrid/16619892 -oh /oragrid/product/11.2.0
2013-12-04 23:29:52: s_run_as_user2: Running /bin/su oracle -c ' /oragrid/product/11.2.0/OPatch/opatch query -get_patch_type //oragrid/16619892 -oh /oragrid/product/11.2.0 '
2013-12-04 23:29:53: Removing file /tmp/fileKFA5PW
2013-12-04 23:29:53: Successfully removed file: /tmp/fileKFA5PW
2013-12-04 23:29:53: /bin/su exited with rc=75

2013-12-04 23:29:53: output is
2013-12-04 23:29:53: Patch type is
2013-12-04 23:29:53: GI patches are //oragrid/16619898 //oragrid/16619892
2013-12-04 23:29:53: DB patches are //oragrid/16619898/custom/server/16619898 //oragrid/16619892
2013-12-04 23:29:53: Oracle user for /oragrid/product/11.2.0 is oracle
2013-12-04 23:29:53: Running as user oracle: /oragrid/product/11.2.0/OPatch/opatch util saveconfigurationsnapshot -configFile /oragrid/product/11.2.0/cfgtoollogs/opatchauto2013-12-04_23-29-49.cfg.log
2013-12-04 23:29:53: s_run_as_user2: Running /bin/su oracle -c ' /oragrid/product/11.2.0/OPatch/opatch util saveconfigurationsnapshot -configFile /oragrid/product/11.2.0/cfgtoollogs/opatchauto2013-12-04_23-29-49.cfg.log '
2013-12-04 23:29:53: Removing file /tmp/fileeYSuiU
2013-12-04 23:29:53: Successfully removed file: /tmp/fileeYSuiU
2013-12-04 23:29:53: /bin/su exited with rc=1

2013-12-04 23:29:53: The Oracle Home /product/11.2.0 is not valid directory. Please give proper Oracle Home.
OPatch returns with error code = 1

2013-12-04 23:29:53: Opening file /etc/oracle/ocr.loc
2013-12-04 23:29:53: Value (FALSE) is set for key=local_only
2013-12-04 23:29:53: Oracle user for /oragrid/product/11.2.0 is oracle
2013-12-04 23:29:53: Running as user oracle: /oragrid/product/11.2.0/OPatch/opatch version -oh /oragrid/product/11.2.0
2013-12-04 23:29:53: s_run_as_user2: Running /bin/su oracle -c ' /oragrid/product/11.2.0/OPatch/opatch version -oh /oragrid/product/11.2.0 '
2013-12-04 23:29:54: Removing file /tmp/file55ZPYR
2013-12-04 23:29:54: Successfully removed file: /tmp/file55ZPYR
2013-12-04 23:29:54: /bin/su successfully executed

2013-12-04 23:29:54: opatch version in oracle home /oragrid/product/11.2.0 is 11.2.0.3.5

2013-12-04 23:29:54: Oracle user for /oragrid/product/11.2.0 is oracle
2013-12-04 23:29:54: Oracle user for /oragrid/product/11.2.0 is oracle
2013-12-04 23:29:54: silent mode option is -silent -ocmrf /oragrid/product/11.2.0/ocm.rsp
2013-12-04 23:29:54: Running /oragrid/product/11.2.0/bin/crsctl check cluster -n rac1
2013-12-04 23:29:54: Executing cmd: /oragrid/product/11.2.0/bin/crsctl check cluster -n rac1
2013-12-04 23:29:54: Processing oracle home /oragrid/product/11.2.0
2013-12-04 23:29:54: Opening file /etc/oracle/ocr.loc
2013-12-04 23:29:54: Value (FALSE) is set for key=local_only
2013-12-04 23:29:54: Home type of /oragrid/product/11.2.0 is CRS
2013-12-04 23:29:54: Oracle user for /oragrid/product/11.2.0 is oracle
2013-12-04 23:29:54: Oracle user for /oragrid/product/11.2.0 is oracle
2013-12-04 23:29:54: Running as user oracle: /oragrid/product/11.2.0/OPatch/opatch version -oh /oragrid/product/11.2.0
2013-12-04 23:29:54: s_run_as_user2: Running /bin/su oracle -c ' /oragrid/product/11.2.0/OPatch/opatch version -oh /oragrid/product/11.2.0 '
2013-12-04 23:29:54: Removing file /tmp/fileCveUDR
2013-12-04 23:29:54: Successfully removed file: /tmp/fileCveUDR
2013-12-04 23:29:54: /bin/su successfully executed

2013-12-04 23:29:54: opatch version in oracle home /oragrid/product/11.2.0 is 11.2.0.3.5

2013-12-04 23:29:54: Running as user oracle: /oragrid/product/11.2.0/OPatch/opatch util checkMinimumOPatchVersion -ph //oragrid/16619898 -version 11.2.0.3.5 -oh /oragrid/product/11.2.0
2013-12-04 23:29:54: s_run_as_user2: Running /bin/su oracle -c ' /oragrid/product/11.2.0/OPatch/opatch util checkMinimumOPatchVersion -ph //oragrid/16619898 -version 11.2.0.3.5 -oh /oragrid/product/11.2.0 '
2013-12-04 23:29:57: Removing file /tmp/fileTO5UVS
2013-12-04 23:29:57: Successfully removed file: /tmp/fileTO5UVS
2013-12-04 23:29:57: /bin/su successfully executed

2013-12-04 23:29:57: Running as user oracle: /oragrid/product/11.2.0/OPatch/opatch util checkMinimumOPatchVersion -ph //oragrid/16619892 -version 11.2.0.3.5 -oh /oragrid/product/11.2.0
2013-12-04 23:29:57: s_run_as_user2: Running /bin/su oracle -c ' /oragrid/product/11.2.0/OPatch/opatch util checkMinimumOPatchVersion -ph //oragrid/16619892 -version 11.2.0.3.5 -oh /oragrid/product/11.2.0 '
2013-12-04 23:30:00: Removing file /tmp/fileGxUG83
2013-12-04 23:30:00: Successfully removed file: /tmp/fileGxUG83
2013-12-04 23:30:00: /bin/su successfully executed

2013-12-04 23:30:00: Status of opatch version check for /oragrid/product/11.2.0 is 1
2013-12-04 23:30:00: Opatch version check passed for oracle home /oragrid/product/11.2.0
2013-12-04 23:30:00: Opatch version check passed for all oracle homes
2013-12-04 23:30:00: Opening file /etc/oracle/ocr.loc
2013-12-04 23:30:00: Value (FALSE) is set for key=local_only
2013-12-04 23:30:00: The cluster nodes are rac1 rac2
2013-12-04 23:30:00: checking if path /oragrid/product/11.2.0/crs/install is shared
2013-12-04 23:30:00: Running as user oracle: /oragrid/product/11.2.0/bin/cluvfy comp ssa -t software -s /oragrid/product/11.2.0/crs/install -n rac1,rac2 -display_status
2013-12-04 23:30:00: s_run_as_user2: Running /bin/su oracle -c ' /oragrid/product/11.2.0/bin/cluvfy comp ssa -t software -s /oragrid/product/11.2.0/crs/install -n rac1,rac2 -display_status '
2013-12-04 23:30:20: Removing file /tmp/filePBo6vp
2013-12-04 23:30:20: Successfully removed file: /tmp/filePBo6vp
2013-12-04 23:30:20: /bin/su exited with rc=1

2013-12-04 23:30:20: return code for shared check is 256
2013-12-04 23:30:20: output of sharedness check is
Verifying shared storage accessibility

Checking shared storage accessibility...

"/oragrid/product/11.2.0/crs/install" is not shared

Shared storage check failed on nodes "rac2,rac1"

Verification of shared storage accessibility was unsuccessful on all the specified nodes.
NODE_STATUS::rac2:VFAIL
NODE_STATUS::rac1:VFAIL
OVERALL_STATUS::VFAIL

2013-12-04 23:30:20: the ishared value is 0
2013-12-04 23:30:20: The oracle home /oragrid/product/11.2.0 is not shared
2013-12-04 23:30:20: Processing oracle home /oragrid/product/11.2.0
2013-12-04 23:30:20: Opening file /etc/oracle/ocr.loc
2013-12-04 23:30:20: Value (FALSE) is set for key=local_only
2013-12-04 23:30:20: Home type of /oragrid/product/11.2.0 is CRS
2013-12-04 23:30:20: Oracle user for /oragrid/product/11.2.0 is oracle
2013-12-04 23:30:20: Running as user oracle: /oragrid/product/11.2.0/OPatch/opatch prereq CheckComponents -ph //oragrid/16619898 -oh /oragrid/product/11.2.0
2013-12-04 23:30:20: s_run_as_user2: Running /bin/su oracle -c ' /oragrid/product/11.2.0/OPatch/opatch prereq CheckComponents -ph //oragrid/16619898 -oh /oragrid/product/11.2.0 '
2013-12-04 23:30:23: Removing file /tmp/fileU3icUM
2013-12-04 23:30:23: Successfully removed file: /tmp/fileU3icUM
2013-12-04 23:30:23: /bin/su successfully executed

2013-12-04 23:30:23: Running as user oracle: /oragrid/product/11.2.0/OPatch/opatch prereq CheckComponents -ph //oragrid/16619892 -oh /oragrid/product/11.2.0
2013-12-04 23:30:23: s_run_as_user2: Running /bin/su oracle -c ' /oragrid/product/11.2.0/OPatch/opatch prereq CheckComponents -ph //oragrid/16619892 -oh /oragrid/product/11.2.0 '
2013-12-04 23:30:27: Removing file /tmp/filelKic0k
2013-12-04 23:30:27: Successfully removed file: /tmp/filelKic0k
2013-12-04 23:30:27: /bin/su successfully executed

2013-12-04 23:30:27: Oracle user for /oragrid/product/11.2.0 is oracle
2013-12-04 23:30:27: Running as user oracle: /oragrid/product/11.2.0/OPatch/opatch prereq CheckConflictAgainstOH -ph //oragrid/16619898 -oh /oragrid/product/11.2.0
2013-12-04 23:30:27: s_run_as_user2: Running /bin/su oracle -c ' /oragrid/product/11.2.0/OPatch/opatch prereq CheckConflictAgainstOH -ph //oragrid/16619898 -oh /oragrid/product/11.2.0 '
2013-12-04 23:30:31: Removing file /tmp/filegbypr6
2013-12-04 23:30:31: Successfully removed file: /tmp/filegbypr6
2013-12-04 23:30:31: /bin/su successfully executed

2013-12-04 23:30:31: Running as user oracle: /oragrid/product/11.2.0/OPatch/opatch prereq CheckConflictAgainstOH -ph //oragrid/16619892 -oh /oragrid/product/11.2.0
2013-12-04 23:30:31: s_run_as_user2: Running /bin/su oracle -c ' /oragrid/product/11.2.0/OPatch/opatch prereq CheckConflictAgainstOH -ph //oragrid/16619892 -oh /oragrid/product/11.2.0 '
2013-12-04 23:30:35: Removing file /tmp/fileSlfK71
2013-12-04 23:30:35: Successfully removed file: /tmp/fileSlfK71
2013-12-04 23:30:35: /bin/su successfully executed

2013-12-04 23:30:35: Status of component/conflict check for /oragrid/product/11.2.0 is 1
2013-12-04 23:30:35: Conflict check passes for oracle home /oragrid/product/11.2.0
2013-12-04 23:30:35: Conflict check passed for all oracle homes
2013-12-04 23:30:35: Processing oracle home /oragrid/product/11.2.0
2013-12-04 23:30:35: Opening file /etc/oracle/ocr.loc
2013-12-04 23:30:35: Value (FALSE) is set for key=local_only
2013-12-04 23:30:35: Home type of /oragrid/product/11.2.0 is CRS
2013-12-04 23:30:35: Oracle user for /oragrid/product/11.2.0 is oracle
2013-12-04 23:30:35: Running as user oracle: /oragrid/product/11.2.0/bin/emctl stop dbconsole
2013-12-04 23:30:35: s_run_as_user2: Running /bin/su oracle -c ' /oragrid/product/11.2.0/bin/emctl stop dbconsole '
2013-12-04 23:30:36: Removing file /tmp/fileyedrRa
2013-12-04 23:30:36: Successfully removed file: /tmp/fileyedrRa
2013-12-04 23:30:36: /bin/su exited with rc=2

2013-12-04 23:30:36: Unlock crshome...
2013-12-04 23:30:36: crshome passed is
2013-12-04 23:30:36: Exclude file used is /oragrid/product/11.2.0/OPatch/crs/installPatch.excl
2013-12-04 23:30:36: Home location in olr.loc is /oragrid/product/11.2.0
2013-12-04 23:30:36: unlock crs home is /oragrid/product/11.2.0
2013-12-04 23:30:36: Executing /oragrid/product/11.2.0/bin/crsctl stop crs -f
2013-12-04 23:30:36: Executing cmd: /oragrid/product/11.2.0/bin/crsctl stop crs -f
2013-12-04 23:32:32: Command output:
> CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac1'
> CRS-2673: Attempting to stop 'ora.crsd' on 'rac1'
> CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac1'
> CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac1'
> CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'rac1'
> CRS-2673: Attempting to stop 'ora.rac.db' on 'rac1'
> CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac1'
> CRS-2677: Stop of 'ora.rac.db' on 'rac1' succeeded
> CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac1' succeeded
> CRS-2673: Attempting to stop 'ora.rac1.vip' on 'rac1'
> CRS-2677: Stop of 'ora.rac1.vip' on 'rac1' succeeded
> CRS-2672: Attempting to start 'ora.rac1.vip' on 'rac2'
> CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'rac1' succeeded
> CRS-2673: Attempting to stop 'ora.scan1.vip' on 'rac1'
> CRS-2677: Stop of 'ora.scan1.vip' on 'rac1' succeeded
> CRS-2672: Attempting to start 'ora.scan1.vip' on 'rac2'
> CRS-2676: Start of 'ora.rac1.vip' on 'rac2' succeeded
> CRS-2676: Start of 'ora.scan1.vip' on 'rac2' succeeded
> CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'rac2'
> CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'rac2' succeeded
> CRS-2677: Stop of 'ora.DATA.dg' on 'rac1' succeeded
> CRS-2673: Attempting to stop 'ora.asm' on 'rac1'
> CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded
> CRS-2673: Attempting to stop 'ora.net1.network' on 'rac1'
> CRS-2677: Stop of 'ora.net1.network' on 'rac1' succeeded
> CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac1' has completed
> CRS-2677: Stop of 'ora.crsd' on 'rac1' succeeded
> CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac1'
> CRS-2673: Attempting to stop 'ora.crf' on 'rac1'
> CRS-2673: Attempting to stop 'ora.ctssd' on 'rac1'
> CRS-2673: Attempting to stop 'ora.evmd' on 'rac1'
> CRS-2673: Attempting to stop 'ora.asm' on 'rac1'
> CRS-2677: Stop of 'ora.mdnsd' on 'rac1' succeeded
> CRS-2677: Stop of 'ora.evmd' on 'rac1' succeeded
> CRS-2677: Stop of 'ora.crf' on 'rac1' succeeded
> CRS-2677: Stop of 'ora.ctssd' on 'rac1' succeeded
> CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded
> CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac1'
> CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac1' succeeded
> CRS-2673: Attempting to stop 'ora.cssd' on 'rac1'
> CRS-2677: Stop of 'ora.cssd' on 'rac1' succeeded
> CRS-2673: Attempting to stop 'ora.gipcd' on 'rac1'
> CRS-2677: Stop of 'ora.gipcd' on 'rac1' succeeded
> CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac1'
> CRS-2677: Stop of 'ora.gpnpd' on 'rac1' succeeded
> CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac1' has completed
> CRS-4133: Oracle High Availability Services has been stopped.
>End Command output
2013-12-04 23:32:32: /oragrid/product/11.2.0/bin/crsctl stop crs -f
2013-12-04 23:32:32: Executing cmd: /oragrid/product/11.2.0/bin/crsctl check cluster -n rac1
2013-12-04 23:32:34: Command output:
> CRS-4639: Could not contact Oracle High Availability Services
> CRS-4000: Command Check failed, or completed with errors.
>End Command output
2013-12-04 23:32:34: Executing cmd: /oragrid/product/11.2.0/bin/crsctl check has
2013-12-04 23:32:35: Command output:
> CRS-4639: Could not contact Oracle High Availability Services
>End Command output
2013-12-04 23:32:35: The CRS home passed in is /oragrid/product/11.2.0
2013-12-04 23:34:35: Waiting for complete CRS stack to stop
2013-12-04 23:34:35: Invoking removeproc to clean oracle client procs
2013-12-04 23:34:35: Executing cmd: /sbin/fuser -k /oragrid/product/11.2.0/bin/crsctl.bin
2013-12-04 23:34:35: fuser command output for /oragrid/product/11.2.0/bin/crsctl.bin is
2013-12-04 23:34:35: Oracle user for /oragrid/product/11.2.0 is oracle
2013-12-04 23:34:35: Opening file /etc/oracle/ocr.loc
2013-12-04 23:34:35: Value (FALSE) is set for key=local_only
2013-12-04 23:34:35: Running as user oracle: /oragrid/product/11.2.0/OPatch/opatch prereq CheckApplicable -ph //oragrid/16619898 -oh /oragrid/product/11.2.0
2013-12-04 23:34:35: s_run_as_user2: Running /bin/su oracle -c ' /oragrid/product/11.2.0/OPatch/opatch prereq CheckApplicable -ph //oragrid/16619898 -oh /oragrid/product/11.2.0 '
2013-12-04 23:34:39: Removing file /tmp/filenBeWwV
2013-12-04 23:34:39: Successfully removed file: /tmp/filenBeWwV
2013-12-04 23:34:39: /bin/su successfully executed

2013-12-04 23:34:39: Running as user oracle: /oragrid/product/11.2.0/OPatch/opatch prereq CheckApplicable -ph //oragrid/16619892 -oh /oragrid/product/11.2.0
2013-12-04 23:34:39: s_run_as_user2: Running /bin/su oracle -c ' /oragrid/product/11.2.0/OPatch/opatch prereq CheckApplicable -ph //oragrid/16619892 -oh /oragrid/product/11.2.0 '
2013-12-04 23:34:44: Removing file /tmp/file5N7kpS
2013-12-04 23:34:44: Successfully removed file: /tmp/file5N7kpS
2013-12-04 23:34:44: /bin/su successfully executed

2013-12-04 23:34:44: Status of Applicable check for /oragrid/product/11.2.0 is 1
2013-12-04 23:34:44: Oracle user for /oragrid/product/11.2.0 is oracle
2013-12-04 23:34:44: Executing command /oragrid/product/11.2.0/OPatch/opatch napply //oragrid/16619898 -local -silent -ocmrf /oragrid/product/11.2.0/ocm.rsp -oh /oragrid/product/11.2.0 -invPtrLoc /oragrid/product/11.2.0/oraInst.loc as oracle
2013-12-04 23:34:44: Running as user oracle: /oragrid/product/11.2.0/OPatch/opatch napply //oragrid/16619898 -local -silent -ocmrf /oragrid/product/11.2.0/ocm.rsp -oh /oragrid/product/11.2.0 -invPtrLoc /oragrid/product/11.2.0/oraInst.loc
2013-12-04 23:34:44: s_run_as_user2: Running /bin/su oracle -c ' /oragrid/product/11.2.0/OPatch/opatch napply //oragrid/16619898 -local -silent -ocmrf /oragrid/product/11.2.0/ocm.rsp -oh /oragrid/product/11.2.0 -invPtrLoc /oragrid/product/11.2.0/oraInst.loc '
2013-12-04 23:41:02: Removing file /tmp/filesPciS4
2013-12-04 23:41:02: Successfully removed file: /tmp/filesPciS4
2013-12-04 23:41:02: /bin/su successfully executed

2013-12-04 23:41:02: status of apply patch is 0
2013-12-04 23:41:02: The apply patch output is Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation. All rights reserved.

Oracle Home       : /oragrid/product/11.2.0
Central Inventory : /oragrid/oraInventory
    from           : /oragrid/product/11.2.0/oraInst.loc
OPatch version    : 11.2.0.3.5
OUI version       : 11.2.0.3.0
Log file location : /oragrid/product/11.2.0/cfgtoollogs/opatch/opatch2013-12-04_23-34-44PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 16619898

Do you want to proceed? [y|n]
Y (auto-answered by -silent)
User Responded with: Y
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/oragrid/product/11.2.0')

Is the local system ready for patching? [y|n]
Y (auto-answered by -silent)
User Responded with: Y
Backing up files...
Applying interim patch '16619898' to OH '/oragrid/product/11.2.0'

Patching component oracle.crs, 11.2.0.3.0...

Patching component oracle.usm, 11.2.0.3.0...

Verifying the update...
Patch 16619898 successfully applied.
Log file location: /oragrid/product/11.2.0/cfgtoollogs/opatch/opatch2013-12-04_23-34-44PM_1.log

OPatch succeeded.

2013-12-04 23:41:02: patch //oragrid/16619898 apply successful for home /oragrid/product/11.2.0
2013-12-04 23:41:02: Executing command /oragrid/product/11.2.0/OPatch/opatch napply //oragrid/16619892 -local -silent -ocmrf /oragrid/product/11.2.0/ocm.rsp -oh /oragrid/product/11.2.0 -invPtrLoc /oragrid/product/11.2.0/oraInst.loc as oracle
2013-12-04 23:41:02: Running as user oracle: /oragrid/product/11.2.0/OPatch/opatch napply //oragrid/16619892 -local -silent -ocmrf /oragrid/product/11.2.0/ocm.rsp -oh /oragrid/product/11.2.0 -invPtrLoc /oragrid/product/11.2.0/oraInst.loc
2013-12-04 23:41:02: s_run_as_user2: Running /bin/su oracle -c ' /oragrid/product/11.2.0/OPatch/opatch napply //oragrid/16619892 -local -silent -ocmrf /oragrid/product/11.2.0/ocm.rsp -oh /oragrid/product/11.2.0 -invPtrLoc /oragrid/product/11.2.0/oraInst.loc '
2013-12-04 23:41:13: Removing file /tmp/filek536M4
2013-12-04 23:41:13: Successfully removed file: /tmp/filek536M4
2013-12-04 23:41:13: /bin/su exited with rc=73

2013-12-04 23:41:13: status of apply patch is 18688
2013-12-04 23:41:13: The apply patch output is Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation. All rights reserved.

Oracle Home       : /oragrid/product/11.2.0
Central Inventory : /oragrid/oraInventory
    from           : /oragrid/product/11.2.0/oraInst.loc
OPatch version    : 11.2.0.3.5
OUI version       : 11.2.0.3.0
Log file location : /oragrid/product/11.2.0/cfgtoollogs/opatch/opatch2013-12-04_23-41-03PM_1.log

Verifying environment and performing prerequisite checks...
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:

Following executables are active :
/oragrid/product/11.2.0/lib/libclntsh.so.11.1
UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
Log file location: /oragrid/product/11.2.0/cfgtoollogs/opatch/opatch2013-12-04_23-41-03PM_1.log

OPatch failed with error code 73

2013-12-04 23:41:13: patch //oragrid/16619892 apply failed for home /oragrid/product/11.2.0
2013-12-04 23:41:13: Performing Post patch actions
2013-12-04 23:41:13: norestart flag is set to
2013-12-04 23:41:13: Opening file /etc/oracle/ocr.loc
2013-12-04 23:41:13: Value (FALSE) is set for key=local_only
2013-12-04 23:41:13: Oracle user for /oragrid/product/11.2.0 is oracle
2013-12-04 23:41:13: Oracle user for /oragrid/product/11.2.0 is oracle
2013-12-04 23:41:13: Running as user oracle: /oragrid/product/11.2.0/bin/emctl start dbconsole
2013-12-04 23:41:13: s_run_as_user2: Running /bin/su oracle -c ' /oragrid/product/11.2.0/bin/emctl start dbconsole '
2013-12-04 23:41:14: Removing file /tmp/filedZAZaE
2013-12-04 23:41:14: Successfully removed file: /tmp/filedZAZaE
2013-12-04 23:41:14: /bin/su exited with rc=2

2013-12-04 23:41:14: Performing Post patch actions for Grid Home /oragrid/product/11.2.0
2013-12-04 23:41:14: Executing cmd: /oragrid/product/11.2.0/rdbms/install/rootadd_rdbms.sh
2013-12-04 23:41:14: setrdbmsfileperms succeeded
2013-12-04 23:41:14: Patching Oracle Clusterware
2013-12-04 23:41:14: norestart flag is set to 0
2013-12-04 23:41:15: Executing cmd: /bin/rpm -q sles-release
2013-12-04 23:41:15: Command output:
> package sles-release is not installed
>End Command output
2013-12-04 23:41:15: init file = /oragrid/product/11.2.0/crs/init/init.ohasd
2013-12-04 23:41:15: Copying file /oragrid/product/11.2.0/crs/init/init.ohasd to /etc/init.d directory
2013-12-04 23:41:15: Setting init.ohasd permission in /etc/init.d directory
2013-12-04 23:41:15: init file = /oragrid/product/11.2.0/crs/init/ohasd
2013-12-04 23:41:15: Copying file /oragrid/product/11.2.0/crs/init/ohasd to /etc/init.d directory
2013-12-04 23:41:15: Setting ohasd permission in /etc/init.d directory
2013-12-04 23:41:15: Executing cmd: /bin/rpm -q sles-release
2013-12-04 23:41:15: Command output:
> package sles-release is not installed
>End Command output
2013-12-04 23:41:15: Removing "/etc/rc.d/rc3.d/S96ohasd"
2013-12-04 23:41:15: Removing file /etc/rc.d/rc3.d/S96ohasd
2013-12-04 23:41:15: Successfully removed file: /etc/rc.d/rc3.d/S96ohasd
2013-12-04 23:41:15: Creating a link "/etc/rc.d/rc3.d/S96ohasd" pointing to /etc/init.d/ohasd
2013-12-04 23:41:15: Removing "/etc/rc.d/rc5.d/S96ohasd"
2013-12-04 23:41:15: Removing file /etc/rc.d/rc5.d/S96ohasd
2013-12-04 23:41:15: Successfully removed file: /etc/rc.d/rc5.d/S96ohasd
2013-12-04 23:41:15: Creating a link "/etc/rc.d/rc5.d/S96ohasd" pointing to /etc/init.d/ohasd
2013-12-04 23:41:15: Removing "/etc/rc.d/rc0.d/K15ohasd"
2013-12-04 23:41:15: Removing file /etc/rc.d/rc0.d/K15ohasd
2013-12-04 23:41:15: Successfully removed file: /etc/rc.d/rc0.d/K15ohasd
2013-12-04 23:41:15: Creating a link "/etc/rc.d/rc0.d/K15ohasd" pointing to /etc/init.d/ohasd
2013-12-04 23:41:15: Removing "/etc/rc.d/rc1.d/K15ohasd"
2013-12-04 23:41:15: Removing file /etc/rc.d/rc1.d/K15ohasd
2013-12-04 23:41:15: Successfully removed file: /etc/rc.d/rc1.d/K15ohasd
2013-12-04 23:41:15: Creating a link "/etc/rc.d/rc1.d/K15ohasd" pointing to /etc/init.d/ohasd
2013-12-04 23:41:15: Removing "/etc/rc.d/rc2.d/K15ohasd"
2013-12-04 23:41:15: Removing file /etc/rc.d/rc2.d/K15ohasd
2013-12-04 23:41:15: Successfully removed file: /etc/rc.d/rc2.d/K15ohasd
2013-12-04 23:41:15: Creating a link "/etc/rc.d/rc2.d/K15ohasd" pointing to /etc/init.d/ohasd
2013-12-04 23:41:15: Removing "/etc/rc.d/rc3.d/K15ohasd"
2013-12-04 23:41:15: Removing file /etc/rc.d/rc3.d/K15ohasd
2013-12-04 23:41:15: Successfully removed file: /etc/rc.d/rc3.d/K15ohasd
2013-12-04 23:41:15: Creating a link "/etc/rc.d/rc3.d/K15ohasd" pointing to /etc/init.d/ohasd
2013-12-04 23:41:15: Removing "/etc/rc.d/rc4.d/K15ohasd"
2013-12-04 23:41:15: Removing file /etc/rc.d/rc4.d/K15ohasd
2013-12-04 23:41:15: Successfully removed file: /etc/rc.d/rc4.d/K15ohasd
2013-12-04 23:41:15: Creating a link "/etc/rc.d/rc4.d/K15ohasd" pointing to /etc/init.d/ohasd
2013-12-04 23:41:15: Removing "/etc/rc.d/rc6.d/K15ohasd"
2013-12-04 23:41:15: Removing file /etc/rc.d/rc6.d/K15ohasd
2013-12-04 23:41:15: Successfully removed file: /etc/rc.d/rc6.d/K15ohasd
2013-12-04 23:41:15: Creating a link "/etc/rc.d/rc6.d/K15ohasd" pointing to /etc/init.d/ohasd
2013-12-04 23:41:15: The file ohasd has been successfully linked to the RC directories
2013-12-04 23:41:15: Executing cmd: /oragrid/product/11.2.0/bin/acfsdriverstate supported
2013-12-04 23:41:16: Command output:
> ACFS-9200: Supported
>End Command output
2013-12-04 23:41:16: acfs is supported
2013-12-04 23:41:16: Executing '/oragrid/product/11.2.0/bin/acfsroot install'
2013-12-04 23:41:16: Executing cmd: /oragrid/product/11.2.0/bin/acfsroot install
2013-12-04 23:41:27: Command output:
> ACFS-9300: ADVM/ACFS distribution files found.
> ACFS-9312: Existing ADVM/ACFS installation detected.
> ACFS-9314: Removing previous ADVM/ACFS installation.
> ACFS-9315: Previous ADVM/ACFS components successfully removed.
> ACFS-9307: Installing requested ADVM/ACFS software.
> ACFS-9308: Loading installed ADVM/ACFS drivers.
> ACFS-9321: Creating udev for ADVM/ACFS.
> ACFS-9323: Creating module dependencies - this may take some time.
> ACFS-9154: Loading 'oracleoks.ko' driver.
> ACFS-9154: Loading 'oracleadvm.ko' driver.
> ACFS-9154: Loading 'oracleacfs.ko' driver.
> ACFS-9327: Verifying ADVM/ACFS devices.
> ACFS-9156: Detecting control device '/dev/asm/.asm_ctl_spec'.
> ACFS-9156: Detecting control device '/dev/ofsctl'.
> ACFS-9309: ADVM/ACFS installation correctness verified.
>End Command output
2013-12-04 23:41:27: /oragrid/product/11.2.0/bin/acfsroot install ... success
2013-12-04 23:41:27: USM driver install status is 1
2013-12-04 23:41:27: ACFS drivers installation completed
2013-12-04 23:41:27: Starting Oracle Clusterware
2013-12-04 23:41:27: Executing /oragrid/product/11.2.0/bin/crsctl start crs
2013-12-04 23:41:27: Executing cmd: /oragrid/product/11.2.0/bin/crsctl start crs
2013-12-04 23:41:41: Command output:
> CRS-4123: Oracle High Availability Services has been started.
>End Command output
2013-12-04 23:41:41: Executing cmd: /oragrid/product/11.2.0/bin/crsctl check crs
2013-12-04 23:41:42: Command output:
> CRS-4638: Oracle High Availability Services is online
> CRS-4535: Cannot communicate with Cluster Ready Services
> CRS-4530: Communications failure contacting Cluster Synchronization Services daemon
> CRS-4534: Cannot communicate with Event Manager
>End Command output
2013-12-04 23:41:42: Running /oragrid/product/11.2.0/bin/crsctl check cluster -n rac1
2013-12-04 23:41:42: Executing cmd: /oragrid/product/11.2.0/bin/crsctl check cluster -n rac1
2013-12-04 23:41:42: Checking the status of cluster
2013-12-04 23:41:47: Executing cmd: /oragrid/product/11.2.0/bin/crsctl check cluster -n rac1
2013-12-04 23:41:47: Checking the status of cluster
2013-12-04 23:41:52: Executing cmd: /oragrid/product/11.2.0/bin/crsctl check cluster -n rac1
2013-12-04 23:41:52: Checking the status of cluster
2013-12-04 23:41:57: Executing cmd: /oragrid/product/11.2.0/bin/crsctl check cluster -n rac1
2013-12-04 23:41:57: Checking the status of cluster
2013-12-04 23:42:02: Executing cmd: /oragrid/product/11.2.0/bin/crsctl check cluster -n rac1
2013-12-04 23:42:02: Checking the status of cluster
2013-12-04 23:42:07: Executing cmd: /oragrid/product/11.2.0/bin/crsctl check cluster -n rac1
2013-12-04 23:42:07: Checking the status of cluster
2013-12-04 23:42:12: Executing cmd: /oragrid/product/11.2.0/bin/crsctl check cluster -n rac1
2013-12-04 23:42:12: Checking the status of cluster
2013-12-04 23:42:17: Executing cmd: /oragrid/product/11.2.0/bin/crsctl check cluster -n rac1
2013-12-04 23:42:17: Checking the status of cluster
2013-12-04 23:42:22: Executing cmd: /oragrid/product/11.2.0/bin/crsctl check cluster -n rac1
2013-12-04 23:42:22: Checking the status of cluster
2013-12-04 23:42:27: Executing cmd: /oragrid/product/11.2.0/bin/crsctl check cluster -n rac1
2013-12-04 23:42:27: Checking the status of cluster
2013-12-04 23:42:32: Executing cmd: /oragrid/product/11.2.0/bin/crsctl check cluster -n rac1
2013-12-04 23:42:32: Checking the status of cluster
2013-12-04 23:42:37: Executing cmd: /oragrid/product/11.2.0/bin/crsctl check cluster -n rac1
2013-12-04 23:42:38: Checking the status of cluster
2013-12-04 23:42:43: Executing cmd: /oragrid/product/11.2.0/bin/crsctl check cluster -n rac1
2013-12-04 23:42:43: Checking the status of cluster
2013-12-04 23:42:48: Executing cmd: /oragrid/product/11.2.0/bin/crsctl check cluster -n rac1
2013-12-04 23:42:48: Checking the status of cluster
2013-12-04 23:42:53: Executing cmd: /oragrid/product/11.2.0/bin/crsctl check cluster -n rac1
2013-12-04 23:42:53: Checking the status of cluster
2013-12-04 23:42:58: Executing cmd: /oragrid/product/11.2.0/bin/crsctl check cluster -n rac1
2013-12-04 23:42:58: Checking the status of cluster
2013-12-04 23:43:03: Executing cmd: /oragrid/product/11.2.0/bin/crsctl check cluster -n rac1
2013-12-04 23:43:03: Oracle CRS stack installed and running
2013-12-04 23:43:03: Running as user oracle: /oragrid/product/11.2.0/bin/crsctl status resource ora.oc4j
2013-12-04 23:43:03: s_run_as_user2: Running /bin/su oracle -c ' /oragrid/product/11.2.0/bin/crsctl status resource ora.oc4j '
2013-12-04 23:43:03: Removing file /tmp/fileSPHMTZ
2013-12-04 23:43:03: Successfully removed file: /tmp/fileSPHMTZ
2013-12-04 23:43:03: /bin/su successfully executed

2013-12-04 23:43:03: Running as user oracle: /oragrid/product/11.2.0/bin/srvctl stop oc4j
2013-12-04 23:43:03: s_run_as_user2: Running /bin/su oracle -c ' /oragrid/product/11.2.0/bin/srvctl stop oc4j '
2013-12-04 23:43:21: Removing file /tmp/fileRPEcmm
2013-12-04 23:43:21: Successfully removed file: /tmp/fileRPEcmm
2013-12-04 23:43:21: /bin/su successfully executed

2013-12-04 23:43:21: Running as user oracle: /oragrid/product/11.2.0/bin/crsctl get jazn /oragrid/product/11.2.0/oc4j/j2ee/home/OC4J_DBWLM_config/system-jazn-data.xml -f
2013-12-04 23:43:21: s_run_as_user2: Running /bin/su oracle -c ' /oragrid/product/11.2.0/bin/crsctl get jazn /oragrid/product/11.2.0/oc4j/j2ee/home/OC4J_DBWLM_config/system-jazn-data.xml -f '
2013-12-04 23:43:21: Removing file /tmp/filev0qBjC
2013-12-04 23:43:21: Successfully removed file: /tmp/filev0qBjC
2013-12-04 23:43:21: /bin/su successfully executed

2013-12-04 23:43:21: Running as user oracle: /oragrid/product/11.2.0/bin/qosctl -autogenerate
2013-12-04 23:43:21: s_run_as_user2: Running /bin/su oracle -c ' /oragrid/product/11.2.0/bin/qosctl -autogenerate '
2013-12-04 23:43:24: Removing file /tmp/fileDijqgT
2013-12-04 23:43:24: Successfully removed file: /tmp/fileDijqgT
2013-12-04 23:43:24: /bin/su successfully executed

2013-12-04 23:43:24: Running as user oracle: /oragrid/product/11.2.0/bin/crsctl set jazn /oragrid/product/11.2.0/oc4j/j2ee/home/OC4J_DBWLM_config/system-jazn-data.xml -f
2013-12-04 23:43:24: s_run_as_user2: Running /bin/su oracle -c ' /oragrid/product/11.2.0/bin/crsctl set jazn /oragrid/product/11.2.0/oc4j/j2ee/home/OC4J_DBWLM_config/system-jazn-data.xml -f '
2013-12-04 23:43:24: Removing file /tmp/fileqkXrxk
2013-12-04 23:43:24: Successfully removed file: /tmp/fileqkXrxk
2013-12-04 23:43:24: /bin/su successfully executed

2013-12-04 23:43:24: Running as user oracle: /oragrid/product/11.2.0/bin/srvctl start oc4j
2013-12-04 23:43:24: s_run_as_user2: Running /bin/su oracle -c ' /oragrid/product/11.2.0/bin/srvctl start oc4j '
2013-12-04 23:43:56: Removing file /tmp/filehsRb5L
2013-12-04 23:43:56: Successfully removed file: /tmp/filehsRb5L
2013-12-04 23:43:56: /bin/su successfully executed

2013-12-04 23:43:56: QoS users were patched correctly.

저작자표시 비영리 변경금지

Posted by pat98

pat98's always & forever

'오라클'에 해당되는 글 499건

11gR2 RAC parameter 권장값

exadata flashcache 모드 변경

RAC Database 에 Exadata Bundle Patch (Patch Set 11.2.0.4.3)

Exadata scrub 기능

Exadata user guide

exadata cellcli 명령어

11g rac resource 제거

oracle profile

Vendor별 Clusterware 상태확인

opatch auto 의 이해

카테고리

태그목록

글 보관함

최근에 올라온 글

달력

링크

최근에 달린 댓글

티스토리툴바

« | » 2025.1
일	월	화	수	목	금	토
			1	2	3	4
5	6	7	8	9	10	11
12	13	14	15	16	17	18
19	20	21	22	23	24	25
26	27	28	29	30	31