Operating System Commands

Operating System Commands:

This section will look at some commands that the dba can run to quickly check the status of the RAC cluster: -

System logs:

The following commands will show system logs that can help in finding the root cause of faults and also current system states or errors. Sample output shows the errpt from a system.

p13404prDXXXX-> errpt -a | more

Error Logs:

Viewing the error logs located under /usr/local/logs is also an excellent start to view if the state of a system if the Oracle side of things is experiencing problems

As shown from the above output for searching errorlogs this examples shows that machine p13404prd019 could not talk to p13604prd023.

{p13404XXXXX}/usr/local/logs$ egrep "error" /usr/local/logs/errorlog*


More error log interrogation :


Running and egrep command on the daemon logs will also show if any errors can lead towards possible failure from the example below you can see errors on the tcp_connect_failed this confirms that from the output above a node cannot be communicated via tcp between node 19 and node 23 – this would tend towards a network or possible network card errors…

{p13404XXXXX}/usr/local/logs$ egrep "Broker_tcp_connect_failed"