Friday, July 25, 2014

Some Tips on Exadata

Run Exacheck Report

The Exa-Check report needs to be run from the first DB node. 

Below are the steps : 

1. Login as oracle user(Database user), make a clean directory and load Exachk225(Oracle Exadata Database Machine exachk or HealthCheck (Doc ID 1070954.1). 
2. cd to the directory created 

4. export RAT_IBSWITCH_USER=root (if you do not have the password for the Nm2user) 
3. export RAT_TIMEOUT=120 
4. export RAT_ROOT_TIMEOUT=600 
5. export RAT_PASSWORDCHECK_TIMEOUT=10 
6. ./exachk -a 

answer the prompt to set crs home as "Y". 
select all databases 
answer the prompts for the root password on the storage servers 
answer the prompts for the root userid password on the database servers 
answer the prompts for the nm2user(root) password on the IB switches.


Change password for root User of Exadata DB & Cell Sever

Save all hostname in one file and call that filename into dcli command as follows,

[oracle@dbnode01 ~]$ cat /home/oracle/all_group
dbnode01
dbnode02
cellnode01
cellnode02
cellnode03

[root@dbnode01 ~]# PASSWORD=xxxxx (any password)
[root@dbnode01 ~]# dcli -l root -g /home/oracle/all_group "echo ${PASSWORD} | passwd --stdin root"
dbnode01: Changing password for user root.
dbnode01: passwd: all authentication tokens updated successfully.
dbnode02: Changing password for user root.
dbnode02: passwd: all authentication tokens updated successfully.
cellnode01: Changing password for user root.
cellnode01: passwd: all authentication tokens updated successfully.
cellnode02: Changing password for user root.
cellnode02: passwd: all authentication tokens updated successfully.
cellnode03: Changing password for user root.
cellnode03: passwd: all authentication tokens updated successfully.
[root@dbnode01 ~]#

The same way you can do for rest of the users too in exadata environment.

No comments:

Post a Comment