在安腾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
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官方文件解释:物理内存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方法文档介绍--------------------
编辑文件 /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
# 开始安装
./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
========================================
常见问题:
网页界面上的按钮出现“口口”的乱码
解决方案：
1.停止服务,emctl stop dbconsole;
2.把相关目录（RHEL4里面是/etc/java/）下的font.properties用
font.properties.zh_CN.Redhat8.0替换(或font.properties.zh，只要是中文简体就可以。）;
3.删除
$ORACLE_HOME/oc4j/j2ee/oc4j_applications/applications/em/em/cabo/images/cache/zhs中的gif文件
;
4.重起服务（最好是重启服务器） emctl start dbconsole;
/etc/oratab的内容
orcl:/oracle/10.2.0/db_1:Y
在安装完oracle10g后，由于jre默认使用的字体问题，使得em,dbca,netca,netmgr显示中文时出现"□□"字样的乱码，下面来说明这个问题的解决办法：
1. 改变$ORACLE_HOME/jdk目录下的jre的默认字体
cd $ORACLE_HOME/jdk/jre/lib/
ls font*zh_CN*
font.properties是默认使用的字体
还可以看到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下的默认字体
cd $ORACLE_HOME/jre/1.4.2/lib/
ls font*zh_CN*
font.properties是默认使用的字体
还可以看到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页面中用到),注意不要删错目录
cd $ORACLE_HOME/oc4j/j2ee/oc4j_applications/applications/em/em/cabo/images/cache/zhs/
ls *.gif
rm -f *.gif
4. 重新启动EM服务
cd $ORACLE_HOME/bin/
./emctl stop dbconsole
./emctl start dbconsole
好可以进入em web页面看看是否中文不再是 "□□"字样的乱码了！
=====================================================
以下的 J2EE 应用程序已经配置, 并且可用下面列出的 URL 来访问。
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
\==========================================
最近有机会在安腾机上折腾，试验了一下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
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官方文件解释:物理内存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方法文档介绍--------------------
编辑文件 /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
# 开始安装
./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
========================================
常见问题:
网页界面上的按钮出现“口口”的乱码
解决方案：
1.停止服务,emctl stop dbconsole;
2.把相关目录（RHEL4里面是/etc/java/）下的font.properties用
font.properties.zh_CN.Redhat8.0替换(或font.properties.zh，只要是中文简体就可以。）;
3.删除
$ORACLE_HOME/oc4j/j2ee/oc4j_applications/applications/em/em/cabo/images/cache/zhs中的gif文件
;
4.重起服务（最好是重启服务器） emctl start dbconsole;
/etc/oratab的内容
orcl:/oracle/10.2.0/db_1:Y
在安装完oracle10g后，由于jre默认使用的字体问题，使得em,dbca,netca,netmgr显示中文时出现"□□"字样的乱码，下面来说明这个问题的解决办法：
1. 改变$ORACLE_HOME/jdk目录下的jre的默认字体
cd $ORACLE_HOME/jdk/jre/lib/
ls font*zh_CN*
font.properties是默认使用的字体
还可以看到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下的默认字体
cd $ORACLE_HOME/jre/1.4.2/lib/
ls font*zh_CN*
font.properties是默认使用的字体
还可以看到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页面中用到),注意不要删错目录
cd $ORACLE_HOME/oc4j/j2ee/oc4j_applications/applications/em/em/cabo/images/cache/zhs/
ls *.gif
rm -f *.gif
4. 重新启动EM服务
cd $ORACLE_HOME/bin/
./emctl stop dbconsole
./emctl start dbconsole
好可以进入em web页面看看是否中文不再是 "□□"字样的乱码了！
=====================================================
以下的 J2EE 应用程序已经配置, 并且可用下面列出的 URL 来访问。
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
\==========================================
