在安騰AI64 RHEL3 U3服務(wù)器上安裝ORACLE10G
最近有機(jī)會(huì)在安騰機(jī)上折騰，試驗(yàn)了一下ORACLE10安裝
ORALCE 安裝記錄
# 解壓
zcat 10201_database_linuxitanium.cpio.gz | cpio -idmv
# 檢查必要的軟件環(huán)境
rpm -q make gcc glibc compat-db compat-gcc compat-gcc-c++ compat-libstdc++ compat-libstdc++-devel openmotif21 setarch libaio
Red Hat Enterprise Linux 3.0:
make-3.79.1-17
control-center-2.2.0.1-13
gcc-3.2.3-47
gcc-c++-3.2.3-47
gdb-6.1post-1.20040607.52
glibc-2.3.2-95.30
glibc-common-2.3.2-95.30
glibc-devel-2.3.2-95.30
glibc-devel-2.3.2-95.20 (32 bi
compat-db-4.0.14-5.1
compat-gcc-7.3-2.96.128
compat-gcc-c++-7.3-2.96.128
compat-libstdc++-7.3-2.96.128
compat-libstdc++-devel-7.3-2.9
gnome-libs-1.4.1.2.90-34.2 (32
libstdc++-3.2.3-47
libstdc++-devel-3.2.3-47
openmotif-2.2.3-3.RHEL3
sysstat-5.0.5-5.rhel3
setarch-1.3-1
libaio-0.3.96-3
libaio-devel-0.3.96-3
Red Hat Enterprise Linux 4.0:
binutils-2.15.92.0.2-10.EL4
compat-db-4.1.25-9
control-center-2.8.0-12
gcc-3.4.3-9.EL4
gcc-c++-3.4.3-9.EL4
glibc-2.3.4-2
glibc-common-2.3.4-2
gnome-libs-1.4.1.2.90-44.1
libstdc++-3.4.3-9.EL4
libstdc++-devel-3.4.3-9.EL4
make-3.80-5
pdksh-5.2.14-30
sysstat-5.0.5-1
xscreensaver-4.18-5.rhel4.2
# ORALCE官方文件解釋:物理內(nèi)存1-2G的話 SWAP需要是物理內(nèi)存的1.5-2倍,超過(guò)2G SWAP能和內(nèi)存相等
需要4G的安裝空間,和1.2G的數(shù)據(jù)存儲(chǔ)空間
查看物理內(nèi)存
grep MemTotal /proc/meminfo
MemTotal:? ???16530752 kB
查看SWAP空間
grep SwapTotal /proc/meminfo
SwapTotal:? ???8191968 kB
查看臨時(shí)文件空間
df -k /tmp
Filesystem? ?? ?? ???1K-blocks? ?? ?Used Available Use% Mounted on
/dev/sda3? ?? ?? ?? ? 26742696? ?5639068??19745148??23% /
查看磁盤空間
df -k
Filesystem? ?? ?? ???1K-blocks? ?? ?Used Available Use% Mounted on
/dev/sda3? ?? ?? ?? ? 26742696? ?5639068??19745148??23% /
/dev/sda1? ?? ?? ?? ?? ?204580? ?? ?7680? ? 196900? ?4% /boot/efi
none? ?? ?? ?? ?? ?? ? 8265376? ?? ?? ?0? ?8265376? ?0% /dev/shm
/dev/sdc1? ?? ?? ?? ?516054864? ?1609484 488231320? ?1%
創(chuàng)建oralce用戶和組
groupadd oinstall
groupadd dba
useradd -g oinstall -G dba oracle
登錄oracle用戶
# su ? oracle
$ cd ~
$ vi .bash_profile
#---------ORACLE 10G CONFIG---------
export ORACLE_BASE=/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.1.0/asm
export ORACLE_SID=OraDB10g
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib
# XManager client
export DISPLAY=202.117.11.110:0.0
#------------END--------------------
wq
source .bash_profile
# 創(chuàng)建目錄,分配權(quán)限
mkdir /app
mkdir /app/oracle
mkdir /app/oracle/product
mkdir /app/oracle/product/10.1.0/
chown -R oracle.oinstall /app/oracle
mkdir /var/opt/oracle
chown oracle.dba /var/opt/oracle
chmod 755 /var/opt/oracle
修改內(nèi)核參數(shù)
vi /etc/sysctl.conf
#----------- oracle 10g config --------------------------------------
kernel.shmall = 2097152
kernel.shmmax = 8589934592
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 1048576
net.core.rmem_max = 1048576
net.core.wmem_default = 262144
net.core.wmem_max = 262144

-----------Oracle方法文檔介紹--------------------
編輯文件? /etc/sysctl.conf file
If the value of any kernel parameter is different from the recommended value,
then complete the following procedure:
Using any text editor, create or edit the /etc/sysctl.conf file, and add or edit
lines similar to the following:

kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 1048576
net.core.rmem_max = 1048576
net.core.wmem_default = 262144
net.core.wmem_max = 262144

By specifying the values in the /etc/sysctl.conf file, they persist when you
restart the system.
On SUSE systems only, enter the following command to ensure that the system
reads the /etc/sysctl.conf file when it restarts:
# /sbin/chkconfig boot.sysctl on
Note: Include lines only for the kernel parameter values that you
want to change. For the semaphore parameters (kernel.sem), you
must specify all four values. However, if any of the current values
are larger than the recommended value, then specify the larger
value.



-----------------------------
#----------- oracle 10g config---------------------------------------
wq
/sbin/sysctl -p
su oracle
# 開(kāi)始安裝
./runInstaller
凡是有變動(dòng)的參數(shù)在下面列出,其他參數(shù)使用默認(rèn)值
Global Database Name:OraDB10g
Database Password:xjtuoracle
Inventory dir:/app/oracle/oraInventory
提示中選擇使用推薦的目錄
提示警告信息,主要是說(shuō)swap空間不足,按照文件說(shuō)明,swap應(yīng)當(dāng)至少于內(nèi)存相等,我們忽略此警告
CChecking operating system requirements ...
Expected result: One of redhat-3,redhat-3,SuSE-9,asianux-1,asianux-2,redhat-4
Actual Result: redhat-Red Hat Enterprise Linux AS release 3 (Taroon Update 3)
Check complete. The overall result of this check is: Passed
=======================================================================
Checking operating system package requirements ...
Checking for make-3.79; found make-1:3.79.1-17. Passed
Checking for binutils-2.14; found binutils-2.14.90.0.4-35. Passed
Checking for gcc-3.2; found gcc-3.2.3-42. Passed
Checking for libaio-0.3.96; found libaio-0.3.96-3. Passed
Check complete. The overall result of this check is: Passed
=======================================================================
Checking kernel parameters
Checking for semmsl=250; found semmsl=250. Passed
Checking for semmns=32000; found semmns=32000. Passed
Checking for semopm=100; found semopm=100. Passed
Checking for semmni=128; found semmni=128. Passed
Checking for shmmax=536870912; found shmmax=8589934592. Passed
Checking for shmmni=4096; found shmmni=4096. Passed
Checking for shmall=2097152; found shmall=2097152. Passed
Checking for file-max=65536; found file-max=65536. Passed
Checking for VERSION=2.4.21; found VERSION=2.4.21-20.EL. Passed
Checking for ip_local_port_range=1024 - 65000; found ip_local_port_range=1024 - 65000. Passed
Checking for rmem_default=262144; found rmem_default=1048576. Passed
Checking for rmem_max=262144; found rmem_max=1048576. Passed
Checking for wmem_default=262144; found wmem_default=262144. Passed
Checking for wmem_max=262144; found wmem_max=262144. Passed
Check complete. The overall result of this check is: Passed
=======================================================================
Checking Recommended glibc version
Expected result: ATLEAST=2.3.2-95.27
Actual Result: 2.3.2-95.27
Check complete. The overall result of this check is: Passed
=======================================================================
Checking physical memory requirements ...
Expected result: 922MB
Actual Result: 16128MB
Check complete. The overall result of this check is: Passed
=======================================================================
Checking available swap space requirements ...
Expected result: 12096MB
Actual Result: 7999MB
Check complete. The overall result of this check is: Failed
Checking Network Configuration requirements ...
Check complete. The overall result of this check is: Not executed
Validating ORACLE_BASE location (if set) ...
Check complete. The overall result of this check is: Passed
=======================================================================
Checking Oracle Home path for spaces...
Check complete. The overall result of this check is: Passed
=======================================================================
Checking for proper system clean-up....
Check complete. The overall result of this check is: Passed
=======================================================================
Checking for Oracle Home incompatibilities ....
Actual Result: NEW_HOME
Check complete. The overall result of this check is: Passed
=======================================================================

安裝完成顯示日值在
根據(jù)提示用root執(zhí)行校本
/app/oracle/oraInventory/orainstRoot.sh
/app/oracle/product/10.1.0/asm/root.sh
使用默認(rèn)設(shè)置
安裝完成
執(zhí)行下列命令,來(lái)解決em的中文問(wèn)題
cd $ORACLE_HOME/javavm/lib/ojvmfonts/
mv font.properties font.properties.bak
cp font.properties.zh_CN.Redhat2.1 font.properties
cd $ORACLE_HOME/jre/1.4.2/lib/
mv font.properties font.properties.bak
cp font.properties.zh_CN.Redhat2.1 font.properties
cd $ORACLE_HOME/jdk/jre/lib/
mv font.properties font.properties.bak
cp font.properties.zh_CN.Redhat2.1 font.properties
啟動(dòng)ORACLE 10G命令
emctl start dbconsole
isqlplusctl start
停止ORACLE 10G命令
emctl stop dbconsole
isqlplusctl stop

em圖片cache目錄
/app/oracle/product/10.1.0/asm/oc4j/j2ee/oc4j_applications/applications/em/em/cabo/images/cache

========================================
常見(jiàn)問(wèn)題:
網(wǎng)頁(yè)界面上的按鈕出現(xiàn)“口口”的亂碼
解決方案：
1.停止服務(wù),emctl stop dbconsole;
2.把相關(guān)目錄（RHEL4里面是/etc/java/）下的font.properties用
font.properties.zh_CN.Redhat8.0替換(或font.properties.zh，只要是中文簡(jiǎn)體就可以。）;
3.刪除
$ORACLE_HOME/oc4j/j2ee/oc4j_applications/applications/em/em/cabo/images/cache/zhs中的gif文件
;
4.重起服務(wù)（最好是重啟服務(wù)器） emctl start dbconsole;

/etc/oratab的內(nèi)容
orcl:/oracle/10.2.0/db_1:Y

在安裝完oracle10g后，由于jre默認(rèn)使用的字體問(wèn)題，使得em,dbca,netca,netmgr顯示中文時(shí)出現(xiàn)"□□"字樣的亂碼，下面來(lái)說(shuō)明這個(gè)問(wèn)題的解決辦法：
1. 改變$ORACLE_HOME/jdk目錄下的jre的默認(rèn)字體
cd $ORACLE_HOME/jdk/jre/lib/
ls font*zh_CN*
font.properties是默認(rèn)使用的字體
還可以看到font.properties.zh_CN.Redhat8.0和其它的字體
cp font.properties font.properties.bak
cp font.properties.zh_CN.Redhat8.0 font.properties
2. 改變$ORACLE_HOME/jre下的默認(rèn)字體
cd $ORACLE_HOME/jre/1.4.2/lib/
ls font*zh_CN*
font.properties是默認(rèn)使用的字體
還可以看到font.properties.zh_CN.Redhat8.0和其它的字體
cp font.properties font.properties.bak
cp font.properties.zh_CN.Redhat8.0 font.properties
3.刪除Cache下的gif文件(em頁(yè)面中用到),注意不要?jiǎng)h錯(cuò)目錄
cd $ORACLE_HOME/oc4j/j2ee/oc4j_applications/applications/em/em/cabo/images/cache/zhs/
ls *.gif
rm -f *.gif
4. 重新啟動(dòng)EM服務(wù)
cd $ORACLE_HOME/bin/
./emctl stop dbconsole
./emctl start dbconsole
好可以進(jìn)入em web頁(yè)面看看是否中文不再是 "□□"字樣的亂碼了！
=====================================================
以下的 J2EE 應(yīng)用程序已經(jīng)配置, 并且可用下面列出的 URL 來(lái)訪問(wèn)。
iSQL*Plus URL:
http://database:5560/isqlplus
iSQL*Plus DBA URL:
http://database:5560/isqlplus/dba
Enterprise Manager 10g Database Control URL:
http://database:1158/em
\==========================================

在安騰AI64 RHEL3 U3服務(wù)器上安裝ORACLE10G