Oracle 10gR2 + RedHat Enterprise Linux AS4 install

Jul 30 posted in Oracle (RSS), 420 views.

Toss in 2 days, finally the problems encountered have been resolved .... The following is my installation summary wrote it myself, a little chaotic, makeshift look at the

(1) installation of linux, run by service is not choice, but choose to install the development tools, do not install a firewall, or some will be prompted to connect the port did not open out.
(2) Open the terminal, execute the following command, check the installation package, do not have to be installed (usually in the dis2 and dis3 I)
rpm-q make gcc glibc compat-db compat-gcc compat-gcc-c + + compat-libstdc + + compat-libstdc + +-devel openmotif21 setarch libaio
(3) Create Oracle group and user accounts such as:
# / Usr / sbin / groupadd oinstall
# / Usr / sbin / groupadd dba
# / Usr / sbin / useradd-m-g oinstall-G dba oracle
# Id oracle
uid = 501 (oracle) gid = 501 (oinstall) groups = 501 (oinstall), 502 (dba)
Set oracle account password:
passwd oracle
(4) create a directory such as:
# Mkdir-p / u01/app/oracle
# Chown-R oracle: oinstall / u01/app/oracle
# Chmod-R 775 / u01/app/oracle

(5) configuration Linux kernel parameters (two kinds of method), modified without re-start the update: / sbin / sysctl-p
The first: Open the / etc / sysctl.conf copy the following
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_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_max = 262144

Second: Open a terminal
cat>> / etc / sysctl.conf <<EOF
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_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_max = 262144
EOF

(6) oracle user settings Shell restricted. Oracle recommends Linux accounts for each of the process can be used to open the file number and the number of set limits, ROOT login. (Paragraph (6) steps can be skipped.)
cat>> / etc / profile <<EOF
if [\ $ USER = "oracle"]; then
if [\ $ SHELL = "/ bin / ksh"]; then
ulimit-p 16384
ulimit-n 65536
else
ulimit-u 16384-n 65536
fi
umask 022
fi
EOF

cat>> / etc / csh.login <<EOF
if (\ $ USER == "oracle") then
limit maxproc 16384
limit descriptors 65536
umask 022
endif
EOF

(7) oracle user's environment variable to oracle logged in and through. Bash_profile or. Profile (bash or ksh), add the following lines will be added to the registry configuration file ORACLE_BASE (direct gedit / home / oracle / .bash_profile)
Add the following content:

export ORACLE_BASE = / u01/app/oracle
export ORACLE_HOME = $ ORACLE_BASE/10.2.0/db_1
export ORACLE_SID = dssdb
export PATH = $ PATH: $ ORACLE_HOME / bin

(8) Extract oracle 10g installation disk, and then the new terminal, run / runInstaller (note capitalization)
(9) to create an instance, start the database
(10) to follow the linux with oracle startup.

root log on, in the / etc / rc.d / init.d to create named dbora, editor add the following

=================================================

#! / bin / bash
# Reference http://staff.in2.hr/denis/oracle/10g1install_fedora3_en.html # n4_4
# Chkconfig: 35 95 1
# Description: init script to start / stop oracle database 10g, TNS listener, EMS
#
#
# Match these values to your environment:
export ORACLE_BASE = / u01/app/oracle
export ORACLE_HOME = $ ORACLE_BASE/10.2.0/db_1
export ORACLE_SID = dssdb
export PATH = / home / oracle / bin: $ ORACLE_HOME / bin: $ PATH
export ORACLE_USER = oracle

# See how we are called:
case $ 1 in
start)
su - "$ ORACLE_USER" <<EOO
dbstart
EOS
emctl start dbconsole
EOO
;;

stop)
su - "$ ORACLE_USER" <<EOO
dbshut
EOS
emctl stop dbconsole
EOO
;;

*)
echo "Usage: $ 0 (start | stop)"
;;
esac

==========================

Open the terminal run:
chown oracle.oinstall / etc / rc.d / init.d / dbora
chmod 755 / etc / rc.d / init.d / dbora

Use chkconfig to set permissions to run
chkconfig dbora reset

Check
chkconfig - list dbora
The results are as follows:
ora10 0: off 1: off 2: off 3: on 4: off 5: on 6: off

Note: When the system is not in runlevels 3 and 5, the use of

service dbora start start the service.
service dbora stop stop the service.

(11) modify the $ ORACLE_HOME / bin / dbstart

# Set this to bring up Oracle Net Listener
ORACLE_HOME_LISTNER = $ ORACLE_HOME

If there are no ASM (automatic storage), put the contents of the section removed, ASM instance should be loaded before loading.

(12) Restart your computer, you can, and start will be relatively slow due to the auto-start em, database, listener, agent

Common manual control database command to open the em
emctl start dbconsole
Close em
emctl stop dbconsole

Start listener
lsnrctl start <monitor name "(default is LISTENER, can be omitted)
Close
lsnrctl stop

Start emagent
emctl start agent
Close
emctl stop agent

Start an instance of
sqlplus / nolog
conn / as sysdba
startup
Close
shutdown immediate

Pass test database is

tnsping

================================================== ===
Frequently Asked Questions:

Web interface buttons appear on the "mouth" of the garbled

Solution:
1. Stop the service, emctl stop dbconsole;
2. To the relevant directory (RHEL4 which is the / etc / java /) under the font.properties with font.properties.zh_CN.Redhat8.0 replace (or font.properties.zh, as long as you can Simplified Chinese.);

3. Remove the $ ORACLE_HOME/oc4j/j2ee/oc4j_applications/applications/em/em/cabo/images/cache/zhs in gif files;

4. Re-play services (preferably to restart the server) emctl start dbconsole;

================================================== ===
The following J2EE applications has been configured, and can be used to access the URL listed below.

iSQL * Plus URL:
http://database:5560/isqlplus

iSQL * Plus DBA URL:
http://database:5560/isqlplus/dba

Enterprise Manager 10g Database Control URL:
http://database:1158/em

\ ==========================================

Useful linux commands
df-h
ps-A
top
free
cat / proc / meminfo
uname
grep MemTotal / proc / meminfo
grep SwapTotal / proc / meminfo
hostname