所选语种没有对应资源,请选择:

本站点使用Cookies,继续浏览表示您同意我们使用Cookies。Cookies和隐私政策>

提示

尊敬的用户,您的IE浏览器版本过低,为获取更好的浏览体验,请升级您的IE浏览器。

升级

FusionCube DB 3.1 数据库最佳实践 03 (Oracle RAC 12c R2)

评分并提供意见反馈 :
华为采用机器翻译与人工审校相结合的方式将此文档翻译成不同语言,希望能帮助您更容易理解此文档的内容。 请注意:即使是最好的机器翻译,其准确度也不及专业翻译人员的水平。 华为对于翻译的准确性不承担任何责任,并建议您参考英文文档(已提供链接)。
工具使用

工具使用

数据库环境部署完成之后,进入到$ORACLE_HOME/suptools/orachk目录下,用oracle用户执行命令:./oracheck

[oracle@dbn03 orachk]$ ./orachk 
This version of orachk was released on 26-May-2016 and its older than 120 days. No new version of orachk is available in RAT_UPGRADE_LOC. It is highly recommended that you download the latest version of orachk from my oracle support to ensure the highest level of accuracy of the data contained within the report.
Do you want to download latest version from my oracle support? [y/n][y]
updates.oracle.com is not reachable. Please establish connectivity to updates.oracle.com and try again.
Do you want to continue running this version? [y/n][y]
Running older version...
CRS stack is running and CRS_HOME is not set. Do you want to set CRS_HOME to /u01/app/12.2.0/grid?[y/n][y]
Checking ssh user equivalency settings on all nodes in cluster
Node dbn04 is configured for ssh user equivalency for oracle user
Searching for running databases . . . . .
. . 
List of running databases registered in OCR
1. dbn
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].
. . . . 
. 
Checking Status of Oracle Software Stack - Clusterware, ASM, RDBMS
. . . . . . . . . . . . . .. . . . . . . . . . . .. . . . . . 
-------------------------------------------------------------------------------------------------------
                                                 Oracle Stack Status                            
-------------------------------------------------------------------------------------------------------
Host Name  CRS Installed  RDBMS Installed  CRS UP    ASM UP    RDBMS UP  DB Instance Name
-------------------------------------------------------------------------------------------------------
dbn03       Yes             Yes             Yes        Yes      Yes      dbn01     
dbn04       Yes             Yes             Yes        Yes      Yes      dbn02     
-------------------------------------------------------------------------------------------------------
. . . . . . 
163 of the included audit checks require root privileged data collection . If sudo is not configured or the root password is not available, audit checks which require root privileged data collection can be skipped.
1. Enter 1 if you will enter root password for each  host when prompted
2. Enter 2 if you have sudo configured for oracle user to execute root_orachk.sh script 
3. Enter 3 to skip the root privileged collections 
4. Enter 4 to exit and work with the SA to configure sudo  or to arrange for root access and run the tool later.
Please indicate your selection from one of the above options for root access[1-4][1]:- 
Is root password same on all nodes?[y/n][y]
Enter root password :- 
Verifying root password.
. . . 
*** Checking Best Practice Recommendations (PASS/WARNING/FAIL) ***
Collections and audit checks log file is 
/u01/app/oracle/orachk/orachk_dbn03_dbn_072617_143828/log/orachk.log
Checking for prompts in /home/oracle/.bash_profile on dbn03 for oracle user...
Checking for prompts in /home/oracle/.bash_profile on dbn04 for oracle user...
Starting to run orachk in background on dbn04 
. . 
=============================================================
                    Node name - dbn03                                
=============================================================
. . . . . 
Collecting - ASM Disk Groups 
Collecting - ASM Disk I/O stats 
Collecting - ASM Diskgroup Attributes 
Collecting - ASM disk partnership imbalance 
Collecting - ASM diskgroup attributes 
Collecting - ASM diskgroup usable free space 
Collecting - ASM initialization parameters 
Collecting - Active sessions load balance for dbn database
Collecting - Archived Destination Status for dbn database
Collecting - Cluster Interconnect Config for dbn database
Collecting - Database Archive Destinations for dbn database
Collecting - Database Files for dbn database
Collecting - Database Instance Settings for dbn database
Collecting - Database Parameters for dbn database
Collecting - Database Parameters for dbn database
Collecting - Database Properties for dbn database
Collecting - Database Registry for dbn database
Collecting - Database Sequences for dbn database
Collecting - Database Undocumented Parameters for dbn database
Collecting - Database Undocumented Parameters for dbn database
Collecting - Database Workload Services for dbn database
Collecting - Dataguard Status for dbn database
Collecting - Files not opened by ASM 
Collecting - Log Sequence Numbers for dbn database
Collecting - Percentage of asm disk  Imbalance 
Collecting - Process for shipping Redo to standby for dbn database
Collecting - RDBMS Feature Usage for dbn database
Collecting - Redo Log information for dbn database
Collecting - Standby redo log creation status before switchover for dbn database
Collecting - /proc/cmdline
Collecting - /proc/modules
Collecting - CPU Information
Collecting - CRS active version
Collecting - CRS oifcfg
Collecting - CRS software version
Collecting - CSS Reboot time
Collecting - CSS disktimout
Collecting - Cluster interconnect (clusterware)
Collecting - Clusterware OCR healthcheck 
Collecting - Clusterware Resource Status
Collecting - DiskFree Information
Collecting - DiskMount Information
Collecting - Huge pages configuration
Collecting - Interconnect network card speed
Collecting - Kernel parameters
Collecting - Linux module config.
Collecting - Maximum number of semaphore sets on system
Collecting - Maximum number of semaphores on system
Collecting - Maximum number of semaphores per semaphore set
Collecting - Memory Information
Collecting - NUMA Configuration
Collecting - Network Interface Configuration
Collecting - Network Performance
Collecting - Network Service Switch
Collecting - OS Packages
Collecting - OS version
Collecting - Operating system release information and kernel version
Collecting - Oracle Executable Attributes
Collecting - Patches for Grid Infrastructure 
Collecting - Patches for RDBMS Home 
Collecting - Shared memory segments
Collecting - Table of file system defaults
Collecting - Voting disks (clusterware)
Collecting - number of semaphore operations per semop system call
Preparing to run root privileged commands  dbn03.
Collecting - Broadcast Requirements for Networks 
Collecting - CRS Opatch version 
Collecting - CRS user time zone check 
Collecting - Custom rc init scripts (rc.local) 
Collecting - Disk Information 
Collecting - Grid Infastructure user shell limits configuration 
Collecting - Interconnect interface config 
Collecting - Linux Operating system health check using vmpscan.sh 
Collecting - Network interface stats 
Collecting - OCR and Voting file location 
Collecting - OLR Integrity 
Collecting - Root user limits 
Collecting - Verify no database server kernel out of memory errors  
Collecting - root time zone check 
Collecting - slabinfo 
Collecting - umask setting for GI owner 
Data collections completed. Checking best practices on dbn03.
--------------------------------------------------------------------------------------
 INFO =>    Important Automatic Storage Management (ASM) Notes and Technical White Papers
 INFO =>    Oracle Data Pump Best practices.
 INFO =>    Important Storage Minimum Requirements for Grid & Database Homes
 INFO =>    Oracle asm filter driver is not loaded
 WARNING => There are some application objects with STALE statistics. for dbn
 INFO =>    Most recent ADR incidents for /u01/app/oracle/product/12.2.0/db
 WARNING => PGA allocation for all databases is more than total memory available on this system完成后,将显示以下(或类似)内容: Detailed report (html) - /u01/app/oracle/orachk/orachk_dbn03_dbn_072617_143828/orachk_dbn03_dbn_072617_143828.html
UPLOAD(if required) - /u01/app/oracle/orachk/orachk_dbn03_dbn_072617_143828.zip两个节点一般需要运行10多分钟,每个节点大概需要5分钟。
翻译
下载文档
更新时间:2018-12-26

文档编号:EDOC1100035765

浏览量:7717

下载量:450

平均得分:
本文档适用于这些产品
相关文档
相关版本
Share
上一页 下一页