install oracle 11g – 64 bit (1)

16 Feb

1. create user, password, profile
# groupadd oinstall
# groupadd dba
# groupadd oper
# groupadd asmadmin
# useradd -u 500 -g oinstall -G dba,oper,asmadmin oracle
# mkdir -p /u01/app/oracle/product/11.1.0/db_1
# chown -R oracle:oinstall /u01

# vi /home/oracle/.bash_profile

# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH

# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=test.localdomain; export ORACLE_HOSTNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1; export ORACLE_HOME
ORACLE_SID=test; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
if [ $USER = “oracle” ]; then
if [ $SHELL = “/bin/ksh” ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi

# chown oracle.oinstall /home/oracle/.bash_profile
# passwd oracle

2. edit /etc/sysctl.conf
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=4194304
net.core.wmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_max=262144

# sysctl -p
3. edit /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

4. edit /etc/pam.d/login
session required /lib/security/pam_limits.so

5. edit /etc/hosts
# vi /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
172.20.33.33 test test.localdomain

6. install rpm
# rpm -Uvh elfutils-0.125-3.el5.i386.rpm
# rpm -Uvh elfutils-devel-0.125-3.el5.i386.rpm
# rpm -Uvh elfutils-devel-static-0.125-3.el5.i386.rpm
# rpm -Uvh elfutils-libelf-0.125-3.el5.i386.rpm
# rpm -Uvh elfutils-libelf-devel-0.125-3.el5.i386.rpm
# rpm -Uvh elfutils-libelf-devel-static-0.125-3.el5.i386.rpm
# rpm -Uvh elfutils-libs-0.125-3.el5.i386.rpm
# rpm -Uvh libaio-0.3.106-3.2.i386.rpm
# rpm -Uvh libaio-devel-0.3.106-3.2.i386.rpm
# rpm -Uvh libao-0.8.6-5.i386.rpm
# rpm -Uvh libao-devel-0.8.6-5.i386.rpm
# rpm -Uvh sysstat-7.0.0-3.el5.i386.rpm
# rpm -Uvh unixODBC-2.2.11-7.1.i386.rpm
# rpm -Uvh unixODBC-devel-2.2.11-7.1.i386.rpm

7. download & unzip
# unzip linux.x64_11gR1_database.zip

8. login oracle
$ ./runInstaller

# /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory to 770.
Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete

# /u01/app/oracle/product/11.1.0/db_1/root.sh
Running Oracle 11g root.sh script…
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/11.1.0/db_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:
Copying dbhome to /usr/local/bin …
Copying oraenv to /usr/local/bin …
Copying coraenv to /usr/local/bin …

Creating /etc/oratab file…
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
Finished product-specific root actions.

9.  OEM
Enterprise Manager Database Control URL – (test) :
https://test.localdomain:1158/em

2 Responses to “install oracle 11g – 64 bit (1)”

  1. subekti February 22, 2009 at 4:10 am #

    pak, /lib sudah dimasukan, tetapi kelihatannya /lib64 belum dimasukan. kira-kira pengaruh gak ya…he..he…?

    • setijoagus February 23, 2009 at 12:42 am #

      selama ini nggak ngaruh tuh….
      mungkin Pak Bekti pny pengalaman lain ??

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: