Ugrade from 9i to 10G DBUA/Listner issue

[vince_laurent]

I am trying to use DBUA to upgrade my database. At 16% I got a pop up error saying: "ORA-12547 TNS: Lost Contact" Ignore does nothing... And I don't really want to abort.

I am running HP-UX 11i, Oracle 9.2.0.8 going to 10.2.0.2.

I am on page 31 of the upgrade guide. I am also stuck...

Ideas?

Yes, I have installed the patches...

Yes, I have my oracle user environment set to the new 10G stuff...

Thanks

Vince

[Former Member]

Hi Vince,

If you have made any Doccument or Screenprints can you plz email it to syedershad@gmail.com, i need to upgrade oracle from 9i to 10.2.0.2, and its on Sunsolaris, SAP is 4.6c.

Regards,

Ershad Ahmed.

[markus_doehr2]

There´s a VERY good upgrade documentation from SAP:

http://service.sap.com/instguides

--> Other Documentation

--> Database Upgrades

--> Oracle

--> Upgrade to Oracle Database 10g Release 2 (10.2): UNIX

Everything is explained there step-by-step.

Also check the relevant upgrade notes (and especially the attachment):

Note 819830 - Oracle Database 10g: Additional Information on upgrade:UNIX

Install the latest Patchset 10.2.0.2 and all relevant patches from as with

Note 871096 - Oracle Database 10g: Patch sets/patches for 10.2.0

explained.

For Solaris you will need the latest OPatch to install the patches, otherwise verification will fail (see

Note 841728 - Oracle Database 10g: Software installation problems 10.2.0

, installation problem #5)

It does not make sense to use "screenshots" since every system is different.

--

Markus

[vince_laurent]

Good documentation - yes. Organized documentation - NO. Besides the upgrade guide I have about 30 notes that I had to go through. What I did was make a step-by-step cheat sheet with stuff from the upgrade guide AND all the notes so what the notes said to do/check was done at the right time. I am almost done with 1 server and have 10 more to go. I wanted ONE place to go for everything IN ORDER and so that is what I am working on....

Just my $0.02

Vince

[markus_doehr2]

I agree 100 %.

The ORGANIZATION of doing what at what time in what manner takes about 75 % of your work. If you prepare an upgrade, it´s the most work, getting all documentation, notes, help.sap.com´s, whitepapers, database documentation etc. in place. The upgrade itself is then only a matter of "doing it".

This is the price of an all-integrated-all-in-one software. Oracle itself is complicated and big enough to fill several books alone leaving aside any application running on top. If you add the complexity of a SAP system then, especially if it´s not on the newest release you can´t do anything but read ALL notes, that belong even if "somehow" to the topic.

I said so often in OSS calls or on events to NOT add additional notes but modify the ORIGIN of the error (e. g. the upgrade guide, the "root cause"). Sometimes it´s done, but most of the time it´s much easier and faster to just write a new note.

I do it the same way, read all documentation/notes, make a step-by-step list yourself for that specific system and execute. It´s the only way of doing things without much risk.

--

Markus

[vince_laurent]

Digging through a ton of metalink articles and such I ended up just relinking oracle. Then it worked. Go figure...

relink all

[Former Member]

Hi

can u post the process u followed

Regards

Jameel Khan

[vince_laurent]

Are you wanting the enitre 9i to 10G process or what?

[markus_doehr2]

Is your listener still running or did it abort?

--

Markus

[vince_laurent]

It was still running.