操作系统centos6.5
oracle:11g
一、检查安装oracle所需的rpm包
二、环境配置
ROOT用户下操作
1)修改用户的SHELL的限制,修改/etc/security/limits.conf文件
[root@localhost /]# vi /etc/security/limits.conf
添加以下内容
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
2)修改/etc/pam.d/login 文件
[root@localhost /]# vi /etc/pam.d/login
添加以下内容
session required pam_limits.so
3)修改/etc/profile
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
4)修改linux内核,修改/etc/sysctl.conf文件。
[root@localhost /]# vi /etc/sysctl.conf
fs.file-max = 6815744
fs.aio-max-nr = 1048576
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
5)要使/etc/sysctl.conf 更改立即生效,执行以下命令。
[root@localhost etc]# 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
error: "net.bridge.bridge-nf-call-ip6tables" is an unknown key
error: "net.bridge.bridge-nf-call-iptables" is an unknown key
error: "net.bridge.bridge-nf-call-arptables" is an unknown key
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 68719476736
kernel.shmall = 4294967296
fs.file-max = 6815744
fs.aio-max-nr = 1048576
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
6)创建相关用户和组
[root@localhost ~]# groupadd oinstall
[root@localhost ~]# groupadd dba
[root@localhost ~]# groupadd oper
[root@localhost ~]# useradd -g oinstall -G dba oracle
[root@localhost ~]# passwd oracle
7)创建oracle安装文件夹
[root@localhost ~]# mkdir -p /u01/app/oracle/product/11.2/db_1
[root@localhost ~]# mkdir -p /u01/oraInventory
[root@localhost ~]# chown -R oracle:oinstall /u01/
[root@localhost ~]# chmod -R 775 /u01/
8)配置
[root@localhost ~]# vi /home/oracle/.bash_profile
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=$ORACLE_BASE/product/11.2/db_1
ORACLE_SID=orcl
PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH
oracle 用户 生效环境变量
source ~/.bash_profile
9)检查网络
/etc/hosts
/etc/sysconfig/network
/etc/sysconfig/network-scripts/ifcfg-eth0
三 配置应答文件db_install.rsp
应答文件的默认模板目录response在解压后database目录下。
主要配置内容如下:
oracle.install.option --安装类型
1.只装数据库软件(INSTALL_DB_SWONLY) 2.安装数据库软件并建库(INSTALL_DB_AND_CONFIG) 3.升级数据库 (UPGRADE_DB)
oracle.install.option= INSTALL_DB_SWONLY
指定操作系统主机名,通过hostname命令获得
ORACLE_HOSTNAME=oracle
指定oracle inventory 目录的所有者通常是oinstall 或dba
UNIX_GROUP_NAME=oinstall
指定产品清单oracle inventory目录路径,win平台可以省略
INVENTORY_LOCATION=
指定数据库语言,可以选择多个,用逗号隔开。选择en,zh_CH
SELECTED_LANGUAGES=en,zh_CH
设置ORACLE_HOME的路径
ORACLE_HOME=
设置ORACLE_BASE的路径
ORACLE_BASE=
选择Oracle安装数据库软件版本
oracle.install.db.InstallEdition=
指定拥有OSDBA、OSOPER权限用户组,通常回事dba组
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=oinstall
如果是安装RAC,在这里指定所有节点
oracle.install.db.CLUSTER_NODES=node1,node2
建立监听
[oracle@oracle /]$ netca /silent /responsefile /u01/database/response/netca.rsp
Parsing command line arguments:
Parameter "silent" = true
Parameter "responsefile" = /u01/database/response/netca.rsp
Done parsing command line arguments.
Oracle Net Services Configuration:
Profile configuration complete.
Oracle Net Listener Startup:
Running Listener Control:
/u01/app/oracle/product/11.2.0/db_1/bin/lsnrctl start LISTENER
Listener Control complete.
Listener started successfully.
Listener configuration complete.
Oracle Net Services configuration successful. The exit code is 0
[oracle@oracle /]$ dbca -silent -responseFile /u01/database/response/dbca.rsp
Enter SYS user password:
Enter SYSTEM user password:
Copying database files
1% complete
3% complete
11% complete
18% complete
26% complete
37% complete
Creating and starting Oracle instance
40% complete
45% complete
50% complete
55% complete
56% complete
60% complete
62% complete
Completing Database Creation
66% complete
70% complete
73% complete
85% complete
96% complete
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/orcl11g/orcl11g.log" for further details.
oracle:11g
一、检查安装oracle所需的rpm包
二、环境配置
ROOT用户下操作
1)修改用户的SHELL的限制,修改/etc/security/limits.conf文件
[root@localhost /]# vi /etc/security/limits.conf
添加以下内容
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
2)修改/etc/pam.d/login 文件
[root@localhost /]# vi /etc/pam.d/login
添加以下内容
session required pam_limits.so
3)修改/etc/profile
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
4)修改linux内核,修改/etc/sysctl.conf文件。
[root@localhost /]# vi /etc/sysctl.conf
fs.file-max = 6815744
fs.aio-max-nr = 1048576
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
5)要使/etc/sysctl.conf 更改立即生效,执行以下命令。
[root@localhost etc]# 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
error: "net.bridge.bridge-nf-call-ip6tables" is an unknown key
error: "net.bridge.bridge-nf-call-iptables" is an unknown key
error: "net.bridge.bridge-nf-call-arptables" is an unknown key
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 68719476736
kernel.shmall = 4294967296
fs.file-max = 6815744
fs.aio-max-nr = 1048576
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
6)创建相关用户和组
[root@localhost ~]# groupadd oinstall
[root@localhost ~]# groupadd dba
[root@localhost ~]# groupadd oper
[root@localhost ~]# useradd -g oinstall -G dba oracle
[root@localhost ~]# passwd oracle
7)创建oracle安装文件夹
[root@localhost ~]# mkdir -p /u01/app/oracle/product/11.2/db_1
[root@localhost ~]# mkdir -p /u01/oraInventory
[root@localhost ~]# chown -R oracle:oinstall /u01/
[root@localhost ~]# chmod -R 775 /u01/
8)配置
[root@localhost ~]# vi /home/oracle/.bash_profile
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=$ORACLE_BASE/product/11.2/db_1
ORACLE_SID=orcl
PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH
oracle 用户 生效环境变量
source ~/.bash_profile
9)检查网络
/etc/hosts
/etc/sysconfig/network
/etc/sysconfig/network-scripts/ifcfg-eth0
三 配置应答文件db_install.rsp
应答文件的默认模板目录response在解压后database目录下。
主要配置内容如下:
oracle.install.option --安装类型
1.只装数据库软件(INSTALL_DB_SWONLY) 2.安装数据库软件并建库(INSTALL_DB_AND_CONFIG) 3.升级数据库 (UPGRADE_DB)
oracle.install.option= INSTALL_DB_SWONLY
指定操作系统主机名,通过hostname命令获得
ORACLE_HOSTNAME=oracle
指定oracle inventory 目录的所有者通常是oinstall 或dba
UNIX_GROUP_NAME=oinstall
指定产品清单oracle inventory目录路径,win平台可以省略
INVENTORY_LOCATION=
指定数据库语言,可以选择多个,用逗号隔开。选择en,zh_CH
SELECTED_LANGUAGES=en,zh_CH
设置ORACLE_HOME的路径
ORACLE_HOME=
设置ORACLE_BASE的路径
ORACLE_BASE=
选择Oracle安装数据库软件版本
oracle.install.db.InstallEdition=
指定拥有OSDBA、OSOPER权限用户组,通常回事dba组
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=oinstall
如果是安装RAC,在这里指定所有节点
oracle.install.db.CLUSTER_NODES=node1,node2
oracle.install.db.isRACOneInstall=
oracle.install.db.racOneServiceName=
选择数据库的用途,一般/事物处理,数据仓库
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
指定GlobalName
oracle.install.db.config.starterdb.globalDBName=ora11g
指定SID
oracle.install.db.config.starterdb.SID=ora11g
选择字符集。不正确的字符集会给数据显示和存储带来麻烦无数。
通常中文选择有ZHS16GBK简体中午库,建议选择unicode和AL32UTF8国际字符集
oracle.install.db.config.starterdb.characterSet=AL32UTF8
11g新特性自动内存管理
oracle.install.db.config.starterdb.memoryOption=true
是否载入模板实例
oracle.install.db.config.starterdb.installExampleSchemas=false
指定Oracle自动管理内存的大小,最小为256M
oracle.install.db.config.starterdb.memoryLimit=
是否启用安装设置
oracle.install.db.config.starterdb.enableSecuritySettings=true
以上参数含义应答文件里面有详细说明。如需其他功能 可以参照应答文件里面的说明,酌情配置。
[oracle@oracle database]$ ./runInstaller -silent -responseFile /soft/database/response/db_install.rsporacle.install.db.racOneServiceName=
选择数据库的用途,一般/事物处理,数据仓库
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
指定GlobalName
oracle.install.db.config.starterdb.globalDBName=ora11g
指定SID
oracle.install.db.config.starterdb.SID=ora11g
选择字符集。不正确的字符集会给数据显示和存储带来麻烦无数。
通常中文选择有ZHS16GBK简体中午库,建议选择unicode和AL32UTF8国际字符集
oracle.install.db.config.starterdb.characterSet=AL32UTF8
11g新特性自动内存管理
oracle.install.db.config.starterdb.memoryOption=true
是否载入模板实例
oracle.install.db.config.starterdb.installExampleSchemas=false
指定Oracle自动管理内存的大小,最小为256M
oracle.install.db.config.starterdb.memoryLimit=
是否启用安装设置
oracle.install.db.config.starterdb.enableSecuritySettings=true
以上参数含义应答文件里面有详细说明。如需其他功能 可以参照应答文件里面的说明,酌情配置。
建立监听
[oracle@oracle /]$ netca /silent /responsefile /u01/database/response/netca.rsp
Parsing command line arguments:
Parameter "silent" = true
Parameter "responsefile" = /u01/database/response/netca.rsp
Done parsing command line arguments.
Oracle Net Services Configuration:
Profile configuration complete.
Oracle Net Listener Startup:
Running Listener Control:
/u01/app/oracle/product/11.2.0/db_1/bin/lsnrctl start LISTENER
Listener Control complete.
Listener started successfully.
Listener configuration complete.
Oracle Net Services configuration successful. The exit code is 0
[oracle@oracle /]$ dbca -silent -responseFile /u01/database/response/dbca.rsp
Enter SYS user password:
Enter SYSTEM user password:
Copying database files
1% complete
3% complete
11% complete
18% complete
26% complete
37% complete
Creating and starting Oracle instance
40% complete
45% complete
50% complete
55% complete
56% complete
60% complete
62% complete
Completing Database Creation
66% complete
70% complete
73% complete
85% complete
96% complete
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/orcl11g/orcl11g.log" for further details.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28282660/viewspace-1458539/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/28282660/viewspace-1458539/