Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Migration procedure wanted: Oracle 32 bit to Oracle 64 bit

Steven E. Protter
Exalted Contributor

Migration procedure wanted: Oracle 32 bit to Oracle 64 bit

We have an oracle db running on HP-UX 11.00 32 bit.

Its oracle 8i release 3 8.1.7.0.0 with full JVM installation.

We want to migrate this database to HP-UX 11.11 64 bit. Oracle's procedures thus far have been full of holes. Big holes, that you can drive a semi truck through.

Our current migration procedure generates this error:

PLS-213, ORA-6553: PACKAGE STANDARD NOT ACCESSIBLE

Thats because it deletes a package called dbms_standard

Then when it tries to create it brand new, it can't access the package.

We are wondering if any real world users have encountered this problem and what they did to solve it.

Oracle's been workin on this about 3 weeks and they seem somewhat clueless(a charitable description). You guys do real work on HP-UX and points will be liberally awarded for help.

Steve

Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
21 REPLIES
Dave Chamberlin
Trusted Contributor

Re: Migration procedure wanted: Oracle 32 bit to Oracle 64 bit

You can't install a 64 bit APP on a 32 bit OS. If you had a 64 bit OS, you could do a full export of the 32 bit database into a 64 bit database.
John Poff
Honored Contributor

Re: Migration procedure wanted: Oracle 32 bit to Oracle 64 bit

Hi Steve,

The 64 bit version of Oracle will choke like a big dog on a 32-bit HP-UX installation. I experienced it first hand last summer by accident. One of our guys loaded the OS and missed that tiny little part about the 32/64 bitness in HP-UX. We wound up reloading the OS and starting from scratch.

I'm kind of surprised that Oracle didn't ask you if the OS was 64 bit.

JP
Steven E. Protter
Exalted Contributor

Re: Migration procedure wanted: Oracle 32 bit to Oracle 64 bit

Allow me to clarify.

The target environment is a different machine.

Its an 11.11 machine, 64 bit. Oracle 8.1.7 is already installed and working, also 64 bit.

We are need a data migration plan.

How to get the data off the 32 bit platform and into an instance on the 64 bit platform.

Steve
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
John Poff
Honored Contributor

Re: Migration procedure wanted: Oracle 32 bit to Oracle 64 bit

Hi,

We've been doing some 32 bit Oracle 7.X migrations to 64 bit Oracle 8.1.x recently. Our DBAs have been exporting the database on the old system, copying it over to the new system, and importing the data into the Oracle 8 database.

JP
Steven E. Protter
Exalted Contributor

Re: Migration procedure wanted: Oracle 32 bit to Oracle 64 bit

thanks, one of our issues has been the presence or absence of vital java objects. It also seems that some objects are not compiled properly.

There are also issues with 32 bit word size to 64 bit word size.

Exports have not been importing really well into the target db.

I'm hoping to get lucky and run into a sysadmin who has done exactly what we are trying to do.

You'd think it would take five minutes since the version number is the same on all platforms, but we're dealing with Oracle support here.

Steve
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Brian Crabtree
Honored Contributor

Re: Migration procedure wanted: Oracle 32 bit to Oracle 64 bit

Hmmm. It sounds like you are hitting more than one issue. For the Java problem, I would suggest having them reload all of the java from scratch (there are procedures for this on metalink). For the invalid procedures, you can run $OH/rdbms/admin/utlrp.sql or utlirp.sql. The utlrp.sql script just rebuilds the packages that are invalid, while the utlirp.sql script invalidates all the packages, and then rebuilds them (requirement for a change in word size).

Can you run the following sql statement and paste the results here or in an attachment?

select object_name,object_type,status from dba_objects where owner = 'SYS' order by object_name,object_type;

Thanks,

Brian
Indira Aramandla
Honored Contributor

Re: Migration procedure wanted: Oracle 32 bit to Oracle 64 bit

Hi with the erro message that you are experiencing, "ORA-00604 ORA-06553 PLS-213 Standard-package not accessible", you can try to execute the ORACLE_HOME/rdbms/admin/catalog.sql and catproc.sql as the SYS user ans see if this fixes.
But then again I have seen that you have Java issues. With Java issues, the only way is to reconfigure your database for Java. You have to remove the java (follow the instructions in hava enabling the database in Metalink) and re-configure the java. After the java configuration there should be roughly 1,040 java objects and class all with status ='VALID" and the package DBMS_JAVA should exist.
Never give up, Keep Trying
Alexander M. Ermes
Honored Contributor

Re: Migration procedure wanted: Oracle 32 bit to Oracle 64 bit

Hi there.
The idea with export / import is ok.
You have to recompile your objects after the import. We found this the hard way.
It may be possible, that oyu compile your views every minute during the import, otherwise you might get stuck.
Oracle has sent me some tools.
----------------------------
compile.sql

@viewcomp
@package
@packbody
@procedure
@trigcomp

@badobjects
-------------------------------

viewcomp.sql

@terse
spool vslave.sql

select 'alter view '||owner||'.'||object_name||' compile ; '
from dba_objects
where object_type='VIEW'
and status = 'INVALID'
/

spool off
@login
spool viewcomp
@verbose
@vslave
spool off
@login

prompt viewcomp.sql completed
-------------------------------------
terse.sql

set term off
set show off
set scan on
set space 1
set time off
set timing off
set sqlprompt ''
set sqlcontinue ''
set pages 50000
set lines 255
set head off
set feed off
set pause off
set wrap off
~
--------------------------------

package.sql

@terse
spool pslave.sql

select 'alter package '||owner||'.'||object_name||' compile package ; '
from dba_objects
where object_type = 'PACKAGE'
and status = 'INVALID'
/

spool off
@login
spool package
@verbose
@pslave
spool off
@login

prompt package.sql completed
~
--------------------------------------

packbody.sql

@terse
spool slave.sql


select 'alter package '||owner||'.'||object_name||' compile body ; '
from dba_objects
where object_type = 'PACKAGE BODY'
and status = 'INVALID'
/
spool off
@login
spool packbody
@verbose
@slave
spool off
@login

prompt packbody.sql completed
-----------------------------

procedure.sql

@terse
spool slave.sql

select 'alter procedure '||owner||'.'||object_name||' compile ; '
from dba_objects
where object_type = 'PROCEDURE'
and status = 'INVALID'
/

spool off
@login
spool procedure
@verbose
@slave
spool off
@login

prompt procedure.sql completed
~
------------------------------------

trigcomp.sql

@terse
spool tslave.sql

select 'alter trigger '||owner||'.'||trigger_name||' compile ; '
from dba_triggers
/

spool off
@login
spool trigcomp
@verbose
@tslave
spool off
@login

prompt trigcomp.sql completed
--------------------------------------

badobjects.sql

@login
spool badobjects

select owner, object_name, object_type
from dba_objects
where status = 'INVALID'
/

spool off

prompt end of badobjects.sql

--------------------------------------------

Hope i could help.
Rgds
Alexander M. Ermes

.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
H.Merijn Brand (procura
Honored Contributor

Re: Migration procedure wanted: Oracle 32 bit to Oracle 64 bit

Don't forget that you will need a completely rebuilt perl for 64bit if you are using DBD::Oracle. Note that if you are using a lot of CPAN modules, some might not work in 64bit mode.

Just a reminder.

Enjoy, have FUN! H.Merijn
Enjoy, Have FUN! H.Merijn
Steven E. Protter
Exalted Contributor

Re: Migration procedure wanted: Oracle 32 bit to Oracle 64 bit

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
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Steven E. Protter
Exalted Contributor

Re: Migration procedure wanted: Oracle 32 bit to Oracle 64 bit

Here is a log....

Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Steven E. Protter
Exalted Contributor

Re: Migration procedure wanted: Oracle 32 bit to Oracle 64 bit

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
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Steven E. Protter
Exalted Contributor

Re: Migration procedure wanted: Oracle 32 bit to Oracle 64 bit

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

Any experience with that migration path?

Steve
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
H.Merijn Brand (procura
Honored Contributor

Re: Migration procedure wanted: Oracle 32 bit to Oracle 64 bit

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)
Enjoy, Have FUN! H.Merijn
James Lakin
Occasional Advisor

Re: Migration procedure wanted: Oracle 32 bit to Oracle 64 bit

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
Honored Contributor

Re: Migration procedure wanted: Oracle 32 bit to Oracle 64 bit

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
Exalted Contributor

Re: Migration procedure wanted: Oracle 32 bit to Oracle 64 bit

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
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Steven E. Protter
Exalted Contributor

Re: Migration procedure wanted: Oracle 32 bit to Oracle 64 bit


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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Brian Crabtree
Honored Contributor

Re: Migration procedure wanted: Oracle 32 bit to Oracle 64 bit

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
Yogeeraj_1
Honored Contributor

Re: Migration procedure wanted: Oracle 32 bit to Oracle 64 bit

hi steve,

So strange that Oracle told you to install patch 2 and then the one-off patch! Normally, they recommend applying the latest available patch which in this case would be 8.1.7.4.

Hope that you do not face any new bugs with the new installation....

Best Regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Steven E. Protter
Exalted Contributor

Re: Migration procedure wanted: Oracle 32 bit to Oracle 64 bit

We went to 8.1.7.2.1 not .0 but the notes are hard to follow.

Is anything Oracle says that's stupid suprising?

We had to go to the one off patch after the big patch because there is no direct route from Release 3 8.1.7.0 to the patch for our original problem.

I'm going to talk to the dba about 8.1.7.4 before we have any more issues.

Since were not going to be the same version as the systems we're migrating from we might want to be more current.

Thanks for your replies and your time.

Steve.
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com