导入oracle数据库904,Oracle904InstalOnRedHatAS3-数据库专栏,ORACLE

短命女 2022-10-21 11:42 0阅读 0赞

—————————make raid disk storage———————-

step 1 :

follow as the hint,press ctrl-m,start to config raid

step 2 :

make 3 raids :1 disk,1 disk ,4 disks.

———————install as3 operation system in ide————————

step 1:

in installing we choose chinese simplified language package,

step 2:

set operation system default language is us english

step 3:

in install package,wo choose develope package and ftp package

finish the operation system install

——————–

——————–fdisk and partition—————————————-

step 1

fdisk /dev/sda

n–>p—>1—>return—->+20000m

n–>p—>2—>return—->+20000m

n–>p—>3—>return—->return—>w

fdisk /dev/sdb

n–>p—>1—>return—->return—->w

fdisk /dev/sdc

n–>p—>1—>return—->+40000m

n–>p—>2—>return—->return—->w

mkfs.ext3 /dev/sdc1

mkfs.ext3 /dev/sdc2

step 2

raw /dev/raw/raw1 /dev/sda1

raw /dev/raw/raw2 /dev/sda2

raw /dev/raw/raw3 /dev/sda3

raw /dev/raw/raw4 /dev/sdb1

step 3

add  command into /etc/rc.d/rc.local

raw /dev/raw/raw1 /dev/sda1

raw /dev/raw/raw2 /dev/sda2

raw /dev/raw/raw3 /dev/sda3

raw /dev/raw/raw4 /dev/sdb1

chown oracle /dev/raw/raw1

chown oracle /dev/raw/raw2

chown oracle /dev/raw/raw3

chown oracle /dev/raw/raw4

mount -t tmpfs /dev/tmpfs /oradata/bcp\_for\_ora/m0 -o size=500m

step 4

mkdir /oracle /oradata

step 5

mount /dev/sdc1 /oracle

mount /dev/sdc2 /oradata

it may like this

/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*/

label=/             /                    ext3    defaults        1 1

label=/boot      /boot             ext3    defaults        1 2

none                /dev/pts             devpts  gid=5,mode=620  0 0

none                /proc                  proc    defaults        0 0

none                /dev/shm             tmpfs   defaults        0 0

label=/swap /swap                 ext3    defaults        1 2

/dev/sdc1          /oracle               ext3    defaults        0 0

/dev/sdc2          /oradata              ext3    defaults        0 0

/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*/

step 6

add the above two commands into /etc/fstab

——————————————————————————

install oracle

\*———————–

\*notation!!!! as3 linux install must include developer rpms

\*———————–

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

step 1.

add user and group

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

groupadd dba

groupadd oinstall

useradd -g oinstall -g dba oracle

passwd oracle

mkdir /oracle

mkdir -p /oracle/ora9/product/

chown oracle.oinstall /oracle

chown -r oracle.oinstall /oracle/ora9

chmod 755 /oracle

chown -r oracle.oinstall /oradata /dev/raw/raw1 /dev/raw/raw2 /dev/raw/raw3 /dev/raw/raw4

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

step 2.

append these lines to

/etc/sysctl.conf to set kernel parameters:

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

kernel.shmmax = 1073741824

kernel.shmmni = 4096

\# \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*

kernel.shmall = 2097152

\#\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*

kernel.sem    = 250 32000 100 128

fs.file-max   = 65536

net.ipv4.ip\_local\_port\_range = 1024 65000

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

step 3.

append these lines to

/etc/security/limits.conf to

modify your resource limits:

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

oracle soft nofile 65536

oracle hard nofile 65536

oracle soft nproc 16384

oracle hard nproc 16384

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

step 4.

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

echo 250 32000 100 128 > /proc/sys/kernel/sem

echo 1073741824 > /proc/sys/kernel/shmmax

echo 4096 > /proc/sys/kernel/shmmni

echo 2097152 > /proc/sys/kernel/shmall

echo 65536 > /proc/sys/fs/file-max

echo 1024 65000 > /proc/sys/net/ipv4/ip\_local\_port\_range

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

step 5.

go into the ./rpms directory and

add the neccessory runtime file

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

rpm -ivh compat-libstdc++-7.3-2.96.122.i386.rpm

rpm -ivh compat-libstdc++-devel-7.3-2.96.122.i386.rpm

rpm -ivh compat-db-4.0.14-5.i386.rpm

rpm -ivh compat-gcc-7.3-2.96.122.i386.rpm

rpm -ivh compat-gcc-c++-7.3-2.96.122.i386.rpm

rpm -ivh tcl-8.3.5-92.i386.rpm

rpm -ivh setarch-1.3-1.i386.rpm

rpm -ivh openmotif-2.2.2-16.i386.rpm

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

step 6.

change compilers settings

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

mv /usr/bin/gcc /usr/bin/gcc323

ln -s /usr/bin/gcc296 /usr/bin/gcc

mv /usr/bin/g++ /usr/bin/g++323

ln -s /usr/bin/g++296 /usr/bin/g++

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

step 7.

unzip the compressed install file

notice:

1. copy the three install file into oracles home

2. change the owner and group to oracle and oinstall

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

chgrp oinstall lnx\*

chown oracle lnx\*

cpio -idmv

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

step 8.

unzip the compressed install file

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

unzip p3006854\_9204\_linux.zip

cd 3006854

sh rhel3\_pre\_install.sh

note: if you get the following error when you run rhel3\_pre\_install.sh:

rhel3\_pre\_install.sh: line 36: gcc: command not found

then you forgot to install or link gcc, see above. this means you cant start any binaries any more:

\# ls

ls: error while loading shared libraries: /etc/libcwait.so: cannot open shared object file: no such file or directory

\# rm /etc/ld.so.preload

rm: error while loading shared libraries: /etc/libcwait.so: cannot open shared object file: no such file or directory

to fix that, run the echo command which is a built-in shell command:

\# echo “” > /etc/ld.so.preload

rm /etc/ld.so.preload

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

step 9.

copy and replace the oracles .bash\_profile

with below contents

notice :

1. check your oracles path

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

.bash\_profile  list

\# .bash\_profile

\# take your display with you at remote login:

\# put it into your ~/.bash\_profile

\# oracle 9i

export oracle\_base=/oracle/ora9

export oracle\_home=/oracle/ora9/product/

export path=$oracle\_home/bin:$oracle\_home/apache/apache/bin:$path

export oracle\_owner=oracle

export oracle\_sid=ora9i32

export oracle\_term=xterm

export java\_home=$oracle\_home/jdk

export classpath=./:$oracle\_home/jdbc/lib/classes12.jar:$oracle\_home/lib/xmlparserv2.jar:$oracle\_home/rdbms/jlib/jmscommon.jar:$oracle\_home/rdbms/jlib/aqapi.jar:$oracle\_home/rdbms/jlib/xsu12.jar:$oracle\_home/dm/lib/odmapi.jar:oracle\_home/jdbc/lib/nls\_charset12.zip

\# use old linuxthreads with floating stacks instead of

\# the new native posix thread library (nptl)

\# \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*

export ld\_assume\_kernel=2.4.19

\#  \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*

export threads\_flag=native

\# edit paths

export path

unset username

umask 022

export ld\_library\_path=/oracle/ora9/product/9.2/lib

export path=/sbin:$java\_home/bin:/oracle/ora9/product/9.2/bin:$path