oracle11.2.0.4安装前系统参数配置.sql
oracle11.2.0.4在centos6.0上安装相关脚本.sql
一. 系统分区
/boot 200MB
/SWAP 内存的2倍(6000MB)
/ 其它所有
需要的软件包:
pdksh-5.2.14-37.el5_8.1.x86_64.rpm
安装pdksh包(该程序包未被纳入CentOS的安装盘中):
使用命令:wget ftp://rpmfind.net/linux/centos/5.9/os/x86_64/CentOS/pdksh-5.2.14-37.el5_8.1.x86_64.rpm 将pdksh程序包下载到本地
wget ftp://rpmfind.net/linux/centos/5.9/os/x86/CentOS/pdksh-5.2.14-37.el5_8.1.x86.rpm
[root@demo /]# rpm -ivh pdksh-5.2.14-37.el5_8.1.x86_64.rpm
二. 检查网络配置及YUM源
[root@platformdb01 ~]# cat /etc/sysconfig/network-scripts/ifcfg-eth0
DEVICE="eth0"
HWADDR="08:00:27:46:DE:B5"
NM_CONTROLLED="yes"
ONBOOT="yes"
BOOTPROTO=static
IPADDR=192.168.56.11
NETMASK=255.255.255.0
GATEWAY=192.168.56.1
DNS1=8.8.8.8
--=======================
DEVICE="eth1"
HWADDR="08:00:27:46:DE:B5"
NM_CONTROLLED="yes"
ONBOOT="yes"
BOOTPROTO=static
IPADDR=192.168.9.11
NETMASK=255.255.252.0
GATEWAY=192.168.10.253
DNS1=8.8.8.8
DNS1=8.8.8.8
[root@platformdb01 ~]# cat /etc/resolv.conf
# Generated by NetworkManager
nameserver 172.18.3.1
[root@platformdb01 ~]# cd /etc/yum.repos.d
[root@platformdb01 yum.repos.d]# ll
总用量 12
-rw-r--r--. 1 root root 1926 7月 3 2011 CentOS-Base.repo
-rw-r--r--. 1 root root 637 7月 3 2011 CentOS-Debuginfo.repo
-rw-r--r--. 1 root root 626 7月 3 2011 CentOS-Media.repo
修改计算机名:
Vi /etc/sysconfig/network中hostname改为,然后重启服务器
--配置YUM源
四,安装步骤
1.
yum install –y binutils* compat-libstdc++* gcc* ksh* libaio* libgcc* libstdc++ make* numactl-devel* sysstat* libaio-devel* unixODBC-devel*
yum install elfutils-libelf-devel
yum install glibc-utils*
--==========================执行下面这个,会提示有包没有找到
yum install elfutils-libelf*
yum install unixODBC*
elfutils-libelf-devel-static-0.148-1.el6.x86_64 --没有
unixODBC-kde-2.2.14-11.el6.x86_64 -- 没有
glibc-static-2.12-1.7.el6.x86_64 --这个包也没有
最后发现:这几个包不要没事的,不影响DB安装的
[root@CAH_Database3 U03]# rpm -ivh pdksh-5.2.14-37.el5_8.1.x86_64.rpm
warning: pdksh-5.2.14-37.el5_8.1.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID e8562897: NOKEY
error: Failed dependencies:
pdksh conflicts with ksh-20120801-28.el6_7.3.x86_64
[root@CAH_Database3 U03]# rpm -qa | grep ksh
ksh-20120801-28.el6_7.3.x86_64
[root@CAH_Database3 U03]# rpm -e ksh-20120801-28.el6_7.3.x86_64
查询rpm –qa | grep lib
2.创建ORCLE用户
[root@platformdb01 ~]# groupadd oinstall
[root@platformdb01 ~]# groupadd dba
[root@platformdb01 ~]# useradd -g oinstall -G dba oracle
[root@platformdb01 ~]# passwd oracle
3.修改sysctl.conf(路径:/etc/sysctl.conf)
#for oracle
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
[root@platformdb01 ~]# sysctl -p
Setting Kernel Parameters...
kernel.shmmax = 536870912
kernel.shmmax = 1052530688 --right
4.资源限制
[root@platformdb01 ~]# vi /etc/security/limits.conf
#for oracle
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle hard stack 10240
6.创建ORCLCE相关目录
[root@platformdb01 u01]# mkdir -p /u01/oracle/oracle11g
[root@platformdb01 u01]# chown -R oracle:oinstall /u01
[root@platformdb01 u01]# chmod -R 775 /u01
7.设置环境变量
[root@platformdb01 ~]# su - oracle
[oracle@platformdb01 ~]$ vi .bash_profile
# for oracle
ORACLE_BASE=/u01/oracle
ORACLE_HOME=$ORACLE_BASE/oracle11g
ORACLE_SID=dcms
PATH=$ORACLE_HOME/bin:$PATH
NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"
NLS_LANG=American_america.AL32UTF8
#NLS_LANG="American_America".ZHS16GBK
EDITOR=vi
export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH NLS_DATE_FORMAT NLS_LANG EDITOR
source .bash_profile
8.解压数据库
mkdir /sf
chown -R oracle:oinstall /sf
Cd /u01
[oracle@platformdb01 ~]$ unzip linux.x64_11gR2_database_1of2.zip
[oracle@platformdb01 ~]$ unzip linux.x64_11gR2_database_2of2.zip
xhost +
9.用Xmanager进行安装
export DISPLAY=192.168.9.177:0.0
export LANG=en_us
[root@demo ~]# su - oracle
[oracle@demo ~]$ export DISPLAY=192.168.9.177:0.0
[oracle@demo ~]$ xclock
Warning: Missing charsets in String to FontSet conversion
--看看能不能调出图形化界面
./runInstaller进行安装
6.归档与rman恢复目录路径的设置
SQL> alter system set log_archive_dest_1='location=/rman/arch/';
shutdown immediate;
startup mount; (在mount状态下进行归档设置)
alter database archivelog;
alter database open;
alter system switch logfile;
alter system archive log current;
---下面是安装过程中遇到的问题:
[oracle@demo database]$ ./runInstaller
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB. Actual 30493 MB Passed
Checking swap space: must be greater than 150 MB. Actual 4095 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2016-05-05_03-37-00AM. Please wait ...[oracle@demo database]$ #
# An unexpected error has been detected by HotSpot Virtual Machine:
#
# SIGSEGV (0xb) at pc=0x00007f1ad1a84da0, pid=2384, tid=139752489056016
#
# Java VM: Java HotSpot(TM) 64-Bit Server VM (1.5.0_51-b10 mixed mode)
# Problematic frame:
# C [ld-linux-x86-64.so.2+0x14da0]
#
# An error report file with more information is saved as hs_err_pid2384.log
#
# If you would like to submit a bug report, please visit:
# http://java.sun.com/webapps/bugreport/crash.jsp
解决方法如下:在运行runInstaller之前,先设定如下的环境变量。
$ export LD_BIND_NOW=1
这个环境变量的作用是,让连接器在程序执行前把所有的函数地址都连接好。
这个原因看起来好像和安装Oracle没什么关系,但是,确实能解决问题。
解决方法如下:在运行runInstaller之前,先设定如下的环境变量。