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

1 comment:

  1. Do you need to increase your credit score?
    Do you intend to upgrade your school grade?
    Do you want to hack your cheating spouse Email, whatsapp, Facebook, instagram or any social network?
    Do you need any information concerning any database.
    Do you need to retrieve deleted files?
    Do you need to clear your criminal records or DMV?
    Do you want to remove any site or link from any blog?
    you should contact this hacker, he is reliable and good at the hack jobs..
    contact : cybergoldenhacker at gmail dot com

    ReplyDelete