RPM方式安裝oracle資料庫

安裝oracle資料庫有多重方法，這裡講述rpm方式安裝。因為這一種是官方提供的安裝方法。
當然，我們更方便的方法就是使用yum方式安裝，這一種只需一步操作安裝yum，就可以把
我們安裝資料庫時配置環境的rpm包都安裝上。而rpm方式，就是要我們一個一個地安裝所需
要的rpm包。

安裝系統環境：

虛擬機器：vmware 系統Linux （OEL5.6）主機IP：192.168.2.20

---安裝虛擬機器與系統：

--安裝好後主機名：

[root@su ~]# cat /etc/sysconfig/network

NETWORKING=yes

NETWORKING_IPV6=no

HOSTNAME=su.oracle.com

GATEWAY=192.168.2.20

---建立安裝所需的使用者與組：

[root@su ~]# groupadd -g 1000 oinstall

[root@su ~]# groupadd -g 1001 dba

[root@su ~]# groupadd -g 1002 oper

useradd -u 1001 -d /home/oracle -g oinstall -G dba,oper oracle

[root@su ~]# 

---建立安裝所需的目錄並授權屬主屬組：

[root@su ~]# mkdir /soft

[root@su ~]# chown -R oracle:oinstall /soft

[root@su ~]# chmod -R 755 /soft

[root@su ~]# mkdir -p /u01/app/oracle

[root@su ~]# chown -R oracle:oinstall /u01

[root@su ~]# chmod -R 755 /u01

[root@su ~]# chown -R oracle:oinstall /soft

[root@su ~]# chmod -R 755 /soft

[root@su ~]# mkdir -p /u01/app/oracle

[root@su ~]# chown -R oracle:oinstall /u01

[root@su ~]# chmod -R 755 /u01

---傳輸oracle軟體安裝介質：

[root@su soft]# rz

rz waiting to receive.

開始 zmodem 傳輸。  按 Ctrl+C 取消。

  100% 1362873 KB 10095 KB/s 00:02:15       0 Errors..

  100% 1124320 KB 10810 KB/s 00:01:44       0 Errors..

[root@su soft]#

#傳輸完成。

---安裝RPM包：
--官方文件提供的安裝包;

The following or later version of packages for Asianux Server 3, Oracle Linux 5, and Red Hat Enterprise Linux 5 should be installed:

binutils-2.17.50.0.6
compat-libstdc++-33-3.2.3
elfutils-libelf-0.125
elfutils-libelf-devel-0.125
elfutils-libelf-devel-static-0.125
gcc-4.1.2
gcc-c++-4.1.2
glibc-2.5-24
glibc-common-2.5
glibc-devel-2.5
glibc-headers-2.5
kernel-headers-2.6.18
ksh-20060214
libaio-0.3.106
libaio-devel-0.3.106 
libgcc-4.1.2
libgomp-4.1.2
libstdc++-4.1.2 
libstdc++-devel-4.1.2
make-3.81
sysstat-7.0.2

--掛載光碟並安裝rpm包：
[root@su ~]# mount /dev/cdrom /mnt     #掛載光碟#

mount: block device /dev/cdrom is write-protected, mounting read-only

[root@su ~]#

[root@su ~]# cd /mnt

[root@su mnt]# ls

blafdoc.css     eula.py    README-en.html         Server

Cluster         GPL        RELEASE-NOTES-en       supportinfo

ClusterStorage  images     RELEASE-NOTES-en.html  TRANS.TBL

EULA            isolinux   RPM-GPG-KEY            VT

eula.en_US      README-en  RPM-GPG-KEY-oracle

[root@su mnt]# cd Server/

[root@su Server]#

[root@su Server]# pwd

/mnt/Server

 

[root@su Server]# rpm -ivh binutils-2.17.50.0.6-14.el5.x86_64.rpm

warning: binutils-2.17.50.0.6-14.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159

Preparing...                ########################################### [100%]

        package binutils-2.17.50.0.6-14.el5.x86_64 is already installed

[root@su Server]# rpm -ivh compat-libstdc++-33-3.2.3-61.x86_64.rpm

warning: compat-libstdc++-33-3.2.3-61.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159

Preparing...                ########################################### [100%]

        package compat-libstdc++-33-3.2.3-61.x86_64 is already installed

[root@su Server]#

 

... ...

[root@su Server]# rpm -ivh gcc-4.1.2-50.el5.x86_64.rpm

warning: gcc-4.1.2-50.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159

Preparing...                ########################################### [100%]

        package gcc-4.1.2-50.el5.x86_64 is already installed

[root@su Server]#

[root@su Server]# rpm -ivh gcc-c++-4.1.2-50.el5.x86_64.rpm

warning: gcc-c++-4.1.2-50.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159

Preparing...                ########################################### [100%]

        package gcc-c++-4.1.2-50.el5.x86_64 is already installed

[root@su Server]#

[root@su Server]# rpm -ivh glibc-common-2.5-58.x86_64.rpm

warning: glibc-common-2.5-58.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159

Preparing...                ########################################### [100%]

        package glibc-common-2.5-58.x86_64 is already installed

[root@su Server]#

[root@su Server]# rpm -ivh glibc-devel-2.5-58.x86_64.rpm

warning: glibc-devel-2.5-58.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159

Preparing...                ########################################### [100%]

        package glibc-devel-2.5-58.x86_64 is already installed

[root@su Server]#

[root@su Server]# rpm -ivh glibc-headers-2.5-58.x86_64.rpm

warning: glibc-headers-2.5-58.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159

Preparing...                ########################################### [100%]

        package glibc-headers-2.5-58.x86_64 is already installed

[root@su Server]#

[root@su Server]# rpm -ivh kernel-headers-2.6.18-238.el5.x86_64.rpm

... ...

th file from package kernel-uek-headers-2.6.32-100.26.2.el5.x86_64

        file /usr/include/sound/asound_fm.h from install of kernel-headers-2.6.18-238.el5.x86_64 conflicts with file from package kernel-uek-headers-2.6.32-100.26.2.el5.x86_64

        file /usr/include/sound/emu10k1.h from install of kernel-headers-2.6.18-238.el5.x86_64 conflicts with file from package kernel-uek-headers-2.6.32-100.26.2.el5.x86_64

        file /usr/include/sound/hdsp.h from install of kernel-headers-2.6.18-238.el5.x86_64 conflicts with file from package kernel-uek-headers-2.6.32-100.26.2.el5.x86_64

        file /usr/include/sound/hdspm.h from install of kernel-headers-2.6.18-238.el5.x86_64 conflicts with file from package kernel-uek-headers-2.6.32-100.26.2.el5.x86_64

        file /usr/include/sound/sfnt_info.h from install of kernel-headers-2.6.18-238.el5.x86_64 conflicts with file from package kernel-uek-headers-2.6.32-100.26.2.el5.x86_64

        file /usr/include/video/sisfb.h from install of kernel-headers-2.6.18-238.el5.x86_64 conflicts with file from package kernel-uek-headers-2.6.32-100.26.2.el5.x86_64

 

[root@su Server]# rpm -ivh libaio-0.3.106-5.x86_64.rpm

warning: libaio-0.3.106-5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159

Preparing...                ########################################### [100%]

        package libaio-0.3.106-5.x86_64 is already installed

[root@su Server]#

[root@su Server]# rpm -ivh libaio-devel-0.3.106-5.x86_64.rpm

warning: libaio-devel-0.3.106-5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159

Preparing...                ########################################### [100%]

   1:libaio-devel           ########################################### [100%]

[root@su Server]#

[root@su Server]# rpm -ivh libgcc-4.1.2-50.el5.x86_64.rpm

warning: libgcc-4.1.2-50.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159

Preparing...                ########################################### [100%]

        package libgcc-4.1.2-50.el5.x86_64 is already installed

[root@su Server]#

[root@su Server]# rpm -ivh libstdc++-4.1.2-50.el5.x86_64.rpm

warning: libstdc++-4.1.2-50.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159

Preparing...                ########################################### [100%]

        package libstdc++-4.1.2-50.el5.x86_64 is already installed

[root@su Server]#

[root@su Server]# rpm -ivh libstdc++-devel-4.1.2-50.el5.x86_64.rpm

warning: libstdc++-devel-4.1.2-50.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159

Preparing...                ########################################### [100%]

        package libstdc++-devel-4.1.2-50.el5.x86_64 is already installed

[root@su Server]#

[root@su Server]# rpm -ivh make-3.81-3.el5.x86_64.rpm

warning: make-3.81-3.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159

Preparing...                ########################################### [100%]

        package make-3.81-3.el5.x86_64 is already installed

[root@su Server]#

 

[root@su Server]# rpm -ivh sysstat-7.0.2-3.el5_5.1.x86_64.rpm

warning: sysstat-7.0.2-3.el5_5.1.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159

Preparing...                ########################################### [100%]

   1:sysstat                ########################################### [100%]

[root@su Server]# 

---設定環境變數：

[oracle@su ~]$ vi .bash_profile

# .bash_profile

 

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

        . ~/.bashrc

fi

# User specific environment and startup programs 

PATH=$PATH:$HOME/bin

export PATH

--新增內容

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1

export ORACLE_SID=ORA11GR2

export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin

~

#新增後並儲存。

--儲存後使檔案生效：
[oracle@su ~]$ . .bash_proile
或者
[oracle@su ~]$ source  .bash_proile

---解壓oracle安裝包：

[oracle@su ~]$ cd /soft

[oracle@su soft]$ ls

lost+found  p13390677_112040_Linux-x86-64_1of7.zip  p13390677_112040_Linux-x86-64_2of7.zip

[oracle@su soft]$

[oracle@su soft]$ unzip p13390677_112040_Linux-x86-64_1of7.zip

... ...

[oracle@su soft]# unzip p13390677_112040_Linux-x86-64_2of7.zip 

---安裝資料庫軟體：
--啟動影像化介面安裝oracle軟體：

[root@su ~]# xhost +

access control disabled, clients can connect from any host

[root@su ~]#

... ...

[oracle@su database]$ ./runInstaller

Starting Oracle Universal Installer...

 

Checking Temp space: must be greater than 120 MB.   Actual 10330 MB    Passed

Checking swap space: must be greater than 150 MB.   Actual 4094 MB    Passed

Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2016-11-14_04-17-05PM. Please wait ...[oracle@su database]$ You can find the log of this install session at:

 /u01/app/oraInventory/logs/installActions2016-11-14_04-17-05PM.log

--安裝後在root使用者續執行以下兩個指令碼：

[root@su ~]# /u01/app/oraInventory/orainstRoot.sh

Changing permissions of /u01/app/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions for world.

Changing groupname of /u01/app/oraInventory to oinstall.

The execution of the script is complete.

You have new mail in /var/spool/mail/root

[root@su ~]#

[root@su ~]# /u01/app/oracle/product/11.2.0/dbhome_1/root.sh

Performing root user operation for Oracle 11g

 

The following environment variables are set as:

    ORACLE_OWNER= oracle

    ORACLE_HOME=  /u01/app/oracle/product/11.2.0/dbhome_1

 

Enter the full pathname of the local bin directory: [/usr/local/bin]:

   Copying dbhome to /usr/local/bin ...

   Copying oraenv to /usr/local/bin ...

   Copying coraenv to /usr/local/bin ...

 

Creating /etc/oratab file...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

---啟用dbca建庫：
--啟動dbca建庫：
... ...
--啟動netca配置監聽：

[oracle@su ~]$ netca

Oracle Net Services Configuration:

Configuring Listener:LISTENER

Listener configuration complete.

Oracle Net Listener Startup:

    Running Listener Control:

      /u01/app/oracle/product/11.2.0/dbhome_1/bin/lsnrctl start LISTENER

    Listener Control complete.

    Listener started successfully.

Oracle Net Services configuration successful. The exit code is 0

[oracle@su ~]$

建庫成功後的提醒介面