Oracle Linux 5.8 Installs Oracle 10.2.0.5 x64

First, the normal way to install a new 1. Oracle Installation Environment Ready

Use OEL5.8 x64 installation, installation process, choose Anti-Custom selected GUI, development package, development library, old software development package, etc., must install, or in the installation of the database process reported missing packet errors, the database installation can not go on.
For the unknown environment does not install the development package and development of the system, can be installed in the following ways, the most complete.
This article originates from: http://koumm.blog.51cto.com
# yum Groupinstall ' development Tools '
# yum Groupinstall ' development Libraries '

(1) Confirm that the following packages are installed

# rpm-q--QF '%{name}-%{version}-%{release} (%{arch}) \ n ' binutils compat-libstdc++-33 compat-gcc-34-c++ Elfutils-libelf elfutils-libelf-devel elfutils-libelf-devel-static gcc gcc-c++ glibc glibc-common glibc-devel Glibc-headers kernel-headers ksh libaio libaio-devel libgcc libgomp libstdc++ libstdc++-devel make Sysstat UnixODBC UnixOD Bc-devel openmotif22 openmotif compat-db setarch libxp

Binutils-2.17.50.0.6-20.el5 (x86_64)
Compat-libstdc++-33-3.2.3-61 (x86_64)
Compat-libstdc++-33-3.2.3-61 (i386)
compat-gcc-34-c++-3.4.6-4.1 (x86_64)
Elfutils-libelf-0.137-3.el5 (x86_64)
Elfutils-libelf-0.137-3.el5 (i386)
Elfutils-libelf-devel-0.137-3.el5 (x86_64)
Elfutils-libelf-devel-static-0.137-3.el5 (x86_64)
Gcc-4.1.2-52.el5 (x86_64)
Gcc-c++-4.1.2-52.el5 (x86_64)
glibc-2.5-81 (x86_64)
glibc-2.5-81 (i686)
glibc-common-2.5-81 (x86_64)
glibc-devel-2.5-81 (x86_64)
Glibc-devel-2.5-81 (i386)
glibc-headers-2.5-81 (x86_64)
Kernel-headers-2.6.18-308.el5 (x86_64)
Ksh-20100621-5.el5 (x86_64)
Libaio-0.3.106-5 (x86_64)
Libaio-0.3.106-5 (i386)
Package libaio-devel are not installed
Libgcc-4.1.2-52.el5 (x86_64)
Libgcc-4.1.2-52.el5 (i386)
libgomp-4.4.6-3.el5.1 (x86_64)
libgomp-4.4.6-3.el5.1 (i386)
Libstdc++-4.1.2-52.el5 (x86_64)
Libstdc++-4.1.2-52.el5 (i386)
Libstdc++-devel-4.1.2-52.el5 (x86_64)
Make-3.81-3.el5 (x86_64)
Package Sysstat are not installed
Package UnixODBC are not installed
Package unixodbc-devel are not installed
Package openmotif22 are not installed
Package openmotif are not installed
Package compat-db are not installed
setarch-2.0-1.1 (x86_64)
Package LIBXP are not installed

# mount an ISO file or CD

# mount/dev/cdrom/mnt
# Cd/mnt/server

#采用OEL5.8 X64 Installation

RPM-IVH compat-db-4.2.52-5.1.i386.rpm compat-db-4.2.52-5.1.x86_64.rpm
RPM-IVH libaio-devel-0.3.106-5.x86_64.rpm libaio-devel-0.3.106-5.i386.rpm
RPM-IVH sysstat-7.0.2-11.el5.x86_64.rpm numactl-devel-0.9.8-12.0.1.el5_6.x86_64.rpm
RPM-IVH unixodbc-2.2.11-10.el5.x86_64.rpm unixodbc-devel-2.2.11-10.el5.x86_64.rpm unixODBC-libs-2.2.11-10.el5.x86 _64.rpm
RPM-IVH unixodbc-2.2.11-10.el5.i386.rpm unixodbc-devel-2.2.11-10.el5.i386.rpm unixodbc-libs-2.2.11-10.el5.i386.rpm
RPM-IVH libxp-1.0.0-8.1.el5.i386.rpm libxp-1.0.0-8.1.el5.x86_64.rpm
RPM-IVH openmotif22-2.2.3-20.x86_64.rpm openmotif-2.3.1-6.el5.x86_64.rpm

#采用OEL5. X64 Installation

RPM-IVH compat-db-4.2.52-5.1.i386.rpm compat-db-4.2.52-5.1.x86_64.rpm
RPM-IVH libaio-devel-0.3.106-5.x86_64.rpm libaio-devel-0.3.106-5.i386.rpm
RPM-IVH sysstat-7.0.2-12.0.1.el5.x86_64.rpm numactl-devel-0.9.8-12.0.3.el5_6.x86_64.rpm
RPM-IVH unixodbc-2.2.11-10.el5.x86_64.rpm unixodbc-devel-2.2.11-10.el5.x86_64.rpm unixODBC-libs-2.2.11-10.el5.x86 _64.rpm
RPM-IVH unixodbc-2.2.11-10.el5.i386.rpm unixodbc-devel-2.2.11-10.el5.i386.rpm unixodbc-libs-2.2.11-10.el5.i386.rpm
RPM-IVH libxp-1.0.0-8.1.el5.i386.rpm libxp-1.0.0-8.1.el5.x86_64.rpm
RPM-IVH RPM-IVH openmotif22-2.2.3-20.x86_64.rpm openmotif-2.3.1-7.2.el5.x86_64.rpm

(2) Replace Sqlplus tool

# wget http://utopia.knoware.nl/~hlub/uck/rlwrap/rlwrap-0.37.tar.gz
# tar ZXVF rlwrap-0.37.tar.gz
# CD rlwrap-0.37
#./configure
# Make && make install

Note: If installing Rlwrap will prompt this error message, this example will not appear as follows.
You need the GNU ReadLine Library (ftp://ftp.gnu.org/gnu/readline/) to build
This program!

This time, you need to install
libtermcap-devel-2.0.8-46.1.i386.rpm
readline-devel-5.1-3.el5.i386.rpm

2. Create a user account

Create OINSTALL,DBA groups and Oracle users.

The commands for creating user groups and users are as follows (as root):

Groupadd Oinstall
Groupadd dba
USERADD-G oinstall-g dba Oracle
passwd Oracle

Mkdir-p/u01/app/oracle/product/10.2.0/db_1
Chmod-r 775/u01/app
Chown-r oracle:oinstall/u01

3. Modify Kernel Support

# vi/etc/sysctl.conf

Kernel.shmall = 2097152
Kernel.shmmax = 2147483648
Kernel.shmmni = 4096
Kernel.sem = 250 32000 100 128
Fs.file-max = 359670
Net.ipv4.ip_local_port_range = 9000 65500
Net.core.rmem_default = 1048576
Net.core.rmem_max = 1048576
Net.core.wmem_default = 262144
Net.core.wmem_max = 262144

# sysctl-p

Kernel parameter Configuration Description:
Kernel.shmall = 2097152 # The total number of shared memory pages that the system can use, the default is 2097152.
Kernel.shmmax = 2147483648 # The maximum value of a single shared memory segment, in bytes, this example is 2GB.
Kernel.shmmni = 4096 # maximum default number of shared memory segments

# maximum shared memory space = Kernel.shmall * Kernel.shmmni = 2097152*4k = 8G
# This allows you to calculate the maximum shared memory space of the operating system and is determined by the above two parameters, such as a system with shared memory of 16G, 16g/kernel.shmmni (4K) = Kernel.shmall need to increase kernel.shmall
# because Shmmax This example is 2G size, when allocating shared memory segments will be allocated multiple, such as 2g+2g+2g, such as allocation, no more than the maximum shared memory space, it is recommended to allocate less than the maximum value of shared memory, you can avoid excessive creation of shared memory segments.
# for Oracle database, the SGA is the use of shared memory segment space, the size of the SGA is less than the maximum shared memory space, otherwise will be reported ora-27102:out of memory, then need to see whether the above parameters are reasonable.

4. modifying file descriptors

Cat >>/etc/security/limits.conf << EOF
Oracle Soft Nproc 2047
Oracle Hard Nproc 16384
Oracle Soft Nofile 1024
Oracle Hard Nofile 65536
Eof

5. Modify Login Authentication Module

Cat >>/etc/pam.d/login << EOF
Session required/lib64/security/pam_limits.so
Eof

6. Modify the local Hosts file

# vi/etc/hosts
192.168.14.180 Node1

7. Modify the Oracle User environment variable (1) To configure the system environment variable to add to the last.

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
Fi
Eof

(2) Configuring Oracle Environment variables

# su-oracle

Cat >>/home/oracle/.bash_profile << EOF
Export Editor=vi
Export Oracle_base=/u01/app/oracle
Export oracle_home=\ $ORACLE _base/product/10.2.0/db_1
Export ORACLE_SID=ORCL
Export path=\ $ORACLE _home/bin:\ $PATH
Export nls_lang= "simplified Chinese_china. ZHS16GBK "
Export Lang=en_us
Export Lc_all=en_us
Export Ld_library_path=/lib:/usr/lib:\ $ORACLE _home/lib
Alias sqlplus= "Rlwrap Sqlplus"
Alias rman= "Rlwrap Rman"
Umask 022
Eof
source. bash_profile

8. Copying Oracle into a Linux system

# MV 10201_database_linux_x86_64.cpio.gz/u01/app/
# MV p8202632_10205_linux-x86-64.zip/u01/app/

# Gunzip 10201_database_linux_x86_64.cpio.gz
# CPIO-IDMV < 10201_database_linux_x86_64.cpio
# Unzip P8202632_10205_linux-x86-64.zip

# Oracle installation package extracted under/u01/app/database
# Oracle Patch Package decompression under/u01/app/disk1

# Chown-r Oracle:oinstall/u01/app/database

9. Oracle10 installation (1) installation of VNC service mode

# for the server in the remote room in the case of the installation, previously ran Vncserver, configured password.
# Vi/root/.vnc/xstartup
#!/bin/sh

# Uncomment the following-lines for normal desktop:
Unset Session_manager
Exec/etc/x11/xinit/xinitrc

[-x/etc/vnc/xstartup] && Exec/etc/vnc/xstartup
[-R $HOME/. Xresources] && Xrdb $HOME/. Xresources
Xsetroot-solid Grey
Vncconfig-iconic &
Xterm-geometry 80x24+10+10-ls-title "$VNCDESKTOP Desktop" &
Gnome-session &

or directly cancel the above unset as well as the comments with exec.

# vncserver:1
# vncserver-kill:1 off Desktop number: 1

(2) VNC Client connection begins installation of Oracle database software

# Xhost +
Access control disabled, clients can connect from any host

$ su-oracle
$ cd/u01/oracle/database
$./runinstaller

# Redhat AS5 under Installation, the OS version check can be ignored in the following way.

$./runinstaller-ignoresysprereqs

Finally, the following two scripts are executed at root

/u01/app/oracle/orainventory/orainstroot.sh
/u01/app/oracle/product/10.2.0/db_1/root.sh

(3) Install 10.2.0.5 Patch Pack

$ cd/u01/app/disk1
$./runinstaller

The following script is executed during installation to prompt root
/u01/app/oracle/product/10.2.0/db_1/root.sh

10. Start the Monitoring service

$ netca
# parameters are all by default

11. Create a Database

$ dbca

# for database creation, here are some considerations
# Select Gernel purpose, in SID and global name, select the SID you created in. Bash_profile.
# Select ZHS16GBK in the database character set option, the session connection number is larger, the redolog is larger. Other default OK, complete.

Oracle's start-up service configuration

#开机自启动采用rc. Local startup, not configured as a service, shutting down the database or doing it manually.

$ vi/etc/oratab
#把最后的N改成Y (default is N)
Orcl:/u01/app/oracle/product/10.2.0/db_1:y

# sed-i ' s/:n/:y/g '/etc/oratab

Cat >>/etc/rc.local << EOF
# Oracle Service Start
Su-oracle-c "Lsnrctl Start"
Su-oracle-c "Dbstart"
Eof

13. Apply EM patch

Problem solved after Oracle patching EM does not start
Oracle 10.2.0.4 (5) because a certificate expires, the EM cannot be started after 2011.1.1 days, the solution is to apply patches p8350262_10204_generic.zip or P8350262_10205_generic.zip

$ emctl Stop Dbconsole
$ unzip P8350262_10204_generic.zip
$ CD 8350262
$/u01/app/oracle/product/10.2.0/db_1/opatch/opatch Apply

After testing, for the newly installed Oracle 10g database, you must first hit the above patch, then remove EM, and then rebuild EM. EM will start normally.

Second, re-configure EM

Note: This must be done in the following order.

(1) Install the Chinese font.

# RPM-IVH ttfonts-zh_cn-2.14-6.noarch.rpm

(2) Reconfigure EM

The following two commands are commonly used to perform fast when the system is idle:

$ emca-deconfig dbcontrol db-repos Drop Delete the database control and delete the EM repository at the same time
$ emca-config Dbcontrol db-repos Create an EM repository and simultaneously prepare the database Control

(3) Login and visit

Https://192.168.14.180:1158/em/console/logon/logon

(4) Run script configuration em

Description: The script needs to be run and logged in before it can be executed.

/home/oracle/config.sh

#!/bin/bash
Source/home/oracle/.bash_profile
CD $ORACLE _home/jdk/jre/lib/
MV Font.properties Font.properties.bak
CP Font.properties.zh_CN. Redhat font.properties
CD $ORACLE _home/oc4j/j2ee/oc4j_applications/applications/em/em/cabo/images/cache/zhs/
RM *.gif
CD $ORACLE _home/jre/1.4.2/lib/
MV Font.properties Font.properties.bak
CP Font.properties.zh_CN. Redhat font.properties
CD $ORACLE _home/oc4j/j2ee/oc4j_applications/applications/em/em/cabo/images/cache/zhs/
RM-RF *.gif
CD $ORACLE _home/javavm/lib/ojvmfonts/
MV Font.properties Font.properties.bak
CP Font.properties.zh_CN. Redhat font.properties

(5) test shutdown and startup

$ emctl Stop Dbconsole
$ emctl Start Dbconsole

Third, the non-normal mode of new Installation 1. Oracle Installation Environment Ready

With oel5.x X64 installation, the installation process only selected graphical interface, no installation development package, development library, old software development package and other cases of installation due to the lack of related packages, the installation process will be wrong.
# yum Groupinstall ' development Tools '
# yum Groupinstall ' development Libraries '

(1) Confirm that the following packages are installed

# rpm-q--QF '%{name}-%{version}-%{release} (%{arch}) \ n ' binutils compat-libstdc++-33 compat-gcc-34-c++ Elfutils-libelf elfutils-libelf-devel elfutils-libelf-devel-static gcc gcc-c++ glibc glibc-common glibc-devel Glibc-headers kernel-headers ksh libaio libaio-devel libgcc libgomp libstdc++ libstdc++-devel make Sysstat UnixODBC UnixOD Bc-devel openmotif22 openmotif compat-db setarch libxp

Binutils-2.17.50.0.6-14.el5 (x86_64)
Compat-libstdc++-33-3.2.3-61 (x86_64)
Compat-libstdc++-33-3.2.3-61 (i386)
compat-gcc-34-c++-3.4.6-4.1 (x86_64)
Elfutilsos-libelf-0.137-3.el5 (x86_64)
Elfutils-libelf-0.137-3.el5 (i386)
Elfutils-libelf-devel-0.137-3.el5 (x86_64)
Elfutils-libelf-devel-static-0.137-3.el5 (x86_64)
Gcc-4.1.2-50.el5 (x86_64)
Gcc-c++-4.1.2-50.el5 (x86_64)
glibc-2.5-58 (x86_64)
glibc-2.5-58 (i686)
glibc-common-2.5-58 (x86_64)
glibc-devel-2.5-58 (x86_64)
GLIBC-DEVEL-2.5-58 (i386)
glibc-headers-2.5-58 (x86_64)
Package kernel-headers are not installed
ksh-20100202-1.el5_5.1 (x86_64)
Libaio-0.3.106-5 (x86_64)
Libaio-0.3.106-5 (i386) r
Libaio-devel-0.3.106-5 (x86_64)
Libgcc-4.1.2-50.el5 (x86_64)
Libgcc-4.1.2-50.el5 (i386)
Libgomp-4.4.4-13.el5 (x86_64)
Libgomp-4.4.4-13.el5 (i386)
Libstdc++-4.1.2-50.el5 (x86_64)
Libstdc++-4.1.2-50.el5 (i386)
Libstdc++-devel-4.1.2-50.el5 (x86_64)
Make-3.81-3.el5 (x86_64)
sysstat-7.0.2-3.el5_5.1 (x86_64)
unixodbc-2.2.11-7.1 (x86_64)
unixodbc-devel-2.2.11-7.1 (x86_64)
Openmotif22-2.2.3-18 (x86_64)
openmotif-2.3.1-5.el5_5.1 (x86_64)
compat-db-4.2.52-5.1 (x86_64)
setarch-2.0-1.1 (x86_64)
Libxp-1.0.0-8.1.el5 (x86_64)
Libxp-1.0.0-8.1.el5 (i386)

2. Avoid njni10 Error resolution

Because the operating system does not have the development Kit tools installed, the following error occurs when installing oracle10g.
The "Unsatisfiedlinkerror exception loading native library:njni10" error is resolved when NETCA or DBCA are executed.

GLIBC and Glibc-devel Package 32bit version, 64bit version needs to be installed:

# RPM-UVH glibc-*.i686.rpm glibc-devel-*.i386.rpm
# RPM-UVH compat-libstdc++-33-3.2.3-61*.i386.rpm
After installing the 32bit glibc and Glibc-devel, the Oracle is relink:

$ $ORACLE _home/bin/relink All

This article is from the "Koumm Linux Technology blog" blog, be sure to keep this source http://koumm.blog.51cto.com/703525/1580315

Oracle Linux 5.8 Installs Oracle 10.2.0.5 x64