Site icon IT Tutorial

Oracle ORAchk ile Database Health Check

Merhaba Arkadaşlar,

Bu yazımda sizlere Oracle ın Database Health Check ( Sağlık / Hata kontrol ) için geliştirdiği ORAchk toolunu anlatacağım. ORAchk veritabanı ve veritabanı sunucusu üzerinde ayrıntılı kontroller yaparak database, clusterware, patch,OS konularında tavsiyelerde bulunan ve best practice sler sunan RACchk ve Exadata Exachk toollarına benzer bir tooldur. ORAchk in en güncel versiyonu 2.2.5 olup kayıtlı kullanıcınızla metalinkten indirebilirsiniz.

 

 

ORAchk toolunu genel veritabanı sağlık taraması ( Health Check ) yapmak için kullanılabildiği gibi RAC Database Upgrade i öncesinde de çalıştırabilir ve Upgrade öncesi Sorunları ve tavsiyeleri alabilirsiniz.

ORAchk toolu aşağıdaki ortamlarda kullanılabilir.

Bu Tool aşağıdaki sistemler üzerinde desteklenmektedir.

ORAchk toolunun desteklendiği veritabanı versiyonları ise aşağıdaki gibidir.

 

 

Ben Bu yazımda IBM-AIX üzerindeki Oracle RAC 11.2.0.3 veritabanımı 11.2.0.4 versiyonuna Upgrade öncesi kullanacak ve Upgrade öncesi sistemin durumunu ve Oracle ın best practicelerini öğreneceğim. ORAchk toolunu yukarda belirttiğim linkten indirip sunucuma indirdikten sonra aşağıdaki adımlarla ORAchk toolunu kullanıma açıyorum.

orachk.zip dosyası aşağıdaki gibi açılır.

oracle:testserver01:/oracle:>cd orachk/
 oracle:testserver01:/oracle/orachk:>ls -all
 total 11288
 drwxr-xr-x 2 oracle oinstall 256 Jul 02 10:33 .
 drwxr-xr-x 10 oracle oinstall 4096 Jul 02 10:33 ..
 -rw-r--r-- 1 oracle oinstall 5770368 Jul 02 09:53 orachk.zip
oracle:testserver01:/oracle/orachk:>unzip orachk.zip
 Archive: orachk.zip
 inflating: UserGuide.txt
 inflating: rules.dat
 inflating: orachk
 creating: .cgrep/
 inflating: .cgrep/hiacgrep
 inflating: .cgrep/lcgrep5
 inflating: .cgrep/auto_upgrade.pl
 inflating: .cgrep/check_reblance_free_space.sql
 inflating: .cgrep/psqlplus
 inflating: .cgrep/scgrepx86
 inflating: .cgrep/init.tmpl
 inflating: .cgrep/utluppkg.sql
 inflating: .cgrep/scgrep
 inflating: .cgrep/versions.dat
 inflating: .cgrep/raw_data_browser.pl
 inflating: .cgrep/lcgrep6
 inflating: .cgrep/profiles.dat
 inflating: .cgrep/auto_upgrade_check.pl
 inflating: .cgrep/CollectionManager_App.sql
 inflating: .cgrep/utlu112i.sql
 inflating: .cgrep/ggdiscovery.sh
 inflating: .cgrep/lcgreps9
 inflating: .cgrep/checkDiskFGMapping.sh
 inflating: .cgrep/lcgreps10
 inflating: .cgrep/pxhcdr.sql
 inflating: .cgrep/diff_collections.pl
 inflating: .cgrep/rack_comparison.py
 inflating: .cgrep/exalogic_zfs_checks.aksh
 inflating: .cgrep/lcgrep4
 inflating: .cgrep/merge_collections.pl
 inflating: .cgrep/acgrep
 inflating: .cgrep/show_file_in_html.pl
 inflating: .cgrep/scnhealthcheck.sql
 inflating: .cgrep/lcgreps11
 inflating: .cgrep/reset_crshome.pl
 inflating: .cgrep/ogghc_12101.sql
 creating: .cgrep/profiles/
 inflating: .cgrep/profiles/DF65D0F7FB6F1014E04312C0E50A7808.prf
 inflating: .cgrep/profiles/DFE9C207A8F2428CE04313C0E50A6B0A.prf
 inflating: .cgrep/profiles/D49C4F9F48735396E0431EC0E50A9A0B.prf
 inflating: .cgrep/profiles/D49C0AB26A6D45A8E0431EC0E50ADE06.prf
 inflating: .cgrep/profiles/D49BDC2EC9E624AEE0431EC0E50A3E12.prf
 inflating: .cgrep/profiles/F9ED0179CCD8256BE04312C0E50A5399.prf
 inflating: .cgrep/profiles/F6AFECA37F177C3FE04313C0E50A56BF.prf
 inflating: .cgrep/profiles/D49B218473787400E0431EC0E50A0BB9.prf
 inflating: .cgrep/profiles/E2E972DDE1E14493E04312C0E50A1AB1.prf
 inflating: .cgrep/profiles/F32F44CE0BCD662FE04312C0E50AB058.prf
 inflating: .cgrep/profiles/D49AD88F8EE75CD8E0431EC0E50A0BC3.prf
 inflating: .cgrep/profiles/E8DF76E07DD82E0DE04313C0E50AA55D.prf
 inflating: .cgrep/profiles/EA5EE324E7E05128E04313C0E50A4B2A.prf
 inflating: .cgrep/profiles/D462A6F7E9C340FDE0431EC0E50ABE12.prf
 inflating: .cgrep/profiles/E1BF012E8F210839E04313C0E50A7B68.prf
 inflating: .cgrep/profiles/DF65D6117CB41054E04312C0E50A69D1.prf
 inflating: .cgrep/profiles/D8367AD6754763FEE04312C0E50A6FCB.prf
 inflating: .cgrep/profiles/D49C0FBF8FBF4B1AE0431EC0E50A0F24.prf
 inflating: .cgrep/profiles/DA94919CD0DE0913E04312C0E50A7996.prf
 inflating: .cgrep/profiles/EF6C016813C51366E04313C0E50AE11F.prf
 extracting: .cgrep/profiles/F13E11974A282AB3E04312C0E50ABCBF.prf
 inflating: .cgrep/utlusts.sql
 inflating: .cgrep/asrexacheck
 inflating: .cgrep/create_version.pl
 inflating: .cgrep/oracle-upstarttmpl.conf
 inflating: .cgrep/preupgrd.sql
 inflating: .cgrep/ogghc_11203.sql
 inflating: .cgrep/ogghc_11204.sql
 inflating: CollectionManager_App.sql
 inflating: raccheck
 inflating: readme.txt
 inflating: collections.dat
 oracle:testserver01:/oracle/orachk:>

 

2.Adım: ORAchk toolunu unzip ettiğimizde aşağıdaki gibi dosyalar gelecektir.

 oracle:testserver01:/oracle/orachk:>ls -all
 total 75752
 drwxr-xr-x 3 oracle oinstall 4096 Jul 02 10:34 .
 drwxr-xr-x 10 oracle oinstall 4096 Jul 02 10:33 ..
 drwxrwxr-x 3 oracle oinstall 4096 May 31 09:37 .cgrep
 -rw-r--r-- 1 oracle oinstall 3435193 May 31 09:37 CollectionManager_App.sql
 -rw-r--r-- 1 oracle oinstall 432 May 31 09:37 UserGuide.txt
 -rw-rw-r-- 1 oracle oinstall 22951324 May 31 09:37 collections.dat
 -rwxr-xr-x 1 oracle oinstall 1604239 May 31 09:37 orachk
 -rw-r--r-- 1 oracle oinstall 5770368 Jul 02 09:53 orachk.zip
 -rwxr-xr-x 1 oracle oinstall 1604239 May 31 09:37 raccheck
 -rw-r--r-- 1 oracle oinstall 3879 May 31 09:37 readme.txt
 -rw-rw-r-- 1 oracle oinstall 3384097 May 31 09:37 rules.dat

 

Toolu yukarda kalın harflerle listelediğim orachk komutuyla çalıştırıyoruz. ORAchk toolunu aşağıdaki parametrelerle farklı amaçlar için çalıştırabilirsiniz.

 

Ben bu yazımda 11.2.0.3 versiyonunda bulunan Oracle RAC veritabanımı 11.2.0.4 e upgrade i öncesi çalıştırıp sonuçlarına bakacağım. Tool u aşağıdaki gibi çalıştırıp gelen sorulara kırmızı renkle cevabı verip ilerliyorum.

 

oracle:testserver01:/oracle/orachk:>./orachk -u -o pre
 Enter upgrade target version (valid versions are 11.2.0.3.0, 11.2.0.4.0, 12.1.0.1.0, 12.1.0.2.0):- 11.2.0.4.0
CRS stack is running and CRS_HOME is not set. Do you want to set CRS_HOME to /oracle/product/11.2.0.3/grid?[y/n][y]y
Checking ssh user equivalency settings on all nodes in cluster
Node testserver02 is configured for ssh user equivalency for oracle user
Searching for running databases . . . . .
. .
 List of running databases registered in OCR
 1. TESTDB
 2. None of above
Select databases from list for checking best practices. For multiple databases, select 1 for All or comma separated number like 1,2 etc [1-2][1].1
 . .
 Checking Status of Oracle Software Stack - Clusterware, ASM, RDBMS
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
 -------------------------------------------------------------------------------------------------------
 Oracle Stack Status
 -------------------------------------------------------------------------------------------------------
 Host Name CRS Installed ASM HOME RDBMS Installed CRS UP ASM UP RDBMS UP DB Instance Name
 -------------------------------------------------------------------------------------------------------
 testserver01Yes N/A Yes Yes Yes Yes TESTDB1
 testserver02Yes N/A Yes Yes Yes Yes TESTDB2
 -------------------------------------------------------------------------------------------------------
 ---------------------------------------------------------------------------------------------------------------------------------
 Installed components summary
 ---------------------------------------------------------------------------------------------------------------------------------
 GI_HOME ORACLE_HOME Database Names
 ---------------------------------------------------------------------------------------------------------------------------------
 /oracle/product/11.2.0.3/grid - 11.2.0.3.0 /oracle/app/product/11.2.0.3/db - 11.2.0.3.0 TESTDB
 ---------------------------------------------------------------------------------------------------------------------------------
 Copying plug-ins
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . .
 Checking Grid Infrastructure and RDBMS upgrade readiness to version 112040

Collections and audit checks log file is
 /oracle/orachk/orachk_testserver01_TESTDB_070214_104039/log/orachk.log

Checking for prompts in /home/users/oracle/.profile on testserver01 for oracle user...
 Checking for prompts in /home/users/oracle/.profile on testserver02 for oracle user...

Starting to run orachk in background on testserver02
=============================================================
 Node name - testserver01
 =============================================================
Collecting - ASM Diskgroup Attributes
 Collecting - ASM initialization parameters
 Collecting - Database Parameters for TESTDB database
 Collecting - Database Undocumented Parameters for TESTDB database
 Collecting - Pre-upgrade File Locations for TESTDB database
 Collecting - AIX Packages
 Collecting - CPU Information
 Collecting - Disk Information
 Collecting - DiskFree Information
 Collecting - DiskMount Information
 Collecting - Memory Information
 Collecting - Network Interface Configuration
 Collecting - Network Performance
 Collecting - Network Service Switch
 Collecting - Network tunable parameters
 Collecting - OS fixes or patches
 Collecting - OS version
 Collecting - Patches for Grid Infrastructure
 Collecting - Patches for RDBMS Home
 Collecting - System and Kernel Settings
 Data collections completed. Checking best practices on testserver01.
 --------------------------------------------------------------------------------------
 INFO => Prior to Upgrade Verify NO Materialized Views Being Refreshed (Automatically or Manually) for TESTDB
 FAIL => Opatch version is lower than recommended in RDBMS_HOME for /oracle/app/product/11.2.0.3/db
 FAIL => Opatch version is lower than recommended in GRID_HOME
 INFO => Special Considerations for SCAN and HAIP of 11.2.0.2 and above Grid Infrastructure
 INFO => Minimizing Planned Downtime for Upgrades and Patching
 INFO => Upgrade Related References
 INFO => Lifetime Support Policy and Product Certification INFO
 INFO => Capture performance baseline, backup important configuration files and batch, cron, DBMS_JOBS and DBMS_SCHEDULER jobs
 INFO => Known Issues Integrating pre-11gR2 Databases with Grid Infrastructure
 INFO => Useful Information for Operating Oracle RAC on AIX Power Architecture
 INFO => Be Aware of New Instant Client for Simplified Deployment
 INFO => Oracle E-Business Suite interoperability and migration resources
 INFO => Oracle Software Download Sites
 WARNING => Some Users Needing Network ACLs for Oracle Utility Packages Found for TESTDB
 FAIL => Auditing tables (SYS.AUD$/sys.fga_log$) row count is large enough that there could potentially be a problem during the upgrade process for TESTDB
 INFO => Steps to execute rootupgrade.sh
 INFO => Save "Oracle Enterprise Manager Database Control" files and data with the emdwgrd Utility before upgrading database.
 INFO => Information about ASM process parameter when its not set to default value
 INFO => Information about Grid Infrastructure software installation directory
 WARNING => Package gpfs.base-3.3.0.11-ppc_64 is recommended but NOT installed

Copying results from testserver02 and generating report. This might take a while. Be patient.
=============================================================
 Node name - testserver02
 =============================================================
Collecting - AIX Packages
 Collecting - CPU Information
 Collecting - Disk Information
 Collecting - DiskFree Information
 Collecting - DiskMount Information
 Collecting - Memory Information
 Collecting - Network Interface Configuration
 Collecting - Network Performance
 Collecting - Network Service Switch
 Collecting - Network tunable parameters
 Collecting - OS fixes or patches
 Collecting - OS version
 Collecting - Patches for Grid Infrastructure
 Collecting - Patches for RDBMS Home
 Collecting - System and Kernel Settings
 Data collections completed. Checking best practices on testserver02.
 --------------------------------------------------------------------------------------

FAIL => Opatch version is lower than recommended in RDBMS_HOME for /oracle/app/product/11.2.0.3/db
 FAIL => Opatch version is lower than recommended in GRID_HOME
 INFO => Information about ASM process parameter when its not set to default value
 WARNING => Package gpfs.base-3.3.0.11-ppc_64 is recommended but NOT installed

---------------------------------------------------------------------------------
 CLUSTERWIDE CHECKS
 ---------------------------------------------------------------------------------
 ---------------------------------------------------------------------------------
Detailed report (html) - /oracle/orachk/orachk_testserver01_TESTDB_070214_104039/orachk_testserver01_TESTDB_070214_104039.html
 UPLOAD(if required) - /oracle/orachk/orachk_testserver01_TESTDB_070214_104039.zip
 oracle:testserver01:/oracle/orachk:>

 

ORAchk toolunun ürettiği ayrıntılı raporu yukardaki pathden sunucudan indirip açtığımda aşağıdaki gibi bir rapor karşımıza çıkmaktadır.

 

Rapor çok uzun olduğu için sadece önemli kısımların ekran görüntülerini vereceğim. Aşağıdaki gibi veritabanında dikkat edilmesi gereken bulgular verilmiştir. Bunlardan kimisi Fail,kimisi warning kimisi ise info şeklinde gruplandırılmıştır.

 

Yada Veritabanı için önerilen Best Practiceleri aşağıdaki bölümden bulabilirsiniz.

 

Böylece bir yazımın daha sonuna gelmiş bulunmaktayım bir sonraki yazıda görüşmek dileğiyle Esen kalın.

 

Oracle Exadata SQL Server Goldengate Weblogic EBS ve Linux konusunda aşağıdaki konularda 7×24 Uzman Danışmanlara yada Eğitimlere mi İhtiyacınız var mehmet.deveci@gridgroup.com.tr adresine mail atarak Bizimle iletişime geçebilirsiniz.

– Oracle Veritabanı Danışmanlığı
– Oracle Veritabanı Bakım ve Destek
– Exadata Danışmanlığı
– Exadata Bakım ve Destek
– SQL Server Veritabanı Danışmanlığı
– SQL Server Veritabanı Bakım ve Destek
– Goldengate Danışmanlığı
– Goldengate Bakım ve Destek
– Linux Danışmanlığı
– Linux Bakım ve Destek
– Oracle EBS Danışmanlığı
– Oracle EBS Bakım ve Destek
– Weblogic Danışmanlığı
– Weblogic Bakım ve Destek
– Oracle Veritabanı Eğitimleri
– Oracle VM Server Danışmanlığı
– Oracle VM Server Bakım ve Destek
– Oracle EPPM Danışmanlığı
– Oracle EPPM Bakım ve Destek
– Oracle Primavera Danışmanlığı
– Oracle Primavera Bakım ve Destek
– Oracle Eğitimleri
– SQL Server Eğitimleri
– Goldengate Eğitimleri
– Exadata Eğitimleri
– Linux Eğitimleri
– Oracle EBS Eğitimleri
– Oracle VM Server Eğitimleri
– Weblogic Eğitimleri
– Oracle EPPM Eğitimleri
– Oracle Primavera Eğitimleri

Exit mobile version