oracle数据库安装文档

oracle 数据库安装文档
概述
内蒙古中行数据库安装：平台red hat 6.6 ，数据库版本1120.4,升级psu
，、环境准备
1、安装前准备
1.1 编辑/etc/security/limits.co nf 文件
vi /etc/security/limits.c onf oracle soft n proc 2047 oracle hard n proc 16384 oracle soft n ofile 1024 oracle hard n ofile 65536
vi /etc/sysctl.c onf
#kernel.shmmax = 68719476736 #kernel.shmall = 4294967296 fs.aio-max-nr = 1048576 fs.file-max = 6815744
kernel.shmall = 2097152 kernel.shmmax = 4294967295 kern el.shm mni = 4096
kernel.sem = 250 32000 100 128 net.ipv4.ip_local_port_ra nge = 9000 65500 n et.core.rmem_default = 262144 n et.core.rmem_max = 4194304
n et.core.wmem_default = 262144 n et.core.wmem_max = 1048586
1•创建组和用户：
groupadd -g 600 oin stall
groupadd -g 601 dba
groupadd -g 602 oper
2•修改用户口令:
1.5创建目录
mkdir -p /u01/app
chow n -R oracle: oin stall /u01/app/ chmod -R 775 /u01/app/ mkdir -p /u01/app/ora Inven tory
chow n -R oracle: oin stall /u01/app/ora Inven tory/ chmod -R 775 /u01/app/ora Inven tory/ mkdir -p
/u01/app/oracle
chow n -R oracle: oin stall /u01/app/oracle/ chmod -R 775 /u01/app/oracle/
vi .bash_profile
umask 022
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export ORACLE_SID=orcl
export TERM=xterm
export ORA_NLS33=/oracle/db/product/11.2.0/db_1/data
export
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib:/lib:/usr/l ib export
PATH=$ORACLE_HOME/bi n:/usr/bi n:/etc/:/usr/sbi n:/usr/ucb:/sb in:$ORAC
LE_HOME/OPatch:/bi n:/usr/ccs/bi n: $PATH
export
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jli b ；
#PATH=$PATH:$HOME/bin
[oraclesclny -] 5 vl .baafL profile
if [ -f -/^baahre ]; then
■ -/. ba.shrc
CRrL__E_3j-LZ± 二 /uu 1 /app/oracle CRACLE^HCt!E= /produce;/ ・・ /dbhome_l ORACLE_弓 llL^jhbdkf TERM=xterm
ORA_1TLS 3 3-/oracle/db/product/ ・丄 /db_l/data LD 』IBRAJlY_PATIMCMCLEb ri J FJ7 lib: $ORA£XE M B<»£/iriksns/ lib :/lib :/usr/lib ElTH*i /bin: /LUI r/bins /etc/ : / use/sbin:/usr/ueb: / abin: /DPatchi /bin: / uvr/ccs/b
CU^SEATH«^aRA£I£ H<HE/JU ： «GRA£XE 且CME/j 1U>£ «SIA£XE KMB/rmM/lilLbj
#export PATH
e F -e e e e e i e
1、Oracle 软件安装
进入安装目录/stage/database,运行runlnstaller
启动图形界面
|[oracle@olny 吐丘匚abaae] $ ./ninl 且日匸aller Starting
Oracle Database llg Release 2 Installer - Installing database - Step 1 of 11
Installer ・ *七 Oracle Universal
Temp apace: mus€ swap space ： urast moniMr; musn be
Checking
Checking Checking Preparing to launch Oracle Universal -[uncle Solny database ]$ |
be greater be greater
ccnJigured Acwal 33270 MB Actual 399& MB to display az least 25fi colors. Insualler from /tep/OraInsta112016-03-10_07-5G-25PH , Please wait …
than 120 MB. than 150 HEU
Passed
Passed Actual 1677721A Passed
Con figure Security Updates
ORACU
COM 也e 倉 secur nv upases
Provide your email a.ddre^s to be informed a1 securhy issues, install the product ^nd initiate
canfigura^ion manager. Viewdstails.
Email!
Apply SdfhMTt Updaf ts Installation Oplion Eis ier for you if you use your My 0 racle Supp Drt email 比日 dre ss/us emam c.
Grid InsUllatiDn Op? ions
Typical InrtaJllalion
Summary in si an Pro duel
Finish
I wish to 『ecerve security updates via My Oracle Supp 口rt
将电子邮件和口令字段留空。

取消选择从 My Oracle Support 接收安全更新的
选项，然后单击Next
选择 skip software updates 单击 Next
[• Install Product
Use pre-dawnlaadcd softwar? updates
Sum marv
Finish
I 1 * 'kip sofivware updMtf
Configure Security Updates
选择Yes ，单击Next
Download Software Updates
ORACLE
[ Confinurt 屏 UiD£l 訓亡呂
十 Do wniloa.d Softuaie Updatef T
Do^riioad sonware update? for this in 们訓i/icm. seftMware updoes cdnsist of recomin^naecs updaces co the InslalOer system requirement checkSj, PatchSei Updates (P^LJ?X and other recommended patche*^, Selccl onfe of the folloowinQ options:
Uss Mt Oracle SyppQfi credemliis f&r 叮cwlcinQ
e Support user name:
install Type
tr^cie Suppon p 笑列旳>rd;
II 111 OH
Prerequisite Ch (
| 凸0创 Sewn** |工色班 匚■pin 恂已口
ion |
< fiack Nexl > ill
Cancel
Select w of the follow! n<g inttall o pc ions.
Note: If you want to upgrade an existing Oracle Database llg Release Z iin stance select "Upgrade an tscliiiiig d aiabais e" o pi ion.
匸:iRafe 4H0 con*lgure a d 即狛時 E 了 Install databasft software cmly
Jpgrade an exi Sling dalabast
选择如上图选项，单击Next
w Finish
Help 选择如上图选项选项，单击Next Grid Installatiaiii Options O 启ACf qqg
DATABASE
r 个 T T
Configure Securily Update?
Download Software Updates
InEtmli 戲icm 。

口ti©n Ctiid hruftaliation Oplkmif I “Fall 丫¥口电 Typical inst<allaMon Frerequisle Checks
Surn filafy Install Pro dud
Stlecnhe of d&iab^e instaJlMlonyoMmm io perform. 壬 Single instance database installation Oracle geal Application Clusters database insia.llaition Oracle RAC One Node database install^tiDn < Back | Mext >
Cancel
Select Installation Option
Cohfigu^e Securtty Uipdates Dgvmloecl 置伽■「亡U 口厲皿匕三 li
沾询lladion Opt ion
£rid Ins;t3lllmt ・cm Option 歩
InistaJI Type Typical Instilllorn
Select Product Languages OF? AdW
DATABASE
ir
T
Downlo
Soft wire Upd 3L '
Installation Option
Oid In 到alldticm ODlions ： Product LaihgEiages
匸 寸曰心日亍启EdlUUf
In^tallatiQin 5匚越
Operating Syjum Croup ； Select (he Vanguag«s In ^ichycur produd will nun
T T T
T T
y Pr F|eireciuij|i& Checks
Available Languages: Arabic
Bengali
Brazilian Portuguese Etulgarfani
Canadian French C-^ial^n Croatian C zech Dtnisb Dutch
Egypil^n
English (UniUd Kingdom) Estonian Finnish Frert th G-erinan Greek Helbrevi/ H |uingariaii ,,ii I 匚 elan die
EngMsh
__
E
画
Fi
单击Next Select Database Edit jam -< L-nh 比避C-ir>11!
OQACILm MMg
DATABASE
Qnd lnsfalilatio>n opi Proid^int Lac 口uaaES
Ddiaba$e Ed h ion
Infall 扯ion Lot 杭ion
Which dauba$t ediilon do yomvwiht TO ihstdP
』Emerprlsig
(_4,7C@)
Oracle Database llg Enterprise Edhion i$ a. ?clf^rnanagiing d^.1 abaise I hat has the Scalability,, perfei-mance. high
^lili^blliliv, and securlly features requl 『电日 co ruruhe met!日亡用&件和“小 Hiisslon-crrtdcal app|i“tiw
〔：Sundard Edition (4.6GB)
Oracle Dvtabase llg Standard Edition h afuli-ft^uredi dalarnianueinient soiutiQn Ideally suitedl« the nee-ds of rnediuiti-
sized businestes ft includes Oracle Real AppHica.tion Clusters for enterprise!-class iviilibilrty and 匚om BE com plete with ins own Oracle Clusterware and storage mmaotment cipabiliries.
Help
EdltloriQr^ (4.6CB)
Oracle Database llg Standard Edrtian One is afulkfcalured d^Ca. m anagcme-nl: solution ideally suiUd co the needs of small and m -sia td bwlnt?ses.
Select Oplions...
选择如上图选项，单击Next
You arc starting ygurflrsl Instaliitlaun ornnhis ihcft. SpxIR n aireciory for IniEtallalhn files. This directory is called the "inventory
directoty'. The installer automatically s ：ets up subdirectories for each product to cont ；ain invenlory da.^1. The sub direclory for each product lypicaJly requires 150 kilobytes of disk space.
Sum m ary Install Product Finish
核对如上路径，单击Next
Speciify Installation Location O 尼 AdE
DATABASE
1V
Configure Secwfiry Uipdaxes Download Sofinw^rt Updates Installadon Option Grid Installation Options Product Languages
Edlhi □门
L/
ln$l^llailQn ScaHon Wr 电
加E In# Em de Prtrequisiit 匚hecks Summary
Install Product Finish
Specily 乜 to place ill Oracle soft Mart and confianracion-relMedi files in sidled This in sialic ion ow>er. This location Is the Oracle bue directory for the ImsUliiation owner.
Oracle Base: /uOl/app/
Specify a location for storing Oracle database softvrare files separate from database configuration files vh rhe Oracle bast dirtttCsrV- TTiiS software diirtCCGrV is (tie Oracle d 畝屯 11古呂亡 fiomt dirtCtC?rY. iciNwreLQC^IcPi ；
Brovys-e,
< Back.
核对如上路径，单击Next
Create I nventory
OF?ACf
DATABASE
1F
Invenlory rectory:
/uOl/oraiweHtorY
Brcrwe
Crid Installatian Options r
7 Product Languages
Database Edit ion
■Create mvetMory
Sutclfy an ope riti ng lysrem groiun*uhose mem bers hawe wire perm iss-lonToiht inveniorvdirectory (orairweriitciiry). ORiiny E ntory Croup H 沖 e :卜油口 制］二
< 肿nk
flexx a
Cancel
丫 Canfigui't Secur^v Update
Downl&ad Sofiwirt Upd 和上
<£,uk I 出m Cancel Privileged Operaitiing System Groups
ORACLE'
OAT A~BA S £Coftfiguft Stcuriry u^d&ie
■7
Grid Insiallation Options
Pro duct Languages
EdilMcn
Ins-taJlMioh Local ion
CrEaiE InHEntury
PfEr^Qukite：匚Fi亡匚
Ks
iWim
Install
SYSDB^ ad 5TSOPER privileges are required to create a. dac^b^e uslrig operating (OS)
aulhentkailon. Membership In OSCBA grwtf the SYSD&A privilege ar>d ni-embershlp In OSOPER grants 1 h E SYSO PER
priw Ihg £ which Is a subsr ft M SYSDBA privileges. Sei ext t|ie name of the OSDBA group t? grains the SYSD BA privilege
Tthe user accouni you are using to runi this install be a ni embe-r of this group.
Database Administrator (OSDBA) Croup:
Qp射；i8r (0SOPER) Croup (Optlonar)'J,i Wl ▼
核对如上选项，单击Next
Perform Prerequisite Checks
0^2* MMg
DATABASE Configure Securitv Updoes
Download Softyvare Updates
Some of th亡miniffiuni require mtftts for install ition are noi committed. Review and fix the i^^ues lified in tht following iab>le r
asl recfieck ihe sytsern.
I Check Again ] fix & Check A gain 1 Ishow Fiiiled VI Ignore All
d inst^iiatiQn O^tlQms
Produa Lansuagies
Database Edltlcn
InstaJItiion Locilion
CrtiU Inventory
0口疋rmti厂口R'KE 們匚
LD .ID：
Preiequifite Check!
SummarY
This Is a prereqmlsrte concision to tert Aether the D社tKa哲电Wksh-5.2 1*B is：available on the fmore：日时
和1引
Expected Value : pdksh-5.2.14
Actual Value : missing
Help cfiack 匚少心Cancel 选择ignore All，单击
Next
S,avc RtJponse File...
Conflgurt Securiiy
Download
Software Update
Installation Option Grid InsUllatian Oplions Product Languages Database Edrtion Installation LocalNoni Create Invgn^ry Operating
Gi
Prerequisite Checks Sum mary flnslall Pioducl
Inla^rating Spjliat
XML
an4 Svcuir^Fil&t
且
t ip | I €童生卄~||
世口；
1： A ][ 中玳和I | I 匚宙“匚
社1—
出现“Execute Configuration scripts （执行配置脚本）”窗口时，执行该窗口中 列出的步骤：打开终端窗口，然后以 root 身份登录，按顺序执行窗口中的脚 本。

执行完毕后点击0K 等待完成安装。

Summary
ORACf Wg
DATABASE
T
* 平 丫
Cohfigurt Security UpdMts Down load Soffurare Updates In^talladon Option Criid InstaJIation Options Product Languagf$ 电 Edlilcn in>$戈剤I 訓Ion L*艦邯Ion
Crewe inMemoiry
Operxtirig Sy^leni Groups B Oracle Database llg Hekafe 2 inrstillEr
F Globil senings
Dis-k space 『equired 4 7 GB avaliabk 11.47 GS
S ourc e loc^tl on 1 /$i 边 g e /d atmb 迪 WE JI n stall/, ./^t^ge/procluci $ .xm I Database edition: Enterprise Edition (Install database software only) Oracle base: /uDl/app/
Software lotarioft ： /m01/4pu/Biroduci ：/lL 2.0/db
L
- Prlvil-e-ged OperiUng System Groups; dbaCOSDBA), db a (050PER) t- Invert nt -y
mfat madi ion]
Irwentoiry lcca.lion: /uOl ralinyent D ry □ralnventoqr group: a install
RrE 「ie ：QLii£it 赳 Ch
色匸ks * Summary
核对安装信息，单击 Next Install Product
DATABASE
-Progress
Exlracting files to '/uOl/app /produc^/l 1.2.10/db'.
■=r Oracle Database instdlalion In Progress
■ Prepare
匚匚 eededl ■ Co^ files In Progress ■ Link binanes Pending
■ Setup flies
Pending
氐覽匚皿芒Roon Scripts
Pending
Infoimationi Mandig«mAHt
Status
~ Oracle Database llg 2 Installer ・ iMt创liwg - Step 12 af 12
Funish ORACI-E q* DATABASE
Configure Securilr Updaies
Dovuni^ad Sonwsre Updat电无
dnstallalion Option
Grid In si all al ion Options
ProdUCI Languages
Database Edition
In si all a( ion Location
operaJEing S Y低仲croup；
PrerequisiliB Checks
Summary
Install Produci
Finish
Help
The insulin ion of Oracl E D：a.i： abase was successful.
、PSU升级
3.1、将OPatch 压缩包cp 到$ORACLE_HOME
[oraclee-Qlny ~] $ cp p6S80880_112DOG_LINUX- zip /uOl/app/oracle/product/11.2 ・O/dbhcnne_iy [oraclefiolny ~] $ cd /u.01 /app/nrac le/produc t/Il・2・Q/iibhome_lZ
[oracletclny dbhoi«_l ] s 1B
r<wt.sh
□rialnst ・1cx:
[oracleO-olny dbhome_l] $ |
3.2、查看OPatch现在的版本
[oraclegolny OPatch]$ ./opatch version OPatch Version： 11,2,0,3,4 QPatcti succeeded,
[oracleficlny OPatch]?
3.3、mv掉原来的opatch目录
[Dracle@olny dbhoire_l] $ mv OFatcli/ OPatch-bat
[oracle@olny » la
root ・stL
□ralnat B I DC [oracle@olny
3.5、再次检查版本，发现已OPatch级成功
3.6、设置环境变量
oracle@udbsOl export PATH=$PATH：/usr/ccs/bin 'oracle^udbsOl
un zip p2*******_112040_Li nux-x86-64
Da you w&nt to proceed? [y|n]
Patching ccmponent oracle ・syMan.agent r 1Q.2・◎・4•・5 —・
component oracle.nisirtl.Tgfj, 11.2.0・4・0・・w
Patching coxqxinent oracle ・xdk 亠raf, 11*2^0■心・QU ・■ Patching conponent Tracis , rdtniis ■ rsrf ■ 11^2
・
Patching co-mponent oracle ・syaman ・DIM ・core, 10.2.0・4.5….
Ccwosite patch 2194E347 succegsfully applied +
Log file lac&Dlon: /uO 1/app/oracle/producc/l 1 2 ・ 0/dbhQ®fc_l/cfgEMllags/opatcii/opatcdiS01 ft-03-10_20*23- 14P
OPacch succeeded.
[oracleSDlny 21MB347J4 |
3.10、验证升级成功
(Dtaele@olny 2194E347]$ /u01 /app/cr aele/pr oduec/11.2・0/也対1口6亡二1+0^白匕匕3|5^匕已1 IslnvenLory Oracle Interinn Patch Installer vsrsicn 11.2,0^3.12
Copyright (c| 2016^ Ozacle Cbrpar ati on B All zighta reserved ・
Oracle Bone : /uD 1/app/Dracle/prodtict/11 ・ 2.0/dbhoine_l
Central Inventory : /uO 1/app/oraInventory
fra-m i /uDl/ app/orBale/product/11 ・ N ■ fl/dbhame_l/oraIiiBt . lac OPateh veraian : JJ ・2.D»3・12 OUI version
: H.2.QU4 4
Eog file lonzatian x /uO 1/app/Qr acle/ptoduct/11 ・ 2 ・ O/clbhQinE_l/cf gtoollogs /dpatch./opatch2016-03-10_20-30-2§■
PH_l.log
Lslnventory Output rile location i /uO 1/app/or acle/pr Dducc/11.2 ・口/血11口址_1/匚空§匸811旳3/心艸匕少/丄：5丄11甘/113!丄11 ventory2D16-03-10_2D -3 0-29PM, txt
Local Machine Information::
□Lny
ARU platform id: 22fi
ARU platfqrm description-:Linux Installed Top-level Products (1^:
Oraele Datatoaae llg
U ・2-0,4.0
There are 1 products installed in this Oracle Hmre*
Interim patches (1) :
PaEchlng
co-E^sonent oracle ・C3vm. 11-2.0.4.0- Patching cofi^janent ora 亡 1总.xdk p 11.2.0.4.0.
Patching
cofl^sonent
oracle a rdhms t
Patching
Parching conponent oracle ・ xdk ,parser ・ j ava,
Patching
亡oi^afLent otA cle ・ aysman ・ console..血*
□ x
单击Next
四、dbca 建库
运行runlnstaller 启动图形界面
Database 匚onfiguration Assistant: Welcome
Welcome to Database Com^iguratioin As&i&unt for Oracle database
The DatatoaEE Canfiguratii on Assistant wnable5 you to creale a cmnfigure databaEE options in an exlsllng database delete a daiabue, and manage database templates
cancel
Help i
Database Configuratioo Assistant, Step 1 of 12 : Operations □ x
Select the Dperation that wu want co perfcrm:
• Creaie a Database
广Configure [?afaE3ase Opllcrns
r uefeie a Database
厂Manage Templates
'彳、応M CDHfiguration operations musl be perTormed using AutomialiE Storage 电丿Management
Configur-anon Assisonf (ASMCA) from Oracle Grid Infraftructure home.
选择上图选项，单击Next
选择上图选项，单击Next
填入SID ,单击Next
选择上图选项，单击Next
Database Configuration Assistant Step 5 of 12 : Database Credentials □ x
Jser Name Password Confrim Passward
rrs
SYSTEM
For security reasons^ wu must specify passwords forth E folilowing accounts h the new datafiase.
r Use Different AdministrativE Passwords
丽Use the Same Adminislrative Password for^JII Arcounts
Password: •亦■
亦
Confirm Password 卜音”杓|
Cancel 〔 Help
输入密码，选择上图选项，单击Next
单击Yes
Specify siorage tyoe and locaiions for database files.
Storage Twe-
Storage Locations:
'■ U^e Database File Loe:atiori^ from Template
厂Use 匚omrnon Loe®ion for All Database Files
B IWFE…
Browse.._
/SX If wu warn io specify different locations for any database files^ pick anv of the above1 :options
except Ormele-ManmQECI Files and USQ the Storage page later to cusromize each file location. If
you use Oracle-Managed Files, Oracle automatically generates the names： for database files, which
can noi be changed on rhe page.
File Uocation Variables .
rjext j Einish Cancel丿一哑_J
选择上图选项，单击Next
选择上图选项，单击Next
Database Compon?nlm Custom Scripts
Select lhe compon^ntf you want to configure for u餐in vour database Pro^de the tablespace in which you want rtiE compen&nt io reside. C&mpcinenis whiclh appear disabled are either nut installed or depend on components Yvnich are not selected
厂Oracle r&id
F Oracle OL^P
I- Orarls Spalial
r Oracle Label Security
厂Sampre Schemas
SYSAU X [SYS/UX [SYSTE |SYS^UX
Emterpnse Manager Repo site rv Is^SALlX
r OrarlE Warehouse Builder 厂oracle Database vaun [乎
哑
I J Y5Z4JX
Stan card Dai abase Components...
Caticel I Help Finish 选择上图选项，单击Next
按要求选择Block Size
Database Configuration Assistant, Step 9 of 11 : Initializationi Parameters □ x
Memory Sibling Cl a'dcter Sets Connection Mode
Daratjase Character set
广LI EE the default
The default characi&r set for this database h basEd on the language gening of mis
operating mysrenr WE8MSWIN125?.
* Use Unicode (AJ.52UIFE)
Setting character set to (Jnicads (ALJ2UTF8) eriatiies you to stcne multiple lancuage
groups.
广 Chaose from the list of character sets
Database Character S&t ^.32n' Z - Jrin'ocfe LTF-8 liniwrsEd character set
r show retommarided dwacier sets only
Nalional Chanacter 冠|jiil6LrirFi6 Unicode LfTF-16_iJnh«rsai_cliaracter_5Bft
Derauli Language Ainerltan
Detaun Territory I United Stales
□All Initialization Parameters....
Cancel Help
Next Einish
按要求填入file Directory，按要求填入file size，核对无误单击Next Array
等待安装完成
Database Configuration Assistant Database Configuration Assistant
Database creation complete. For details check the logfiles at / uO 1/ app/cf gt oollogs /dbca/ cc .
Database Infonnation ：
Global Database Name:
t 匚
S^tem ldentiTier(SlD/
cc Server Parameter File name: /uO 1/app/praduct/11.2.0/db/dbs/spfllecc ora
Note: AJI database accounts except SYS and SYSTEM are locked. Select the Password Management butloin to view a complete list of locked accounts or to manage the
database accounts. From ihe Passwcirci Management window unlock onlythe accounts you will use. Oracle 匚orpo ration strongly re 匚ommEndE changing The cl 已faul^ passwords immediaiely aRer unlocking the account
Password Management...
单击Exit,完成安装
High
Rol wit Sta。