Migration procedure wanted: Oracle 32 bit to Oracle 64 bit

[Steven E. Protter]

Brian, funny you mention those sql scripts.

Thats the one that deltes dbms_standard and then can't put it back.

Sort of a circular issue. We think we have one major issue, complicated by smaller ones. I'm going to have my dba read this thread, because its just a bit over my head right now.

Thanks, keep em coming, let me know what if any logs you want to see.

Steve

[Steven E. Protter]

Here is a log....

[Steven E. Protter]

I'm working on the output for Brian's sql statment but right now oracle is down.

Basically prior to running the ut... script its present and valid, afterward, its absent.

After looking at the log, you'll see why.

The script that is supposed to fix it is breaking it.

[Steven E. Protter]

Oracle has told us to install 8.1.7.2
and then a patch for this problem.

Any experience with that migration path?

Steve

[H.Merijn Brand (procura]

I've just installed 8.1.7.4 on AIX-4.3.3.0 ove 8.1.7.0 and it went as smooth as on HP-UX (for as far as you consider Oracle installs smooth :)

Just download the upgrade patch from the Oracle repository, unzip it into a temp folder, run runInstaller, and select the fatch folder/Data1/stage/products.xxx (forgot the extention) and click next.

Enjoy, have FUN! H.Merijn (though fun is not the word I'd choose for working with Oracle)

[James Lakin]

Hi,
A small migration gotcha I experienced which is noted in Metalink but not explained well by ORACLE: Run the utlirp and other migration scripts via sqlplus and NOT svmgrl and you will get better results.

[Brian Crabtree]

Steve,

James is correct, however you will want to run this as the SYS user, not the SYSTEM user. You can do this with by running 'sqlplus internal'. Can you run the following sql command as well:

select * from dba_objects where object_name like '%STANDARD%';

Thanks,

Brian

[Steven E. Protter]

Oracle finally did get around to telling us to go to 8.1.7.2 and then apply a patch for this error.

It also requires some changes to some basic sql scripts.

I will provide an update when this 300 Meg Monster is installed.

Steve

[Steven E. Protter]

1) The 8.1.7.2.0 patchset for HP-UX 64-bit, patch number 1909158
2) The patch for bug 1994933 (8.1.7.2.0 HP-UX 64-bit).

This fixes the problem. You need to not print more than the first 10 pages or so of the readme, unless you like killing trees.

You need to stop in the procedure where you turn on system triggers and install patch for bug 19994933 prior to executing that step unless you like a database that won't stop and start.

Steve

[Brian Crabtree]

Steve,

Just as a sidenote, if you downloaded the 8.1.7.2.1 patchset from Metalink, you can ignore this, however Oracle originally released 8.1.7.2.0 for HP-UX, which crashed a number of databases due to some major bugs. It was only out for about a week or so before being removed, and was replaced with 8.1.7.2.1 (no banner or executable version change so it says 8.1.7.2.0). You might want to verify that you have the newest version of the 8.1.7.2.1 patchset available.

Brian