vmstat- virtual memory statistics

vmstat reports information about processes, memory, paging, block IO, traps, and cpu activity.
The first report produced gives averages since the last reboot. Addi-tional reports give information on a sampling period of length delay.The process and memory reports are instantaneous in either case.
vmstat - Report virtual memory statistics
SYNOPSIS
vmstat [-a] […]

Veritas Cluster Fundamentals and Commands

VERITAS CLUSTER FUNDAMENTALS

Cluster Definition
Cluster Setup
VCS and Its Advantages
Disadvantages of VCS
Hardware Setup and Requirments
VCS Communication
GAB
LLT
I/O Fencing
HAD
Sample DataCenter Setup
Oracle Service Group
VCS AGENT
Veritas Cluster Commands

sed command to find and replace text in files

[root@tritya root]# cat /tmp/testfile.conf
gernel.sysrq = 0
gernel.core_uses_pid = 1
gernel.shmall = 2097152
gernel.shmmax = 536870912
gernel.shmmni = 4096
gernel.sem = 250 32000 100 128
Example : Find and Replace the text “gernel.’ to “kernel.” in the above file /tmp/testfile.conf

Oracle 10g required Kernel Parameters and settings for Linux

Oracle Database 10g Release 2 (in Linux) requires the kernel parameter settings shown below. The values given are minimums, so if your system uses a larger value, don’t change it.
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.wmem_default=262144
net.core.rmem_max=262144
net.core.wmem_max=262144

Oracle 10g Database Creation Steps

DATABASE CREATION STEPS in Linux: After Performing the oracle software only Installation.The below are the steps for creating a database .
Password file creation
======================
[oracle@Nalanta dbs]$ orapwd file=orapwtritya password=specialone entries=5
Directory creations
===================

[oracle@Nalanta dbs]$ mkdir -p /usr1/oracle/oradata/controlfiles/
[oracle@Nalanta dbs]$ mkdir -p /usr1/oracle/oradata/datafiles/
[oracle@Nalanta dbs]$ mkdir -p /usr1/oracle/oradata/logfiles/
[oracle@Nalanta dbs]$ mkdir -p /usr1/oracle/oradata/admin/{bdump,cdump,udump}

TYPES OF CONTROL FILE BACKUP

Method 1:
SQL> alter database backup controlfile to trace;
Database altered.
The above command backup the Controlfile in a human readable format in USER_DUMP_ DEST location

Monitoring Locks in oracle

Monitoring Locks in oracle
===================
Using catblock.sql Located in
$ORACLE_HOME/rdbms/admin will create the following useful views for monitoring locks in the database.

Creating soft link

softlink – symbolic link
symboliclink links are used for shortcuts.
Command : ln -s
Example : create a shortcut to backup location in a users home directory.
[oracle@tritya oracle]$ echo $HOME

Monitoring swap space in linux / solaris

Monitoring swap space in linux /solaris

In LINUX Free command displays the total amount of free and used physical memory and swap space in the
system, as well as the buffers and cache consumed by the kernel.

[oracle@tritya oracle]$ free

ls command to show hidden files and hidden characters in file name

LS command to show hidden
files and hidden characters in a file
ls -a command shows hidden files
ex : ls -a
[oracle@tritya TEST]$ ls -al