vincent's Blog

############ check sofware packages

binutils-2.15.92.0.2-10.EL4
compat-db-4.1.25-9
control-center-2.8.0-12
gcc-3.4.3-9.EL4
gcc-c++-3.4.3-9.EL4
glibc-2.3.4-2
glibc-common-2.3.4-2
gnome-libs-1.4.1.2.90-44.1
libstdc++-3.4.3-9.EL4
libstdc++-devel-3.4.3-9.EL4
make-3.80-5
pdksh-5.2.14-30
sysstat-5.0.5-1
xscreensaver-4.18-5.rhel4.2


rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' \
binutils compat-db control-center gcc gcc-c++ glibc glibc-common gnome-libs \
libstdc++ libstdc++-devel make pdksh sysstat xscreensaver libaio

####### kernal parameter
vi /etc/sysctl.conf

kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem=250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range=1024 65000
net.core.rmem_max = 1048576
net.core.rmem_default = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144

/sbin/sysctl -p

#### create user

groupadd dba
groupadd oinstall
useradd -g oinstall -G dba -d /oracle oracle
passwd oracle

chown -R oracle.oinstall /oracle
##############
vi /etc/security/limits.conf

* soft nproc 2047
* hade nproc 16384
* soft nofile 1024
* hade nofile 65536

vi /etc/pam.d/login

session required /lib/security/pam_limits.so
session required pam_limits.so

vi /etc/profile
if [ $USER = "oracle" ];then
if [ $SHELL = "/bin/bash" ];then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi

vi /oracle/.bash_profile

umask 022
export ORACLE_BASE=/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2
export ORACLE_SID=ora10g
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib

source ./.bash_profile


######### install ASM
rpm -Uvh oracleasm-support-2.0.3-1.i386.rpm
rpm -Uvh oracleasm-2.6.9-11.EL-2.0.3-1.i686.rpm
rpm -Uvh oracleasmlib-2.0.2-1.i386.rpm
rpm -Uvh oracleasm-2.6.9-11.ELsmp-2.0.3-1.i686.rpm


########## config ASM
/etc/rc.d/init.d/oracleasm configure



Default user to own the driver interface []: oracle
Default group to own the driver interface []: dba
Start Oracle ASM library driver on boot (y/n) [n]: y
Fix permissions of Oracle ASM disks on boot (y/n) [y]: y



#### create ASM disk

/etc/rc.d/init.d/oracleasm createdisk VL01 /dev/hda10
Marking disk "/dev/hda10" as an ASM disk: [ OK ]
/etc/rc.d/init.d/oracleasm scandisks
Scanning system for ASM disks: [ OK ]
/etc/rc.d/init.d/oracleasm listdisks
VL01

################## install oracle
unzip 10201_database_linux32.zip
cd /database

./runInstaller





############ ASM managment

ORACLE_SID=+ASM
export $ORACLE_SID
asmcmd
ASMCMD> help
asmcmd [-p] [command]

The environment variables ORACLE_HOME and ORACLE_SID determine the
instance to which the program connects, and ASMCMD establishes a
bequeath connection to it, in the same manner as a SQLPLUS / AS
SYSDBA. The user must be a member of the SYSDBA group.

Specifying the -p option allows the current directory to be displayed
in the command prompt, like so:

ASMCMD [+DATAFILE/ORCL/CONTROLFILE] >

[command] specifies one of the following commands, along with its
parameters.

Type "help [command]" to get help on a specific ASMCMD command.

commands:
--------
cd
du
find
help
ls
lsct
lsdg
mkalias
mkdir
pwd
rm
rmalias
ASMCMD>



#### db console
emctl start console


http://x.x.x.x:1158/em