Saturday, December 27, 2008

Installing Oracle10g on Linux RHELAS3

Simply, the first DL first oracle10g for linux from the site in oraclenya
http://otn.oracle.com/software/products/database/oracle10g/index.html
file -> ship.db.lnx32.cpio.gz
gunzip ship.db.lnx32.cpio.gz
* Unpack the files ship.db.lnx32_10103.cpio
-> # Cd / app
# Cpio-idmv -> # Cd / app
# Cpio-idmv </ mnt/cdrom/ship.db.lnx32_10103.cpio
examination and memory swap
# Grep MemTotal / proc / meminfo
# Grep SwapTotal / proc / meminfo
if the swap is less than 1 ghz
# Dd if = / def / zero of = tmpswap bs = 1k count = 700000
# Chmod 600 tmpswap
# Mkswap tmpswap
# Swapon tmpswap
inspection capacity directory / tmp
# Df / tmp 


update the kernel parameters
# / Etc / sysctl.conf
-> # Kernel Parameters for oracle 10.1.0 #
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
after run # sysctl-p
set the limit and the maximum file
# / Etc / security / limits.conf
-> # To increase the shell limits for oracle 10.1.0 #
* Soft nproc 2047
* Hard nproc 16384
* Soft nofile 4096
* Hard nofile 63536
# / Etc / profile
-> If [$ USER = "oracle"]; then
if [$ SHELL = "/ bin / ksh"]; then
ulimit-p 16384
ulimit-n 63536
else
ulimit-u 16384-n 63536
fi
fi
export ORACLE_BASE = / app / oracle;
export ORACLE_HOME = $ ORACLE_BASE/product/10.0.1;
export ORACLE_SID = ora10g;
after saving a command # source / etc / profile
create a group, user, and the directory
# Mkdir-p / app/oracle/product/10.0.1
# Mkdir-p / var / app / oracle
(# Groupadd DBA have access SYSDBA)
# Groupadd oinstall software owner ()
# Useradd-c "Oracle Software Owner"-g-G oinstall oracle DBA-d / app / oracle
owner and directory access rights
# Chown-R oracle: oinstall / app / oracle
# Chown oracle: DBA / var / app / oracle
# Chmod 755 / app / oracle
# Chmod 755 / var / app / oracle
INSTALLATION
from the root terminal
# Xhost +
from another terminal
# Su - oracle
$ Cd / app/Disk1
$. / RunInstaller
at the time of the installation process you are prompted to run the file
/ app / oracle / oraInventory / orainstRoot.sh
through user root
from the root terminal
# Cd / app / oracle / oraInventory
#. / OrainstRoot.sh
after the installation process is complete, click the OK button before .. run file root.sh
through user root
from the root terminal
# Cd / app/oracle/product/10.1.0
#. / Root.sh
Until this process is complete installation oracle10g.
nb: When Linux restart the oracle does not run automatically, we must
create automation scripts to run the database and the oracle
enterprise manager from the root terminal
# configuration change listener
# vi / app/oracle/product/10.1.0/network/admin/listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = / app/oracle/product/10.1.0)
(PROGRAM = extproc)
)
)
with
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = / app/oracle/product/10.1.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ora10g)
(ORACLE_HOME = / app/oracle/product/10.1.0)
(SID_NAME = ora10g)
)
)
edit the settings in / etc / oratab file with the "Y":
# Vi / etc / oratab
ora10g: / u01/app/oracle/product/10.1.0: Y
Create a script in the / etc / init.d / dbora
# Vi / etc / init.d / dbora
:
#! bin / sh
# chkconfig: - 20 80
# description: Oracle Autostart script
#
# coding gugun by virtuous
#
# ORA_HOME set to be equivalent to the $ ORACLE_HOME
# from which you execute dbstart
# / etc / init.d / dbora
ORACLE_HOME = / app/oracle/product/10.1.0;
ORACLE_OWNER = oracle;
# Start oracle database
su - $ ORACLE_OWNER-c $ ORACLE_HOME / bin / dbstart
su - $ ORACLE_OWNER-c $ ORACLE_HOME / bin / lsnrctl start
# To run the oracle enterprise manager control
su - $ ORACLE_OWNER $ ORACLE_HOME / bin / emctl start dbconsole
------ ----- EOF
change permissions on / etc / init.d / dbora
# Chmod 755 / etc / init.d / dbora
edit the file / app/oracle/product/10.1.0/bin/dbstart
# Vi / app/oracle/product/10.1.0/bin/dbstart
ORATAB = / app / opt / oracle / oratab
with
ORATAB = / etc / oratab
edit / add / etc / rc.local
# Vi / etc / rc.local
/ etc / init.d / dbora
================================================== =========
notes: the script is based on experiments that have been done by the author
and running well, the script is made for easier and
must
================================================== =========
By
Gugun Gunawan
Learn More... OCP: Oracle Database 11g Administrator Certified Professional Certification Kit: (1Z0-051, 1Z0-052, and 1Z0-053)

Reference:
Administration Oracle 10g, Evara Samsyiar
InfoLinux 02/2005 and 03/2005 (the installation of oracle 9i on RH9)
http://www.oracle.com/technology/pub/articles/smiley_10gdb_install.html
Oracle Database Concepts: http://dba.ipbhost.com/lofiversion/index.php/t879.html
Source: http://www.yogyafree.net/magazine.htm, http://www.yogyafree.net/forum2

No comments:

Post a Comment

Template Designed by Mastemplate