Comments

Oracle Database 10g (10.1.0.2) Installation On Red Hat Enterprise Linux 4 (RHEL4) - A brief guide to installing Oracle 10g (10.1.0.2) on Red Hat Enterprise Linux 4 (RHEL4).

Gustavo Lucas said...

for startup/shutdown, DB oracle, EM and isqlplus
change the dbora script to:

#!/bin/sh
# description: Oracle auto start-stop script.
# chkconfig: - 20 80
#
# Set ORA_HOME to be equivalent to the $ORACLE_HOME
# from which you wish to execute dbstart and dbshut;
#
# Set ORA_OWNER to the user id of the owner of the
# Oracle database in ORA_HOME.
ORA_HOME=/u01/app/oracle/product/10.1.0/db_1
ORA_OWNER=oracle
if [ ! -f $ORA_HOME/bin/dbstart ]
then
echo "Oracle startup: cannot start"
exit
fi
case "$1" in
'start')
# Start the Oracle databases:
# The following command assumes that the oracle login
# will not prompt the user for any values
su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start"
su - $ORA_OWNER -c "$ORA_HOME/bin/emctl start dbconsole"
su - $ORA_OWNER -c "$ORA_HOME/bin/isqlplusctl start"
su - $ORA_OWNER -c $ORA_HOME/bin/dbstart
;;
'stop')
# Stop the Oracle databases:
# The following command assumes that the oracle login
# will not prompt the user for any values
su - $ORA_OWNER -c $ORA_HOME/bin/dbshut
su - $ORA_OWNER -c "$ORA_HOME/bin/isqlplusctl stop"
su - $ORA_OWNER -c "$ORA_HOME/bin/emctl stop dbconsole"
su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl stop"
;;
esac

Shanker Jadapa said...

I was working on Cent-os 4, this document did not cover the following parameters.

net.core.rmem_default=262144
net.core.wmem_default=262144
net.core.rmem_max=262144
net.core.wmem_max=262144

Jr DBA said...

I am working on RHEL 4 ,
Oracle gave me these pre-requisties warning messages that are missing /etc/sysctl.conf

"checking kernel parameters
checking for rmem_default=262144; found rmem_default=110592
checking for rmem_max=262144;found rmem_max=131071
checking for wmem_default=262144;found wmem_default=110592
checking for wmem_max=262144;found wmem_max=131071"

Any specific reason for not adding above kernel parameters??

Tim... said...

Hi.

When I wrote the article, setting these parameters was not required. If you are using a later spin of the software, then the requirements may have changed.

Note: In the RAC article for this version, these parameters are required so they are included. See:

http://www.oracle-base.com/articles/10g/OracleDB10gR2RACInstallationOnCentos4UsingVMware.php#oracle_installation_prerequisites

If you are actually doing in a RAC installation, then I would suggest you follow that article. If not, they must be a new requirement with a later version of the installer.

Cheers

Tim...

Mario said...

ORA-27125: simply authorize the oracle gropu to access huge shm memory, for kernels newer than 2.6.7:

echo "" > /proc/sys/vm/hugetlb_shm_group

where is the gid of group oinstall (usually 500).

Regards, Mario

DO NOT ask technical questions here, that's what my forum is for!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

Add your comments here.
Name
Comment (max 400 chars - plain text)