vmware linux oracle 11g timesten安装记录.docx
《vmware linux oracle 11g timesten安装记录.docx》由会员分享，可在线阅读，更多相关《vmware linux oracle 11g timesten安装记录.docx（14页珍藏版）》请在冰豆网上搜索。
vmwarelinuxoracle11gtimesten安装记录
说明：
oracle数据库和timesten数据库都是在oracle官网下载的。
网址：
顺便附上oracle官网的timsten安装教程
linux操作系统需要的补丁包可以从网站中找到。
p8670579_112010_LINUX.zip可以XX到。
虚拟机版本：
vmwareserver1.0.6
操作系统版本
redhatlinuxe4U5（Linuxrhel42.6.9-55.ELsmp#1SMPFriApr2017:
03:
35EDT2007i686athloni386GNU/Linux）
oracle数据库版本
linux_11gR2_database_1of2.zip
linux_11gR2_database_2of2.zip
timesten数据库版本
timesten112241.linux86.tar.gz
硬件需求
内存1200M
硬盘20G
swap1G
tmp1G
一、oracle11gr2的安装
1、创建用户和组，创建安装目录并授权，解压安装文件，安装补丁。
（1）创建用户和组
su-root
groupaddoinstall
groupadddba
useradd-goinstall-Gdbaoracle
passwdoracle
（2）创建安装目录
su-root
mkdir-p/home/oracle/app/
chown-Roracle.oinstall/home/oracle/
chmod-R755/home/oracle
（3）解压安装文件。
生成oracle安装文件（database文件夹）和timesten安装文件（linux86文件夹）
su-oracle
cd/home/oracle/software
uziplinux_11gR2_database_1of2.zip
uziplinux_11gR2_database_2of2.zip
tar-xzvftimesten112241.linux86.tar.gz
（4）按照顺序安装补丁
su-root
rpm-ivhglibc-common-2.3.4-2.41.i386.rpm--force
rpm-ivhglibc-2.3.4-2.41.i386.rpm--force
2、配置linux参数
（1）.bash_profile
ORACLE_BASE=/home/oracle/app
ORACLE_HOME=$ORACLE_BASE/oracle/product/11.2.0/dbhome_1
ORACLE_SID=hpdb11g
PATH=$PATH:
$HOME/bin:
$ORACLE_HOME/bin
exportORACLE_BASE
exportORACLE_HOME
exportORACLE_SID
exportNLS_LANG=AMERICAN_AMERICA.ZHS16GBK
#执行source.bash_profile立即生效
（2）/etc/sysctl.conf
kernel.shmall=2097152
kernel.shmmax=2147483648
kernel.shmmni=4096
kernel.sem=25032000100128
fs.file-max=6815744
net.ipv4.ip_local_port_range=900065500
net.core.rmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048576
fs.aio-max-nr=1048576
#执行sysctl-p立即生效
（3）/etc/pam.d/login
sessionrequired/lib/security/pam_limits.so
sessionrequiredpam_limits.so
（4）/etc/security/limits.conf
oraclesoftnproc2047
oraclehardnproc16384
oraclesoftnofile1024
oraclehardnofile65536
（5）/etc/sysconfig/i18n
LANG="zh_CN.GBK"
SUPPORTED="zh_CN.UTF-8:
zh_CN:
zh:
en_US.UTF-8:
en_US.en"
SYSFONT="latarcyrheb-sun16"
#linux编码是utf—8，windows是GBK。
解决linux查看windows文件乱码问题
3、安装oracle11gr2
su-root
xhost+
su-oracle
./runInstaller
如果出现图1这样的错误，需要打补丁。
图1
打系统补丁
[oracle@rhel4oracle_software]$unzipp8670579_112010_LINUX.zip
[oracle@rhel4oracle_software]$cd8670579
[oracle@rhel48670579]$$ORACLE_HOME/OPatch/opatchapply-invPtrLoc$ORACLE_HOME/oraInst.loc
InvokingOPatch11.1.0.6.6
Oracle中间补丁程序安装程序版本11.1.0.6.6
版权所有（c）2009,OracleCorporation。
保留所有权利。
Oracle主目录:
/home/oracle/app/oracle/product/11.2.0/dbhome_1
主产品清单:
/home/oracle/oraInventory
从:
/home/oracle/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch版本:
11.1.0.6.6
OUI版本:
11.2.0.1.0
OUI位置:
/home/oracle/app/oracle/product/11.2.0/dbhome_1/oui
日志文件位置:
/home/oracle/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2013-04-15_10-35-41上午.log
Patchhistoryfile:
/home/oracle/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt
--------------------------------------------------------------------------------
补丁程序有多个Archive（归档）操作,但没有Make（建立）操作。
--------------------------------------------------------------------------------
ApplySession将中间补丁程序'8670579'应用到OH'/home/oracle/app/oracle/product/11.2.0/dbhome_1'
Runningprerequisitechecks...
OPatch从产品清单中检测到非集群Oracle主目录,将仅对本地系统打补丁。
请关闭本地系统上在此ORACLE_HOME之外运行的Oracle实例。
（Oracle主目录='/home/oracle/app/oracle/product/11.2.0/dbhome_1'）
本地系统是否已准备打补丁?
[y|n]
y
UserRespondedwith:
Y
为Oracle主目录备份文件和产品清单（不是用于自动回退）
正在备份受补丁程序'8670579'影响的文件以用于还原。
此操作将需要一些时间...
正在备份受补丁程序'8670579'影响的文件以用于回退。
此操作将需要一些时间...
正在为组件work.rsf,11.2.0.1.0打补丁...
用"lib/libnnz11.a/ahseteco.o"更新归档文件"/home/oracle/app/oracle/product/11.2.0/dbhome_1/lib/libnnz11.a"
用"lib/libnnz11.a/am11rkg.o"更新归档文件"/home/oracle/app/oracle/product/11.2.0/dbhome_1/lib/libnnz11.a"
用"lib/libnnz11.a/amsha.o"更新归档文件"/home/oracle/app/oracle/product/11.2.0/dbhome_1/lib/libnnz11.a"
用"lib/libnnz11.a/cpui32.o"更新归档文件"/home/oracle/app/oracle/product/11.2.0/dbhome_1/lib/libnnz11.a"
用"lib/libnnz11.a/sha.o"更新归档文件"/home/oracle/app/oracle/product/11.2.0/dbhome_1/lib/libnnz11.a"
用"lib/libnnz11.a/x931rand.o"更新归档文件"/home/oracle/app/oracle/product/11.2.0/dbhome_1/lib/libnnz11.a"
用"lib/libnnz11.a/am11dkg.o"更新归档文件"/home/oracle/app/oracle/product/11.2.0/dbhome_1/lib/libnnz11.a"
用"lib/libnnz11.a/am931rnd.o"更新归档文件"/home/oracle/app/oracle/product/11.2.0/dbhome_1/lib/libnnz11.a"
用"lib/libnnz11.a/amsharnd.o"更新归档文件"/home/oracle/app/oracle/product/11.2.0/dbhome_1/lib/libnnz11.a"
用"lib/libnnz11.a/ghash.o"更新归档文件"/home/oracle/app/oracle/product/11.2.0/dbhome_1/lib/libnnz11.a"
用"lib/libnnz11.a/shacomm.o"更新归档文件"/home/oracle/app/oracle/product/11.2.0/dbhome_1/lib/libnnz11.a"
将文件复制到"/home/oracle/app/oracle/product/11.2.0/dbhome_1/lib/libnnz11.so"
ApplySession将中间补丁程序'8670579'添加到产品清单
Verifyingtheupdate...
InventorycheckOK:
PatchID8670579isregisteredinOracleHomeinventorywithpropermeta-data.
FilescheckOK:
FilesfromPatchID8670579arepresentinOracleHome.
本地系统已打补丁,可以重新启动。
OPatchsucceeded.
4、安装timesten数据库
（1）创建用户和组
su-root
groupaddttadmin
useradd-gttadmin-u505timesten
（2）创建安装目录并授权
su-root
mkdir/etc/TimesTen
chmod775/etc/TimesTen
chgrp-Rttadmin/etc/TimesTen
（3）设置环境变量
su-timesten
timesten.bash_profile
exportTIMESTEN=/home/timesten/TimesTen/tt1122
PATH=$PATH:
$HOME/bin:
$TIMESTEN/bin
（4）安装timesten数据库
su-timesten
注意：
TNS_ADMIN设置为/home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin
yes和no虽然[]里有默认的还是要输入。
全过程贴出来。
[timesten@rhel4linux86]$./setup.sh
NOTE:
EachTimesTeninstallationisidentifiedbyauniqueinstancename.
Theinstancenamemustbeanon-nullalphanumericstring,notlonger
than255characters.
Pleasechooseaninstancenameforthisinstallation?
[tt1122]
Instancenamewillbe'tt1122'.
Isthiscorrect?
[yes]yes
Ofthethreecomponents:
[1]Client/ServerandDataManager
[2]DataManagerOnly
[3]ClientOnly
Whichwouldyouliketoinstall?
[1]1
Ofthefollowingoptions:
[1]/home/timesten
[2]/home/oracle_software
[3]Specifyalocation
[q]Quittheinstallation
Wherewouldyouliketoinstallthett1122instanceofTimesTen?
[1]1
Wherewouldyouliketocreatethedaemonhomedirectory?
[/home/timesten/TimesTen/tt1122/info]
Thedaemonlogswillbelocatedin/home/timesten/TimesTen/tt1122/info
Wouldyouliketospecifyadifferentlocationforthedaemonlogs?
[no]no
Installinginto/home/timesten/TimesTen/tt1122...
Uncompressing...
NOTE:
IfyouareconfiguringTimesTenforusewithOracleClusterware,the
daemonportnumbermustbethesameacrossallTimesTeninstallations
managedwithinthesameOracleClusterwarecluster.
NOTE:
Allinstallationsthatreplicatetoeachothermustusethesamedaemon
portnumberthatissetatinstallationtime.Thedaemonportnumbercan
beverifiedbyrunning'ttVersion'.
Thedefaultportnumberis53392.
DoyouwanttousethedefaultportnumberfortheTimesTendaemon?
[yes]yes
Thedaemonwillrunonthedefaultportnumber（53392）.
NOTE:
Forsecurity,werecommendthatyourestrictaccesstothe
TimesTeninstallationtomembersofasingleOSgroup.Onlymembersof
thatOSgroupwillbeallowedtoperformdirectmodeconnectionsto
TimesTen,andonlymembersofthatOSgroupwillbeallowedtoperform
operationsthataccessTimesTendatastores,TimesTenfilesandshared
memory.TheOSgroupdefaultstotheprimarygroupoftheinstance
administrator.Youcandefaulttothisgroup,chooseanotherOSgroup
oryoucanmakethisinstanceworld-accessible.Ifyouchoosetomake
thisinstanceworld-accessible,alldatabasefilesandsharedmemory
arereadableandwritablebyallusers.
RestrictaccesstothetheTimesTeninstallationtothegroup'ttadmin'?
[yes]yes
NOTE:
EnablingPL/SQLwillincreasethesizeofsomeTimesTenlibraries.
WouldyouliketoenablePL/SQLforthisinstance?
[yes]yes
Inordertousethe'In-MemoryDatabaseCache'featureinanydatabases
createdwithinthisinstallation,youmustsetavaluefortheTNS_ADMIN
environmentvariable.Itcanbeleftblank,andavaluecanbesuppliedlater
using/bin/ttModInstall.
PleaseenteravalueforTNS_ADMIN（s=skip）?
[]/home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin
TNS_ADMINwillbesetto/home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin
YoucanchangeTNS_ADMINlaterbyrunning/bin/ttmodinstall.
NOTE:
Itappearsthatyouarerunningversion3.4orhigheroftheg++
compiler.TimesTenshipswithmultiplesetsofclientlibrariesandserver
binaries:
onebuiltforcompatibilitywithg++3.4.6andonewith
g++4.1.0.Theinstallerhascreatedlinkstothe3.4.6libraryinthe
/libdirectoryandtothe3.4.6serverbinaryinthe
/bindirectory.Ifyouwanttouseadifferentcompiler,
pleasemodifythelinkstopointtothedesiredlibraryandserverbinary.
Installingservercomponents...
WhatistheTCP/IPportnumberthatyouwanttheTimesTenServertolistenon?
[53393]
DoyouwanttoinstallQuickStartandtheTimesTenDocumentation?
[no]yes
Wherewouldyouliketoinstallthequickstartanddocdirectories（s=skip）?
[/home/timesten/TimesTen/tt1122]
TheTimesTenQuickstartapplicationscantakeupto64Mbytesofdiskspace.
Dependingonhowyoursystemisconfigured,youmaynotwanttocreatethe
QuickStartDemoDataStoredirectoryinthedefaultlocation,
/home/timesten/TimesTen/tt1122/info/DemoDataStore
Wherewouldyouliketo
升级会员 