Oracle9i R2 (9.2.0.4) Database on CentOS Relase 5.5 (Final)
★ 安裝 Oracle 9iR2 Server (9.2.0.4) ★
============================
1. 建立使用者和群組
-------------------------
增加安裝過程中需要用到的使用者和群組
groupadd oinstall
groupadd dba
useradd -g oinstall -G dba oracle
2. 建立安裝目錄
--------------------------
我們將把所有東西都安裝到在 /u01 目錄下：
mkdir /u01
chmod 755 /u01
chown oracle.oinstall /u01
3. 系統配置
--------------------------
a) Patch說明:
幾個需要的包所在的路徑
===========================
clear;rpm -q compat-db \
compat-gcc-34 \
compat-gcc-34-c++ \
compat-libgcc-296 \
libaio-devel \
libXp \
openmotif \
openmotif22 \
libXp-devel \
libXpm \
libXpm-devel \
compat-libcwait
yum install compat-db
yum install libaio-devel
yum install libXp
yum install openmotif
yum install openmotif22
yum install libXp-devel
yum install libXpm-devel
yum install compat-libcwait
b) 設置內核參數
vi /etc/sysctl.conf
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
參數說明：
====================
sem 4個參數依次為
--SEMMSL(每個用戶擁有信號量最大數)
--SEMMNS(系統信號量最大數)
--SEMOPM(每次semopm系統調用運算元)
--SEMMNI(系統辛苦量集數最大數)
Shmmax 最大共用記憶體(這裏設定為實體記憶體的一半 4G記憶體的話為：2048×1024×1024)
Shmmni 最小共用記憶體
Shmall 所有記憶體大小
====================
執行sysctl以反映修改 使內核參數立刻生效，重啟也可以
sysctl -p
c) 設置環境變數
su - oracle
vi .bash_profile
-------------------------------
# Setup Oracle Environment
export ORACLE_BASE=/u01/oracle
export ORACLE_HOME=/u01/oracle/product/9.2.0
export ORACLE_SID=ora9204
export ORACLE_TERM=xterm
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export NLS_LANG=AMERICAN_AMERICA.ZHT16BIG5
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib:/usr/X11R6/lib
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORACLE_OWNER=oracle
# Setup Search Path
export PATH=$PATH:$ORACLE_HOME/bin:/home/oracle/Opatch:/sbin
4.載入光碟與解壓ORACLE(9.2.0.4)原始檔
------------------
cpio -idmv < ship_9204_linux_disk1.cpio
cpio -idmv < ship_9204_linux_disk2.cpio
cpio -idmv < ship_9204_linux_disk3.cpio
得到： /Disk1 /Disk2 /Disk3 三個目錄
mv Disk* /
cd /
chown oracle.oinstall /Disk* -R
5.Oracle安裝
--------------------------
a) 用oracle登錄到圖形介面
b) 以 Root 用戶登錄並允許用戶 oracle 向 X 顯示器寫入：
su -
xhost +
su - oracle
c) Install
./runInstaller
安裝時出現以下錯誤(after ./runInstaller execution)
error while loading shared libraries: libstdc++-libc6.1-1.so.2: cannot open shared object file: No such file or directory
解決方法:
================================
以 root 身分建立 libstdc++-libc6.1-1.so.2 的symbolic link
su -
cd /usr/lib
ln -s libstdc++-3-libc6.2-2-2.10.0.so libstdc++-libc6.1-1.so.2
================================
(1)Welcome
[Next]
(2)Inventory Locations
[OK]
(3)Unix Group Name
設為「oinstall」
[Next]
(4)切換 root 身份執行「/tmp/orainstRoot.sh」
[Continue]
(5)File Locations
[Next]
(6)Available Products
選「Oracle 9i Database 9.2.0.4.0」
[Next]
(7)Install Types
選「Enterprise Edition (2.84GB)」
[Next]
(8)Database Configuration
選「Software Only」
[Next]
(9)Summary
[Install]
之後以 root 執行 [/u01/oracle/product/9.2.0/root.sh]
[OK]
[End of installation]
[The installation of Oracle9i Database was successful]
[Exit]
d) 上Patch
su - oracle
mkdir /u01/install/
chown oracle.oinstall /u01/install/ -R
export PATH=$PATH:/u01/install/OPatch:/sbin
unzip -d /u01/install/ p2617419_220_GENERIC.zip
unzip -d /u01/install/ p3238244_9204_LINUX.zip
chown oracle.oinstall /u01/install/* -R
cd /u01/install/3238244/
export PATH=$PATH:/u01/install/OPatch:/sbin
opatch apply
Please respond Y|N > ==>Y (ENTER)
OPatch Succeeded.
e) Ok, Congratulations
$ sqlplus / nolog
f)無法啟動dbca或是netca，錯誤訊息如下：
$ dbca& 或是 $ netca&
/opt/oracle/jre/1.1.8/bin/../lib/i686/green_threads/libzip.so: symbol errno, version GLIBC_2.0 not defined in file libc.so.6 with link time reference (libzip.so)
Unable to initialize threads: cannot find class java/lang/Thread
Could not create Java VM
========================
解決方法：
cd /u01/oracle/product/9.2.0/
ls -l JRE
lrwxrwxrwx 1 oracle oinstall 25 Dec 7 10:11 JRE -> /u01/oracle/jre/1.1.8
rm JRE
ln -s /u01/oracle/jre/1.3.1/ JRE
cd /u01/oracle/product/9.2.0/JRE/bin/
ln -s java jre
cd /u01/oracle/product/9.2.0/JRE/bin/i386/native_threads
ln -s java jre
g)啟動netca用以建立網路設定
netca&
如果運行netca遇到問題
/u01/oracle/product/9.2.0/bin/netca: line 138: 16942 Aborted $JRE -classpath $CLASSPATH oracle.net.ca.NetCA $*
修改netmgr
vi /u01/oracle/product/9.2.0/bin/netmgr
# Run Net Manager
$JRE -classpath $CLASSPATH oracle.net.mgr.container.NetApplication oracle.net.mgr.container.NetApplication
改成..
# Run Net Manager
$JRE -noverify -classpath $CLASSPATH oracle.net.mgr.container.NetApplication oracle.net.mgr.container.NetApplication
之後就可以順利運行了，但是用netca還是有問題，錯誤訊息：
/opt/ora9i/product/9204/bin/netca: line 138: 3802 Aborted $JRE -classpath $CLASSPATH oracle.net.ca.NetCA $*
不過大部分的netca的功能都可以用netmgr來完成。
posted on Wednesday, January 26, 2011 3:08 PM
Feedback
# re: Oracle9i R2 (9.2.0.4) Database on CentOS Relase 5.5 (Final)
Initializing Java Virtual Machine from /tmp/OraInstall2011-04-30_11-18-24AM/jre/bin/java. Please wait...
Error occurred during initialization of VM
Unable to load native library: /tmp/OraInstall2011-04-30_11-18-24AM/jre/lib/i386/libjava.so: symbol __libc_wait, version GLIBC_2.0 not defined in file libc.so.6 with link time reference
4/30/2011 11:19 AM | Andy
# re: Oracle9i R2 (9.2.0.4) Database on CentOS Relase 5.5 (Final)
上面那个错误你见过吗
