Tuesday, November 10, 2015

RACCheck Tools-oracle 11.2.0.4

Oracle raccheck is a tools for checking your Oracle rac.in this case I have oracle rac 11.2.0.4 and we have raccheck tools by default in the ORACLE_HOME. If you have previous version of the oracle database then you have to download it and run raccheck tools .


1- login with oracle user on linux and go to ORACLE_HOME path and then:

$ /oracle/product/11.2.0/db_1/suptools/raccheck/raccheck -a


Do you want to continue using older version of raccheck? [y/n][y]

CRS stack is running and CRS_HOME is not set. Do you want to set CRS_HOME to /grid/product/11.2.0/grid_1?[y/n][y]

Checking ssh user equivalency settings on all nodes in cluster

Node css-db-test-2 is configured for ssh user equivalency for oracle user


Searching for running databases . . . . .

.
List of running databases registered in OCR
1. orcl
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  ASM HOME       RDBMS Installed  CRS UP    ASM UP    RDBMS UP  DB Instance Name
-------------------------------------------------------------------------------------------------------
css-db-test-1 Yes             Yes             Yes             Yes        Yes      Yes      orcl1
css-db-test-2 Yes             Yes             Yes             Yes        Yes      Yes      orcl2
-------------------------------------------------------------------------------------------------------

8 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_raccheck.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[1-4][1]:- 4

if the intent is to set up sudo configuration please have a root privileged user add the following line to the end of sudoers file using /usr/sbin/visudo on each node of cluster.

oracle ALL=(root) NOPASSWD:/tmp/root_raccheck.sh

No comments:

Post a Comment