linux 安装oracle11g 命令

安装Linux AS5 U3操作系统,选择定制安装,只要按基本的X窗口,GHOME桌面

磁盘分区和硬件信息

内存 1GB 硬盘 IDE 80GB

/boot  100M
swap   2048M
/      剩余空间

(安装的oracle数据库用户测试开发,因此没有对分区进行细分,实际按oracle的要求还需要分区/u01安装数据库软件 /u02存放数据文件)

安装rpm包的顺序(DVD光盘中)
rpm -Uvh libgomp-4.3.2-7.el5.i386.rpm
rpm -Uvh kernel-headers-2.6.18-128.el5.i386.rpm
rpm -Uvh glibc-headers-2.5-34.i386.rpm
rpm -Uvh glibc-devel-2.5-34.i386.rpm

rpm -Uvh glibc-common-2.5-34.i386.rpm  (可能已安装)
rpm -Uvh glibc-2.5-34.i386.rpm  (可能已安装)

rpm -Uvh libstdc++-devel-4.1.2-44.el5.i386.rpm
rpm -Uvh libstdc++-4.1.2-44.el5.i386.rpm (可能已安装)
rpm -Uvh gcc-4.1.2-44.el5.i386.rpm
rpm -Uvh gcc-c++-4.1.2-44.el5.i386.rpm

rpm -Uvh binutils-2.17.50.0.6-9.el5.i386.rpm (可能已安装)
rpm -Uvh compat-libstdc++-33-3.2.3-61.i386.rpm (可能已安装)
rpm -Uvh make-3.81-3.el5.i386.rpm (可能已安装)

rpm -Uvh sysstat-7.0.2-3.el5.i386.rpm

rpm -Uvh elfutils-libelf-0.137-3.el5.i386.rpm (可能已安装)
rpm -Uvh elfutils-libelf-devel-0.137-3.el5.i386.rpm elfutils-libelf-devel-static-0.137-3.el5.i386.rpm (注意,一起安装这两个包)

rpm -Uvh libaio-devel-0.3.106-3.2.i386.rpm
rpm -Uvh libaio-0.3.106-3.2.i386.rpm (可能已安装)

rpm -Uvh unixODBC-2.2.11-7.1.i386.rpm
rpm -Uvh unixODBC-devel-2.2.11-7.1.i386.rpm


查询软件包是否已安装
[root@hebzhjg Server]# rpm -qa | grep 'binutils*'
binutils-2.17.50.0.6-9.el5
[root@hebzhjg Server]#
[root@hebzhjg Server]# rpm -qa | grep 'compat*'
avahi-compat-libdns_sd-0.6.16-1.el5
compat-libstdc++-33-3.2.3-61
compat-libstdc++-296-2.96-138
compat-libgcc-296-2.96-138
[root@hebzhjg Server]# rpm -qa | grep 'elfutils*'
elfutils-libelf-devel-0.137-3.el5
elfutils-libelf-0.137-3.el5
elfutils-libelf-devel-static-0.137-3.el5
[root@hebzhjg Server]# rpm -qa | grep 'gcc*'
pkgconfig-0.21-2.el5
dejavu-lgc-fonts-2.10-1
libgcc-4.1.2-44.el5
gnome-python2-gconf-2.16.0-1.fc6
gcc-4.1.2-44.el5
gcc-c++-4.1.2-44.el5
libgcrypt-1.2.4-1.el5
compat-libgcc-296-2.96-138
gcalctool-5.8.25-1.el5
[root@hebzhjg Server]# rpm -qa | grep 'libaio*'
libaio-devel-0.3.106-3.2
libaio-0.3.106-3.2
[root@hebzhjg Server]# rpm -qa | grep 'libgcc*'
libgcc-4.1.2-44.el5
libgcrypt-1.2.4-1.el5
compat-libgcc-296-2.96-138
[root@hebzhjg Server]# rpm -qa | grep 'libstdc*'
libstdc++-4.1.2-44.el5
compat-libstdc++-33-3.2.3-61
libstdc++-devel-4.1.2-44.el5
compat-libstdc++-296-2.96-138
[root@hebzhjg Server]# rpm -qa | grep 'make*'
make-3.81-3.el5
[root@hebzhjg Server]# rpm -qa | grep 'sysstat*'
sysstat-7.0.2-3.el5
[root@hebzhjg Server]# rpm -qa | grep 'unix*'
unix2dos-2.2-26.2.2
dos2unix-3.1-27.1
unixODBC-devel-2.2.11-7.1
unixODBC-2.2.11-7.1

 

修改系统内核参数

在/etc/sysctl.conf 文件的末尾添加下面设置

####################################################
# Install oracle11g add by hebzhjg
kernel.shmmni = 4096
 
# semaphores: semmsl,semmns,semopm,semmni
kernel.sem = 250 32000 100 128
 
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 262144


运行 sysctl -p 生效设置
[root@hebzhjg etc]# /sbin/sysctl -p
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 4294967295
kernel.shmall = 268435456
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 262144


修改安全权限设置参数

在/etc/security/limits.conf 文件的末尾添加下面设置

########################################
# Install oracle add
oracle          soft    nproc   2047
oracle          hard    nproc   16384
oracle          soft    nofile  1024
oracle          hard    nofile  65536

在/etc/pam.d/login 文件末尾添加下面设置

###########################################
# Install oracle add
session    required     /lib/security/pam_limits.so
session    required     pam_limits.so

禁用 SELINUX
修改 /etc/selinux/config

SELINUX=disabled
SELINUXTYPE=targeted


创建oracle的用户组和用户

[root@hebzhjg /]# groupadd oinstall
[root@hebzhjg /]# groupadd dba
[root@hebzhjg /]# groupadd oper
[root@hebzhjg /]# groupadd asmadmin
[root@hebzhjg /]# useradd -g oinstall -G dba,oper,asmadmin oracle

修改 oracle 用户密码
[root@hebzhjg /]# passwd oracle
Changing password for user oracle.

设置密码:oracleroot

创建安装 oracle 数据库的目录和存放数据文件的目录

[root@hebzhjg opt]# mkdir -p /opt/app/oracle/product/11.1.0/db_1
[root@hebzhjg opt]# chown -R oracle:oinstall /opt/app
[root@hebzhjg opt]# chmod -R 755 /opt/app/

[root@hebzhjg opt]# ls -l
总计 28
drwxr-xr-x 3 oracle oinstall  4096 03-13 17:16 app

用户oracle用户登录,在home目录下编辑 .bash_profile 文件

cd ~
vi .bash_profile

添加如下设置

# Oracle Settings
TMP=/tmp;       export TMP
TMPDIR=$TMP;    export TMPDIR
 
ORACLE_HOSTNAME=hebzhjg; export ORACLE_HOSTNAME
ORACLE_BASE=/opt/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1; export ORACLE_HOME
ORACLE_SID=orcl; export ORACLE_SID     (注意这里的ORACLE_SID要与安装时的匹配,否则可能无法启动em)
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export 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/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
 
if [[ $USER = "oracle" ]]; then
   if [[ $SHEEL = "/bin/ksh" ]]; then
      ulimit -p 16384
      ulimit -u 65536
   else
      ulimit -u 16384 -n 65536
   fi
fi

 

装载数据库光盘,用oracle用户登录GUI界面安装

注意,选择 单cpu安装类型,否则可能安装失败

安装后配置oracle数据库自动启动

修改 /etc/oratab 文件

# vi /etc/oratab
修改 orcl:/opt/app/oracle/product/11.1.0/db_1:N
最后的N为Y

在 /etc/init.d 创建oracle的启动脚步

# vi /etc/init.d/oracle

#!/bin/sh
# chkconfig: 345 99 10
# description: Oracle auto start-stop script.
#
# Set ORA_HOME to be equivalent to the $ORACLE_HOME
# from which you wish to execute dbstart and dbshut;
#
# Set ORA_OWNER to the user id of the owner of the
# Oracle database in ORA_HOME.
 
ORA_HOME=/opt/app/oracle/product/11.1.0/db_1
ORA_OWNER=oracle
 
if [ ! -f $ORA_HOME/bin/dbstart ]
then
    echo "Oracle startup: cannot start"
    exit
fi
 
case "$1" in
    'start')
        # Start the Oracle databases:
        # The following command assumes that the oracle login
        # will not prompt the user for any values
        echo "Start oracle database ..."
        su - $ORA_OWNER -c "$ORA_HOME/bin/dbstart $ORA_HOME"
        ;;
    'stop')
        # Stop the Oracle databases:
        # The following command assumes that the oracle login
        # will not prompt the user for any values
        echo "Stop oracle database ..."
        su - $ORA_OWNER -c "$ORA_HOME/bin/dbshut $ORA_HOME"
        ;;
esac


启动和停止 oracel em 控制台

emctl start dbconsole
emctl stop dbconsole


启动em失败时,可能是主机名没有在host中,修改/etc/hosts文件

127.0.0.1 localhost yourhostname
192.168.0.222 localhost yourhostname

 

安装过程中出现"显示器检验无法通过  " 注销后 切换到oracle

用户重新安装.(检测xdpinfo文件是否存在)

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值