Tuesday, November 6, 2007

Changing DB 32-Bit to 64-Bit

INSTALLING THE 64BIT RELEASE

1. Ensure that there is ample free size for the 64bit release installation.
Recommended free space should be 3G.

2. Start the Installer GUI.


3. On the File Locations Screen, create a new name and path for the 64bit
oracle installation under the Destination.

A typical entry would be

Name: orahome920_64b
Path: /u01/app/oracle/product/9.2.0-64b

4. Proceed with the installation. Stop at the configuration assistant
configuration screen.

5. Install the latest 64bit patch set under the new oracle installation.


CHANGING THE WORD-SIZE OF YOUR CURRENT RELEASE

The instructions in this section guide you through changing the word-size of
your current release (switching from 32-bit software to 64-bit software or vice versa).

Complete the following steps to change the word-size of your current release:

1. Start SQL*Plus.

2. Connect to the database instance AS SYSDBA.

3. Run SHUTDOWN IMMEDIATE on the database:
SQL> SHUTDOWN IMMEDIATE

4. Perform a full offline backup of the data depending on the available backup
mechanism, eg BCV, Unix file copy.

5. If the initialization parameter file eg initSID.ora, spfileSID.ora, listener.ora, sqlnet.ora resides within the old OR
ACLE_HOME, then copy it to the corresponding location of the new 64b it ORACLE_HOME. If the parameter files are symbol
ic links to another location, then the symbolic links have to be created in the new ORACLE_HOME.

Example:
Old $ORACLE_HOME/dbs
initSID.ora->/u01/app/oracle/admin/lss/initSID.ora
spfileSID.ora->/u01/app/oracle/admin/lss/spfileSID.ora
The same links have to be created in new $ORACLE_HOME/dbs.


6. Change your active Oracle instance environment to point at the new 64Bit ORACLE_HOME.
Eg
a)
Edit /var/opt/oracle/oratab if using dbhome/oraenv to set the environment.

lss:/u01/app/oracle/product/9.2.0:Y

i) set it to the new 64bit Oracle Home path

lss:/u01/app/oracle/product/9.2.0-64b:Y

b)
Change the essential environment setting eg $ORACLE_HOME,$LD_LIBRARY_PATH to use new 64bit Oracle Home Path if h
ardcoded

export ORACLE_HOME=/u01/app/oracle/product/9.2.0

Change to

export ORACLE_HOME=/u01/app/oracle/product/9.2.0-64b

7. Set AQ_TM_PROCESSES=0 if it is not.

a) If using initSID.ora to start instance, then add it to the init file.

b) If using spfileSID.ora to start instance,then the database can be startup and the parameter set by running th
e below command.

SQL> ALTER SYSTEM SET aq_tm_processes=0 SCOPE=SPFILE;

c) shutdown the database again.
9. Set _system_trig_enabled = false.

a) If using initSID.ora to start instance, then add it to the init file.
b) If using spfileSID.ora to start instance, then the database can be startup and the parameter set by running th
e below command.

SQL> ALTER SYSTEM SET "_system_trig_enabled"=FALSE SCOPE=SPFILE;

c) shutdown the database again.


The parameter should be set to FALSE for scripts that perform dictionary operations as the objects on which the triggers d
epend may become invalid or be dropped, causing the triggers to fail and thus preventing the scripts from running successf
ully.

10. When migrating from a 32-bit Oracle version to a 64-bit Oracle version, Oracle recommends doubling the size of paramet
ers such as:

SHARED_POOL_SIZE
SHARED_POOL_RESERVED_SIZE
LARGE_POOL_SIZE

11. At a system prompt, change to the new 64bit ORACLE_HOME/rdbms/admin
directory.

12. Start SQL*Plus.

13. Connect to the database instance AS SYSDBA.

14. Run STARTUP RESTRICT:

SQL> STARTUP RESTRICT

15. Run the following script:

SQL> @?/rdbms/admin/catalog.sql

16. Check for DBMS_PACKAGE validity.

17. If invalid, run below

SQL> alter package dbms_standard compile;
18. Run the following script:

SQL> @?/rdbms/admin/catproc.sql

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

SQL> SPOOL /tmp/catoutw.log

20. Run utlirp.sql:

SQL> @?/rdbms/admin/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 P
L/SQL. Finally, it triggers a recompile of all PL/SQL modules, such as packages, procedures, types, and so on.

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

SQL> SPOOL OFF

Then, check the spool file and verify that the packages and procedures compiled successfully. You named the spool fil
e in Step 12; the suggested name was catoutw.log. Correct any problems you find in this file.


22. Run ALTER SYSTEM DISABLE RESTRICTED SESSION:

SQL> ALTER SYSTEM DISABLE RESTRICTED SESSION;

23. Remove the parameter aq_tm_processes or set value back to the original value.

a) If using initSID.ora to start instance, then remove or edit it from the init file after shutting down the data
base.

b) If using spfileSID.ora to start instance, then the parameter can be change by running the below command.

SQL> ALTER SYSTEM SET aq_tm_processes= SCOPE=SPFILE;

To remove the parameter.

SQL> ALTER SYSTEM RESET aq_tm_processes SCOPE=SPFILE SID=.*.;
24. Remove the parameter _system_trig_enabled = FALSE

a) If using initSID.ora to start instance, then remove it from the init file after shutting down the database.

b) If using spfileSID.ora to start instance, then the parameter can be removed by running the below command.

SQL> ALTER SYSTEM RESET "_system_trig_enabled" SCOPE=SPFILE SID=.*.;

25. The word-size of your database is changed. The database can be shutdown and reopen for normal use.

15 Comments:

RD said...

Basically, the OS should be 64bit in the first place right? Or is it possible that you have a 32 bit DB in a 32bit OS and change to 62bit?

M A D A N M O H A N said...

You are right the O/s Should be 64-bit for 64-bit database.

We cannot have 64-bit DB running on 32-bit O/s ,but reverse is very much possible.

M A D A N M O H A N said...

Hi RDR,

Please see the Question 90 in "Oracle Apps DBA Interview Questions" post.

Hope i cleared your doubt.

Rgds,
Madan

Anonymous said...

Good dispatch and this fill someone in on helped me alot in my college assignement. Thank you as your information.

Anonymous said...

What are the downs of having the 32bit version running on a 64 bit server. Is it really necessary to make the word size changes.

Easter said...

Hi RDR, Please see the Question 90 in "Oracle Apps DBA Interview Questions" post. Hope i cleared your doubt. Rgds, Madan

Anonymous said...

Very rapidly this site will be famous among all blogging and site-building
viewers, due to it's pleasant content

my web-site :: diets that work

Anonymous said...

While it iscertainly okay to play video family guy video
game for over seven hours per day. District 4 has also has" Career"
tributes and is the epitome of football songs.

Here are 5 family guy video game that are well-loved,
bringing lots of laughters to the event. While playing on residentialswingsets is not the only gamer facing this dilemma, and you're teaching them to monitor their own progress along the way in.

My blog; back to the future video game

Anonymous said...

You can ignore or embrace discount dance and imbue
them with the best artistic quality. And like its predecessor -Star
Wars- anything you could slap that almost
phallic alien face on would and did make money.
It is amazing to look at one of Max's spiritual successor; Stranglehold. It is like you are supposed to.

Feel free to surf to my blog post :: just dance kinect

Anonymous said...

Many celebrities are actually fascinated with the
retro looks of due to the fact, for example, Oprah, Paris Hilton,
Pamela Anderson and Kate Hudson etc. These
types of Ugg Boots Clearance may be found in 2 colors from the store at fine sand too as saying.
So you can find that shoes, clothes, even bags for kids has become more exquisite than
before.

my web page: ルイヴィトン バッグ

Anonymous said...

Hi my family member! I wish to say that this article is amazing,
nice written and come with almost all significant infos.

I would like to peer more posts like this .

my blog post; the auto body shop Sacramento

Anonymous said...

If some one needs expert view concerning running a blog then i advise him/herto go to see this website, Keep up the fastidious
job.

Here is my web blog ... Montana Nude Pics

Anonymous said...

Business owners formerly hired full-time personnel to crew aircraft and maintain the company
aircraft; however, the aviation management business model has changed significantly.
Lucerne is best cut at a height approximately 50 mm above ground level.
By adjusting your devices settings, you can disable in-app purchases.


Here is my page ... hay day cheats

Anonymous said...

Although Flash is one of the farmville 2 country
escape cheats ice ball. Today, each and every mobile.
For newcomer gamers, new business models, without any scope
of mobile bingo games, and you just need to select your language, such
as: new games. The adorable turtle swims along to beat.
Cut farmville 2 country escape cheats The Rope: Like Angry
Birds.

Feel free to visit my website: Farmville 2 country escape cheat tool activation code

Anonymous said...

smokeless cigarettes, e cigarette, electronic cigarette, electronic cigarettes, e cig reviews, e cigarette