Red Hat LINUX ADVANCED SERVER 2.1 - Informations techniques télécharger pdf (Page 16)

Tips and Techniques: Install and Configure Oracle9i on Red Hat Linux

Advanced Server

hostname resolution might fail, which could potentially result in loss of Oracle

sqlnet connection.

The solution is to increase the number of attempts and timeout to 5 and 15 Sec

respectively, in the network configuration. The following lines are added to

/etc/resolv.conf:

options attempts:5

options timeout:15

MONITORING

For fine-tuning database parameters in init.ora, it is essential to monitor the kernel

parameters periodically. The data monitored are the vital statistics of the system and

need to be collected at different points of operation, ranging from medium to peak

loads. Monitoring and tuning of system and database parameters go hand in hand.

Listed below are some of the data points that could be monitored and tools that

could effectively help in collecting the same.

To monitor memory, /proc/meminfo and /proc/slabinfo information could be

collected. These two would give a complete picture of memory.

Other interesting stat to monitor is network information. /proc/net/dev,

/proc/net/snmp, /proc/net/softnet_stat data is collected for that purpose. Users

could use the tool “

netstat

”.

Also utilities like

vmstat

for reporting virtual memory information,

sar

for

measuring system activity information,

iostat

for measuring io and cpu stats for

devices and partitions and

top

for measuring top cpu processes are available.

DEBUGGING AND TRACING

Debugging and tracing facilities are very critical in the case of crash or hang of a

system, during database install time or at runtime. By looking at trace or logs,

problem could be easily analyzed and resolved. It is highly advisable to have the

following parameter always set, to help in debugging.

echo 1 > /proc/sys/kernel/sysrq

Tips and Techniques: Install and Configure Oracle9i on Red Hat Linux Advanced Server Page 16

1 2 ... 11 12 13 14 15 16 17 18 19 20

Pas de commentaire

Red Hat LINUX ADVANCED SERVER 2.1 - Informations techniques Page 16