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安装过程中,对软件包进行检查时,发现仍有所需软件包未安装时,可根据显示未安装软件包的名字,再次对所缺少的软件包进行安装。
Oracl-11G安装手册
Oracl 11G 64位安装手册1、解压两个压缩包到同一目录,即"database",然后单击解压目录下的"setup.exe"文件,如下图所示:2、.执行安装程序后会出现如下的命令提示行。
3、等待片刻之后就会出现启动画(加载应用程序)4、稍微等待一会,就会出现如下图所示的安装画面,选择第二项:仅安装数据库软件,然后单击"下一步"继续,同时在出现的信息提示框单击"是"继续。
5、之后会出现安装类型对话框,选择:单实例数据库安装6、选择你运行产品使用需要的语言7、选择数据库版本(这里选择企业版)8、选择Oracl的安装路径9、Oracl自动检测本机环境是否符合要求10、检测完成之后,点击完成即可11、Oracl正在安装产品12、1为Sage X3创建用户,赋予权限接下来我们要做的是为windows操作系统创建一个名叫“adonix”的登陆用户,并为用户“adonix”和用户“administrator”赋予权限。
其中,“administrator”是windows操作系统自动创建的用户。
点击“系统工具”>>“本地用户和组”>>“用户”。
密码设置为1位或1位以上,X3才可以正常设置console中的server;如果windows提示密码需满足“8位以上,字母数字并用”等条件,你可以照做,或在“开始”>>“所有程序”>>“管理工具”>>“本地安全策略”>>“账户策略”>>“密码策略”中禁用“密码必须符合复杂性要求”。
现在已经成功地将adonix添加到了ora_dba组中,按相同的方法把adonix也添加进Administrators组中。
给用户adonix赋予权限,点击“开始”>>“所有程序”>>“管理工具”>>“本地安全策略”。
RHEL5下静默安装oracle 11G R2+weblogic(已验证)
RHEL5下静默安装oracl e 11G R2+webl ogic(已验证)准备工作:Rhel5安装介质oracle11GR2安装介质weblogic10.3安装介质jdk1.6.0_13安装介质静默安装oracle 11G R2Oracle:Ip:10.31.120.67Hostname:cnsh41278开放端口:1521、1158修改/etc/hosts文件(根据实际环境添加相应主机、IP的映射)[root@oracle ~]#vi /etc/hosts10.31.120.67 cnsh41278关闭防火墙[root@RHEL5 /]#chkconfig iptables off (重启后永久性生效)service iptables stop (即时生效,重启后失效)关闭selinuxvi /etc/selinux/configSELINUX =disabled【设置ipvi /etc/sysconfig/network-scripts/ifcfg-eth0】检查系统软件[root@RHCE~]# uname –a.[root@RHCE~]# cat /etc/redhat-release软件包检查(x86_64)(--ok)binutils-2.17.50.0.6compat-libstdc++-33-3.2.3elfutils-libelf-0.125elfutils-libelf-devel-0.125elfutils-libelf-devel-static-0.125gcc-4.1.2gcc-c++-4.1.2glibc-2.5-24glibc-common-2.5glibc-devel-2.5glibc-headers-2.5kernel-headers-2.6.18ksh-20060214libaio-0.3.106libaio-devel-0.3.106libgcc-4.1.2libgomp-4.1.2libstdc++-4.1.2libstdc++-devel-4.1.2make-3.81sysstat-7.0.2unixODBC-2.2.11unixODBC-devel-2.2.11查看软件包是否存在:[root@RHCE ~]# rpm –aq | grep使用rpm –q命令检查下系统是否已经安装了以上软件包rpm -q binutils okrpm -q compat-libstdc++ okrpm -q elfutils-libelf okrpm -q elfutils-libelf-devel okrpm -q elfutils-libelf-devel-static okrpm -q gcc okrpm -q gcc-c++ okrpm -q glibc okrpm -q glibc-common okrpm -q glibc-devel okrpm -q glibc-headers okrpm -q kernel-headers okrpm -q ksh okrpm -q libaio okrpm -q libaio-devel okrpm -q libgcc okrpm -q libgomp okrpm -q libstdc++ okrpm -q libstdc++-devel okrpm -q make okrpm -q sysstat okrpm -q unixODBC okrpm -q unixODBC-devel ok拷贝文件到linux安装包到/tmp目录安装依赖软件包[root@oracle ~]# rpm –vih修改Linux 内核参数检查参数是否满足要求:[root@RHCE ~]# sysctl -a | grep其值大于要求的值可以不做修改,修改需要修改的参数。
Oracle 11g虚拟机安装文档
oracle 11g installationdatabase : oracle 11g (11.2.0.4)platform :VMware fusion 7Grid Infrastructure :11.2.0.4os : redhat 6.12016年2⽉月15⽇日CLORACLE LEARN阅读须知⺫⽬目标本⽂文档⽤用于Oracle 11g 安装测试使⽤用,不包含商业⽤用途⽂文档结构通过安装Oracle 11g 数据库加深对数据库的使⽤用和理解,本⽂文档严格按照Oracle 官⽅方安装⽂文档要求执⾏行。
⽂文章的主要结构如下:1)操作系统安装2)配置数据库安装环境3)安装grid软件4)安装database软件5)检查测试1.概述1.1 背景独⽴立安装数据库,并记录完整安装过程1.2 ⺫⽬目的通过VMware fusion 虚拟机安装redhat 6.1 操作系统,部署Oracle 11g r2 单实例测试环境,并打最新的PSU,升级到最新的数据库版本2.操作系统环境2.1 安装操作系统设置主机名,与redhat 5不同的是,⺴⽹网络配置和主机名设置放在⼀一起,且在下⾯面,有可能会忽视掉,当然在安装成功后,也是可以配置⺴⽹网络的。
为了⽅方便,在这⾥里,⼀一并将其设置。
注:因为全世界分为24个时区,所以,要告知系统时区在哪⾥里。
如图所⽰示,你可以选择台湾,或直接⽤用⿏鼠标在地图上选择。
要特别注意UTC,它与“夏令时”有关,不需要选择这个选项,否则会造成时区混乱,导致系统显⽰示的时间与本地时间不同。
这个是很重要的“系统管理员的⼝口令”设置,如图所⽰示。
在Linux中,系统管理员的默认名称为root,请注意,这个⼝口令很重要。
⾄至少6个字符以上,含有特殊符号,并要记好。
为⽅方便⼤大家分区硬盘,redhat给了我们分区模式,分别为:使⽤用所有空间(Use All Space ):选择此选项,删除您硬盘上的所有分区(这包括如Windows的NTFS分区VFAT或其他操作系统创建的分区)。
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 是单个段允许使⽤的⼤⼩。
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。
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静默安装
1、安装RPM包# yum install 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备注:部分机器估计libaio的32和64包都需要,没有还不行。
2、固定IP地址,hostname,hosts记录[root@localhost ~]# vim /etc/sysconfig/networkhostname=[root@oracle11g ~]# vim /etc/sysconfig/network-scripts/ifcfg-eth0DEVICE=eth0BOOTPROTO=noneHWADDR=00:0C:29:1E:68:68ONBOOT=yesIPADDR=192.168.1.16NETMASK=255.255.255.0GATEWAY=192.168.1.254[root@oracle11g ~]# ifconfig eth0 | head -n 2eth0 Link encap:Ethernet HWaddr 00:0C:29:9F:DF:4Ainet addr:192.168.1.16 Bcast:192.168.1.255 Mask:255.255.255.0[root@oracle11g ~]# grep -v '^#' /etc/hosts127.0.0.1 localhost.localdomainlocalhost192.168.1.16 3、设置系统的操作资源[root@oracle11g ~]#vim /etc/sysctl.conf 添加到文件底端kernel.shmall = 2097152kernel.shmmax = 2147483648kernel.shmmni = 4096kernel.sem = 250 32000 100 128fs.file-max = 65536net.ipv4.ip_local_port_range = 1024 65000 net.core.rmem_default = 1048576net.core.rmem_max = 1048576net.core.wmem_default = 262144net.core.wmem_max = 262144[root@oracle11g ~]#sysctl -pshell限制[root@oracle11g ~]# grep -v '^#' /etc/security/limits.conf oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536[root@oracle11g ~]# grep 'limit' /etc/pam.d/system-auth session required pam_limits.so4、设置oracle用户建议指定GID和UID方式(尤其集群环境) [root@oracle11g ~]# groupadd -g 1000 oinstall[root@oracle11g ~]# groupadd -g 1001 dba[root@oracle11g ~]# useradd -u 1000 -g oinstall -G dba oracle[root@oracle11g ~]# passwd oracle建立oracle软件安装文件目录[root@oracle11g ~]# mkdir -p /u01/oracle[root@oracle11g ~]# chown -R oracle:oinstall /u01/设置oracle环境变量[root@oracle11g ~]vi ~oracle/.bash_profileumask 022export ORACLE_BASE=/u01/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0 export ORACLE_SID=oracle11gexport PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib加载配置oracle用户注销重新登录或##su - oracle#source .bash_profile5、解压安装文件#unzip linux.x64_11gR2_database_1of2.zip -d /mnt#unzip linux.x64_11gR2_database_2of2.zip -d /mnt6、修改配置文件[root@oracle11g ~]# grep -v '^#' /mnt/database/response/db_install.rsp (参考静默安装----配置文件说明)oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2 _0oracle.install.option=INSTALL_DB_SWONLYORACLE_HOSTNAME=UNIX_GROUP_NAME=oinstallINVENTORY_LOCATION=/u01/oracleSELECTED_LANGUAGES=en,zh_CN,zh_TW (选择要支持的语言)ORACLE_HOME=/u01/oracle/product/11.2.0ORACLE_BASE=/u01/oracleoracle.install.db.InstallEdition=EEoracle.install.db.isCustomInstall=trueoracle.install.db.DBA_GROUP=dbaoracle.install.db.OPER_GROUP=oinstalloracle.install.db.config.starterdb.characterSet=AL32UTF8 (根据生产环境中的需要,进行修改字符集)oracle.install.db.config.starterdb.memoryOption=trueoracle.install.db.config.starterdb.installExampleSchemas=falseoracle.install.db.config.starterdb.enableSecuritySettings=trueoracle.install.db.config.starterdb.control=DB_CONTROLoracle.install.db.config.starterdb.automatedBackup.enable=falseDECLINE_SECURITY_UPDATES=true (要家上,要不然会报错【server】email address 错误)7、静默安装数据库[root@oracle11g ~]#cd /mnt/database/response[root@oracle11g response]$ chown -R oracle:oinstall/mnt/database/response/db_install.rsp[root@oracle11g response]$chmod 700 db_install.rsp#su - oracle#cd /mnt/database/$ ./runInstaller -silent -force -responseFile/mnt/database/response/db_install.rsp (注意要写绝对路径)如报ins-13014 错误不需要理会报ins-07001 配置文件中的有些文件找不到,对安装没有多大影响(日志文件看安装进度)#tail -100f /u01/oracle/logs/installActions2013-06-10_04-01-32PM.log带出现以下内容,说明安装成功#!/bin/sh#Root scripts to run/u01/oracle/orainstRoot.sh/u01/oracle/product/11.2.0/root.shTo execute the configuration scripts:1. Open a terminal window2. Log in as "root"3. Run the scripts4. Return to this window and hit "Enter" key to continueSuccessfully Setup Software.注意:必须用root用户跑一下脚本#/u01/oracle/orainstRoot.sh#/u01/oracle/product/11.2.0/root.sh[root@oracle11g 11.2.0]# su - oracle[oracle@oracle11g ~]$ ps aux |grepora_oracle 18649 0.0 0.0 61188 744 pts/2 S+ 16:31 0:00 grepora_ (说明没有数据库)只安装了实例[oracle@oracle11g ~]$ sqlsqlite3 sqlldr sqlldrO sqlplus[oracle@oracle11g ~]$ sqlplus / as sysdba (出现错误,但实例已安装完成)sqlplus: error while loading shared libraries:/u01/oracle/product/11.2.0/lib/libclntsh.so.11.1: cannot restore segment prot after reloc: Permission denied(关闭防火墙与sensetforce )[root@oracle11g ~]# iptables -LChain INPUT (policy ACCEPT)target prot opt source destinationChain FORWARD (policy ACCEPT)target prot opt source destinationChain OUTPUT (policy ACCEPT)target prot opt source destination[root@oracle11g ~]# getenforceEnforcing[root@oracle11g ~]# setenforce 0[root@oracle11g ~]# getenforcePermissive[oracle@oracle11g ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Mon Jun 10 16:40:29 2013 Copyright (c) 1982, 2009, Oracle. All rights reserved.Connected to an idle instance.SQL>。
Oracle 11g安装图文攻略(转载网络文章)
Oracle 11g安装图文攻略呵呵,花了一个多小时,左右把11g安装折腾好了。
其中折腾SQL Developer 花了好长时间,总算搞定了。
好了,先总结下安装步骤,希望给后面的童鞋提高安装效率。
呵呵。
一、Oracle 下载注意Oracle分成两个文件,下载完后,将两个文件解压到同一目录下即可。
路径名称中,最好不要出现中文,也不要出现空格等不规则字符。
官方下地址:/technetwork/database/enterprise-edition/downloads/ index.html以下两网址来源此官方下载页网。
win 32位操作系统下载地址:/otn/nt/oracle11g/112010/win32_11gR2_database_ 1of2.zip/otn/nt/oracle11g/112010/win32_11gR2_database_ 2of2.zipwin 64位操作系统下载地址:/otn/nt/oracle11g/112010/win64_11gR2_database_ 1of2.zip/otn/nt/oracle11g/112010/win64_11gR2_database_ 2of2.zip二、Oracle安装1. 解压缩文件,将两个压缩包一起选择,鼠标右击 -> 解压文件如图2.两者解压到相同的路径中,如图:3. 到相应的解压路径上面,找到可执行安装文件【 setup.exe 】双击安装。
如图:4. 安装第一步:配置安全更新,这步可将自己的电子邮件地址填写进去(也可以不填写,只是收到一些没什么用的邮件而已)。
取消下面的“我希望通过My Oracle Support接受安全更新(W)”。
如图:5. 安全选项,直接选择默认创建和配置一个数据库(安装完数据库管理软件后,系统会自动创建一个数据库实例)。
如图:6. 系统类,直接选择默认的桌面类就可以了。
(若安装到的电脑是,个人笔记本或个人使用的电脑使用此选项) 如图:7. 典型安装。
oracle11_linux6静默安装个人记录
一,安装必要组件[root@db-zhfx ~]# rpm -q gcc gcc-c++ glibc glibc-devel make binutils compat-db compat-libcap1 compat-libstdc++-33 unixODBC unixODBC-devel libaio-devel sysstat libgcc libstdc++- libaio libaio-develgcc-4.4.7-11.el6.x86_64gcc-c++-4.4.7-11.el6.x86_64glibc-2.12-1.80.el6.x86_64glibc-2.12-1.80.el6.i686glibc-devel-2.12-1.80.el6.x86_64make-3.81-20.el6.x86_64binutils-2.20.51.0.2-5.34.el6.x86_64compat-db-4.6.21-15.el6.x86_64compat-libcap1-1.10-1.x86_64compat-libstdc++-33-3.2.3-69.el6.x86_64unixODBC-2.2.14-11.el6.x86_64unixODBC-devel-2.2.14-11.el6.x86_64libaio-devel-0.3.107-10.el6.x86_64sysstat-9.0.4-20.el6.x86_64libgcc-4.4.7-11.el6.x86_64libgcc-4.4.7-11.el6.i686libstdc++-4.4.7-11.el6.x86_64libaio-0.3.107-10.el6.x86_64libaio-devel-0.3.107-10.el6.x86_64[root@db-zhfx ~]#二,系统参数修改/etc/sysctl.conf#Below for oracle11gkernel.core_uses_pid = 1kernel.shmmni = 4096kernel.sem = 250 32000 100 128net.core.rmem_default = 4194304net.core.rmem_max = 4194304net.core.wmem_default = 1048576net.core.wmem_max = 1048576fs.file-max = 6815744fs.aio-max-nr = 1048576net.ipv4.ip_local_port_range = 9000 65000sysctl -p/etc/security/limits.d/90-nproc.conf/etc/security/limits.conf* soft nofile 65536* hard nofile 65536* soft nproc 131072* hard nproc 131072三,创建用户和环境groupadd oinstalluseradd oracle -g oinstall -d /data/oraclepasswd oracle[oracle@iq ~]$ vi .bashrc# .bashrc# Source global definitionsif [ -f /etc/bashrc ]; then. /etc/bashrcfi# User specific aliases and functionsORACLE_BASE=/data/oracleORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1ORACLE_SID=IPMSPATH=$ORACLE_HOME/bin:$PATHORACLE_OWNER=oracleexport ORACLE_UNQNAME=$ORACLE_SIDexport ORACLE_BASE ORACLE_HOME ORACLE_SID PATH ORACLE_OWNR四,修改db_install.rsp并安装cp /upload/database/response/*.rsp /data/oracle/修改db_install.rspLANG=C./runInstaller -silent -responseFile /data/oracle/db_install.rsptail -f /data/oracle/oraInventory/logs/installActions2016-03-28_11-54-07PM.log 五,创建监听netca /silent /responseFile /data/oracle/netca.rsp六,建库nohup dbca -silent -responseFile /data/oracle/dbca.rsp &七,配置文件举例[oracle@iq ~]$ cat dbca.rsp |grep -v ^$|grep -v ^#[GENERAL]RESPONSEFILE_VERSION = "11.2.0"OPERATION_TYPE = "createDatabase"[CREATEDATABASE]GDBNAME = "IPMS"SID = "IPMS"TEMPLATENAME = "General_Purpose.dbc"SYSPASSWORD = "sys1234"SYSTEMPASSWORD = "sys1234"DATAFILEDESTINATION =/data/oracle/dbRECOVERYAREADESTINATION=/data/oracle/flash_recovery_areaSTORAGETYPE=FSCHARACTERSET = "ZHS16GBK"LISTENERS = "LISTENER"TOTALMEMORY = "1600"[oracle@iq ~]$[oracle@iq ~]$ cat db_install.rsp |grep -v ^$|grep -v ^#oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11 _2_0oracle.install.option=INSTALL_DB_SWONLYORACLE_HOSTNAME=IQUNIX_GROUP_NAME=oinstallINVENTORY_LOCATION=/data/oracle/oraInventorySELECTED_LANGUAGES=en,zh_CNORACLE_HOME=/data/oracle/product/11.2.0/dbhome_1ORACLE_BASE=/data/oracleoracle.install.db.InstallEdition=EEoracle.install.db.EEOptionsSelection=falseoracle.install.db.optionalComponents=oracle.rdbms.partitioning:11.2.0.4.0,oracle.oraolap :11.2.0.4.0,oracle.rdbms.dm:11.2.0.4.0,oracle.rdbms.dv:11.2.0.4.0,oracle.rdbms.lbac:11.2.0.4.0,oracle.rdbms.rat:11.2.0.4.0oracle.install.db.DBA_GROUP=oinstalloracle.install.db.OPER_GROUP=oinstalloracle.install.db.CLUSTER_NODES=oracle.install.db.isRACOneInstall=falseoracle.install.db.racOneServiceName=oracle.install.db.config.starterdb.type=GENERAL_PURPOSEoracle.install.db.config.starterdb.globalDBName=IPMSoracle.install.db.config.starterdb.SID=IPMSoracle.install.db.config.starterdb.characterSet=ZHS16GBKoracle.install.db.config.starterdb.memoryOption=trueoracle.install.db.config.starterdb.memoryLimit=1600oracle.install.db.config.starterdb.installExampleSchemas=falseoracle.install.db.config.starterdb.enableSecuritySettings=trueoracle.install.db.config.starterdb.password.ALL=sys1234oracle.install.db.config.starterdb.password.SYS=oracle.install.db.config.starterdb.password.SYSTEM=oracle.install.db.config.starterdb.password.SYSMAN=oracle.install.db.config.starterdb.password.DBSNMP=oracle.install.db.config.starterdb.control=DB_CONTROLoracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=oracle.install.db.config.starterdb.automatedBackup.enable=falseoracle.install.db.config.starterdb.automatedBackup.osuid=oracle.install.db.config.starterdb.automatedBackup.ospwd=oracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGEoracle.install.db.config.starterdb.fileSystemStorage.dataLocation=/data/oracle/db oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=/data/oracle/oraInv entoryoracle.install.db.config.asm.diskGroup=oracle.install.db.config.asm.ASMSNMPPassword=MYORACLESUPPORT_USERNAME=MYORACLESUPPORT_PASSWORD=SECURITY_UPDATES_VIA_MYORACLESUPPORT=DECLINE_SECURITY_UPDATES=truePROXY_HOST=PROXY_PORT=PROXY_USER=PROXY_PWD=PROXY_REALM=COLLECTOR_SUPPORTHUB_URL=oracle.installer.autoupdates.option=oracle.installer.autoupdates.downloadUpdatesLoc=AUTOUPDATES_MYORACLESUPPORT_USERNAME=AUTOUPDATES_MYORACLESUPPORT_PASSWORD=[oracle@iq ~]$[oracle@iq ~]$ cat netca.rsp |grep -v ^$|grep -v ^#[GENERAL]RESPONSEFILE_VERSION="11.2"CREATE_TYPE="CUSTOM"[.ca]INSTALLED_COMPONENTS={"server","net8","javavm"} INSTALL_TYPE=""typical""LISTENER_NUMBER=1LISTENER_NAMES={"LISTENER"}LISTENER_PROTOCOLS={"TCP;1521"}LISTENER_START=""LISTENER""NAMING_METHODS={"TNSNAMES","ONAMES","HOSTNAME"} NSN_NUMBER=1NSN_NAMES={"EXTPROC_CONNECTION_DATA"}NSN_SERVICE={"PLSExtProc"}NSN_PROTOCOLS={"TCP;HOSTNAME;1521"}[oracle@iq ~]$。
Centos7静默安装oracle 11g
Centos7静默安装Oracle11g1、创建用户和组groupadd oinstallgroupadd dbauseradd -g oinstall -g dba -m oraclepasswd oracle2、创建Oracle数据库的安装目录(for静默安装)mkdir -p /opt/oraclemkdir -p /opt/oraInventorymkdir -p /opt/databasemkdir -p /opt/oracle/product/11.2.0mkdir -p /opt/oracle/oradatamkdir -p /opt/oracle/flash_recovery_areachown -R oracle:oinstall /opt/oraclechown -R oracle:oinstall /opt/oracle/oradatachown -R oracle:oinstall /opt/oraInventorychown -R oracle:oinstall /opt/databasechmod -R 775 /opt/oracle3、配置oracle环境su - oraclevim .bash_profile添加如下内容:# 注意:# 1. ORACLE_SID 必须与创建的数据库实例名称一致,否则数据库启动后无法访问# 2. ORACLE_HOME 根据实际情况填写,安装完毕以后,再检查一下,如果有误,需要调整,确保正确ORACLE_BASE=/opt/oracle#ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1ORACLE_HOME=$ORACLE_BASE/product/11.2.0ORACLE_SID=orclPATH=$PATH:$ORACLE_HOME/binexport ORACLE_BASE ORACLE_HOME ORACLE_SID PATH执行生效:source .bash_profile检查是否生效echo $ORACLE_HOME4、解压安装包cd /optunzip linux.x64_11gR2_database_1of2.zip -d /opt/databaseunzip linux.x64_11gR2_database_2of2.zip -d /opt/database5、用root账号创建/etc/oraInst.loc文件,否则安装时会报错:SEVERE: [FATAL] [INS-32038] The operating system group specified for central inventory (oraInventory) ownership is invalid.vim /etc/oraInst.locinventory_loc=/opt/oraInventoryinst_group=oinstall6、安装未安装的package验证命令26个包,如果没有安装,需要先安装Su - rootrpm -qa binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-develelfutils-libelf-devel-static gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers glibc-static kernel-headers pdksh libaio libaio-devel libgcc libgomp libstdc++ libstdc++-devel libstdc++-static make numactl-devel sysstat unixODBC unixODBC-develyum install -y binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-develelfutils-libelf-devel-static gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers glibc-static kernel-headers pdksh libaio libaio-devel libgcc libgomp libstdc++ libstdc++-devel libstdc++-static make numactl-devel sysstat unixODBC unixODBC-devel####redhat7.5 执行的安装命令;yum install -y compat-libstdc++-33 elfutils-libelf-devel gcc gcc-c++ glibc-develyum install -y ksh libaio-devel numactl-develyum install -y unixODBC unixODBC-devel oracleasm oracleasmlib oracleasm-support注意,安装完以后,可以再重新执行一次yum install确认一下,是否有未安装的包。
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命令解压。
解压完成之后,修改宿主
oracle11G静默安装@centos6.8演示教学
o r a c l e11G静默安装@c e n t o s6.8配置系统代理:root 用户加http和ftp代理:sed -i '$a export http_proxy="http://10.45.60.183:8080/"\n exporthttp_ftp="http://10.45.60.183:8080/"' /root/.bash_profileyum.conf增加代理sed -i '$a proxy=http://10.45.60.183:8080/' /etc/yum.confwgetrc增加代理:sed -i '$a https_proxy=http://10.45.60.183:8080/\nhttp_proxy=http://10.45.60.183:8080/\n ftp_proxy=http://10.45.60.183:8080/'/etc/wgetrcps: 运行yum.sh增加本地源和安装vncyum-6.8.sh.配置系统和安装所需软件包2.1 关闭selinuxsed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config2.6安装oracle所需的软件包yum install -y gcc gcc-c++ glibc glibc-devel glibc-headers pdksh libaio libaio-devel libgcc libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-devel zlib-devel unzip compat-libcap1 compat-libstdc++-33重启以后再安装pdksh:wget /centos/5/os/x86_64/CentOS/pdksh-5.2.14-37.el5_8.1.x86_64.rpmrpm -ivh pdksh-5.2.14-37.el5_8.1.x86_64.rpm如果:pdksh 与 (已安裝) ksh-20120801-22.el7_1.3.x86_64 冲突需要先卸载ksh:rpm -e ksh-20120801-22.el7_1.3.x86_642.7 添加oracle用户和组groupadd oinstallgroupadd dbagroupadd opermkdir /oracleuseradd -d /oracle -g oinstall -G dba,oper -u 500 -r -p ztesoft oracle2.8 修改系统参数2.8.1 /etc/sysctl.conffs.file-max = 6815744kernel.sem = 250 32000 100 128kernel.shmmni = 4096kernel.shmall = 1073741824kernel.shmmax = 4398046511104net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576fs.aio-max-nr = 1048576net.ipv4.ip_local_port_range = 9000 65500命令行:sed -i '$a fs.file-max = 6815744\nkernel.sem = 250 32000 100 128\nkernel.shmmni = 4096\nkernel.shmall = 1073741824\nkernel.shmmax =4398046511104\nnet.core.rmem_default = 262144\nnet.core.rmem_max = 4194304\nnet.core.wmem_default = 262144\nnet.core.wmem_max =1048576\nfs.aio-max-nr = 1048576\nnet.ipv4.ip_local_port_range = 9000 65500\n' /etc/sysctl.conf2.8.2 应用核心参数sysctl -p2.8.3 /etc/security/limits.conforacle soft nofile 1024oracle hard nofile 65536oracle soft nproc 2047oracle hard nproc 16384oracle soft stack 10240oracle hard stack 32768命令行:sed -i '$a oracle soft nofile 1024\noracle hard nofile 65536\noracle soft nproc 2047\noracle hard nproc 16384\noracle soft stack 10240\noracle hard stack 32768\n' /etc/security/limits.conf2.9 创建安装文件夹mkdir /oracle/zscmkdir /oracle/oradatamkdir /oracle/oraInventorychown -R oracle:oinstall /oracle3.切换到oracle用户,配置oracle用户环境变量3.1 设置oracle用户密码并切换到oracle用户passwd oraclesu - oracle3.2 编辑oracle用户环境变量配置文件~/.bash_profileexport PS1="[\u@\h\w]$"export ORACLE_BASE=/oracle/zscexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1export ORACLE_SID=zscPATH=/usr/sbin:$PATH:$ORACLE_HOME/bin:$HOME/bin:/$HOME/.local/bin export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export NLS_LANG="SIMPLIFIED CHINESE_CHINA.AL32UTF8"alias cdob='cd $ORACLE_BASE'alias cdoh='cd $ORACLE_HOME'alias tns='cd $ORACLE_HOME/network/admin'alias envo='env | grep ORACLE'3.3 应用环境变量source .bash_profile4.获取安装包进行安装4.1 从/technetwork/database/enterprise-edition/downloads/index.html 下载oracle12c安装包4.2 解压安装包unzip linux.x64_11gR2_database_1of2.zipunzip linux.x64_11gR2_database_2of2.zip4.3 进入database文件夹复制一个应答文件cd databasecp response/db_install.rsp inst.rsp4.4 修改应答文件ps:需要手动修改:INVENTORY_LOCATION=/oracle/oraInventoryORACLE_HOME=/oracle/zsc/product/11.2.0/dbhome_1ORACLE_BASE=/oracle/zsc4.5 执行安装程序./runInstaller -ignoreSysPrereqs -force -silent -responseFile ~/database/inst.rsp4.6 查看是否有出错日志tail –f /oracle/oraInventory/logs/silentInstall2016-05-07_01-34-53PM.log如果没有安装pdksh会报如下错:INFO: Actual Value:缺失INFO: Error Message:PRVF-7532 : 节点 "localhost" 上缺少程序包 "pdksh" INFO: Cause: 指定的节点上未安装必需的程序包; 或者如果该程序包是内核模块, 则未加载该程序包。
Oracle 11g 静默安装-db_install.rsp详解
Oracle 11g 静默安装-db_install.rsp详解前提安装正常的配置流程,配置完服务器后,将db_install.rsp、netca.rsp,dbca.rsp复制到/app/一份,然后参考后面静默配置文件修改好后安装静默安装命令:./runInstaller –silent –responseFile /app/db_install.rsp -showProgress –noconfig –ignoreSysPrereqs静默配置网络监听命令./netca –silent –responseFile /app/netca.rsp静默创建数据库命令./dbca –silent –responseFile /app/dbca.rspvi /etc/selinux/config# 设置SELINUX为disabledSELINUX=disabled[root@oracle ~]# service iptables stop###################################################################### Copyright(c) Oracle Corporation1998,2008. All rights reserved. #### Specify values for the variables listedbelow to customize your installation. #### Each variable is associated with acomment. The comment #### can help to populate the variables withthe appropriate values. #### IMPORTANT NOTE: This file contains plaintext passwords and #### should be secured to have readpermission only by oracle user #### or db administrator who owns thisinstallation. ####对整个文件的说明,该文件包含参数说明,静默文件中密码信息的保密######################################################################---------# Do not change the following system generatedvalue. 标注响应文件版本,这个版本必须和要#安装的数据库版本相同,安装检验无法通过,不能更改#------------------------------------------------------------------------------oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_re sponse_schema_v11_2_0#------------------------------------------------------------------------------# Specify the installation option.# It can be one of the following:# 1. INSTALL_DB_SWONLY# 2. INSTALL_DB_AND_CONFIG# 3. UPGRADE_DB#选择安装类型:1.只装数据库软件 2.安装数据库软件并建库 3.升级数据库#-------------------------------------------------------------------------------oracle.install.option=INSTALL_DB_SWONLY----------# Specify the hostname of the system as setduring the install. It can be used# to force the installation to use analternative hostname rather than using the# first hostname found on the system.(e.g., for systems with multiple hostnames# and network interfaces)指定操作系统主机名,通过hostname命令获得#-------------------------------------------------------------------------------ORACLE_HOSTNAME=dygisapp#-------------------------------------------------------------------------------# Specify the Unix group to be set for theinventory directory.#指定oracle inventory目录的所有者,通常会是oinstall或者dba#-------------------------------------------------------------------------------UNIX_GROUP_NAME=oinstall----------# Specify the location which holds theinventory files.#指定产品清单oracle inventory目录的路径,如果是Win平台下可以省略#-------------------------------------------------------------------------------INVENTORY_LOCATION=/app/oracle/oraInventory#-------------------------------------------------------------------------------# Specify the languages in which thecomponents will be installed.# en : English ja : Japanese# fr : French ko : Korean# ar : Arabic es : Latin American Spanish# bn : Bengali lv : Latvian# pt_BR: Brazilian Portuguese lt : Lithuanian# bg : Bulgarian ms : Malay# fr_CA: Canadian French es_MX: Mexican Spanish# ca : Catalan no : Norwegian# hr : Croatian pl : Polish# cs : Czech pt : Portuguese# da : Danish ro : Romanian# nl : Dutch ru : Russian# ar_EG: Egyptian zh_CN: Simplified Chinese # en_GB: English (Great Britain) sk :Slovak # et : Estonian sl : Slovenian# fi : Finnish es_ES: Spanish# de : German sv : Swedish# el : Greek th : Thai# iw : Hebrew zh_TW:Traditional Chinese# hu : Hungarian tr : Turkish# is : Icelandic uk : Ukrainian# in : Indonesian vi :Vietnamese# it : Italian# Example : SELECTED_LANGUAGES=en,fr,ja#指定数据库语言,可以选择多个,用逗号隔开。
Linux7静默安装Oracle11g教程
Linux7静默安装Oracle11g教程1.查看swap大小,若小于150M,需添加增加虚拟空间dd if=/dev/zero of=/swapadd bs=1024 count=2006424mkswap /swapaddswapon /swapadd重启系统虚拟空间会消失,除非打开/etc/fstab文件,加入/swap swap swap default 0 02.查看操作系统信息[root@docker ~]# uname -mx86_64[root@docker ~]# cat /etc/redhat-releaseCentOS Linux release 7.1.1503 (Core)3.安装前的准备a.修改主机名,linux7以上系统用:hostnamectl set-hostname hostname4.关闭selinux:vi /etc/selinux/config,设置如下,重启系统reboot;5.检查以下服务是否安装binutils-2.23.52.0.1-12.el7.x86_64compat-libcap1-1.10-3.el7.x86_64compat-libstdc++-33-3.2.3-71.el7.i686compat-libstdc++-33-3.2.3-71.el7.x86_64 gcc-4.8.2-3.el7.x86_64gcc-c++-4.8.2-3.el7.x86_64glibc-2.17-36.el7.i686glibc-2.17-36.el7.x86_64glibc-devel-2.17-36.el7.i686glibc-devel-2.17-36.el7.x86_64kshlibaio-0.3.109-9.el7.i686libaio-0.3.109-9.el7.x86_64libaio-devel-0.3.109-9.el7.i686libaio-devel-0.3.109-9.el7.x86_64libgcc-4.8.2-3.el7.i686libgcc-4.8.2-3.el7.x86_64libstdc++-4.8.2-3.el7.i686libstdc++-4.8.2-3.el7.x86_64libstdc++-devel-4.8.2-3.el7.i686libstdc++-devel-4.8.2-3.el7.x86_64libXi-1.7.2-1.el7.i686libXi-1.7.2-1.el7.x86_64libXtst-1.2.2-1.el7.i686libXtst-1.2.2-1.el7.x86_64make-3.82-19.el7.x86_64sysstat-10.1.5-1.el7.x86_64unixODBC-2.3.1-6.el7.x86_64 or laterunixODBC-2.3.1-6.el7.i686 or laterunixODBC-devel-2.3.1-6.el7.x86_64 or laterunixODBC-devel-2.3.1-6.el7.i686 or later若担心系统包比较旧可考虑先更新程序包:yum -y upgrade,(提示:等待时间比较长!)用yum进行安装所需服务:yum -y install binutils compat-libcap1 compat-libstdc++-33 compat-libstdc++-33*i686 compat-libstdc++-33*.devel compat-libstdc++-33 compat-libstdc++-33*.devel gcc gcc-c++ glibc glibc*.i686 glibc-devel glibc-devel*.i686 ksh libaio libaio*.i686 libaio-devel libaio-devel*.devel libgcc libgcc*.i686 libstdc++ libstdc++*.i686 libstdc++-devel libstdc++-devel*.devel libXi libXi*.i686 libXtst libXtst*.i686 make sysstat unixODBC unixODBC*.i686 unixODBC-devel unixODBC-devel*.i686检查31个包是否都有安装,版本号只能大于规定的版本,不能小于rpm -q binutils compat-libcap1 compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel libXi libXtst make sysstat unixODBC unixODBC-devel[root@docker ~]# rpm -q binutils compat-libcap1 compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel libXi libXtst make sysstat unixODBC unixODBC-develbinutils-2.23.52.0.1-55.el7.x86_64 compat-libcap1-1.10-7.el7.x86_64 compat-libstdc++-33-3.2.3-72.el7.x86_64 compat-libstdc++-33-3.2.3-72.el7.i686 gcc-4.8.5-4.el7.x86_64gcc-c++-4.8.5-4.el7.x86_64glibc-2.17-106.el7_2.8.x86_64glibc-2.17-106.el7_2.8.i686glibc-devel-2.17-106.el7_2.8.x86_64 glibc-devel-2.17-106.el7_2.8.i686ksh-20120801-22.el7_1.3.x86_64libaio-0.3.109-13.el7.x86_64libaio-0.3.109-13.el7.i686libaio-devel-0.3.109-13.el7.x86_64 libaio-devel-0.3.109-13.el7.i686libgcc-4.8.5-4.el7.x86_64libgcc-4.8.5-4.el7.i686libstdc++-4.8.5-4.el7.x86_64libstdc++-4.8.5-4.el7.i686libstdc++-devel-4.8.5-4.el7.x86_64 libstdc++-devel-4.8.5-4.el7.i686libXi-1.7.2-2.1.el7.x86_64libXi-1.7.4-2.el7.i686libXtst-1.2.2-2.1.el7.x86_64libXtst-1.2.2-2.1.el7.i686make-3.82-21.el7.x86_64sysstat-10.1.5-7.el7.x86_64unixODBC-2.3.1-11.el7.x86_64unixODBC-2.3.1-11.el7.i686unixODBC-devel-2.3.1-11.el7.x86_64unixODBC-devel-2.3.1-11.el7.i6866.创建oinstall和dba组/usr/sbin/groupadd oinstall/usr/sbin/groupadd dba7.创建Oracle用户:/usr/sbin/useradd -g oinstall -G dba oracle设置oracle密码passwd oracle验证创建及所属组是否正确:id oracle[root@docker ~]# id oracleuid=1001(oracle) gid=1001(oinstall) groups=1001(oinstall),1002(dba) 8.配置内核参数[root@docker ~]# vim /etc/sysctl.conf# System default settings live in /usr/lib/sysctl.d/00-system.conf.# To override those settings, enter new settings here, or in an /etc/sysctl.d/<name>.conf file## For more information, see sysctl.conf(5) and sysctl.d(5).fs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmall = 2097152kernel.shmmax = 7516192768 #7Gkernel.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参数的值不能小于上面的配置,因为这是oracle官方建议的最小值,所以生产环境建议调整为这些参数,以优化系统性能。
oracle11grac静默安装+racADG部署搭建
oracle11grac静默安装+racADG部署搭建说明以下说描述的的安装rac是安装⼀个rac备端,只需要安装grid软件和oracle软件即可。
⼀、硬件配置:cup:Linux db51 3.10.0-1062.el7.x86_64 #1 SMP Wed Aug 7 18:08:02 UTC 2019 x86_64 x86_64 x86_64 GNU/Linux内存:250GOCR:3G*3DATA:480G*6⼆、软件环境:操作系统:CentOS Linux release 7.7.1908 (Core)数据库:oracle 11.2.0.4 R2 RAC三、业务系统:业务系统四、主机规划:五、数据库安装前准备1、配置DNS内容(可忽略):vi /etc/resolv.confnameserver 192.168.3.1nameserver 192.168.3.22、改hosts⽂件节点⼀db51和节点⼆db52:#pub192.168.3.51 db51192.168.3.52 db52#vip192.168.3.54 db51-vip10.10.10.52 db52-vip#priv10.10.10.51 db51-priv192.168.3.55 db52-priv#scan172.16.53.56 db-scan3、关闭防⽕墙systemctl status firewalldsystemctl stop firewalldsystemctl disable firewalld4、关闭selinuxSetenforce 0vi /etc/sysconfig/selinux将SELINUX值改为disabled6、关闭透明⼤页==查看:cat /sys/kernel/mm/transparent_hugepage/enabled[always] madvise never默认为always。
Oracle11g单实例静默安装实战记录(linux)
Oracle11g单实例静默安装实战记录(linux)oracle 11g 单实例静默安装AUTHOR:Oracle_Ran环境规划:OS Version : Red Hat Enterprise Linux Server release 6.7 (Santiago)Oracle Version: 11.2.0.4操作系统环境配置可参考Oracle 单实例安装⽂档1、上传Oracle安装介质,进⼊解压⽬录,复制响应⽂件模板cd /home/oracle/mkdir rspcp /db/soft/database/response/* /home/oracle/rsp/su - rootchmod 700 /home/oracle/rsp/*.rspchown -R oracle:oinstall /home/oracle/rsp/2、修改响应⽂件相关参数vi /home/oracle/rsp/db_install.rsporacle.install.option=INSTALL_DB_SWONLY //安装类型ORACLE_HOSTNAME=hostname //主机名称UNIX_GROUP_NAME=oinstall //安装组INVENTORY_LOCATION=/db/oraInventory //INVENTORY⽬录SELECTED_LANGUAGES=en,zh_CN,AL32UTF8 //选择语⾔ORACLE_HOME=/db/oracle/product/11.2.0/db_1 //oracle_homeORACLE_BASE=/db/oracle //oracle_baseoracle.install.db.InstallEdition=EE //oracle版本oracle.install.db.isCustomInstall=true //⾃定义安装oracle.install.db.DBA_GROUP=dba //dba⽤户组oracle.install.db.OPER_GROUP=oinstall //oper⽤户组oracle.install.db.config.starterdb.type=GENERAL_PURPOSE //数据库类型oracle.install.db.config.starterdb.globalDBName=oadb //globalDBNameoracle.install.db.config.starterdb.SID=orcl //SIDoracle.install.db.config.starterdb.characterSet=AL32UTF8 //字符集oracle.install.db.config.starterdb.memoryLimit=512 //⾃动管理内存的最⼩内存(M)oracle.install.db.config.starterdb.password.ALL=oracle //设定所有数据库⽤户使⽤同⼀个密码DECLINE_SECURITY_UPDATES=true //设置安全更新3、静默安装数据库软件[oracle@template database]$ ./runInstaller -silent -force -responseFile /home/oracle/res/db_install.rsp【注意】安装过程中如果出现Fail,说明安装中断。
CentOS7.6静默(无图形化界面)安装Oracle11g
CentOS7.6静默(⽆图形化界⾯)安装Oracle11g⼀、准备⼯作1.准备CentOS 7 系统环境由于是使⽤静默模式(silent)安装的,⽆需使⽤图形化界⾯,我选择了最⼩安装的服务器版的CentOS 7。
安装完成后,只有命令⾏界⾯。
2.下载 Oracle 11g特别注意:11.2.0.2.0 zlinux64版本的Oracle是安装在IBM服务器的,CentOS 7是⽆法安装的。
(2)下载完成后,有两个压缩⽂件linux.x64_11gR2_database_1of2.zip 和 linux.x64_11gR2_database_2of2.zip3.通过Xftp将压缩⽂件上传到 /db/4.安装依赖包,安装依赖包之前,个⼈建议将yum源修改为aliyun源,下载速度快些,执⾏如下命令即可:cd /etcmv yum.repos.d yum.repos.d.bakmkdir yum.repos.dwget -O /etc/yum.repos.d/CentOS-Base.repo /repo/Centos-7.repoyum clean allyum makecache若提⽰:正在解析主机 ()... 失败:未知的名称或服务。
则执⾏:echo 'nameserver 8.8.8.8'>>/etc/resolv.conf5.修改成功后,安装如下依赖包:yum -y install 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-devel6.安装完成后显⽰如下界⾯7.使⽤如下命令检查依赖是否安装完整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"8.发现 pdksh 没有安装9.执⾏ yum -y install pdksh,发现CentOS 7 没有相关安装包可⽤10.通过wget命令直接下载pdksh的rpm包,我下载到了/tmp/wget -O /tmp/pdksh-5.2.14-37.el5_8.1.x86_64.rpm /5.11/os/x86_64/CentOS/pdksh-5.2.14-37.el5_8.1.x86_64.rpm 下载完成后,进⼊ /tmp/cd /tmp/rpm -ivh pdksh-5.2.14-37.el5_8.1.x86_64.rpm11.再次检查依赖包是否安装完整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"到此依赖包安装完整12.添加oracle⽤户组和⽤户groupadd oinstallgroupadd dbagroupadd asmadmingroupadd asmdbauseradd -g oinstall -G dba,asmdba oracle -d /home/oracle13.添加完成后,查看oracle⽤户id oracle14.初始化oracle⽤户的密码passwd oracle说明:密码需输⼊两次,提⽰密码强度若不⽤管,两次⼀致后会提⽰设置成功15.配置hostname(本机IP映射)vim /etc/hosts192.168.154.154 centos-oracle16.测试hostnameping -c 3 centos-oracle17.优化OS内核参数,kernel.shmmax 参数设置为物理内存的⼀半vim /etc/sysctl.conffs.aio-max-nr=1048576fs.file-max=6815744kernel.shmall=2097152kernel.shmmni=4096kernel.shmmax = 1073741824kernel.sem=25032000100128net.ipv4.ip_local_port_range=900065500net.core.rmem_default=262144net.core.rmem_max=4194304net.core.wmem_default=262144net.core.wmem_max=104858618.使参数⽣效sysctl -p19.限制oracle⽤户的shell权限vim /etc/security/limits.conforacle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536vim /etc/pam.d/loginsession required /lib64/security/pam_limits.sosession required pam_limits.sovim /etc/profileif [ $USER = "oracle" ]; thenif [ $SHELL = "/bin/ksh" ]; thenulimit -p 16384ulimit -n 65536elseulimit -u 16384 -n 65536fifi20.创建oracle安装⽬录mkdir -p /db/app/oracle/product/11.2.0mkdir /db/app/oracle/oradatamkdir /db/app/oracle/inventorymkdir /db/app/oracle/fast_recovery_areachown -R oracle:oinstall /db/app/oraclechmod -R 775 /db/app/oracle21.配置oracle⽤户环境变量su - oraclevim .bash_profileumask 022export ORACLE_HOSTNAME=centos-oracleexport ORACLE_BASE=/db/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/export 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"22.以上配置完成后,个⼈建议重启下系统reboot23.解压oracle压缩⽂件到 /dbcd /db/unzip linux.x64_11gR2_database_1of2.zip -d /dbunzip linux.x64_11gR2_database_2of2.zip -d /db24.解压完成后mkdir /db/etc/cp /db/database/response/* /db/etc/vim /db/etc/db_install.rsporacle.install.option=INSTALL_DB_SWONLYDECLINE_SECURITY_UPDATES=trueUNIX_GROUP_NAME=oinstallINVENTORY_LOCATION=/db/app/oracle/inventorySELECTED_LANGUAGES=en,zh_CNORACLE_HOSTNAME=centos-oracleORACLE_HOME=/db/app/oracle/product/11.2.0ORACLE_BASE=/db/app/oracleoracle.install.db.InstallEdition=EEoracle.install.db.isCustomInstall=trueoracle.install.db.DBA_GROUP=dbaoracle.install.db.OPER_GROUP=dba⼆、开始安装1.切换到oracle⽤户su - oracle# 先cd到/db/database/⽬录然后执⾏./runInstaller -silent -ignorePrereq -responseFile /db/etc/db_install.rsp报错:centos 安装oracle 报Checking swap space: 0 MB available, 150 MB required. Failed <<<<【备注:若⽆此错误请忽略,我在华为云服务器挂载磁盘且安装位置设置为/mnt⽬录,此情景下安装oracle 11g时发送这样的错误,⼀般情况不会出现此错误】解决办法:(1)检查 Swap 空间在设置 Swap ⽂件之前,有必要先检查⼀下系统⾥有没有既存的 Swap ⽂件。
Linux下静默安装Oracle11gRAC
Linux下静默安装Oracle11gRACtitle: Linux下静默安装Oracle 11g RACcategories: 数据库tags:- RAC- Cluster- HA- Oracletimezone: Asia/Shanghaidate: 2019-01-06环境# Red Hat Enterprise Linux Server release 6.10.x86_64 (Santiago)# Oracle Linux 7.5 x86_64p1*******_112040_Linux-x86-64_1of7.zipp1*******_112040_Linux-x86-64_2of7.zipp1*******_112040_Linux-x86-64_3of7.zip注意事项1.主机名都用小写字母,长度不能超过15位,不要有特殊符号2.两个节点的Plublic和VIP所在网卡的网卡名要一样3.表决盘应该都是相同的大小。
不同的大小可能导致可用性降低。
第一步:规划IP地址和主机名1.IP地址规划节点hostname 类型IP地址接口备注1 rac1 Plublic IP 10.0.1.131 eth0 手动设置2 rac2 Plublic IP 10.0.1.132 eth0 手动设置1 rac1-vip Virtaual IP 10.0.1.133 eth0 集群自动设置2 rac2-vip Virtaual IP 10.0.1.134 eth0 集群自动设置Cluster rac-scan SCAN IP 10.0.1.135 eth0 集群自动设置1 rac1-priv Private IP 11.11.11.131 eth1 手动设置2 rac2-priv Private IP 11.11.11.132 eth1 手动设置2.在两个节点分别将Plublic IP和Private IP写入(by all)只需要手动在两个节点上设置静态IP地址即可。
- 1、下载文档前请自行甄别文档内容的完整性,平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益,请联系客服反馈,我们会尽快为您处理(人工客服工作时间:9:00-18:30)。
Oracle 11g静默安装过程——linux环境
一、硬件环境
1.操作系统及Oracle版本
Linux版本:Redhat 6.4
Oracle版本: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
硬盘可以空间不少于5G
swap分区空间不少于2G
支持256色以上显卡
cpu主频不小于550mHZ
cat /etc/issue
uname -r
grep MemTotal /proc/meminfo
grep S /proc/meminfo
grep "model name" /proc/cpuinfo
free
df -k /tmp
df -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.i686
gcc-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.i686
ksh
libgcc-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.i686
libstdc++-devel-4.4.4-13.el6 (x86_64)
libstdc++-devel-4.4.4-13.el6.i686
libaio-0.3.107-10.el6 (x86_64)
libaio-0.3.107-10.el6.i686
libaio-devel-0.3.107-10.el6 (x86_64)
libaio-devel-0.3.107-10.el6.i686
make-3.81-19.el6
sysstat-9.0.4-11.el6 (x86_64)
1.上传依赖包
mkdir /home/rpm
安装依赖包,把Linux安装盘中的rpm包文件传到/home/rpm,Redhat中是Packages文件下。
cd /home/rpm
2.检查安装依赖系统包
rpm -ivh glibc-common*.rpm
rpm -ivh kernel-headers*.rpm
rpm -ivh libgcc*.rpm
rpm -ivh glibc-*.rpm
rpm -ivh libgomp-*.rpm
rpm -ivh nscd*.rpm
rpm -ivh glibc-headers*.rpm
rpm -ivh glibc-devel-*.rpm
rpm -ivh mpfr*.rpm
rpm -ivh ppl*.rpm
rpm -ivh cloog-ppl*.rpm
rpm -ivh cpp*.rpm
rpm -ivh gcc-*.rpm
rpm -ivh libstdc++*.rpm
rpm -ivh libstdc++-devel*.rpm。