oracle 10g installation guide(linux)

8/13/2019 Oracle 10g Installation Guide(Linux)

1/29

Oracle Installation Guide

1. Pre-Installation:

I. Check required packages. (Note: Performed this using root account.)

1. verify Red at !nterprise "inu# packges: $oc I$: Note:1%&'%.1 Note: e*o+ packages as for Redat "inu#. P*ease see meta*ink documents or ,rac*e Insta**ation guide pertains to,- and architecture at +++.orac*e.com. or rhe* /0 check the ff.

"ist do+n rpm using rpm qa then check if the a2ove 3rpm are insta**ed. If not *oadRedhat C$ then insta** the necessary components.

4o verify 556 7 rpm 8q 9packagename6 4o insta** 556 7 rpm 8;vh 9packagename6

II. ;pdates


2/29


1. semms*0 semmns0 semopm0 and semmni

= >s2in>sysct* 8a ? grep sem 4his command disp*ays the va*ue of the semaphore parameters in the order *isted.

,utput e#amp*e is sho+n 2e*o+.s2in>sysct* 8a ? grep shm 4his command disp*ays the detai*s of the shared memory segment sies.

!#amp*e:DrootE*oca*host FG= >s2in>sysct* 8a ? grep shmvm.huget*2shmgroup 5

kerne*.shmmni 5 H&%kerne*.shma** 5 @&'1/@kerne*.shmma# 5 AA//HHA@DrootE*oca*host FG=

A. fi*e8ma#= >s2in>sysct* 8a ? grep fi*e8ma#

4his command disp*ays the ma#imum num2er of fi*e hand*es. !#amp*e:

DrootE*oca*host FG= >s2in>sysct* 8a ? grep fi*e8ma#fs.fi*e8ma# 5 @HB%

H. ip*oca*portrange= >s2in>sysct* 8a ? grep ip*oca*portrange

4his command disp*ays a range of port num2ers.

!#amp*e:DrootE*oca*host FG= >s2in>sysct* 8a ? grep ip*oca*portrangenet.ipvH.ip*oca*portrange 5 A@'%B %1

5566 proc>sys>kerne*>sem

semmns A@

semopm 1 (A@ *ang sakin) semmni 1@B

888888 shma** @&'1/@ >proc>sys>kerne*>shma**

888888 shmma# ha*f sie of >proc>sys>kerne*>shmma# physica* memory (in 2ytes)


3/29


134217728 (128MB)

888888 shmmni H&% >proc>sys>kerne*>shmmni

888888 fi*e8ma# %//A% (mine is @HB%) >proc>sys>fs>fi*e8ma#

888888 ip*oca*portrange >proc>sys>net>ipvH>ip*oca*portrange Jin6 1@H Ja#6 %/ Ca2ra*: A@%'B 8 %1 888888

Ca2ra*:

net.core.rmemdefau*t 5 11/&@net.core.+memdefau*t 5 11/&@net.core.rmemma# 5 11/&@net.core.+memma# 5 11/&@

rmemdefau*t @%@1HH >proc>sys>net>core>rmemdefau*t

888888 rmemma# @%@1HH >proc>sys>net>core>rmemma#

888888 +memdefau*t @%@1HH >proc>sys>net>core>rmemma#

8888888 +memma# @%@1HH >proc>sys>net>core>+memma#

If the va*ue of any kerne* parameter is different from the recommended va*ue0 then comp*ete the fo**o+ing procedure:

;sing any te#t editor0 create or edit the K>etc>sysct*.confK fi*e0 and add oredit*ines simi*ar to the fo**o+ing:

kerne*.shma** 5 p*ease see the forum*a.

kerne*.shmma# 5 ha*f the sie of physica* memmory kerne*.shmmni 5 H&% kerne*.sem 5 @/ A@ 1 1@B fs.fi*e8ma# 5 %//A% net.ipvH.ip*oca*portrange 5 1@H %/ net.core.rmemdefau*t 5 @%@1HH net.core.rmemma# 5 @%@1HH net.core.+memdefau*t 5 @%@1HH


4/29


net.core.+memma# 5 @%@1HH net.ipvH.tcprmem 5 @%@1HH @%@1HH @%@1HH net.ipvH.tcpvmem 5 @%@1HH @%@1HH @%@1HH

ormu*a for shma**:

7 getconf PLM!-I!

shma** 5 -JJLO>PLM!-I!

or e#amp*e: If Physica* memory 1%M 5566 (BM3(1@H33A))>PLM!-I!or R!" /0 ust add the fo**o+ing *ines in >etc>sysct*.conf

=kerne*.shma** 5 @&'1/@=kerne*.shmma# 5 @1H'HBA%HBkerne*.shmmni 5 H&%

= semaphores: semms*0 semmns0 semopm0 semmnikerne*.sem 5 @/ A@ 1 1@B=fs.fi*e8ma# 5 %//A%net.ipvH.ip*oca*portrange 5 1@H %/net.core.rmemdefau*t5@%@1HHnet.core.rmemma#5@%@1HHnet.core.+memdefau*t5@%@1HH

net.core.wmem_max=262144

Lfter kerne* parameter configure0 save and then e#ecute.7 >s2in>sysct* 8p

III. -etting -he** "imits for the orac*e ;ser. (Note: Performed this using rootaccount.)

4o improve the performance of the soft+are on "inu# systems0 you must increasethe fo**o+ing she** *imits for the orac*e user:

-he** "imit Item in *imits.conf ard "imit

Ja#imum num2er of open fi*e descriptors nofi*e %//A%Ja#imum num2er of processes avai*a2*e toa sing*e user nproc 1%ABH

4o increase the she** *imits:

1. Ldd the fo**o+ing *ines to the K>etc>security>*imits.confK fi*e:


5/29


orac*e soft nproc @H'orac*e hard nproc 1%ABHorac*e soft nofi*e 1@H

orac*e hard nofi*e %//A%

@. Ldd or edit the fo**o+ing *ine in the K>etc>pam.d>*oginK fi*e0 if it doesnot a*ready e#ist:

session required pam*imits.so

A. $isa2*e secure *inu# 2y editing the >etc>se*inu#>config fi*e

-!"IN;O5disa2*ed

I. Create ,rac*e user and ,rac*e group. (Note: Performed this using root account.)

1. $etermine ,rac*e Inventory.

= more >etc>oraInst.*oc (Qan @10 not yet done)

556inventory*oc5>u1>app>orac*e>oraInventory 556instgroup5oinsta**

@. If an ,rac*e Inventory $oes Not !#ist

= >usr>s2in>groupadd 8g @ oinsta**

A. Creating the ,-$L Mroup

= >usr>s2in>groupadd 8g @1 d2a

H. Creating an ,-,P!R Mroup (,ptiona*)

= >usr>s2in>groupadd 8g @@ oper

/. Creating an ,rac*e -oft+are ,+ner ;ser

/.1 $etermining if an ,rac*e -oft+are ,+ner ;ser !#ists


6/29


= id orac*e

If the orac*e user e#ists0 then the output from

this command is simi*ar to the fo**o+ing:

556 uid5HH(orac*e) gid5@(oinsta**) groups5@1(d2a)0@@(oper)

/.@ If not e#ist0 create an ,rac*e -oft+are ,+ner ;ser

= >usr>s2in>useradd 8u @ 8g oinsta** 8M d2a orac*e

/.A -et the pass+ord of the orac*e user:

= pass+d orac*e

%. erifying 4hat the ;ser no2ody !#ists

%.1 Check if Kno2odyK e#ist

= id no2ody

%.@ If does not e#ist0create it

= >usr>s2in>useradd no2ody

. Creat ,rac*e $irectory. (Note: Performed this using root account.)

1. ,rac*e ase $irectory

4he ,rac*e ase $irectory is a top8*eve* directory for ,rac*e soft+areinsta**ations.

>mountpoint>app>orac*es+o+ner

!#.

>u1>app>orac*e

A. ,rac*e ome $irectory

>orac*e2ase>product>1.@.>d21

!#.>u1>app>orac*e>product>1.@.>d21

==>>Creating an Oracle Base Directory


7/29


1. ;se the Kdf 8kK command to determine the free disk space on each mountedfi*e

system.

@. rom the disp*ay0 identify a fi*e system that has appropriate free space.

A. !nter commands simi*ar to the fo**o+ing to create the recommendedsu2directories in the mount point directory that you identified and set theappropriate o+ner0 group0 and permissions on them:

= mkdir 8p >mountpoint>app>orac*es+o+ner

= cho+n 8R orac*e:oinsta** >mountpoint>app>orac*es+o+ner = chmod 8R ''/ >mountpoint>app>orac*es+o+ner

or e#amp*e: K>u1>app>orac*eK

= mkdir 8p >u1>app>orac*e

= cho+n 8R orac*e:oinsta** >u1>app>orac*e = chmod 8R ''/ >u1>app>orac*e

H. Login as the oracle userand add the fo**o+ing *ines at the end of the.2ashprofi*e fi*e.

= ,rac*e -ettings

4JP5>tmp e#port 4JP 4JP$IR574JP e#port 4JP$IR

,RLC"!L-!5>opt>app>orac*e e#port ,RLC"!L-! ,RLC"!,J!57,RLC"!L-!>product>1.@.>d21 e#port ,RLC"!,J! ,RLC"!-I$5--$!1 e#port ,RLC"!-I$ ,RLC"!4!RJ5#term e#port ,RLC"!4!RJ PL45>usr>s2in:7PL4 e#port PL4 PL457,RLC"!,J!>2in:7PL4 e#port PL4

"$"IRLRSPL457,RLC"!,J!>*i2:>*i2:>usr>*i2 e#port"$"IRLRSPL4C"L--PL457,RLC"!,J!>re:7,RLC"!,J!>*i2:7,RLC"!,J!>rd2ms>*i2e#port C"L--PL4

if D 7;-!R 5 Korac*eK G then

if D 7-!"" 5 K>2in>kshK G then u*imit 8p 1%ABH u*imit 8n %//A%

e*se u*imit 8u 1%ABH 8n %//A% fi fi

2. Installation of Oracle Dataase !er"er:


8/29


Moto C$>$$ insta**ation.I copied the insta**er in >u1>insta**er dir0 then change the o+nership to orac*e. 4hen*og in as orac*e user0 then unip the insta**er ip fi*e. ,nce you unip the fi*e0 you+i** see the

Run T.>runInsta**erT

Lfter .>runInsta**er start0 the dia*og UInsta**ation JethodV +i** 2e disp*ayed


9/29


Choose type of insta**ation 2ased in you requirements (for e#amp*e. -tandard !dition)0the c*ick TNe#tT to continue.

If destination of insta**ation is correct0 c*ick Ne#t.


10/29


,nce the destination the orac*e insta**ation +i** perform prerequisite checks0 if a**status succeeded0 c*ick Ne#t0 if not p*ease check the *og disp*ayed in the dia*og andfi# 2efore continue to avoid pro2*em during the insta**ation.

Lt T-e*ect Configuration ,ptionT choose the soft+are on*y.


11/29


L summary dia*og +i** 2e disp*ayed0 c*ick Insta** 2utton to insta** the orac*e.


12/29


Insta**ation progress>status +i** 2e disp*ayed0 +ait unti* progress 1W comp*ete.

Lfter insta**ation status 1W comp*ete0 the T!nd of Insta**ationT dia*og +i**disp*ayed0 c*ick e#it to c*ose the insta**ation


13/29



14/29


#. Oracle Dataase Creation $sing Dataase Configuration

%ssistant.

Lt prompt key8in Ud2caV 0 7d2ca.


15/29


Lt U+e*comeV dia*og of $ata2ase Configuration Lssistant0 c*ick TNe#tT.


16/29


Choose TCreate $ata2aseT0 then c*ick TNe#tT.

Choose Menera* Purpose temp*ate $ata2ase (for this manua* on*y).


17/29



18/29


19/29


Lt U$ata2ase i*e "ocationsV dia*og0 choose the U;se Common "ocation for a** $ata2asefi*esV T,RLC"!L-!X>oradataT0 then c*ick ne#t.

Lt TRecovery ConfigurationT dia*og check U-pecify *ash recovery LreaV0 the the sie is1@HJ0 and check U!na2*e LrchivingV.


20/29


Lt U$ata2ase ContentV dia*og0 donTt check U-amp*e -chemasV0 c*ick Ne#t to continue.

Lt UInitia*iation ParametersT dia*og0 the memory a**ocation is H W for this trainingpurpose on*y.

Note: ;sed %W if you +i** use in production.


21/29


Lt UInitia*iation ParametersT dia*og0 c*ick the TCharacter -etT 4a20 choose the;nicode (L"A@;4B) in $ata2ase character set to support mu*tip*e *anguage.

Lt UInitia*iation ParametersT dia*og0 c*ick the Connection Jode ta20 the choose$edicated -erver0 c*ick Ne#t to continue.


22/29


Lt $ata2ase -torage dia*og0 you can configure0 Contro* fi*e0 $atafi*es and Redo *oggroups 2efore c*ick Ne#t.

If you +ish to configure after $ata2ase configuration +iard0 c*ick Ne#t.

Check the UCreate $ata2aseV then c*ick UinishV.


23/29


Lt UConfirmationV $ia*og0 c*ick ,k to continue.


24/29


L progress dia*og +i** disp*ay to *et you the tota* percentage comp*ete.

C*ick !#it to comp*ete.


25/29


&. Post-Installation:

A. Apply Patch and updates data dictionary

Cabral: default pfile can e found in !"#$%& B#'&. en u*e ti* to *tartup te +B . !nce connected to+B, -ou can create te *pfile , create *pfile from pfile=dir/

#fter -ou do ti*, we *ould not a0e an error, wen *tartup dataa*e.

1. #ppl- !racle atc *et

2. acup root.*

3. &xecute utlrp.*l5

3.1 'tart '%lu*

7 sq*p*us >no*og7 connect sys as sysd2a (-tartup data2ase if necessary)

A.@ -Y"6 EZ>rd2ms>admin>ut*rp.sq*

4. &xecute catproc.*l and catalo.*l5

4.1 'tart '%lu*

-Y"6 EZ>rd2ms>admin>catproc.sq*

-Y"6 EZ>rd2ms>admin>cata*og.sq*

Troubleshooting Guide

B. Configuration Datafiles, ser!"che#a and Tablespace.

I. $o%e the datafile fro# Oracle &o#e to another directory.

9f -ou would lie to mo0e an- of te data file* or online redo lo* for ti* dataa*e to anoterdirector-, u*e command* lie te followin:

7 sq*p*us >no*og-Y"6 C,NN!C4 > L- -S-$L-Y"6 -;4$,[N IJJ!$IL4!-Y"6 -4LR4;P J,;N4-Y"6 ,-4 mv 8i >u1>oradata>9-I$6>users1.d2f >u@>oradata>9-I$6>users1.d2f-Y"6 L"4!R $L4LL-! R!NLJ! I"! @ T>u1>oradata>9-I$6>users1.d2fT 4, A T>u@>oradata>9-I$6>users1.d2fT-Y"6 ,-4 mv 8i >u1>oradata>9-I$6>redo1.*og >u@>oradata>9-I$6>redo1.*og-Y"6 L"4!R $L4LL-! R!NLJ! I"!


26/29


@ T>u1>oradata>9-I$6>redo1.*ogT 4, A T>u@>oradata>9-I$6>redo1.*ogT-Y"6 L"4!R $L4LL-! ,P!N-Y"6 !OI4

'ote that this procedure does not (or) for control files.

II. "et All datafiles to *ATO+T+'D O--:

9n dataa*e* created wit *upplied template*, all data file* a0e te auto;extend5 feature turned on.

i* mean* tat wen a data file ecome* full, it will automaticall- row larer a* needed.e prolem wit ti* i* tat an application can et out of control and fill up an entire di* partition.

9t al*o mean* tat -ou need to manae -our free *pace at te operatin *-*tem le0el.

Man- +B#* prefer to manae free *pace at te data a*e le0el - pre;allocatin *pace to data file*and not u*in te auto;extend feature. no*og-Y"6 C,NN!C4 > L- -S-$L-Y"6 L"4!R $L4LL-! $L4LI"! T>u1>oradata>dev1ee>system1.d2fT L;4,!O4!N$ ,-Y"6 L"4!R $L4LL-! $L4LI"! T>u1>oradata>dev1ee>sysau#1.d2fT L;4,!O4!N$ ,-Y"6 L"4!R $L4LL-! $L4LI"! T>u1>oradata>dev1ee>undot2s1.d2fT L;4,!O4!N$ ,

-Y"6 L"4!R $L4LL-! $L4LI"! T>u1>oradata>dev1ee>e#amp*e1.d2fT L;4,!O4!N$ ,-Y"6 L"4!R $L4LL-! $L4LI"! T>u1>oradata>dev1ee>users1.d2fT L;4,!O4!N$ ,-Y"6 L"4!R $L4LL-! 4!JPI"! T>u1>oradata>dev1ee>temp1.d2fT L;4,!O4!N$ ,-Y"6 L"4!R $L4LL-! $L4LI"! T>u1>oradata>dev1ee>system1.d2fT R!-I! %J-Y"6 L"4!R $L4LL-! $L4LI"! T>u1>oradata>dev1ee>sysau#1.d2fT R!-I! AJ-Y"6 L"4!R $L4LL-! $L4LI"! T>u1>oradata>dev1ee>undot2s1.d2fT R!-I! /J-Y"6 L"4!R $L4LL-! 4!JPI"! T>u1>oradata>dev1ee>temp1.d2fT R!-I! /J

III. Configure Oracle 'et

!racle >et i* te networin infra*tructure tat allow* application* runnin on oter *er0er* to

acce** te dataa*e. e !racle >et li*tener i* a proce** tat run* on te dataa*e *er0er andmonitor* a $ port for reue*t* to acce** te dataa*e.

e !racle >et li*tener i* confiured - creatin a file called li*tener.ora in te?!"#$%&_@!M&AnetworAadmin director-.

= i*ename: *istener.ora


27/29


="I-4!N!R 5

($!-CRIP4I,N"I-4 5 ($!-CRIP4I,N 5

(L$$R!--"I-4 5 (L$$R!-- 5 (PR,4,C," 5 4CP)(,-4 5 9IP Lddress6)(P,R4 5 1/@1)) ) ) ) -I$"I-4"I-4!N!R 5 (-I$"I-4 5 (-I$$!-C 5 (M",L"$NLJ! 5 9M*o2a* $2 Name6) (,RLC"!,J! 5 >u1>app>orac*e>product>1.@.>d21) (-I$NLJ! 5 9-I$6) ) )

The per#issions on the listener.ora file should be /01.

// 'tart te !racle >et li*tener wit te followin command:

7 *snrct* start

e !racle client lirarie* in0oed - an application want acce** te dataa*e read confiurationfile* called *lnet.ora and tn*name*.ora.

9n te *ame director- were te *ample li*tener.ora file i* located, -ou will al*o find te *lnet.oraand tn*name*.ora. 'et te file permi**ion* to 644. Cunctional *lnet.ora and tn*name*.ora file* are a*follow*:

= = i*ename: sq*net.ora = =NLJ!-.$!L;"4$,JLIN 5 9yourdomain6 NLJ!-.$IR!C4,RSPL45 (4N-NLJ!-)

= = i*ename: tnsnames.ora

== Note: Sou can change the U$!-!R!R1V.

$!-!R!R1 5 ($!-CRIP4I,N 5 (L$$R!--"I-4 5

(L$$R!-- 5 (PR,4,C," 5 4CP)(,-4 5 9IP Lddress6)(P,R4 5 1/@1)) ) (C,NN!C4$L4L 5 (-I$ 5 9sid6) )


28/29


)

no*og -Y"6 C,NN!C4 systemE$!-!R!R1 !nter pass+ord:

I2. C3+AT+ TAB4+"PAC+

$reate a tale*pace*Dloical roupin* of data file*Dto old -our application data.@ere i* a *ample tale*pace creation *tatement for an application called +e05:

CR!L4! 4L"!-PLC! customercare $L4LI"! T>u@>oradata>9sid6>devdata1.d2fT -I! 1@HJ

-!MJ!N4 -PLC! JLNLM!J!N4 L;4,

$reate application role* if de*ired. #lternati0el-, -ou can u*e te default role* $!>>&$,"&'!E"$&, and +B#.

2. C3+AT+ "C&+$A!"+3.

$reate application *cema* and *et te default tale*pace to one of created tale*pace* wic i* de*inatedto old tale*. #nd a***in uota* to E'&"A'$@&M#.

'ote:


29/29


MRLN4 connect0 resource 4, rico R!,

'ote: 9f -ou rant te "&'!E"$& role to an account, tat account will al*o recei0e teE>%9M9&+ #B%&'#$& *-*tem pri0ilee. i* will let te account create oGect* in an-tale*pace, reardle** of uota*.

oracle 10g installation guide(linux)

Documents