Solved

Health check on AIX 6.1 and Oracle databases

Posted on 2010-08-16
4
1,028 Views
Last Modified: 2013-11-17
We have experienced 4 outages in the last 10 days on our new GIS environment running on the P750.  What are the things/steps that need to be taken to perform a health check?  This is not necessarily server related.  Our configuration includes:

 

AIX 6.1 TL5 SP1

Veritas Storage Foundation HA 5.1 MP1

Oracle 10 and 11g

P750 w/ 3 LPARS created
0
Comment
Question by:Rhiaanon44
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 5

Expert Comment

by:balasundaram_s
ID: 33448219
General healthcheck includes, filesystem usage monitoring, process monitoring, etc.  For a specific application, a customized monitoring solution is highly recommended.
0
 
LVL 68

Accepted Solution

by:
woolmilkporc earned 500 total points
ID: 33448369
Hi,

as for the AIX server side -

- make sure the newest firmware is installed, which should be AL710_086. Get the latest firmware via FIX Central - http://www-933.ibm.com/support/fixcentral/
 
 - check errpt regularly for hardware/system software issues.

- Issue smitty alog_show and check all available alog files (console, boot, dumpsymp etc.)

- Issue "diag -c -s" regularly to run system diagnostics.

- Make sure there is a valid dump device of sufficient size, to hold a possible crash dump, for later analysis by IBM support.
Issue "sysdumpdev -l" to see the dump device(s) and "/usr/lib/dumpcheck -p" to check the size (no messages mean "device is big enough").

- Extend syslog to capture system debugging information - add the line

*.debug /var/adm/debug.log

to /etc/syslog.conf, issue "touch /var/adm/debug.log" and "refresh -s syslogd"

Check the resulting file for hints.

wmp

0
 
LVL 25

Expert Comment

by:madunix
ID: 33448804
in my case i use nagios to monitor AIX OS. look @
http://nagios.org/
http://exchange.nagios.org/directory/Distributions/Pre%252DCompiled-Binaries/AIX
i use AIX5.3
0
 

Author Closing Comment

by:Rhiaanon44
ID: 33487747
Thanks to all of you!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle 12c Default Isolation Level 17 62
oracle collections 2 41
oracle forms question 22 60
construct a query sql 11 37
FreeBSD on EC2 FreeBSD (https://www.freebsd.org) is a robust Unix-like operating system that has been around for many years. FreeBSD is available on Amazon EC2 through Amazon Machine Images (AMIs) provided by FreeBSD developer and security office…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question