[prev in list] [next in list] [prev in thread] [next in thread] 

List:       suse-oracle
Subject:    RE: [suse-oracle] 32bit to 64bit conversion step
From:       <michael.d.taylor () exgate ! tek ! com>
Date:       2006-07-26 21:41:21
Message-ID: 6CFB88F9A6EF4941970041EB633DB5C2B913D4 () us-bv-m24 ! global ! tektronix ! net
[Download RAW message or body]

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@oracle.com] 
Sent: Wednesday, July 26, 2006 12:33 PM
To: Bennett Leve
Cc: Robert W Franklin; Pinault, Damien; suse-oracle@suse.com
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@suse.com
For additional commands, email: suse-oracle-help@suse.com
Please see http://www.suse.com/oracle/ before posting


[prev in list] [next in list] [prev in thread] [next in thread]