现在的位置: 首页 > 综合 > 正文

Linux AS 5.4安装oracle10g 方法

2017年09月17日 ⁄ 综合 ⁄ 共 6067字 ⁄ 字号 评论关闭

Linux AS 5.4安装oracle10g 方法

Linux AS 5.4安装oracle10g 方法
Oracle Database 10g Release 2 (10.2.0.1) Installation On Red Hat Enterprise Linux 5 (RHEL5)

一安装需求
1.swap 分区不低于2G
2.selinux 状态disable
3.物理内存不低于512M

系统组件

GNOME Desktop Environment
Editors
Graphical Internet
Text-based Internet
Development Libraries
Development Tools
Legacy Software Development
Server Configuration Tools
Administration Tools
Base
Legacy Software Support
System Tools
X Window System
二安装过程
1.软件下载
http://www.oracle.com/technology/software/products/database/oracle10g/index.html
2.解包
unzip 10201_database_linux32.zip
3. host配置
vi /etc/hosts
中的127.0.0.1改成192.168.0.6

vi /etc/sysctl.conf file:

kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.rmem_max=262144
net.core.wmem_default=262144
net.core.wmem_max=262144
运行下面命令使设置生效/sbin/sysctl -p
vi /etc/security/limits.conf
* soft nproc 2047
* hard nproc 16384
* soft nofile 1024
* hard nofile 65536
 
vi /etc/pam.d/login

session required /lib/security/pam_limits.so

vi /etc/selinux/config

SELINUX=disabled

安装下面的rpm包
# From RedHat AS5 Disk 1
cd /media/cdrom/Server
rpm -Uvh setarch-2*
rpm -Uvh make-3*
rpm -Uvh glibc-2*
rpm -Uvh libaio-0*
cd /
eject
# From RedHat AS5 Disk 2
cd /media/cdrom/Server
rpm -Uvh compat-libstdc++-33-3*
rpm -Uvh compat-gcc-34-3*
rpm -Uvh compat-gcc-34-c++-3*
rpm -Uvh gcc-4*
rpm -Uvh libXp-1*
cd /
eject

# From RedHat AS5 Disk 3
cd /media/cdrom/Server
rpm -Uvh openmotif-2*
rpm -Uvh compat-db-4*
cd /
eject

建立oracle用户和组

groupadd oinstall
groupadd dba
groupadd oper
add -g oinstall -G dba oracle
passwd oracle
建立相应的目录
mkdir -p /u01/app/oracle/product/10.2.0/db_1
chown -R oracle.oinstall /u01

编辑/etc/redhat-release
vi /etc/redhat-release
Red Hat Enterprise Linux Server release 5 (Tikanga) 被 Red Hat Enterprise Linux Server release 4 (Tikanga) 替换

登陆oracle 建立相应的环境变量

su - oracle
vi ~/.bash_profile

# Oracle Settings
TMP=/tmp;export TMP
TMPDIR=$TMP; export TMP
DIRORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1;
export ORACLE_HOME
ORACLE_SID=test10g;
export ORACLE_SID
ORACLE_TERM=xterm;
export ORACLE_TERM
PATH=/usr/sbin$PATH;
PATH=$ORACLE_HOME/bin$PATH;
export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;
export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlibORACLE_HOME/rdbms/jlib;
export DISPLAY=100.100.10.27:0.0
export LANG=AMRICAN
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
开始安装
设置显示位置
DISPLAY=:0.0; export DISPLAY
启动安装程序
./runInstaller
安装过程

Select Installation Method
Specify Inventory Directory and Credentials
Select Installation Type
Specify Home Details
Product-Specific Prerequisite Checks
Select Configuration Option
Select Database Configuration
Specify Database Configuration Options
Select Database Management Option
Specify Database Storage Option
Specify Backup and Recovery Options
Specify Database Schema Passwords
Summary
Install
Configuration Assistants
Database Configuration Assistant
Database Configuration Assistant Password Management
Execute Configuration Scripts
End Of Installation
安装结束后修改vi /etc/redhat-release 内容为
Red Hat Enterprise Linux Server release 5 (Tikanga)
设置开机启动vi /etc/oratab
TSH1:/u01/app/oracle/product/10.2.0/db_1:Y
启动监听
可在/etc/rc.d/rc.local中加入如下
su - oracle -c "/u01/app/oracle/product/10.2.0/db_1/bin/lsnrctl start"

su - oracle -c "/u01/app/oracle/product/10.2.0/db_1/bin/dbstart start"
先设置ORACLE_SID环境变量后,启动EM console服务
emctl start dbconsole
emctl stop dbconsole
emctl status dbconsole
配置dbconsole的步骤
emca -repos create
emca -config dbcontrol db
emctl start dbconsole
重新配置dbconsole的步骤
emca -repos drop
emca -repos create
emca -config dbcontrol db
emctl start dbconsole
当emctl stop dbconsole
失败时候,修改 vi /etc/hosts 中的IP为127.0.0.1

当EM图片为乱码的时候
参看oracle10gEM乱码解决方案

CREATE USER username IDENTIFIED BY passwd

grant dba to username;
grant unlimited tablespace to username;
grant select any table to username;
grant select any dictionary to username;
grant create session to username;

2.oracle10G 中EM图片乱码解决方案 
 据说,如果安装时,我们系统环境变量设置的是中文环境(而我的RHEL5.2恰恰是选择的英文环境),那么就不会有这个问题。这个问题根本原因在于安装时,JDK/JRE字符集的自动选择。还好有网络,有Google,经过搜索,有很多关于这个问题的解决办法(但大多是同一篇文章)。照葫芦画瓢,跟着做吧:

    在 $ORACLE_HOME/jdk/jre/lib 和 $ORACLE_HOME/jre/1.4.2/lib目录下都有多种字符集字体配置文件:

[oracle@RHEL ~]$ cd $ORACLE_HOME/jdk/jre/lib
[oracle@RHEL lib]$ ls font*zh_CN*
font.properties.zh_CN.Redhat     font.properties.zh_CN.Sun
font.properties.zh_CN.Redhat2.1  font.properties.zh_CN_UTF8.Sun
[oracle@RHEL lib]$ cd $ORACLE_HOME/jre/1.4.2/lib/
[oracle@RHEL 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.Sun来替换缺省字体定义文件:

[oracle@RHEL lib]$ cp font.properties font.properties.bak 
[oracle@RHEL lib]$ cp font.properties.zh_CN.Sun font.properties 
    替换之后需要清理一下Cache,重启EM即可.

    Cache路径通常位于:

$ORACLE_HOME/oc4j/j2ee/oc4j_applications/applications/em/em/cabo/images/cache/zhs 

    清除所有gif文件即可.然后重新启动EM:

[oracle@RHEL lib]$ emctl stop dbconsole
TZ set to UTC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
http://RHEL.smnpc.com:1158/em/console/aboutApplication
Stopping Oracle Enterprise Manager 10g Database Control ...
 ...  Stopped.
[oracle@RHEL lib]$ emctl start dbconsole
TZ set to UTC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
http://RHEL.smnpc.com:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ........................ started.

------------------------------------------------------------------
Logs are generated in directory /usr/app/oracle/product/10.2.0/db_1/RHEL.smnpc.com_orcl/sysman/log

    按照网络上的说法,只要重新登录EM,那么就应该显示正常了。但是,世界上的事终究不是那么一帆风顺,按照古人的说法就是前途光明,道路曲折,问题依然存在。又找了N久,还是没找到解决办法。想来想去,还是觉得这条路或者思路应该是正确的,问题是出在某个地方。查看font.properties(也就是font.properties.zh_CN.Sun)的内容,发现了其中端倪:

filename.-misc-fzsongti-medium-r-normal--*-%d-*-*-p-*-gbk-0=/usr/X11R6/lib/X11/fonts/truetype/songti_gb.ttf
appendedfontpath=/usr/X11R6/lib/X11/fonts/truetype

  恍然大悟,因为这个字体文件根本不存在。修改成已有的中文字体文件:
#filename.-misc-fzsongti-medium-r-normal--*-%d-*-*-p-*-gbk-0=/usr/X11R6/lib/X11/fonts/truetype/songti_gb.ttf
filename.-misc-fzsongti-medium-r-normal--*-%d-*-*-p-*-gbk-0=/usr/share/fonts/chinese/TrueType/uming.ttf
# appendedfontpath=/usr/X11R6/lib/X11/fonts/truetype
appendedfontpath=/usr/share/fonts/chinese/TrueType

    再次重启EM,登录。OMG,正常了

抱歉!评论已关闭.