




版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领
文档简介
64i686ThefollowingorlaterversionofpackagesforOracleLinux6,andRedHatEnterpriseLinux6mustbeinstalled:binutils-2.20.51.0.2-5.11.el6(x86_64)compat-libcap1-1.10-1compat-libstdc++-33-3.2.3-69.el6(x86_64)gcc-4.4.4-13.el6gcc-c++-4.4.4-13.el6glibc-2.12-1.7.el6(i686)glibc-2.12-1.7.el6(x86_64)glibc-devel-2.12-1.7.el6(x86_64) libgcc-4.4.4-13.el6(i686)libgcc-4.4.4-13.el6(x86_64)libstdc++-4.4.4-13.el6(x86_64)libstdc++-devel-4.4.4-13.el6(x86_64)libaio-0.3.107-10.el6(x86_64)libaio-devel-0.3.107-10.el6(x86_64)sysstat-9.0.4-11.el6(x86_64)OracleODBCDriversYoushouldinstallODBCDriverManagerforUNIX.YoucandownloadandinstalltheDriverManagerfromthefollowingTouseODBC,youmustalsoinstallthefollowingadditionalODBCRPMs,dependingonyouroperatingsytem:OnOracleLinux6andRedHatEnterpriseLinux6:unixODBC-2.2.14-11.el6(x86_64)orlaterunixODBC-2.2.14-11.el6.i686orlaterunixODBC-devel-2.2.14-11.el6(x86_64)orlaterunixODBC-devel-2.2.14-11.el6.i686orlater11.2.3或更高的版本,db_install.rspmetalink解压oracle文件,进入 #cp #viCopyright(c)OracleCorporation1998,2008.All SpecifyvaluesforthevariableslistedbelowtocustomizeyourEachvariableisassociatedwithacomment.ThecommentcanhelptopopulatethevariableswiththeappropriateIMPORTANTNOTE:Thisfile intextpasswords##shouldbesecuredtohavereadpermissiononlybyoracle ##ordbadministratorwhoownsthisinstallation. ##对整个文件的说明,该文件包含参数说明,静默文件中信息的####Donotchangethefollowingsystemgeneratedvalue.标注响应文件版本,这个版本必须和要#安装的数据库版本相同,安装检验无法通##Specifytheinstallation#canbeoneofthe####选择安装类型:1.只装数据库软件2.安装数据库软件并建库3.升级数据库##Specifythehostnameofthesystemassetduringtheinstall.Itcanbeused#totheinstallationtouseternativehostnameratherthanusingthe#firsthostnamefoundonthesystem.(e.g.,forsystemswithmultiplehostnames#andnetworkinterfaces)hostname##SpecifytheUnixgrouptobesetfortheinventorydirectory.#指定oracleinventory 的所有者,通常会是oinstall或者dba##Specifythelocationwhichholdstheinventory#指定产品oracle ##Specifythelanguagesinwhich ponentswillbeinstalled.# : :# : :# : :LatinAmerican#bn :Bengali :Latvian#pt_BR:BrazilianPortuguese :Lithuanian# : :#fr_CA:Canadian es_MX:Mexican# : :# : :# : :# : :# : :#ar_EG: :## :# # # :# # :# :# # #:#指定数据库语言,可以选择多个,用逗号隔开。选择en, #SpecifythecompletepathoftheOracleHome.ORALCE_HOME##SpecifythecompletepathoftheOracleBase.ORALCE_BASE###Specifytheinstallationedition #Thevalueshouldcontainonlyoneofthesechoices.#EE :EnterpriseEdition#SE :StandardEdition# StandardEdition# :alEdition(WINDOWS#D##Thisvariableisusedtoenableordisablecustom#true:Componentsmentionedaspartof' ponents'property#areconsideredforinstall.#false:Valuefor' ponents'isnotconsidered.#Oraclefalse,则会使用默认的组件#安装相 ###Thisvariableconsideredonlyif'IsCustomInstall'issetto#Description:ofEnterpriseEditionOptionsyouwouldliketo#Thefollowingchoicesareavailable.Youmayspecify#combinationof Thecomponentsyou#bespecifiedinthe Belowisalistofcomponentsyoumayspecifyto oracle.rdbms.partitioning:11.2.0.1.0-Oracle oracle.rdbms.dm:11.2.0.1.0-OracleData oracle.rdbms.dv:11.2.0.1.0-OracleDatabase oracle.rdbms.lbac:11.2.0.1.0-OracleLabel oracle.rdbms.rat:11.2.0.1.0-OracleRealApplication oracle.oraolap:11.2.0.1.0-Oracle#oracle.install.db.isCustomInstall=true# #PRIVILEGEDOPERATINGSYSTEM#ProvidevaluesfortheOSgroupstowhichOSDBAandOSOPER##needstobegranted.Iftheinstallisbeingperformedasamember##group"dba",thenthatwillbeusedunlessspecifiedotherwise##OSDBA、OSOPERdba#TheDBA_GROUPistheOSgroupwhichistobegrantedOSDBAprivileges.#TheOPER_GROUPistheOSgroupwhichistobegrantedOSOPERprivileges.#Specifytheclusternodenamesselectedduringtheinstallation.#RAC##Specifythetypeofdatabasetocreate.#Itcanbeoneofthefollowing:#-GENERAL_PURPOSE/TRANSACTION_PROCESSING#-DATA_WAREHOUSE#SpecifytheStarterDatabaseGlobalDatabaseName.GlobalName##SpecifytheStarterDatabaseSID.SID#SpecifytheStarterDatabasecharacterset.#Itcanbeoneofthefollowing:#AL32UTF8,WE8ISO8859P15,#EE8MSWIN1250,NE8ISO8859P10,NEE8ISO8859P4,BLT8MSWIN1257,#BLT8ISO8859P13,CL8ISO8859P5,CL8MSWIN1251,AR8ISO8859P6,#AR8MSWIN1256,EL8ISO8859P7,EL8MSWIN1253,IW8ISO8859P8,#IW8MSWIN1255,JA16EUC,JA16EUCTILDE,JA16SJIS,JA16SJISTILDE,#KO16MSWIN949,ZHS16GBK,TH8TISASCII,ZHT32EUC,ZHT16MSWIN950,#ZHT16HKSCS,WE8ISO8859P9,TR8MSWIN1254,VN8MSWIN1258####ThisvariableshouldbesettotrueifAutomaticMemoryManagement#inDatabaseisdesired.#IfAutomaticMemoryManagementisnotdesired,andmemoryallocation#istobedonemanually,thensetittofalse.##Specifythetotalmemoryallocationforthedatabase.Value(inMB)should#atleast256MB,andshouldnotexceedthetotalphysicalmemoryavailableonthesystem.#Example:oracle.install.db.config.starterdb.memoryLimit=512#Oracle256MB#ThisvariablecontrolswhethertoloadExampleSchemasontothestarter#databaseornot.是否载入模板示例#Thisvariableincludesenablingauditsettings,configuringpasswordprofiles#andrevokingsomegrantstopublic.Thesesettingsareprovidedbydefault.#Thesesettingsmayalsobedisabled. ##Passwordscanbedforthefollowingfourschemasin #starter# # ##SYSMAN(usedEnterprise##DBSNMP(usedEnterprise##Samepasswordcanbeusedforallaccounts(not #ordifferentpasswordsforeachaccountcanbeprovided( #Thisvariableholdsthepasswordthatistobeusedforallschemasinthe#starterdatabase.##SpecifytheSYSpasswordforthestarterdatabase.#SpecifytheSYSTEMpasswordforthestarterdatabase.##SpecifytheSYSMANpasswordforthestarterdatabase.#SpecifytheDBSNMPpasswordforthestarterdatabase.#Specifythemanagementoptiontobeselectedforthestarterdatabase.#Itcanbeoneofthefollowing:#1.#2.#SpecifytheManagementServicetouseifGridControlisselectedto#thedatabase.GRID_CONTROL需要设定gridcontrol的路径URL#Thisvariableindicateswhethertoreceivenotificationfor#alertswhenusingDBcontrol.是否启用通知,启用后会将告警等到指定邮##Specifytheaddresstowhichthenotificationsaretobesent.设置通知地##SpecifytheSMTPserverusedfornotifications.设置邮件服务##SPECIFYBACKUPANDRECOVERY #Out-of-boxbackupandrecoveryoptionsforthedatabasecanbe #usingtheentries##安全及恢复设置(默认值即可)out-of-box(out-of-boxexperience)OOBE#Thisvariableistobesettofalseifautomatedbackupisnotrequired.Else#thiscanbesettotrue.OUI##Regardlessofthetypeofstoragethatischosenforbackupandrecovery,#automatedbackupsareenabled,jobwillbetorundaily#2:00AMtobackuptheThisjobwillruntheoperating#userthatisspecifiedinthisvariable.jobJOBID##Regardlessofthetypeofstoragethatischosenforbackupandrecovery,if#automatedbackupsareenabled,ajobwillbescheduledtorundailyat#2:00AMtobackupthedatabase.Thisjobwillrunastheoperatingsystemuser#specifiedbytheaboveentry.Thefollowingentrystoresthepasswordforthe#aboveoperatingsystemuser.jobOSUser##Specifythetypeofstoragetouseforthedatabase.#Itcanbeoneofthefollowing:#-FILE_SYSTEM_STORAGE#-ASM_STORAGE#Specifythedatabasefilelocationwhichisadirectoryfordatafiles,#files,redo#Applicableonlywhenoracle.install.db.config.starterdb.storage=FILE_SYSTEM#使用文件系统存放数据库文件才需要指定数据文件、控制文件、Redolog##Specifythebackupandrecovery#Applicableonlywhenoracle.install.db.config.starterdb.storage=FILE_SYSTEM##SpecifytheexistingASMdiskgroupstobeusedforstorage.#Applicableonlywhenoracle.install.db.config.starterdb.storage=ASM#ASM##SpecifythepasswordforASMSNMPuseroftheASM#Applicableonlywhenoracle.install.db.config.starterdb.storage=ASM_SYSTEM#ASMASM##SpecifytheMyOracleSupportAccountUsername.#Example ##SpecifytheMyOracleSupportAccountUsernamepassword.#Example :MYORACLESUPPORT_PASSWORD=password#metalink##Specifywhethertoenabletheusertosetthepassword#MyOracleSupportcredentials.Thevaluecanbeeithertrueorfalse.#Ifleftblankitwillbeassumedtobefalse.# :#metalink#Specifywhetheruserwantstogiveanydetailsfor#Thevaluecanbeeithertrueorfalse.Ifleftblankitwillbeassumedtobefalse.#Example :DECLINE_SECURITY_UPDATES=false#False11.2#ResponseFiletrue,否则会提示错误,不管是否正确填写了邮件地址#Specifytheservername.Lengthshouldbegreaterthanzero. #Example :_HOS#Specifytheportnumber.ShouldbeNumericandatleast2chars.#Example :_PORT=25#Specifytheusername.Leave_USERand_PWD#blankifyourserverrequiresnoauthentication.#Example :_USER=username#Specify password. _USER #blankifyourserverrequiresnoauthentication.#Example :_PWD=password$cd$./runInstaller-silent-responseFile安装过程中,如果提示[WARNING]不必理会,此时安装程序仍在进行,如果出现[FATAL],#tail- 以下配置需要以 用户的执行#要运行的 要执行配置 请执行以下操作 "root"登返回此窗口并按 键继SuccessfullySetup$root$ORACLE_HOME/bin/netca/silent/responseFile参数"silent" 参数"responsefile"=Oracle ServicesOracle 程序启动正在运行程序控制/u01/app/oracle/product/11.2.0/db_1/bin/lsnrctlstart成功完成 Net 配置。退出代码是 下生成sqlnet.ora和listener.ora两个文件。通过netstat-tlnp 说 器已经在1521端口上开始工作了 并创建相RESPONSEFILE_VERSION= OPERATION_TYPE GDBNAME= SID="wang" TEMTENAME= "General_Purpose.dbc"//建库用的模板文件SYSPASSWORD= //SYS管理员SYSTEMPASSWORD //SYSTEMDATAFILEDESTINATION=/u01/app/oracle/oradata//数据文件存放RECOVERYAREADESTINATION=/u01/app/oracle/oradata_back//恢复数据存放CHARACTERSET //字符集,重要 建库后一般不能更改,所以建库前要确定清楚TOTALMEMORY //oracle$ORACLE_HOME/bin/dbca-silent-responseFile以下是安装不成功的个别案例ps-||-vgrep|wc-ps-||-vlsnrctllsnrctl:errorwhileloadingsharedlibraries:/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1:cannotrestoresegmentprotafterreloc:Permissiondeniedsu-root su-oraclevi/etc/oratabracl:/u01/app/oracle/product/11.2.0/db_1:Y//把“N”改成这样就可以通过dbstart启动此实例,器dbstartdbshutlsnrctlsqlplus/asSQL>shutdownSQL>startupSQL>alterdatabaseSQL>alterdatabaseflashbackon;(如果要启用数据库闪回功能则执行)SQL>alterdatabaseopen;SQL>execute p_serial();(重新编译所有可能失效对象)SQL>altersystemarchivelogcurrent;(手工归档测试)SQL>setlines256pagesSQL>selectUSER_ID,USERNAME,ACCOUNT_STATUS,DEFAULT_TABLESPACEfrom$- -???????????????????????$lsnrctlLSNRCTLfor Version11.2.0.1.0- Productionon Copyright(c) 1991,2009, rights.Connectingto STATUSofthe Version Start14-MAR-0 ListeningEndpoints ServicesService " Instance" status has handler(s) thisService " 1Instance" status has handler(s) thisThecommandcompleted export$sqlplus SQL*Plus:Release 11.2.0.1.0Productionon Mar14 07:18:162012Copyright(c) 1982,2009, rights.ConnectedOracleDatabase11g EnterpriseEditionRelease 11.2.0.1.0- 64bitProductionWiththePartitioning,OLAP, DataMining RealApplicationTesting SQL>shutdownDatabaseDatabaseORACLEinstanceshutdown.SQL>startupmountORACLE TotalSystemFixedVariableDatabaseRedo DatabaseSQL>alterdatabasearchivelog;Databasealtered.SQL>alterdatabaseflashback Databasealtered.SQL>alterdatabaseDatabaseSQL>execute PL/SQLprocedure successfullycompleted.SQL>altersystem archivelog Systemaltered.SQL>Disconnectedfrom OracleDatabase 11gEnterpriseEdition Release11.2.0.1.0- WiththePartitioning,OLAP, DataMining RealApplicationTesting oracle$v
温馨提示
- 1. 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
- 2. 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
- 3. 本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
- 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
- 5. 人人文库网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
- 6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
- 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。
最新文档
- 景区监控布点方案
- 大书店开业活动方案
- 财务总监负责下的财务报表编制与分析聘用合同
- 农场水灾处理措施方案
- 企业商标保护课件的意义
- 工厂饭堂承包方案
- 票据扫描面试题及答案
- 校医防疫面试题及答案
- 2026版《全品高考》选考复习方案生物0502 第14讲 第2课时 基因分离定律的拓展应用含答案
- 移动升降车安全操作规程培训
- 2023年涉县水库投资管理运营有限公司招聘笔试模拟试题及答案解析
- 新版有创血压监测ABP培训课件
- 重症医学科常用知情告知书
- 防溺水、防性侵、防欺凌安全教育家长会
- 二等水准测量记录表
- 母线槽安装检验批质量验收记录
- 养老机构安全检查表
- 企业员工上下班交通安全培训(简详共2份)
- 小区物业服务收支情况公示
- 22种常见环境违法行为笔录调查询问笔录及现场笔录模板(修改版)
- 统编版小学语文二升三衔接专项训练—看图写话(二)【含答案】
评论
0/150
提交评论