Linux下安装Oracle

发表于 | 更新于: | 分类于 ， |
| 字数统计: 382 | 阅读时长 ≈ 2
���Ľ�������л�����Ķ�

Oracle install

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
groupadd -g 6000 asmadmin
groupadd -g 6001 asmdba
groupadd -g 6002 asmoper
groupadd -g 8000 oinstall
groupadd -g 8001 dba
groupadd -g 8002 oper

yum  install unzip  -y
yum install -y xdpyinfo
yum install -y vim

useradd -u 8000 -g oinstall -G dba,asmdba   odsz11g


mkdir /data/palog
cd /data/palog

cat > /etc/sysctl.conf  <<EOF
net.ipv4.ip_forward = 0
fs.aio-max-nr = 1048576
fs.file-max = 6815744
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
kernel.sysrq = 1
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
net.ipv4.ip_local_port_range = 9000 65500
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 68719476736
kernel.shmall = 4294967296
EOF

cat >> /etc/security/limits.conf << EOF
odsz11g          soft    nproc  2047
odsz11g         hard    nproc  16384
odsz11g         soft    nofile  1024
odsz11g         hard    nofile  65536
odsz11g         hard    stack  10240
EOF
 /sbin/sysctl -p
printf "Paic1234\nPaic1234" | passwd odsz11g

切换到odsz11g

1
2
3
4
5
6
7
8
9
10
11
12
13
su - odsz11g
cd /data/palog
wget http://10.25.27.90/medias/oracle/p13390677_112040_Linux-x86-64_1of7.zip
wget http://10.25.27.90/medias/oracle/p13390677_112040_Linux-x86-64_2of7.zip

mkdir -p s01/oracle
chown -R odsz11g:oinstall     s01
mkdir -p u01/oraInventory
chown -R odsz11g:oinstall     u01
chown -R odsz11g:oinstall /data/
unzip p13390677_112040_Linux-x86-64_1of7.zip
unzip p13390677_112040_Linux-x86-64_2of7.zip
rm -rf *.zip

切换到root

1
2
3
4
5
6
7
8
9
10
yum install compat-*
rpm -ivh libnet-1.1.2.1-2.2.el4.rf.i386.rpm
rpm -ivh libstdc++-3.4.6-11.i386.rpm
rpm -ivh pdksh-5.2.14-1.i386.rpm
rpm -ivh libaio-0.3.105-2.i386.rpm
rpm -ivh libaio-devel-0.3.105-2.i386.rpm 
rpm -ivh libgcc-3.4.6-3.1.i386.rpm      
rpm -ivh  unixODBC-2.2.11-7.1.i386.rpm

#rpm -ivh unixODBC-devel-2.2.11-7.1.x86_64.rpm

切换到odsz11g

配置oracle安装用户（odsz11g）的环境变量

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
su - odsz11g

cp .bash_profile .bash_profile.bak
cat >> .bash_profile << EOF 
PATH=$PATH:$HOME/bin

export PATH
export ORACLE_BASE=/data/palog/s01/oracle
export ORACLE_HOME=/product/11.2.0/dbhome_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib/lib:/lib32
export ORACLE_SID=orcl
#这里的IP改成你电脑的IP
export DISPLAY=192.168.1.100:0.0
export PATH=/bin:/OPatch:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/odsz11g/bin:/home/odsz11g/bin
export LANG=en_US.UTF-8
EOF

使用oracle配置文件

1
. .bash_profile

使用xpassive

1
DISPLAY=192.168.0.100:0.0
0%