I would add you can save some time by running utlip.sql to invalidate
all of your PL/SQL, then utlrcmp.sql with a parallelism of 4x number of
CPUs to recompile faster than what utlrp.sql will do.
@utlip.sql
@utlrcmp.sql
exec utl_recomp.recomp_parallel(16);
-Michael
-----Original Message-----
From: Saravanavijayan Velu [mailto:saravanavijayan.velu@(protected)]
Sent: Wednesday, July 26, 2006 12:33 PM
To: Bennett Leve
Cc: Robert W Franklin; Pinault, Damien; suse-oracle@(protected)
Subject: Re: [suse-oracle] 32bit to 64bit conversion step
Robert,
Here are the steps when I moved from Linux 32bit to 64bit..... May be
useful. Again TEST -> TEST -> TEST-> and Implement. Good luck.
_ENVIRONMENT I have validated:_
Outlined steps are testes in DB version 10.2.0.2, Suse 9.0
(Kernel:2.6.5-7.193-smp ) and RH 4.0(Kernel: 2.6.9-34.0.1.0.7.ELsmp) -
x86_64.
SQL> select PLATFORM_ID,PLATFORM_NAME, ENDIAN_FORMAT from
v$transportable_platform where PLATFORM_ID in (10,13);
PLATFORM_ID PLATFORM_NAME ENDIAN_FORMAT
----------- -------------------- --------------
10 Linux IA (32-bit) Little
<----------------------Source
13 Linux 64-bit for AMD Little
<----------------------Destination
1)add following parameter in init.ora
_system_trig_enabled=false
2)
-- Word conversion : utlirp.sql - UTiLity script to Invalidate Pl/sql
modules
startup upgrade
@?/rdbms/admin/utlirp.sql
shutdown
3) edir init.ora and remove or comment
_system_trig_enabled=false
4) issue and workaround:
Issue:
we are in the last step of 32bit to 64bit conversion but session
disconnects
with
ORA-3113 error and alert log reports following error when we run
utlrp.sql :
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10]
[SIGSEGV] [Address not mapped to object] [0x2B983EDF0F] [] []
Workaround: remove olap and reinstall
--OLAP REMOVE
spool olap_remove
@?/olap/admin/catnoamd.sql
@?/olap/admin/olapidrp.plb
exit;
--OLAP ADD
spool olap_add
connect SYS as SYSDBA
@?/olap/admin/olap.sql SYSAUX TEMP;
Refer: Note 352306.1 Upgrading OLAP from 32 to 64 bits if you use OLAP
funtionality.
5)
--Recompile invalid objects
@?/rdbms/admin/utlrp.sql
- Vijayan
Bennett Leve wrote:
> Robert,
>
> It will work if you are going from 32 to 64 and vice versa if the
> platforms are the same. See Metalink note 341880.1 "Migrating
> Oracle9i Single Instance Database from Linux x86 to Linux x86-64".
> The process is the same going in either direction.
> There is a more generic note:
>
> <NOTE:62290.1> - Changing between 32-bit and 64-bit Word Sizes
>
> -Bennett
> *
> *Robert W Franklin wrote:
>
>> I tried going from a 32 to 64 bit. I spent 3 days on it and then
>> called oracle to see if it was possible. Oracle said "that won't
work."
>>
>> Reason: Datafiles are different on the different OS's and with the
>> different Oracle Binaries.
>>
>> If it works, I would be VERY interested in how it was accomplished.
>>
>
>
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
