Re: Moving from 8.1.7 32-bit to 8.1.7 64-bit

Export/import ?? - but that's against the principles of the lazy DBA !!! :-)

Complete the following steps to change the word-size: (I did it on AIX going from 817 32bit to 64bit)

1. Start Server Manager by entering the following command:

    svrmgrl

 2. Run CONNECT INTERNAL:

    SVRMGR> CONNECT INTERNAL  3. Run SHUTDOWN NORMAL on the first database:

    SVRMGR> SHUTDOWN NORMAL  4. Perform a full offline backup of the database (Optional).

 5. If you currently have a 32-bit installation,

    install the 64-bit version. Or, if you currently have a 64-bit     installation, install the 32-bit version.

 6. At a system prompt, change to the $ORACLE_HOME/rdbms/admin

    directory.

 7. Start Server Manager by entering the following:

    svrmgrl

 8. Run CONNECT INTERNAL:

    SVRMGR> CONNECT INTERNAL  9. Run STARTUP RESTRICT:

    SVRMGR> STARTUP RESTRICT

1. Set the system to spool results to a log file for later verification of success:

    SVRMGR> SPOOL CATOUTW.LOG

1. Run UTLIRP.SQL:

    SVRMGR> @utlirp.sql

    The UTLIRP.SQL script recompiles existing PL/SQL modules in the     format required by the new database. This script first alters     certain dictionary tables. Then, it reloads package STANDARD     and DBMS_STANDARD, which are necessary for using PL/SQL.     Finally, it triggers a recompile of all PL/SQL modules, such as     packages, procedures, types, etc.

1. Turn off the spooling of script results to the log file:

    SVRMGR> SPOOL OFF     Then, check the spool file and verify that every package and     procedure compiled successfully. You named the spool file in     Step 10; the suggested name was CATOUTW.LOG. Correct any     problems you find in this file.

1. Run ALTER SYSTEM DISABLE RESTRICTED SESSION:

    SVRMGR> ALTER SYSTEM DISABLE RESTRICTED SESSION The word-size of your database is now changed. You can open the database for normal use.

"Jim Kennedy" <kennedy-family_at_home.com> wrote in message news:Kyr97.415991$p33.8432114_at_news1.sttls1.wa.home.com...
> I am not sure, but my guess would be that you need to export the 32 bit.
> Install the 54 bit, rebuild the db and import the data.
> Jim
> "Yurasis Dragon" <yurasis_spamNOSPAM_at_yahoo.com> wrote in message
> news:7r6cmt4rm9hbg001vp65qbad1t9s7mlkq4_at_4ax.com...
> >
> > So if I install the 64-bit software is there some conversion
> > needed on a 32-bit database that I need to perform or is it
> > as easy as simply re-setting ORACLE_HOME and starting
> > up the old database with the 64-bit software?
> >
> > Thanks in advance for any help.
> >
> >
>
>
Received on Tue Jul 31 2001 - 03:08:10 CDT