Data files are not affected by moving to 64-bit Oracle. After installing
64-bit software you have to change word size from 32-bit to 64-bit.
- Shutdown all products running from 32-bit home.
- cold backup
- install 64-bit software, apply same patchset level as in 32-bit home,
get patch 1994933
- move and edit init.ora. Set these parameters:
aq_tm_processes = 0
job_queue_processes = 0
_system_trig_enabled = FALSE #even if this parameter is not set to true
in your current init.ora, do not omit this !!!
- startup restrict in 64-bit home
For next steps I used 3 shell scripts (for logging purposes and becouse
I had more than one database to migrate):
upg64_1.sh --------------------
sqlplus "/ as sysdba" <<EOF > upg64_1.log
delete from duc$ where pack='JIS$INTERCEPTOR$' and proc='USER_DROPPED';
commit;
select to_char(sysdate,'YYYY/MM/DD HH24:MI:SS') from dual;
@?/rdbms/admin/utlip.sql
select to_char(sysdate,'YYYY/MM/DD HH24:MI:SS') from dual;
EOF
upg64_2.sh --------------------
sqlplus "/ as sysdba" <<EOF > upg64_2.log
select to_char(sysdate,'YYYY/MM/DD HH24:MI:SS') from dual;
@?/javavm/install/initjvmaux.sql
select to_char(sysdate,'YYYY/MM/DD HH24:MI:SS') from dual;
prompt rmsro.sql
@/u01/app/oracle/admin/upload/Patches/p1994933/rmsro.sql
call rmsro.run();
prompt invalidate.sql
select to_char(sysdate,'YYYY/MM/DD HH24:MI:SS') from dual;
@/u01/app/oracle/admin/upload/Patches/p1994933/invalidate.sql
select to_char(sysdate,'YYYY/MM/DD HH24:MI:SS') from dual;
EOF
upg64_3.sh --------------------
sqlplus "/ as sysdba" <<EOF > upg64_3.log
select to_char(sysdate,'YYYY/MM/DD HH24:MI:SS') from dual;
prompt shutdown
shutdown immediate
prompt startup
startup restrict
select to_char(sysdate,'YYYY/MM/DD HH24:MI:SS') from dual;
prompt JVM recreate
create or replace java system
/
prompt shutdown
shutdown immediate
prompt startup
startup restrict
prompt invalidate
@?/rdbms/admin/utlrp.sql;
prompt shutdown
shutdown immediate
prompt startup
startup
select to_char(sysdate,'YYYY/MM/DD HH24:MI:SS') from dual;
spool off
EOF
In step 2 /u01/app/oracle/admin/upload/Patches/p1994933/ points to
directory where I extracted patch 1994933.
--
Posted via http://dbforums.com
Received on Wed May 21 2003 - 00:56:27 CDT