Basic Oracle Exadata administration

Basic Oracle Exadata Machine administration

Using dcli

1. connect as oracle user
2. create a file named mycells
   
   

   cat <<> mycells dbserver01 dbserver02 dbserver03 dbserver04 END

1. Generate a ssh key pair

2. ssh-keygen -t rsa



3. You have completed. Now try it.
   
   

   dcli -g mycells "cat /proc/meminfo | grep Mem"

How to check Exadata version?

[root@remote_dbacell1 ~]# imageinfo [root@remote_dbacell1 ~]# imagehistory

How to clean exawatcher logs?

(Doc ID 1617454.1)


One-time cleanup for ExaWatcher logs:

1.  Stop ExaWatcher
   
   

   ./ExaWatcher.sh --stop

2. Adjust on the command line for a one-time cleanup operation ...  will remove all older ExaWatcher logs over 2GB quotaOutput showing ExaWatcherCleanup.sh execution will be written to the console.  When completed you will see something similar to:"Current size of the result directory /opt/oracle.ExaWatcher/archive/ is 2097152 after clean up. Please see /opt/oracle.ExaWatcher/log/OldFilesDeleted.log to look for the files deleted." - Use 'control C' to exit from cleanup script
   

   ./ExaWatcher.sh --spacelimit "spacelimit" (in MB)ex) ./ExaWatcher.sh  --spacelimit 2048

3. 
   
4. Restart ExaWatcher
   
   

   /opt/oracle.cellos/validations/bin/vldrun.pl -script oswatcher

5. 
   

How to change OS user password for Cell Node, Database Node , ILOM, KVM , Infiniband Switch , GigaBit Ethernet Switch and PDU on Exadata Database Machine

(Doc ID 1291766.1)

1. set /SP/users/root password

   > dcdli -g dbs_cell_group_ilom -| root " ipmitool sunoem cli 'set /SP/users/root password=newpassword' oldpassword"

   
   
   
   

How to stop database nodes?

1. /grid/bin/crsctl stop crs –f
2. Shutdown oswatcher
   
   

   cd /opt/oracle/oswatcher/osw/ /stopOSW.sh

How to power on/off sequence?

Power off sequence

1. On Database server
   1. crsctl stop cluster
   2. shutdown –h –u now
2. On Storage server
   1. Shutdown –h –y now
3. Turn off Rack, network switches

Power on sequence

1. Rack, network switches
2. Storage server
3. Database server

How to Shutdown Exadata storage Server?

Shutdown sequence

cellcli> LIST GRIDDISK WHERE asmdeactivationoutcome != ‘Yes’ cellcli> ALTER GRIDDISK ALL INACTIVE cellcli> LIST GRIDDISK WHERE STATUS !=’INACTIVE’

Startup sequence

cellcli> ALTER GRIDDISK ALL ACTIVE cellcli> LIST GRIDDISK ATTRIBUTES name,attributes

1. 
   

How to replacing a Damaged Physical disk?

1. cellcli> LIST ALERTHISTORY WHERE ALERTMESSAGE LIKE “Logical drive lost.*” DETAIL
2. Replace the physical disk
   1. ALTER PHYSICALDISK
3. Monitor the ASM to confirm the re-addition of the disk

Replacing a damaged Flash Card

1. 
   
   

   cellcli> LIST PHYSICALDISK DETAIL

   
   
2. power off cell
3. replace the damanged card
4. power on the cell

Moving all disk from one cell to another

1. 
   
   

   cellcli> ALTER GRIDDISK ALL INACTIVE

2. Backup OS config
3. Move the disk,flashcard, disk controller and CELLBOOT to new cell
4. Boot the new cell
5. Restart cell services
   
   

   Cellcli> ALTER CELL RESTART SERVICES ALL

   
   
6. Activate the gird disks
   
   

   Cellcli> ALTER GRDDISK ALL ACTIVE

   
   
7.