copy of how to upgrade from 10g database to 11g database

7/26/2019 Copy of How to Upgrade From 10g Database to 11g Database

http://slidepdf.com/reader/full/copy-of-how-to-upgrade-from-10g-database-to-11g-database 1/29

DBA School Flat # 501 & 502, Mahindra Residency, Near Aditya Trade Center,

Aeer!et, "yderaad $h% ''2())5*+1)2('++*0)0(0'210)

Fac-lty% Satya Seela .10 /rs DBA ! n 3SA4

Oracle Database Upgrade from Oracle

10gR2 to 11g

&

Oracle 11g New Features

Why Customers hould Upgrade to 11g!




Aeer!et, "yderaad $h% ''2())5*+1)2('++*0)0(0'210)





Aeer!et, "yderaad $h% ''2())5*+1)2('++*0)0(0'210)


"ow to upgrade from 10g database to 11g

database




Aeer!et, "yderaad $h% ''2())5*+1)2('++*0)0(0'210)

Fac-lty% Satya Seela .10 /rs DBA ! n 3SA4 There are to ays to -!6rade an oracle dataase7

17 By Man-al

27 By DB3A.Dataase 3! 6radation Assistant4 Tool

To -!6rade the dataase 8ersion +7179, i, 1071 to 1072, yo- can

directly -!6rade itho-t a!!lyin6 any !atch set7 B-t hen yo-

-!6rade 1072707170 to 116 .11717047 There is a need to a!!ly a

!atch set .1072707)704 e:ore -!6rade the dataase7

"ere, the :olloin6 ste!s :or ho to -!6rade the 106 dataase

to 116 dataase7

Ass-!tion% .14 ;racle 106 ser8er s* is already installed in the

:olloin6 location

;RAC<=";M>*hoe*oracle*!rod-ct*107270*d=1

.24 3nder this hoe there is one dataase is

r-nnin6 nae !rd7




Aeer!et, "yderaad $h% ''2())5*+1)2('++*0)0(0'210)

Fac-lty% Satya Seela .10 /rs DBA ! n 3SA4t is clearly shoin6 that a dataase nae $RD is r-nnin6, hich

is -nder oracle hoe i7e7 *hoe*oracle*!rod-ct*107270*d=1, and

the release 8ersion is 1072707170

?e ha8e to -!6rade this dataase into 11 67

(7 To -!6rade the eistin6 dataase into 116, @rst o: all e ha8e

to install 11 6 oracle ser8er s* in dierent location

.directory47

i7e7 *hoe*oracle*!rod-ct*117170*d=1

Ca-tion% Dont install 11 6 ser8er s* in the sae directory, in

hich already 106 ser8er s* is installed7

)7 "ere a shoin6 yo- that ho can yo- install to oracle

ser8er s* in the sae ser8er7

i7 ;!en a terinalii7 Ty!e host coandiii7 <o6in as a oracle -seri87 nsert the 11 6 ser8er s* CD87 ec-te the r-nnstaller @le




Aeer!et, "yderaad $h% ''2())5*+1)2('++*0)0(0'210)





Aeer!et, "yderaad $h% ''2())5*+1)2('++*0)0(0'210)


n this ay yo- can install the oracle s* so:tare, in

dierent location7 Do co!lete the installation !rocess7

Ste!s :or -! 6radationSte! 1% ?hile yo- are at r-nnin6 dataase !rd i7e7 a

dataase that yo- ant to -!6rade into 11 67 First o: all

yo- eec-te the !re -!6radation in:oration tool hich

coes ith 116 ser8er s*7 A:ter s!oolin6 a @le7 "ere is

sna!shot77




Aeer!et, "yderaad $h% ''2())5*+1)2('++*0)0(0'210)


A:ter 6i8in6 the !ath o: !re-! 6radataion tool .scri!t4, -st

enter

A:ter eec-tin6 scri!t, -st ty!e s!ool o at sEl

!ro!t7

o to os le8el and o!en the s!ool @le, hich

contains necessary

Recoendation e:ore -!6radin6 the dataase7




Aeer!et, "yderaad $h% ''2())5*+1)2('++*0)0(0'210)





Aeer!et, "yderaad $h% ''2())5*+1)2('++*0)0(0'210)


Be:ore -!6radin6 :olloin6 all recoendations in the eistin6 dataase7

As !er s-66estions e ha8e to do the :olloin6 thin6s%

17 Mini- -ndo tales!ace is reE-ired (5+ MB, so increase the siGe o:

-ndo tales!ace727 Shared=!ool=siGe needs to e increased -!to 22) MB(7 R!lace the d=locH=-ers ith d=cache=siGe ith a 8al-e )1)(0))7 These are the osolete !araeter, it is not recoended in 11 6, so

etter reo8e the :olloin6 !araeter :ro the !araeter @le7

#BacH6ro-nd=d-!=dest>*hoe*!rd*d-!




Aeer!et, "yderaad $h% ''2())5*+1)2('++*0)0(0'210)

Fac-lty% Satya Seela .10 /rs DBA ! n 3SA4 # 3ser=d-!=dest>*hoe*!rd*-d-!

#Core=d-!=dest>*hoe*!rd*cd-!

57 There is !atch set .1072707)704 is reE-ired in the eistin6 dataasee:ore start -! 6radation !rocess7

'7 The !araeter co!atile sho-ld e 1171707170

"ow to apply patch set #$ the oracle

database %

Ste! 1% Be:ore a!!lyin6 !atch, @rst o: all yo- sh-t don all oracle

ser8ices, sto! all listeners, allDataase instances7

Ste! 2% e!ort the ;RAC<=";M that needs to e !atched7Ste! (% o to !atch directory here yo- ha8e donloaded the !atch

set hich yo- ha8e toA!!ly7

Ste! )% eec-te the r-nnstaller, and do accordin6, till the eec-tion o:

the last scri!t7Ste! 5% e!ort the ;RAC<=SD that yo- ant to a!!ly the !atch set7Ste! '% connect as sysdaSte! 9% Start the dataase in -!6rade ode7 .;therise yo- o-ld 6et

an error ora102 oracle nstance terinated and disconnected :orce47SI<JSTART3$ 3$RAD

Ste! +% eec-te this coand KL*rds*adin*cat-!6rd7sEl J enterSte! % checH any in8alid oects as Select co-nt .4 :ro da=oects here stat-s>NA<DO Ste! 10% : there is any in8alid oects, -se the :olloin6 scri!t KL*rds*adin*-tlr!7sEl JenterSte! 11% A6ain checH any in8alid oects as Select co-nt .4 :ro da=oects here stat-s>NA<DOSte! 12% : not :o-nd any in8alid oects7 Then it is oH7Ste! 1(% No sh-t don the dataase !ro!erlySte! 1)% edit the !araeter @le and chan6e co!atile 1072707)70Ste! 15% No connect as sysdaSte! 1'% Start-! the dataase :or oH7




Aeer!et, "yderaad $h% ''2())5*+1)2('++*0)0(0'210)

Fac-lty% Satya Seela .10 /rs DBA ! n 3SA4 Ao8e are the co!lete ste!s :or a!!lyin6 !atchs7 "ere is Screen

sna!shots7




Aeer!et, "yderaad $h% ''2())5*+1)2('++*0)0(0'210)


ClicH Net




Aeer!et, "yderaad $h% ''2())5*+1)2('++*0)0(0'210)


ClicH net




Aeer!et, "yderaad $h% ''2())5*+1)2('++*0)0(0'210)


ClicH nstall




Aeer!et, "yderaad $h% ''2())5*+1)2('++*0)0(0'210)


?ait :or co!lete




Aeer!et, "yderaad $h% ''2())5*+1)2('++*0)0(0'210)


ec-te this scri!t as a root -ser and then clicH oH7




Aeer!et, "yderaad $h% ''2())5*+1)2('++*0)0(0'210)


P-st clicH it7




Aeer!et, "yderaad $h% ''2())5*+1)2('++*0)0(0'210)


ClicH /es7

The ao8e ste!s :or a!!lyin6 a !atch set7

Contin-eQ to -!6rade

Ste! 9% A:ter a!!lyin6 !atch set, increases the siGe o: -ndo tales!ace,

shared !ool siGe, once a6ain yo- eec-te the !re-!6rade in:oration tool

SI<JJK*hoe*oracle*!rod-ct*117170*d=1*rds*adin*-tl-111i7sEl




Aeer!et, "yderaad $h% ''2())5*+1)2('++*0)0(0'210)





Aeer!et, "yderaad $h% ''2())5*+1)2('++*0)0(0'210)


t is clearly shoin6 all reE-ireents :-ll @lled77

Ste! +% Sh-t don the 106 dataase7

Ste! % Chan6e location o: !araeter @le .!@le or s!@le4 :ro 106 location o:

!araeter @le to 116 de:a-lt location o: !araeter @le7

Ste! 10% dit the !araeter @le and chan6e !araeter

Co!atile>117170




Aeer!et, "yderaad $h% ''2())5*+1)2('++*0)0(0'210)


Ste! 11% dit the orata @le and chan6e the ne hoe location o: oracle

dataase7 i7e7

8i *etc*orata Jenter

Ste! 12% ;!en the 7ash=!ro@le and edit the ;racle hoe location




Aeer!et, "yderaad $h% ''2())5*+1)2('++*0)0(0'210)


A:ter chan6in6 the ;racle ne hoe location7 Sa8e and eit :ro !araeter

@le7

Ste! 1(% eec-te the 7ash=!ro@le to aHe the en8ironent 8isile7

Ste! 1)% Connect as sysda and start the dataase in -!6rade ode7




Aeer!et, "yderaad $h% ''2())5*+1)2('++*0)0(0'210)


Ste! 15% eec-te the -!6rade scri!t hich coes ith oracle ne hoe. 11647

Ste! 1'% At the end o: eec-tion o: the ao8e scri!t, the dataase il sh-t

don7 So start the dataase7

SI<Jstart-!

Ste! 19% ChecH the in8alid oects




Aeer!et, "yderaad $h% ''2())5*+1)2('++*0)0(0'210)


Ste! 1+% eec-te the :olloin6 scri!t to reco!ile the in8alid oects7

Ste! 1% A6ain checH in8alid oects7: there is no any in8alid oects then

yo- 6o net ste! other yo- 6o

to ste! 1+7

Ste! 20% eec-te the !ost -!6rade stat-s tool7 To checH the -!6rade stat-s

o: each dataase co!onents7




Aeer!et, "yderaad $h% ''2())5*+1)2('++*0)0(0'210)


Ste! 11% No sh-t don the dataase !ro!erly and start-! the dataase :or

o!eration !-r!oses7 t is the -!6raded dataases7

Ca-tion% Dont start the dataase in old hoe location, it ay corr-!t the

dataase7

The nd7

copy of how to upgrade from 10g database to 11g database

Documents