Oracle 11g静默安装最全文档
SUSE Linux Enterprise 11SP1静默安装Oracle 11gR2说明文档

SUSE Linux Enterprise 11SP1静默安装Oracle 11gR2说明文档1准备oracle安装文件Oracle11gR2包含两个文件linux_11gR2_database_1of2.zip和linux_11gR2_database_2of2.zip,下载地址分别是:/otn/linux/oracle11g/R2/linux_11gR2_database_1of2.zip/otn/linux/oracle11g/R2/linux_11gR2_database_2of2.zip下载完成后将这两个文件通过SSH上传到/usr/local/oracle中。
装程序的目录。
2准备oracle的安装目标目录安装目标目录是用户想将oracle安装到哪个位置的目录,本次我们将oracle安装到/opt/ora cle目录中,以下为目录创建命令。
3创建oracle相关用户和用户组oracle不能在root帐户下进行安装,所以需要为oracle的安装专门创建一个用户,同时需要创建dba和oinstall的用户组。
以下命令将创建dba和oinstall用户组:以下命令将创建oracle用户,并设置密码以下命令将oracle安装目录(/opt/oracle)赋予oracle用户oinstall用户组4检查安装ORACLE依赖的RPM软件包oracle的安装所依赖的软件包,有一部分linux是没有安装的。
这需要将这些尚未安装的软件包先安装后才能正常安装oracle。
这些未安装的软件包在linux安装光盘上可以取到,我们直接在linux的光盘上对这些软件包进行安装(也可将所需的软件包直接复制到linux本地磁盘中),首先我们需要挂载linux光盘,使用以下命令:安装所缺少的软件包,此处只安装本linux系统所缺少的软件包。
如oracle安装过程中,对软件包进行检查时,发现仍有所需软件包未安装时,可根据显示未安装软件包的名字,再次对所缺少的软件包进行安装。
Oracle-11g超详细安装教程

O r a c l e-11g超详细安装教程-CAL-FENGHAI.-(YICAI)-Company One1Oracle 11g的安装准备工作:如果你以前装过Oracle数据库,而且安装目录要改变请先打开注册表编辑器里的:HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\和HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\Oracle11和它下面的几个如果你没安装过Oracle产品的话在注册表里面的与Oracle有关的注册表全删了,如果你安装过Oracle产品,就找与Oracle数据库有关的注册便删了,如果你以前安装过Oracle而没有执行安装前准备的话,在配置数据库的时候会出现各式各样的错误。
首先到网站上下载Oracle 11g官网:下载两个文件放在一个文件夹下解压:打开文件夹,双击下一步:下一步:下一步:下一步:按照上图选择你要安装的语言。
下一步:我们选择安装企业版,内容比较全。
下一步:选择安装目录,按照图片上的,只选择基目录即可。
下一步:我的环境变量有问题,先不用管,选择全部忽略,在这一步之前基本上不会出现问题,如果出现问题请到本文的最后查找。
下一步:保存一下响应文件,哪儿都成。
下一步:这是一个安装过程。
安装完成后,下一步:数据库到这里已经安装完成了。
下面配置数据库:按照图片上的打开软件,下一步:创建数据库。
下一步:下一步:设置全数据库的名称,SID会跟着变,不用设置,下一步:下一步:监听服务没有打开,下面打开监听服务:查看监听服务状态:再回到:确定,下一步:按照图上的做,下一步:下一步:启用归档,长时间保存数据,下一步:勾选示例方案,下一步:下一步:下一步:按照图上的做,目录是自动生成的,下一步:确定:确定:正在创建数据库:管理登录口令:设置各个用户的口令,确定,完成。
验证数据库是否正常:在安装的时候会遇到问题,尤其是在你以前安装过之后,卸载没有完全卸载,遗留的有注册表。
Linux静默安装oracle11g

Linux静默安装oracle11g之前在oracle安装过程中碰到了很多问题,浪费了不少问题,后来有哥同事给了以下安装⽂档,解决了很多多问题,也提到了很多在安装过程中碰到的问题!所以记录⼀下本⽂档是Oracle Database 11.2.0.1 for RHEL5 Server(包括x86和x86_64平台)的静默安装指南. 所有操作⽆需使⽤图形界⾯. 静默安装能减少安装出错的可能性, 也能⼤⼤加快安装速度.# 后跟命令表⽰以操作系统下root⽤户操作;$ 后跟命令表⽰以操作系统下oracle⽤户操作;1.1 上传软件假如放在/wangnc/oracle/11g/⽬录下.# mkdir -p /wangnc/oracle/11g/# cd /wangnc/oracle/11g/可通过SecureFX⼯具sftp上传数据库安装⽂件.1.2 Package安装检查# rpm -q \binutils \compat-libstdc++-33 \elfutils-libelf \elfutils-libelf-devel \expat \gcc \gcc-c++ \glibc \glibc-common \glibc-devel \glibc-headers \libaio \libaio-devel \libgcc \libstdc++ \libstdc++-devel \make \pdksh \sysstat \unixODBC \unixODBC-devel | grep "not installed"1.3 增加数据库组和⽤户# id oracle (确认oracle⽤户是否存在)# /usr/sbin/groupadd oinstall (建⽴产品清单管理组)# /usr/sbin/groupadd dba (建⽴数据库安装组)# /usr/sbin/groupadd asmadmin (建⽴ASM管理组)# /usr/sbin/groupadd asmdba (建⽴Grid管理组)# /usr/sbin/useradd -g oinstall -G dba,asmdba oracle -d /home/oracle (oinstall为主要组,确保/home/oracle原不存在)# id oracle (记住oracle⽤户的uid和gid)uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),504(asmdba)# passwd oracle1.4 调整OS内核参数设置原则:kernel.shmmax 为 4GB-1byte或⼀半的物理内存, 哪个值更低⽤哪个;fs.file-max 为512 * PROCESSES.# vi /etc/sysctl.conf (增加或修改以下参数, 参考值为最⼩需求, kernel.shmmax默认即可⽆需设置 )#------------------------------------------fs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmall = 2097152#kernel.shmmax = 536870912kernel.shmmni = 4096kernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048586#------------------------------------------# /sbin/sysctl -p (设置参数⽴即⽣效)1.5 增加shell限制为了提升性能增加oracle⽤户的shell限制.# vi /etc/security/limits.conf (在⽂件最后增加或修改以下参数)oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536# vi /etc/pam.d/login (在⽂件最后增加或修改以下参数)session required pam_limits.so# vi /etc/profile (在⽂件最后增加或修改以下脚本)if [ $USER = "oracle" ]; thenif [ $SHELL = "/bin/ksh" ]; thenulimit -p 16384ulimit -n 65536elseulimit -u 16384 -n 65536fifi1.6 建⽴必需⽬录# more /etc/oratab (确认原来是否存在Oracle主⽬录)# more /etc/oraInst.loc (确认原来是否存在Oracle产品清单⽬录)# mkdir -p /u01/app/oracle/ (Oracle基础⽬录, ⼀般为/mount_point/app/oracle_owner)# chown -R oracle:oinstall /wangnc/oraclechown -R oracle:oinstall /u01chown -R oracle:oinstall /u02chown -R oracle:oinstall /u03chown -R oracle:oinstall /u04# chmod -R 775 /wangnc/oraclechmod -R 775 /u01chmod -R 775 /u02chmod -R 775 /u03chmod -R 775 /u041.7 设置oracle⽤户环境变量如果服务器有多⽹卡, 注意设置ORACLE_HOSTNAME为某⽹卡IP对应的主机名, 参照/etc/hosts⽂件. # su - oracle$ vi ~/.bash_profileumask 022export ORACLE_HOSTNAME=rhel5export ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1export ORACLE_SID=ORCLexport PATH=.:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/jdk/bin:$PATH export LC_ALL="en_US"export LANG="en_US"export NLS_LANG="AMERICAN_AMERICA.ZHS16GBK"export NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"$ . ~/.bash_profile之前的环境准备与图形安装⼀致,静默安装与图形化安装的区别从此开始1.8 解压Oracle安装⽂件$ cd /wangnc/oracle/11g$ unzip linux*_11gR2_database_1of2.zip -d /u01 (解压到/u01⽬录下,可选⽬录)$ unzip linux*_11gR2_database_2of2.zip -d /u01###记录oracle软件⽬录⽅便操作###$ cd /u01/database$ export DISTRIB=`pwd`在解压后oracle软件的response⽬录⾥有各种响应⽂件的模版.1.9 ⽣成响应⽂件模板1) ⽅法⼀(推荐)$ vi $DISTRIB/db_swonly.rsp#--------------------------------------------------------------------#以下参数不要更改oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0oracle.install.option=INSTALL_DB_SWONLYDECLINE_SECURITY_UPDATES=true#以下参数根据实际情况更改,⼀般也⽆需更改UNIX_GROUP_NAME=oinstallINVENTORY_LOCATION=/u01/app/oracle/oraInventorySELECTED_LANGUAGES=en,zh_CN,zh_TWORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1ORACLE_BASE=/u01/app/oracleoracle.install.db.InstallEdition=EEoracle.install.db.isCustomInstall=trueoracle.install.db.customComponents=oracle.rdbms.partitioning:11.2.0.1.0,oracle.oraolap:11.2.0.1.0,oracle.rdbms.lbac:11.2.0.1.0,oracle.rdbms.dm:11.2.0.1.0,oracle.rdbms.dv:11.2.0.1.0,oracle.rdbms.rat:1 oracle.install.db.DBA_GROUP=dbaoracle.install.db.OPER_GROUP=oinstall#--------------------------------------------------------------------各参数含义如下:-silent 表⽰以静默⽅式安装,不会有任何提⽰-force 允许安装到⼀个⾮空⽬录-noconfig 表⽰不运⾏配置助⼿netca-responseFile 表⽰使⽤哪个响应⽂件,必需使⽤绝对路径oracle.install.responseFileVersion 响应⽂件模板的版本,该参数不要更改oracle.install.option 安装选项,本例只安装oracle软件,该参数不要更改DECLINE_SECURITY_UPDATES 是否需要在线安全更新,设置为false,该参数不要更改ORACLE_HOSTNAME 安装主机名UNIX_GROUP_NAME oracle⽤户⽤于安装软件的组名INVENTORY_LOCATION oracle产品清单⽬录SELECTED_LANGUAGES oracle运⾏语⾔环境,⼀般包括引⽂和简繁体中⽂ORACLE_HOME Oracle安装⽬录ORACLE_BASE oracle基础⽬录oracle.install.db.InstallEdition 安装版本类型,⼀般是企业版oracle.install.db.isCustomInstall 是否定制安装,默认Partitioning,OLAP,RAT都选上了oracle.install.db.customComponents 定制安装组件列表:除了以上默认的,可加上Label Security和Database Vaultoracle.install.db.DBA_GROUP oracle⽤户⽤于授予OSDBA权限的组名oracle.install.db.OPER_GROUP oracle⽤户⽤于授予OSOPER权限的组名2) ⽅法⼆(图形界⾯)$ ./runInstaller &⼀步步设置到Summary页, 然后点击Save Response File按钮, 选择合适的存放路径并Finish后, 回到Summary页, 点击Cancel退出OUI.需要系统的图形化⽀持。
Oracle11G静默安装软件和建库

Oracle11G静默安装软件和建库⼀、准备软件和补丁包p1*******_112040_Linux-x86-64_1of7.zipp1*******_112040_Linux-x86-64_2of7.zipp6880880_112000_Linux-x86-64.zipp2*******_112040_Linux-x86-64.zip⼆、静默安装数据库软件解压数据库软件包,在 /database/response 下⾯有⼀个 db_install.rsp主要做如下修改oracle.install.option=INSTALL_DB_SWONLYORACLE_HOSTNAME=pc #⽤hostname命令查看UNIX_GROUP_NAME=oinstallINVENTORY_LOCATION=/u01/app/oraInventorySELECTED_LANGUAGES=en,zh_CNORACLE_HOME=/u01/app/oracle/product/11.2.0.4/db_1ORACLE_BASE=/u01/app/oracleoracle.install.db.InstallEdition=EEoracle.install.db.DBA_GROUP=dbaoracle.install.db.OPER_GROUP=oinstalloracle.installer.autoupdates.option=SKIP_UPDATESDECLINE_SECURITY_UPDATES=true*注意等号后⾯没有空格--执⾏安装脚本/soft/database/runInstaller -silent -responsefile /database/response/db_install.rsp -ignoresysprereqs -showProgress --其中-silent 指的是静默安装, showProgress 显⽰进度, responseFile 是种⼦⽂件--执⾏命令后,在最后需要执⾏脚本的时候报错了Execute Root Scripts in progress.As a root user, execute the following script(s):1. /u01/app/oraInventory/orainstRoot.sh2. /u01/app/oracle/product/11.2.0.4/db_1/root.sh.................................................. 100% Done.Execute Root Scripts successful.Successfully Setup Software.--报错信息如下[root@pc ~]# cat /u01/app/oracle/product/11.2.0.4/db_1/install/root_pc_2020-04-22_16-09-36.logPerforming root user operation for Oracle 11gThe following environment variables are set as:ORACLE_OWNER= oracleORACLE_HOME= /u01/app/oracle/product/11.2.0.4/db_1Copying dbhome to /usr/local/bin ...Copying oraenv to /usr/local/bin ...Copying coraenv to /usr/local/bin ...Creating /etc/oratab file...Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root script.Now product-specific root actions will be performed.Finished product-specific root actions./u01/app/oracle/product/11.2.0.4/db_1/root.sh: line 14: /u01/app/oracle/product/11.2.0.4/db_1/rdbms/install/rootadd_rdbms.sh: No such file or directory/u01/app/oracle/product/11.2.0.4/db_1/root.sh: line 16: /u01/app/oracle/product/11.2.0.4/db_1/rdbms/install/rootadd_filemap.sh: No such file or directory---最终找到原因竟然是软件包有问题;导致解压后/database 有问题;上⾯安装进度,产⽣的⽂件⼤⼩是 du -sh /u01/app 2.4G ;正确安装应该是4.2G或者4.3G--解压的软件包有问题,当时解压的⽂件⼤⼩是 1.4G;正常解压完/database 应该是2.5G;--安装完成后可以测试登陆数据库[oracle@pc ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Wed Apr 22 18:07:39 2020Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to an idle instance.SQL>SQL> exitDisconnected[oracle@pc ~]$---主库静默DBCA建库:/u01/app/oracle/product/11.2.0.4/db_1/bin/dbca -silent -createDatabase -templateName/u01/app/oracle/product/11.2.0.4/db_1/assistants/dbca/templates/General_Purpose.dbc -gdbName pcc -sid pc -sysPassword oracle -systemPassword oracle -emConfiguration LOCAL -dbsnmpPassword oracle -sysmanPassword oracle -characterSet ZHS16GBK--报错如下:[root@pc soft]# cat /u01/app/oracle/cfgtoollogs/dbca/pc/pc.logCopying database filesDBCA_PROGRESS : 1%DBCA_PROGRESS : 2%ORA-27102: out of memoryDBCA_PROGRESS : 4%DBCA_PROGRESS : 11%DBCA_PROGRESS : 12%ORA-01034: ORACLE not availableORA-01034: ORACLE not availableDBCA_PROGRESS : 100%vi /etc/sysctl.confshmall 是全部允许使⽤的共享内存⼤⼩,shmmax 是单个段允许使⽤的⼤⼩。
静默方式(silent)安装Oracle软件的实际操作

静默方式(silent)安装Oracle软件的实际操作如果你在静默方式(silent)安装Oracle软件的实际操作中,你对静默方式(silent)安装Oracle软件有不解之处时,你可以通过以下的文章对其的实际应用与功能有所了解,以下是文章的具体介绍,望你浏览完以下的内容会有所收获。
有的时候不方便登陆Linux/Unix的图形界面安装数据库,且GUI 方式安装让我们无法知道具体是做了什么操作,我们完全可以采用命令模式安装和删除Oracle软件(代替OUI)、建立和删除数库库(代替dbca)。
平台:RHEL4.5,Oracle10.2.0.11、上传并解压Oracle软件,假如放在/home目录下1.$ cd /home2.$ unzip 10201_database_linux32.zip2、设置安装Oracle软件必须的操作系统信息,如组、用户、系统内核参数、目录、用户初始化参数等增加组和用户1.# groupadd oinstall2.# groupadd dba3.# useradd -g oinstall -G dba Oracle4.# passwd Oracle修改系统内核参数1.# vi /etc/sysctl.conf2.kernel.shmall = 20971523.kernel.shmmax = 21474836484.kernel.shmmni = 40965.kernel.sem = 250 32000 100 1286.fs.file-max = 65536/doc/fa16745303.html,.ipv4.ip_local_p ort_range = 1024 65000/doc/fa16745303.html,.core.rmem_de fault = 1048576/doc/fa16745303.html,.core.rmem_ma x = 1048576/doc/fa16745303.html,.core.wmem_d efault = 262144/doc/fa16745303.html,.core.wmem_m ax = 262144/sbin/sysctl -p (修改以后让参数生效)为了提升性能增加Oracle用户的shell限制1.# vi /etc/security/limits.conf2.Oracle soft nproc 20473.Oracle hard nproc 163844.Oracle soft nofile 10245.Oracle hard nofile 655366.# vi /etc/pam.d/login7.session required /lib/security/pam_limits.so8.session required pam_limits.so9.# vi /etc/profile10.if [ $USER = "Oracle" ]; then11.if [ $SHELL = "/bin/bash" ]; then12.ulimit -p 1638413.ulimit -n 6553614.else15.ulimit -u 16384 -n 6553616.fi17.fi18.# vi /etc/selinux/config (使安全linux标志失效)19.SELINUX=disabled建立Oracle_BASE目录1.# mkdir -p /opt/Oracle2.# chown -R Oracle:oinstall /opt/Oracle3.# chmod -R 775 /opt/OracleOracle用户的.bash_profile文件设置1.# su - Oracle2.$ vi ~/.bash_profile3.umask 0224.export Oracle_BASE=/opt/Oracle5.export Oracle_HOME=/opt/Oracle/product/10.2.0/db_16.export Oracle_SID=WENDING7.export PATH=$Oracle_HOME/bin:$PATH8.$ . ~/.bash_profile3、建立oraInst.loc文件1.$ su -2.# vi /etc/oraInst.loc (加入或修改以下内容,其中/opt/Oracle 是Oracle_BASE)3.inventory_loc=/opt/Oracle/oraInventory4.inst_group=oinstall5.# chmod 664 /etc/oraInst.loc4、建立response文件(在解压后Oracle软件的response目录里有各种响应文件的模版)1.# su - Oracle2.$ cd /home/database/response3.$ cp enterprise.rsp enterprise_temp.rsp4.$ vi enterprise_temp.rsp (以下参数必需设置)5.UNIX_GROUP_NAME="oinstall"6.Oracle_HOME="/opt/Oracle/product/10.2.0/db_1"7.Oracle_HOME_NAME="OraDb10g_home1"8.s_nameForDBAGrp="dba"9.s_nameForDBAGrp="dba"10.n_configurationOption=35、通过response文件运行OUI(-noconfig表示不运行配置助手只装软件)1.$ cd /home/database2.$ ./runInstaller -silent -noconfig -responseFile /home/database/response/enterprise_temp.rsp安装结束后,以root用户执行$Oracle_HOME下的root.sh:1.$ su -2.# /opt/Oracle/product/10.2.0/db_1/root.sh3.# exit6、通过response文件运行NetCA1.$ cd /home/database/response2.$ cp netca.rsp netca_temp.rsp3.$ vi netca_temp.rsp (如果要修改监听名或端口在此编辑,一般什么都不用修改)4.$ $Oracle_HOME/bin/netca /silent /responsefile/home/database/response/netca_temp.rsp执行完后,监听就已经启动了。
oracle11g静默安装

oracle11g静默安装ls /u01/soft/extra/oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64.rpm/u01/soft/extra/oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64.rpm[root@wlc Desktop]# yum install /u01/soft/extra/oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64.rpm [root@wlc Desktop]# echo oracle|passwd oracle --stdinChanging password for user oracle.passwd: all authentication tokens updated successfully.[root@wlc Desktop]# 下⾯⽂件被修改echo "kernel.sem = 250 32000 100 128">>/etc/sysctl.confecho "net.ipv4.ip_local_port_range = 9000 65500">>/etc/sysctl.confecho "net.core.rmem_max = 1048576">>/etc/sysctl.confecho "net.core.rmem_default = 1048576">>/etc/sysctl.confecho "net.core.wmem_max = 1048576">>/etc/sysctl.confecho "net.core.wmem_default = 1048576">>/etc/sysctl.conf[root@wlc Desktop]# ls /etc/sysctl.conf/etc/sysctl.conf[root@wlc Desktop]# ls /etc/security/limits.conf/etc/security/limits.conf[root@wlc Desktop]# useradd -g oinstall -G dba grid[root@wlc Desktop]# echo oracle|passwd grid --stdinChanging password for user grid.passwd: all authentication tokens updated successfully.[root@wlc Desktop]# mkdir -p /u01/app/grid[root@wlc Desktop]# chown -R grid:oinstall /u01/app/grid[root@wlc Desktop]# mkdir /u01/app/oraInventory[root@wlc Desktop]# chown -R grid:oinstall /u01/app/oraInventory[root@wlc Desktop]# su - grid[grid@wlc ~]$ which unzip/usr/bin/unzip[grid@wlc ~]$ unzip -q /u01/soft/p1*******_112030_Linux-x86-64_3of7.zip[grid@wlc ~]$ ls grid/doc readme.html rpm runInstaller stageinstall response runcluvfy.sh sshsetup welcome.html[grid@wlc ~]$[grid@wlc ~]$ ./runInstaller -ignorePrereq -ignoreInternalDriverError -ignoreSysPrereqs -ignoreSysPrereqs -silent -responseFile/home/grid/grid/response/grid_install.rsp INVENTORY_LOCATION=/u01/app/oraInventorySELECTED_LANGUAGES=en,zh_CN oracle.install.option=CRS_SWONLYORACLE_BASE=/u01/app/grid ORACLE_HOME=/u01/app/grid/11g oracle.install.asm.OSDBA=dbaoracle.install.asm.OSOPER=oinstall oracle.install.asm.OSASM=oinstalloracle.installer.autoupdates.option=SKIP_UPDATES......看到有You can find the log of this install session at:/u01/app/oraInventory/logs/installActions2015-05-05_03-20-43PM.log表⽰在安装否则需要tail -f /u01/app/oraInventory/logs/installActions2015-05-05_03-20-43PM.log找错误解决后继续 runInstaller看到 /u01/app/grid/11g 下有内容表⽰在正常安装如不⾏请检查主机名等⼀段时间看到如下内容The installation of Oracle Grid Infrastructure was successful.Please check '/u01/app/oraInventory/logs/silentInstall2015-05-05_03-20-43PM.log' for more details.As a root user, execute the following script(s):1. /u01/app/oraInventory/orainstRoot.sh2. /u01/app/grid/11g/root.shSuccessfully Setup Software.新打开root终端执⾏脚本[root@wlc Desktop]# /u01/app/oraInventory/orainstRoot.shChanging permissions of /u01/app/oraInventory.Adding read,write permissions for group.Removing read,write,execute permissions for world.Changing groupname of /u01/app/oraInventory to oinstall.The execution of the script is complete.[root@wlc Desktop]#[root@wlc Desktop]# /u01/app/grid/11g/root.shCheck /u01/app/grid/11g/install/root__2015-05-05_15-25-04.log for the output of root script[root@wlc Desktop]# cat /u01/app/grid/11g/install/root__2015-05-05_15-25-04.logPerforming root user operation for Oracle 11gThe following environment variables are set as:ORACLE_OWNER= gridORACLE_HOME= /u01/app/grid/11gCreating /etc/oratab file...Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root script.Now product-specific root actions will be performed.To configure Grid Infrastructure for a Stand-Alone Server run the following command as the root user:/u01/app/grid/11g/perl/bin/perl -I/u01/app/grid/11g/perl/lib -I/u01/app/grid/11g/crs/install/u01/app/grid/11g/crs/install/roothas.plTo configure Grid Infrastructure for a Cluster execute the following command:/u01/app/grid/11g/crs/config/config.shThis command launches the Grid Infrastructure Configuration Wizard. The wizard also supports silent operation, and the parameters can be passed through the responsefile that is available in the installation media.[root@wlc Desktop]# 看⽇志执⾏/u01/app/grid/11g/perl/bin/perl -I/u01/app/grid/11g/perl/lib -I/u01/app/grid/11g/crs/install /u01/app/grid/11g/crs/install/roothas.plUsing configuration parameter file: /u01/app/grid/11g/crs/install/crsconfig_paramsCreating trace directoryUser ignored Prerequisites during installationLOCAL ADD MODECreating OCR keys for user 'grid', privgrp 'oinstall'..Operation successful.LOCAL ONLY MODESuccessfully accumulated necessary OCR keys.Creating OCR keys for user 'root', privgrp 'root'..Operation successful.CRS-4664: Node wlc successfully pinned.Adding Clusterware entries to upstartwlc 2015/05/05 15:26:21 /u01/app/grid/11g/cdata/wlc/backup_20150505_152621.olrSuccessfully configured Oracle Grid Infrastructure for a Standalone Server[root@wlc Desktop]#[root@wlc Desktop]# tail -1 /etc/init/oracle-ohasd.confexec /etc/init.d/init.ohasd run >/dev/null 2>&1[root@wlc Desktop]#[root@wlc Desktop]# echo "`tail -1 /etc/init/oracle-ohasd.conf` &"exec /etc/init.d/init.ohasd run >/dev/null 2>&1[root@wlc Desktop]# echo "`tail -1 /etc/init/oracle-ohasd.conf` &" >>/etc/rc.local[root@wlc Desktop]#[root@wlc Desktop]# tail -1 /etc/rc.localexec /etc/init.d/init.ohasd run >/dev/null 2>&1[root@wlc Desktop]#[root@wlc Desktop]# su - grid[grid@wlc grid]$ sed -i '/PATH/i export ORACLE_BASE=/u01/app/grid' ~/.bash_profile[grid@wlc grid]$[grid@wlc grid]$ sed -i '/PATH/i export ORACLE_HOME=/u01/app/grid/11g' ~/.bash_profile[grid@wlc grid]$[grid@wlc grid]$ sed -i 's#PATH=#PATH=$ORACLE_HOME/bin:#' ~/.bash_profile[grid@wlc grid]$ . ~/.bash_profile[grid@wlc grid]$ which crs_stat/u01/app/grid/11g/bin/crs_stat[grid@wlc grid]$ crs_stat -tName Type Target State Host------------------------------------------------------------ora.cssd ora.cssd.type OFFLINE OFFLINEora.diskmon ora....on.type OFFLINE OFFLINEora.evmd ora.evm.type ONLINE ONLINE wlcora.ons ora.ons.type OFFLINE OFFLINE[grid@wlc grid]$[grid@wlc grid]$ srvctl add listener -p "TCP:1521/IPC:EXTPROC1521"[grid@wlc grid]$ srvctl start listener[grid@wlc grid]$ exit[root@wlc Desktop]# mkdir /u01/app/oracle[root@wlc Desktop]# chown -R oracle:oinstall /u01/app/oracle[root@wlc Desktop]# su - oracle[oracle@wlc ~]$ unzip -q /u01/soft/p1*******_112030_Linux-x86-64_1of7.zip[oracle@wlc ~]$ unzip -q /u01/soft/p1*******_112030_Linux-x86-64_2of7.zip[oracle@wlc ~]$ ls database/doc readme.html rpm sshsetup welcome.htmlinstall response runInstaller stage[oracle@wlc ~]$ cd database/[oracle@wlc database]$ ./runInstaller -ignorePrereq -ignoreSysPrereqs -ignoreSysPrereqs -silent -responseFile/home/oracle/database/response/db_install.rsporacle.install.option=INSTALL_DB_SWONLY UNIX_GROUP_NAME=oinstallINVENTORY_LOCATION=/u01/app/oraInventory SELECTED_LANGUAGES=en,zh_CN ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/11g oracle.install.db.InstallEdition=EE oracle.install.db.EEOptionsSelection=true oracle.install.db.DBA_GROUP=dbaoracle.install.db.OPER_GROUP=oinstall DECLINE_SECURITY_UPDATES=trueoracle.installer.autoupdates.option=SKIP_UPDATES/////////////////////////////////////////////////////////////////////////////Starting Oracle Universal Installer...Checking Temp space: must be greater than 120 MB. Actual 7759 MB PassedChecking swap space: must be greater than 150 MB. Actual 8186 MB PassedPreparing to launch Oracle Universal Installer from /tmp/OraInstall2015-05-05_03-42-37PM. Please wait ...[oracle@wlc database]$ No protocol specified[WARNING] [INS-30060] Check for group existence failed.CAUSE: Unexpected error occurred while trying to check for group existence.ACTION: Refer to the logs or contact Oracle Support Services. Note for advanced users: Launch the installer by passing the following flag ''-ignoreInternalDriverError''.You can find the log of this install session at:/u01/app/oraInventory/logs/installActions2015-05-05_03-42-37PM.logThe installation of Oracle Database 11g was successful.Please check '/u01/app/oraInventory/logs/silentInstall2015-05-05_03-42-37PM.log' for more details.As a root user, execute the following script(s):1. /u01/app/oracle/11g/root.shSuccessfully Setup Software.[oracle@wlc database]$ exitlogout[root@wlc Desktop]# /u01/app/oracle/11g/root.shCheck /u01/app/oracle/11g/install/root__2015-05-05_15-47-58.log for the output of root script[root@wlc Desktop]#[root@wlc Desktop]# sed -i '/PATH=/i export ORACLE_BASE=/u01/app/oracle' ~oracle/.bash_profile[root@wlc Desktop]# sed -i '/PATH=/i export ORACLE_HOME=/u01/app/oracle/11g' ~oracle/.bash_profile[root@wlc Desktop]# sed -i 's#PATH=#PATH=$ORACLE_HOME/bin:#' ~oracle/.bash_profile[root@wlc Desktop]# su - oracle[oracle@wlc ~]$ which sqlplus/u01/app/oracle/11g/bin/sqlplusvim ~oracle/.bash_profile# .bash_profile# Get the aliases and functionsif [ -f ~/.bashrc ]; then. ~/.bashrcfi# User specific environment and startup programsexport ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=/u01/app/oracle/11gPATH=$ORACLE_HOME/bin:$PATH:$HOME/binexport PATH[oracle@wlc ~]$ which dbca/u01/app/oracle/11g/bin/dbca[oracle@wlc ~]$[oracle@wlc ~]$ dbca -silent -createDatabase -templateName$ORACLE_HOME/assistants/dbca/templates/General_Purpose.dbc -gdbname updb -sid updb -syspassword oracle -systempassword oracle -emconfiguration LOCAL -dbsnmppassword oracle -sysmanpassword oracle -characterset al32utf8 -sampleSchema true -totalMemory 1200///////////////////Copying database files1% complete3% complete10% complete17% complete24% complete35% completeCreating and starting Oracle instance37% complete42% complete47% complete52% complete53% complete56% complete58% completeRegistering database with Oracle Restart64% completeCompleting Database Creation68% complete71% complete75% complete85% complete96% complete100% completeLook at the log file "/u01/app/oracle/cfgtoollogs/dbca/updb/updb.log" for further details. [oracle@wlc ~]$ tail -1 /etc/oratabupdb:/u01/app/oracle/11g:N # line added by Agentcat /etc/oratab 查看实例名称[oracle@wlc ~]$[oracle@wlc ~]$ echo "export ORACLE_SID=updb">>~/.bash_profile[oracle@wlc ~]$ . ~/.bash_profile[oracle@wlc ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Tue May 5 16:08:53 2015Copyright (c) 1982, 2011, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, Oracle Label Security, OLAP, Data Mining,Oracle Database Vault and Real Application Testing optionsSQL> select open_mode from v$database;OPEN_MODE--------------------READ WRITESQL> exitDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, Oracle Label Security, OLAP, Data Mining,Oracle Database Vault and Real Application Testing options[oracle@wlc ~]$ exitlogout[root@wlc Desktop]# su - grid[grid@wlc ~]$ crs_stat -tName Type Target State Host------------------------------------------------------------ora....ER.lsnr ora....er.type ONLINE ONLINE wlc ora.cssd ora.cssd.type OFFLINE OFFLINE ora.diskmon ora....on.type OFFLINE OFFLINE ora.evmd ora.evm.type ONLINE ONLINE wlc ora.ons ora.ons.type OFFLINE OFFLINE ora.updb.db ora....se.type ONLINE ONLINE wlc [grid@wlc ~]$ exit。
Oracle_11g安装详细教程
1.安装oracle数据库1.1.软、硬件需求检查1.1.1.查看内存、swap空间查看物理内存[root@rhel64 ~]# free -m查看操作系统共享内存,oracle数据库使⽤内存要⼩于此值[root@rhel64 ~]# df -h /dev/shm/调整⽅法:修改/etc/fstab[root@rhel64 ~]# vi /etc/fstab修改对应/dev/shm 项defaults,size=1500M [root@rhel64 ~]# cat /etc/fstab | grep shm[root@rhel64 ~]# mount -o remount /dev/shm[root@rhel64 ~]# df -h /dev/shm/1.1.2.查看系统架构[root@rhel64 ~]# uname -m1.1.3.查看本地主机名解析[root@rhel64 ~]# cat /etc/sysconfig/network [root@rhel64 ~]# cat /etc/hosts1.1.4.磁盘空间检查/tmp空间 >1G[root@rhel64 ~]# df -h /tmp/软件安装⽬录空间 >2G[root@rhel64 ~]# df -h /u01/软件存放⽬录空间 >2.5G (不安装grid) [root@rhel64 ~]# df -h /software/1.1.5.内核需求检查查看操作系统版本[root@rhel64 ~]# cat /proc/version [root@rhel64 ~]# lsb_release -id内核需求:[root@rhel64 ~]# uname -r1.1.6.软件包检查[root@rhel64 ~]# yum install binutils*[root@rhel64 ~]# yum install compat*[root@rhel64 ~]# yum install glibc*[root@rhel64 ~]# yum install ksh*[root@rhel64 ~]# yum install libgcc*[root@rhel64 ~]# yum install libstdc*[root@rhel64 ~]# yum install libaio*[root@rhel64 ~]# yum install make*[root@rhel64 ~]# yum install sysstat*可以提前检查也可以安装报错缺少包时再yum安装具体包[root@rhel64 ~]# yum install unixODBC*1.1.7.修改资源限制[root@rhel64 ~]# cp /etc/security/limits.conf /etc/security/limits.conf.bak [root@rhel64 ~]# vi /etc/security/limits.conforacle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536oracle soft stack 10240[root@rhel64 ~]# tail -8 /etc/security/limits.conf1.1.8.修改内核参数建议编辑前给虚拟机做快照备份!![root@rhel64 ~]# cp /etc/sysctl.conf /etc/sysctl.conf.bak [root@rhel64 ~]# vi /etc/sysctl.conffs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmmni = 4096kernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576[root@rhel64 ~]# tail -16 /etc/sysctl.conf重启,验证[root@rhel64 ~]# reboot1.2.软件安装环境准备1.2.1.创建⽤户和组创建组[root@rhel64 ~]# groupadd oinstall[root@rhel64 ~]# groupadd dba[root@rhel64 ~]# groupadd oper创建⽤户设置密码 oracle:oracle[root@rhel64 ~]# useradd -g oinstall -G dba,oper oracle [root@rhel64 ~]# passwd oracleSecureCRT创建连接使⽤oracle⽤户登录测试[oracle@rhel64 ~]$ id1.2.2.创建⽬录[root@rhel64 ~]# mkdir -p /u01/app/oracle[root@rhel64 ~]# chown -R oracle:oinstall /u01[root@rhel64 ~]# chmod -R 775 /u01/app/oracle1.2.3.设置环境变量使⽤oracle⽤户连接编辑/home/oracle/.bash_profile[oracle@rhel64 ~]$ vi .bash_profileunset TNS_ADMINexport ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1 export ORACLE_SID=PRODexport PATH=$ORACLE_HOME/bin:$PATH[oracle@rhel64 ~]$ source .bash_profile验证[oracle@rhel64 ~]$ echo $ORACLE_BASE[oracle@rhel64 ~]$ echo $ORACLE_HOME[oracle@rhel64 ~]$ echo $ORACLE_SID[oracle@rhel64 ~]$ echo $PATH1.2.4.解压软件,修改属主属组权限root⽤户解压软件包先后解压1、2[root@rhel64 db]# cd /software/db[root@rhel64 db]# ls[root@rhel64 db]# unzip p1*******_112030_Linux-x86-64_1of7.zip [root@rhel64 db]# unzip p1*******_112030_Linux-x86-64_2of7.zip 解压得到database⽬录约2.5G修改属主属组权限[root@rhel64 db]# chown -R oracle:oinstall database/[root@rhel64 db]# chmod -R +x database/1.2.5.启动Xmanager-passive 执⾏安装启动Xmanager - Passiveoracle⽤户设置DISPLAY 将图形化界⾯显⽰在宿主机[oracle@rhel64 ~]$ export DISPLAY=192.168.6.6:0.0 [oracle@rhel64 ~]$ echo $DISPLAY在oracle⽤户home⽬录执⾏安装操作[oracle@rhel64 ~]$ cd /software/db/database/ [oracle@rhel64 database]$ ll[oracle@rhel64 database]$ ./runInstaller1.3.安装oracle软件1.3.1.不勾选1.3.2.Skip software updates1.3.3.Install database software only 仅安装数据库软件1.3.4.Single instance database installation1.3.5.默认English1.3.6.默认 Enterprise Edition1.3.7.Next1.3.8.查看缺少的包1.3.9.yum 进⾏安装可以使⽤yum安装第⼀个包[root@rhel64 db]# yum install elfutils-libelf-devel第⼆个包pdksh包可以从rhel5光盘中找到上传后可以rpm -ivh 安装但与ksh冲突,需要先rpm -e 卸载ksh[root@rhel64 software]# rpm -i pdksh-5.2.14-36.el5.x86_64.rpm[root@rhel64 software]# rpm -e ksh[root@rhel64 software]# rpm -i pdksh-5.2.14-36.el5.x86_64.rpm[root@rhel64 software]# rpm -ivh pdksh-5.2.14-36.el5.x86_64.rpm1.3.10.安装完成Check Again如果内核参数、资源限制等配置有问题,检查环节还会显⽰有其他错误,可先使⽤Fix & Check Again弹出的对话框会提⽰,仔细阅读提⽰内容。
Oracle11gR2全静默安装攻略
1服务器安装1.1 操作系统安装操作系统为CentOS 5.8 x86_64注意:1.为满足Oracle安装需求,设置系统swap空间至少为内存1.5倍,最大16G2.磁盘规划部分,请参见下文操作系统设置-->创建目录部分3.建议hostname分别设置为DBSRV1和DBSRV2,和ADG环境数据库名称保持一致1.2 操作系统设置1.2.1修改共享内存vi /etc/fstabtmpfs /dev/shm tmpfs defaults,size=3276M 0 0为了启用Oracle 11g AMM特性,此处size至少设置为物理内存的80%mount -o remount /dev/shm1.2.2安装必要的包yum -y install binutils compat-db compat-gcc-34 compat-gcc-34-c++ compat-libstdc++-33 elfutils-libelf-devel gcc gcc-c++ glibc-* libXp.so.6 libXt.so.6 libXtst.so.6 libgcc* ksh libXp libaio-devel numactl numactl-devel sysstat unixODBC unixODBC-devel pdksh如果:pdksh包yum不到,需要手工安装# rpm -e ksh 如果和ksh有冲突,可以把ksh卸载掉# rpm -i pdksh-5.2.14-37.el5.i386.rpm# rpm -i pdksh-5.2.14-37.el5.x86_64.rpm1.2.3临时禁用防火墙chkconfig iptables offservice iptables stopsed -i 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config1.2.4内核参数######################################## vi /etc/sysctl.confkernel.shmmni = 4096kernel.sem = 250 32000 100 128fs.file-max = 6815744fs.aio-max-nr = 1048576net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default = 4194304net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576/sbin/sysctl -p######################################## vi /etc/security/limits.conf# Added for Oracle Shell Limitsoracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536grid soft nproc 2047grid hard nproc 16384grid soft nofile 1024grid hard nofile 65536######################################## vi /etc/pam.d/login# Added for Oracle Shell Limitssession required pam_limits.so1.2.5创建用户groupadd oinstallgroupadd dbagroupadd asmdbagroupadd asmadmingroupadd asmoperuseradd -g oinstall -G dba,asmdba -d /home/oracle -s /bin/bash -m oracleecho oracle | passwd --stdin oracleuseradd -g oinstall -G dba,asmdba,asmadmin,asmoper -d /home/grid -s /bin/bash -m grid echo grid | passwd --stdin grid1.2.6创建目录mkdir -p /u01/app/oraclemkdir -p /u01/app/gridmkdir -p /u01/app/grid_homemkdir -p /u01/oradatamkdir -p /u01/redomkdir -p /u02/archivelogmkdir -p /u02/rmanbackupmkdir -p /u02/dpdumpmkdir -p /home/oracle/scriptmkdir -p /home/oracle/uploadmkdir -p /home/grid/uploadchown -R oracle:oinstall /home/oraclechown -R grid:oinstall /home/gridchown -R oracle:oinstall /u01chown -R oracle:oinstall /u02chown -R grid:oinstall /u01/app/gridchown -R grid:oinstall /u01/app/grid_homechmod -R 775 /u01chmod -R 775 /u021.2.7环境变量涉及文件➢rlwrap_static_x64# cp ./rlwrap_static_x64 /usr/bin/# chmod +x /usr/bin/rlwrap*# ln -s /usr/bin/rlwrap_static_x64 /usr/bin/rlwrap# vi /home/oracle/.bash_profileexport ORACLE_HOSTNAME=`hostname`export ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=${ORACLE_BASE}/product/11.2.0/dbhome_1export ORACLE_HOME_LISTNER=${ORACLE_HOME}export ORACLE_PATH=${ORACLE_HOME}/rdbms/adminexport ORACLE_SID=billexport PA TH=${PATH}:${ORACLE_HOME}/binexport LD_LIBRARY_PA TH=${LD_LIBRARY_PA TH}:${ORACLE_HOME}/lib export SQLPATH=~/scriptexport NLS_LANG=AMERICAN_AMERICA.ZHS16GBKalias sqlplus='rlwrap sqlplus'alias rman='rlwrap rman'alias dgmgrl='rlwrap dgmgrl'# vi /home/grid/.bash_profileexport ORACLE_HOSTNAME=`hostname`export ORACLE_BASE=/u01/app/gridexport GI_HOME=/u01/app/grid_homeexport ORACLE_HOME=${GI_HOME}export ORACLE_HOME_LISTNER=${ORACLE_HOME}export ORACLE_PATH=${ORACLE_HOME}/rdbms/adminexport ORACLE_SID=+ASMexport PA TH=${PATH}:${ORACLE_HOME}/binexport LD_LIBRARY_PA TH=${LD_LIBRARY_PA TH}:${ORACLE_HOME}/libexport SQLPATH=~/scriptexport NLS_LANG=AMERICAN_AMERICA.ZHS16GBKalias ct='crs_stat -t'alias asmcmd='rlwrap asmcmd'1.3 GRID软件安装本节的操作如无特殊说明,都是使用grid用户执行。
Linux系统最全Oracle 11g安装文档
Linux系统(X64)安装Oracle11g基本操作一、修改操作系统核心参数在Root用户下执行以下步骤:1)修改用户的SHELL的限制,修改/etc/security/limits.conf文件,输入命令:vi/etc/security/limits.conf,按i键进入编辑模式,将下列内容加入该文件。
oracle soft nproc 2047oracle hard nproc 16384oracle soft nooracle hard no2)修改/etc/pam.d/login 文件,输入命令:vi /etc/pam.d/login,按i键进入编辑模式,将下列内容加入该文件。
(用户限制配置文件。
要使/etc/security/limits.conf 文件配置生效,必须要确保PAM验证模块pam_limits.so 文件被加入到启动文件中。
查看/etc/pam.d/login 文件中有:session required /lib/security/pam_limits.so,64位地址是:/lib64/security/pam_limits.so 否则本地即使输入正确密码也无法登陆。
)(PS 我们平常登陆实际上是运行一个程序login来判断我们是不是这个用户,如果是的话就给我们shell;不是的话就进不去。
而/etc/pam/login这件文件就是我们验证过程中需要经过哪些模块的认证。
根据设定来叛断我们的帐号密码是不是正确,当这个文件有问题的时候,验证就会出错,尽管我的帐号密码是正常的,也进不去。
)session required /lib/security/pam_limits.sosession required pam_limits.so编辑完成后按Esc键,输入“:wq”存盘退出3)修改linux内核,修改/etc/sysctl.conf文件,输入命令: vi /etc/sysctl.conf ,按i键进入编辑模式,将下列内容加入该文件fs. = 6815744fs.aio-max-nr = 1048576kernel.shmall = 2097152kernel.shmmax = 2147483648kernel.shmmni = 4096kernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 4194304net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 10485764)要使 /etc/sysctl.conf 更改立即生效,执行以下命令。
oracle 11g安装配置文档
若没有
vi /etc/pam.d/login 添加以下内容
session required pam_limits.so
13,上传并解压安装文件
将db_112040_Linux-x86-64_1of7.zip
保存退出
3),编辑/etc/hosts
在该文件最后添加一行
192.168.100.101 ora11g
保存退出
4,关闭防火墙和selinux
service iptables stop
chkconfig iptables off
cat /etc/selinux/config
第一部分
虚拟机配置
1,内存>2G
网络选择桥接
2,磁盘>40G
3,虚拟机网络与主机名配置
1),虚拟机网卡配置
vi /etc/sysconfig/network-scripts/ifcfg-eth0
ONBOOT=yes
BOOTPROTO=static
IPADDR=192.168.100.101
Linux version 2.6.32-358.el6.x86_64 (mockbuild@) (gcc version 4.4.7 20120313 (Red Hat 4.4.7-3) (GCC) ) #1 SMP Tue Jan 29 11:47:41 EST 2013
db_112040_Linux-x86-64_2of7.zip
拖拽到虚拟机中,然后,将其mv到/u01.
用unzip命令解压。
解压完成之后,修改宿主
- 1、下载文档前请自行甄别文档内容的完整性,平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益,请联系客服反馈,我们会尽快为您处理(人工客服工作时间:9:00-18:30)。
Oracle 11g静默安装过程——linux环境一、硬件环境1.操作系统及Oracle版本Linux版本:Redhat 6.4Oracle版本:Oracle Database 11g Release 2 (11.2.0.1.0) for Linux x86-64(linux.x64_11gR2_database_1of2.zip、linux.x64_11gR2_database_2of2.zip) 上传到/home下2.硬件检测:物理内存不少于1G硬盘可以空间不少于5Gswap分区空间不少于2G支持256色以上显卡cpu主频不小于550mHZcat /etc/issueuname -rgrep MemTotal /proc/meminfogrep SwapTotal /proc/meminfogrep "model name" /proc/cpuinfofreedf -k /tmpdf -k二、安装操作系统依赖的具体包以下为Asianux 3, Oracle Linux 5, Red Hat Enterprise Linux 5, CentOS 5 操作系统依赖的包binutils-2.20.51.0.2-5.11.el6 (x86_64)compat-libcap1-1.10-1 (x86_64)compat-libstdc++-33-3.2.3-69.el6 (x86_64)compat-libstdc++-33-3.2.3-69.el6.i686gcc-4.4.4-13.el6 (x86_64)gcc-c++-4.4.4-13.el6 (x86_64)glibc-2.12-1.7.el6 (i686)glibc-2.12-1.7.el6 (x86_64)glibc-devel-2.12-1.7.el6 (x86_64)glibc-devel-2.12-1.7.el6.i686kshlibgcc-4.4.4-13.el6 (i686)libgcc-4.4.4-13.el6 (x86_64)libstdc++-4.4.4-13.el6 (x86_64)libstdc++-4.4.4-13.el6.i686libstdc++-devel-4.4.4-13.el6 (x86_64)libstdc++-devel-4.4.4-13.el6.i686libaio-0.3.107-10.el6 (x86_64)libaio-0.3.107-10.el6.i686libaio-devel-0.3.107-10.el6 (x86_64)libaio-devel-0.3.107-10.el6.i686make-3.81-19.el6sysstat-9.0.4-11.el6 (x86_64)1.上传依赖包mkdir /home/rpm安装依赖包,把Linux安装盘中的rpm包文件传到/home/rpm,Redhat中是Packages文件下。
cd /home/rpm2.检查安装依赖系统包rpm -ivh glibc-common*.rpmrpm -ivh kernel-headers*.rpmrpm -ivh libgcc*.rpmrpm -ivh glibc-*.rpmrpm -ivh libgomp-*.rpmrpm -ivh nscd*.rpmrpm -ivh glibc-headers*.rpmrpm -ivh glibc-devel-*.rpmrpm -ivh mpfr*.rpmrpm -ivh ppl*.rpmrpm -ivh cloog-ppl*.rpmrpm -ivh cpp*.rpmrpm -ivh gcc-*.rpmrpm -ivh libstdc++*.rpmrpm -ivh libstdc++-devel*.rpmrpm -ivh gcc-c++*.rpmrpm -ivh binutils*.rpm --nodepsrpm -ivh compat*.rpm --nodepsrpm -ivh elfutils*.rpm --nodepsrpm -ivh libXp *.rpm --nodepsrpm -ivh gcc*.rpm --nodepsrpm -ivh mfr*.rpm --nodepsrpm -ivh cpp*.rpm --nodepsrpm -ivh ppl*.rpm --nodepsrpm -ivh glibc*.rpm --nodepsrpm -ivh ksh*.rpm --nodepsrpm -ivh libaio*.rpm --nodepsrpm -ivh libgcc*.rpm --nodepsrpm -ivh libstdc++*.rpm --nodepsrpm -ivh make*.rpm --nodepsrpm -ivh sysstat*.rpm --nodepsrpm -ivh unixODBC*.rpm –nodeps3.创建所需的操作系统组和用户groupadd oinstallgroupadd dbauseradd -g oinstall -G dba oraclepasswd oracle输入oracle的密码三.修改文件1.修改/etc/hosts文件vim /etc/hosts里面内容修改为:127.0.0.1 localhost192.168.1.2 hostname注意:必须将主机名对应到主机真实ip地址,否则oracle有可能将监听程序仅仅建立在127.0.0.1上。
主机名可根据个人喜好进行设置。
Hostname为主机名,192.168.1.2为服务器的地址2.修改内核参数vi /etc/sysctl.conf里面内容添加:fs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmall = 2097152kernel.shmmax = 536870912kernel.shmmni = 4096kernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576修改后,使设置生效/sbin/sysctl -p3.修改用户限制vi /etc/security/limits.conf里面内容添加:oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536oracle soft stack 102404.修改/etc/pam.d/login文件vi /etc/pam.d/login里面内容添加:session required /lib/security/pam_limits.so session required pam_limits.so5.修改/etc/profile文件vi /etc/profile里面内容添加:if [ $USER = "oracle" ]; thenif [ $SHELL = "/bin/ksh" ]; thenulimit -p 16384ulimit -n 65536elseulimit -u 16384 -n 65536fifi使设置生效source /etc/profile6.创建安装目录(可根据情况,选择比较多空间的目录创建) mkdir -p /optchown -R oracle:oinstall /optchmod -R 775 /opt7.创/etc/oraInst.loc文件,内容如下vi /etc/oraInst.loc里面内容添加:nventory_loc=/opt/oracle/oraInventoryinst_group=oinstall更改文件的权限chown oracle:oinstall /etc/oraInst.locchmod 664 /etc/oraInst.loc8.解压oracle安装文件cd /homeunzip linux.x64_11gR2_database_1of2.zipunzip linux.x64_11gR2_database_2of2.zip9.复制响应文件模板mkdir etccp /home/database/response/* /home/rsp/设置响应文件权限su - rootchmod 700 /home/rsp/*.rspchown -R oracle:oinstall /home/rsp/10.静默安装Oracle软件su - oracle修改安装Oracle软件的响应文件/home/rsp/db_install.rspvi /home/rsp/db_install.rsporacle.install.option=INSTALL_DB_SWONLY //29 行安装类型ORACLE_HOSTNAME=hostname //37 行主机名称UNIX_GROUP_NAME=oinstall //42 行安装组INVENTORY_LOCATION=/opt/oracle/oraInventory //47 行INVENTORY目录SELECTED_LANGUAGES=en,zh_CN,zh_TW //78 行选择语言ORACLE_HOME=/opt/oracle/product/11.2.0/db_1 //83 行oracle_homeORACLE_BASE=/opt/oracle //88 行oracle_baseoracle.install.db.InstallEdition=EE //99 行oracle版本oracle.install.db.isCustomInstall=true //108行自定义安装oracle.install.db.DBA_GROUP=dba //142行dba用户组oracle.install.db.OPER_GROUP=oinstall //147行oper用户组oracle.install.db.config.starterdb.type=GENERAL_PURPOSE //160行数据库类型oracle.install.db.config.starterdb.globalDBName=orcl //165行globalDBNameoracle.install.db.config.starterdb.SID=orcl //170行SIDoracle.install.db.config.starterdb.characterSet=ZHS16GBK//180行字符集oracle.install.db.config.starterdb.memoryLimit=512 //192行自动管理内存的最小内存(M)oracle.install.db.config.starterdb.password.ALL=oracle //233行设定所有数据库用户使用同一个密码DECLINE_SECURITY_UPDATES=true //385行设置安全更新进行静默安装Oracle软件cd /home/database./runInstaller -silent -force -responseFile /home/rsp/db_install.rsp安装中,如果提示[WARNING]不必理会,此时安装程序仍在进行,如果出现[FATAL],则安装程序已经停止了。