oracle11g 32bit upgrade to 64bit

Because of the 32bit database memory limit, it is difficult to break through 4G memory, forcing the database to be upgraded to 64bit.

Upgrade steps:

1, close the database, and cold the database (copy data files, control files, SPFile, etc.), can directly back up the Oracle_base directory.

2, uninstall the original 32bit database software (delete/etc/orainst.loc,/etc/oratab can).

3, install 64bit the same version of the database, and build the library, close the database.

4, the 32bit version of the data files, control files, SPFile,, Listener.ora, Tnsnames.ora to the corresponding directory under 64bit.

5, start the database (Startup upgrade).

6. Recompile the 64-bit PL/SQL module.

@ $ORACLE _home/rdbms/admin/utlirp.sql

After execution, there will be many more invalid objects, need to recompile, and if you install the OLAP components, you need to reinstall the OLAP components, no one skip the following step.

7. Reinstall the OLAP components

7.1. Delete OLAP components

CD $ORACLE _home/rdbms/lib make-f ins_rdbms.mk olap_off make-f ins_rdbms.mk ioracle

7.2. Install OLAP

Sqlplus/as sysdba sql> spool add_olap.log sql> @?/olap/admin/olap.sql sysaux TEMP; Sql> Spool Off

8. Compile Invalid object

Sqlplus/as sysdba sql> spool utlrp.log sql> @?/rdbms/admin/utlrp.sql sql> spool off

9. Rebuilding Javashared Data Objects (SRO)

10, repeat the 8th step, compile invalid object

11. Verify that there are invalid objects and components.

Sql> Select Owner,object_name,object_type from all_objects where status= ' INVALID '; Sql> select Comp_id,comp_name,version,status from Dba_registry;

Attached: Rebuilding javashared Data Objects SQL statement

Begin

Update obj$ set status=5 where obj#= (select obj# from obj$,javasnm$

where Owner#=0 and type#=29 and short (+) =name and

NVL (longdbcs,name) = ' Oracle/aurora/rdbms/compiler ');

Commit

Declare

Cursor C1 is Select

' DROP JAVA DATA ' | | u.name| | ' "." ' | | O.name | | ‘"‘

from obj$ o,user$ u where o.type#=56 and u.user#=o.owner#;

Ddl_statement VARCHAR2 (200);

Iterations number;

Previous_iterations number;

Loop_count number;

My_err number;

Begin

Previous_iterations: = 10000000;

Loop

--to make sure we eventually stop,pick Amaxnumber of iterations

Select COUNT (*) into iterations from obj$ where type#=56;

Exit when Iterations=0 or iterations>=previous_iterations;

Previous_iterations: = iterations;

Loop_count: = 0;

Open C1;

Loop

Begin

Fetch C1 into ddl_statement;

Exit when C1%notfound or Loop_count > iterations;

Exception when others then

My_err: = Sqlcode;

If My_err =-1555 then--snapshot too old, re-execute fetch query

Exit

Else

Raise

End If;

End

Initjvmaux.exec (ddl_statement);

Loop_count: = Loop_count + 1;

End Loop;

Close C1;

End Loop;

End

Commit

INITJVMAUX.DRP (' Delete from java$policy$shared$table ');

Update obj$ set Status=1 where obj#= (select obj# from obj$,javasnm$

where Owner#=0 and type#=29 and short (+) =name and

NVL (longdbcs,name) = ' Oracle/aurora/rdbms/compiler ');

Commit

End

/

Create or replace Java system

/

This article is from the "composer" blog, make sure to keep this source http://zuoqujia.blog.51cto.com/9151800/1652306

oracle11g 32bit upgrade to 64bit