在安腾AI64 RHEL3 U3服务器上安装ORACLE10G
在安腾AI64 RHEL3 U3服务器上安装ORACLE10G
最近有机会在安腾机上折腾，试验了一下ORACLE10安装
ORALCE 安装记录
# 解压
zcat 10201_database_linuxitanium.cpio.gz | cpio -idmv
# 检查必要的软件环境
rpm -q make gcc glibc compat-db compat-gcc compat-gcc-c compat-libstdc compat-libstdc -devel openmotif21 setarch libaio
# ORALCE官方文档解释:物理内存1-2G的话 SWAP需要是物理内存的1.5-2倍,超过2G SWAP可以与内存相等
需要4G的安装空间,和1.2G的数据存储空间
查看物理内存
grep MemTotal /proc/meminfo
MemTotal: 16530752 kB
查看SWAP空间
grep SwapTotal /proc/meminfo
SwapTotal: 8191968 kB
查看临时文件空间
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%
创建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
# 创建目录,分配权限
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
修改内核参数
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 10g config---------------------------------------
wq
/sbin/sysctl -p
su oracle
# 开始安装
./runInstaller
凡是有变动的参数在下面列出,其他参数使用默认值
Global Database Name:OraDB10g
Database Password:xjtuoracle
Inventory dir:/app/oracle/oraInventory
提示中选择使用推荐的目录
提示警告信息,主要是说swap空间不足,按照文档说明,swap应当至少于内存相等,我们忽略此警告
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
=======================================================================
安装完成显示日值在
根据提示用root执行校本
/app/oracle/oraInventory/orainstRoot.sh
/app/oracle/product/10.1.0/asm/root.sh
使用默认设置
安装完成
执行下列命令,来解决em的中文问题
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
启动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/zhs
rhel 5.2没有安装中文语言包，oracle em显示乱码 首先下载zysong.ttf字体放入，选择使用font.properties.zh_CN.Redhat来替换缺省字体定义文件font.properties即可。 如果安装时,我们系统环境变量设置的是中文环境,那么就不会有这个问题.这个问题根本原因在于安装时,JDK/JRE字符集的自动选择.
在 $ORACLE_HOME/jdk/jre/lib 和 $ORACLE_HOME/jre/1.4.2/lib/ 目录下都有多种字符集字体配置文件:
[oracle@danaly ~]$ cd $ORACLE_HOME/jdk/jre/lib[oracle@danaly lib]$ ls font*zh_CN*font.properties.zh_CN.Redhat font.properties.zh_CN.Redhat2.1 font.properties.zh_CN.Sun font.properties.zh_CN_UTF8.Sun[oracle@danaly lib]$ cd $ORACLE_HOME/jre/1.4.2/lib/[oracle@danaly lib]$ ls font*zh_CN*font.properties.zh_CN.Redhat font.properties.zh_CN.Redhat2.1 font.properties.zh_CN.Sun font.properties.zh_CN_UTF8.Sun
我们只要用合适的中文字符集文件替换缺省文件即可,我选择使用font.properties.zh_CN.Redhat来替换缺省字体定义文件:
[oracle@danaly lib]$ cp font.properties.zh_CN.Redhat font.properties
替换之后需要清理一下Cache,重启EM即可.
Cache路径通常位于:
$ORACLE_HOME/oc4j/j2ee/oc4j_applications/applications/em/em/cabo/images/cache/zhs
清除所有gif文件即可.然后重新启动EM:
[oracle@danaly zhs]$ emctl stop dbconsoleTZ set to PRCOracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.http://danaly.hurrray.com.cn:1158/em/console/aboutApplicationStopping Oracle Enterprise Manager 10g Database Control ... ... Stopped. [oracle@danaly zhs]$ emctl start dbconsoleTZ set to PRCOracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.http://danaly.hurrray.com.cn:1158/em/console/aboutApplicationStarting Oracle Enterprise Manager 10g Database Control .............. started. ------------------------------------------------------------------Logs are generated in directory /opt/oracle/product/10.2.0/danaly.hurrray.com.cn_danaly/sysman/log
现在登陆Web页面,EM显示就可以正常显示中文了。
最近有机会在安腾机上折腾，试验了一下ORACLE10安装
ORALCE 安装记录
# 解压
zcat 10201_database_linuxitanium.cpio.gz | cpio -idmv
# 检查必要的软件环境
rpm -q make gcc glibc compat-db compat-gcc compat-gcc-c compat-libstdc compat-libstdc -devel openmotif21 setarch libaio
# ORALCE官方文档解释:物理内存1-2G的话 SWAP需要是物理内存的1.5-2倍,超过2G SWAP可以与内存相等
需要4G的安装空间,和1.2G的数据存储空间
查看物理内存
grep MemTotal /proc/meminfo
MemTotal: 16530752 kB
查看SWAP空间
grep SwapTotal /proc/meminfo
SwapTotal: 8191968 kB
查看临时文件空间
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%
创建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
# 创建目录,分配权限
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
修改内核参数
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 10g config---------------------------------------
wq
/sbin/sysctl -p
su oracle
# 开始安装
./runInstaller
凡是有变动的参数在下面列出,其他参数使用默认值
Global Database Name:OraDB10g
Database Password:xjtuoracle
Inventory dir:/app/oracle/oraInventory
提示中选择使用推荐的目录
提示警告信息,主要是说swap空间不足,按照文档说明,swap应当至少于内存相等,我们忽略此警告
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
=======================================================================
安装完成显示日值在
根据提示用root执行校本
/app/oracle/oraInventory/orainstRoot.sh
/app/oracle/product/10.1.0/asm/root.sh
使用默认设置
安装完成
执行下列命令,来解决em的中文问题
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
启动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/zhs
rhel 5.2没有安装中文语言包，oracle em显示乱码 首先下载zysong.ttf字体放入，选择使用font.properties.zh_CN.Redhat来替换缺省字体定义文件font.properties即可。 如果安装时,我们系统环境变量设置的是中文环境,那么就不会有这个问题.这个问题根本原因在于安装时,JDK/JRE字符集的自动选择.
在 $ORACLE_HOME/jdk/jre/lib 和 $ORACLE_HOME/jre/1.4.2/lib/ 目录下都有多种字符集字体配置文件:
[oracle@danaly ~]$ cd $ORACLE_HOME/jdk/jre/lib[oracle@danaly lib]$ ls font*zh_CN*font.properties.zh_CN.Redhat font.properties.zh_CN.Redhat2.1 font.properties.zh_CN.Sun font.properties.zh_CN_UTF8.Sun[oracle@danaly lib]$ cd $ORACLE_HOME/jre/1.4.2/lib/[oracle@danaly lib]$ ls font*zh_CN*font.properties.zh_CN.Redhat font.properties.zh_CN.Redhat2.1 font.properties.zh_CN.Sun font.properties.zh_CN_UTF8.Sun
我们只要用合适的中文字符集文件替换缺省文件即可,我选择使用font.properties.zh_CN.Redhat来替换缺省字体定义文件:
[oracle@danaly lib]$ cp font.properties.zh_CN.Redhat font.properties
替换之后需要清理一下Cache,重启EM即可.
Cache路径通常位于:
$ORACLE_HOME/oc4j/j2ee/oc4j_applications/applications/em/em/cabo/images/cache/zhs
清除所有gif文件即可.然后重新启动EM:
[oracle@danaly zhs]$ emctl stop dbconsoleTZ set to PRCOracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.http://danaly.hurrray.com.cn:1158/em/console/aboutApplicationStopping Oracle Enterprise Manager 10g Database Control ... ... Stopped. [oracle@danaly zhs]$ emctl start dbconsoleTZ set to PRCOracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.http://danaly.hurrray.com.cn:1158/em/console/aboutApplicationStarting Oracle Enterprise Manager 10g Database Control .............. started. ------------------------------------------------------------------Logs are generated in directory /opt/oracle/product/10.2.0/danaly.hurrray.com.cn_danaly/sysman/log
现在登陆Web页面,EM显示就可以正常显示中文了。
