Oracle OS Watcher (OSWatcher) is a tool to help DBA's to trouble shoot Database performance, Cluster reboot, node eviction, DB server reboot, DB instance Crash related issues and many more.
As we know, OS stats like top, mpstat, netstat plays an important role in Database trouble shooting but there is no way to keep historical date for these stats. Here, OS Watcher is the only rescue for Database Administrator. Suppose Yesterday, There was some performance issue on Database Node but you were not aware about that and when you know that the issue was resolved itself.
Now, DBA can get Database related stats from AWR reports but not OS related stats for last day, To overcome this challenge Oracle introduce OS Watcher utility, which collects OS stats data at a frequency of five minutes and keep it for seven days (default settings). So Now, DBA need not to worry about historical OS stats.
To Trouble shoot Database performance related issues AWR, ADDM and OS Watcher logs are the first place to start for a Remote DBA. Where as for Cluster reboot, node eviction, DB server reboot Alter log files, OS Watcher and System messages (/var/log/messages) plays an important role.
How to Install OS Watcher Utility
1. Download tar file from Oracle Support Article "OSWatcher Black Box.
2. Copy the file oswbb601.tar to the directory where oswbb is to be installed.
3. Extract tar file with “oracle” user
# tar xvf oswbb601.tar
4. Change to oswbb directory created.
5. Start OS Watcher utility using below command.
Example 1:
./startOSW.sh 60 10
This would start the tool and collect data at 60 second intervals and log the last 10 hours of data to archive files.
Example 2:
./startOSW.sh
This would use the default values of 30, 48 and collect data at 30 second intervals and log the last 48 hours of data to archive files.
Example 3:
./startOSW.sh 20 24 gzip
This would start the tool and collect data at 20 second intervals and log the last 24 hours of data to archive files. Each file would be compressed by running the gzip utility after creation.
STOPPING OSW:
To stop the OSW utility execute the stopOSW.sh command. This terminates all the processes associated with the tool.
Example:
./stopOSW.sh
The default location of OS Watcher files is /opt/oracle.oswatcher/osw/archive. To collect OS Watcher files for a particular day use below command.
# cd /opt/oracle.oswatcher/osw/archive
# find . -name '*25.05.16*' -print -exec zip /tmp/osw_`hostname`.zip {} \;
{where 16- year 05- Month 25-day}
Below are the list of sub folders created under archive folder
-bash-4.1$ ls
osw_ib_diagnostics oswiostat oswnetstat oswps oswvmstat
osw_rds_diagnostics oswmpstat oswprvtnet oswtop
As we know, OS stats like top, mpstat, netstat plays an important role in Database trouble shooting but there is no way to keep historical date for these stats. Here, OS Watcher is the only rescue for Database Administrator. Suppose Yesterday, There was some performance issue on Database Node but you were not aware about that and when you know that the issue was resolved itself.
Now, DBA can get Database related stats from AWR reports but not OS related stats for last day, To overcome this challenge Oracle introduce OS Watcher utility, which collects OS stats data at a frequency of five minutes and keep it for seven days (default settings). So Now, DBA need not to worry about historical OS stats.
To Trouble shoot Database performance related issues AWR, ADDM and OS Watcher logs are the first place to start for a Remote DBA. Where as for Cluster reboot, node eviction, DB server reboot Alter log files, OS Watcher and System messages (/var/log/messages) plays an important role.
How to Install OS Watcher Utility
1. Download tar file from Oracle Support Article "OSWatcher Black Box.
2. Copy the file oswbb601.tar to the directory where oswbb is to be installed.
3. Extract tar file with “oracle” user
# tar xvf oswbb601.tar
4. Change to oswbb directory created.
5. Start OS Watcher utility using below command.
Example 1:
./startOSW.sh 60 10
This would start the tool and collect data at 60 second intervals and log the last 10 hours of data to archive files.
Example 2:
./startOSW.sh
This would use the default values of 30, 48 and collect data at 30 second intervals and log the last 48 hours of data to archive files.
Example 3:
./startOSW.sh 20 24 gzip
This would start the tool and collect data at 20 second intervals and log the last 24 hours of data to archive files. Each file would be compressed by running the gzip utility after creation.
STOPPING OSW:
To stop the OSW utility execute the stopOSW.sh command. This terminates all the processes associated with the tool.
Example:
./stopOSW.sh
The default location of OS Watcher files is /opt/oracle.oswatcher/osw/archive. To collect OS Watcher files for a particular day use below command.
# cd /opt/oracle.oswatcher/osw/archive
# find . -name '*25.05.16*' -print -exec zip /tmp/osw_`hostname`.zip {} \;
{where 16- year 05- Month 25-day}
Below are the list of sub folders created under archive folder
-bash-4.1$ ls
osw_ib_diagnostics oswiostat oswnetstat oswps oswvmstat
osw_rds_diagnostics oswmpstat oswprvtnet oswtop
No comments:
Post a Comment