OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » 64 bit to 32 bit

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

64 bit to 32 bit [message #186020]

Fri, 04 August 2006 14:44

Chintu007
Messages: 10
Registered: February 2005

Junior Member

Hello world...
I have 64 bit oracle 9i R2 database and would like to clone 32 bit oracle 9i R2. So can somebody please suggest me what need to be done? Or is it possible or not.

Please reply.

Thanks,

Report message to a moderator

Re: 64 bit to 32 bit [message #186024 is a reply to message #186020]

Fri, 04 August 2006 15:36

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

export/import is one way.

Report message to a moderator

Re: 64 bit to 32 bit [message #187022 is a reply to message #186024]

Thu, 10 August 2006 09:52

Chintu007
Messages: 10
Registered: February 2005

Junior Member

Hello,
Thanks for your reply. Once I am done with export/import then do
I need to run any script? Like any script from $ORACLE_HOME/rdbms directory?
This is what I have done
1. Created new database under 32 bit
2. Ran Catlog and Catproc.
3. Import 64bit data.

At this point if I run following in databse

select * from v$version;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
PL/SQL Release 9.2.0.7.0 - Production
CORE 9.2.0.7.0 Production
TNS for Linux: Version 9.2.0.7.0 - Production
NLSRTL Version 9.2.0.7.0 - Production

SQL> select count(*) from dba_objects where status='INVLAID';

COUNT(*)
----------
0

So that means there is no any invalid objects and version shows 32 bit.

I want to make sure that is this available for user to use?

Please advice.

Thanks,

Report message to a moderator

Re: 64 bit to 32 bit [message #187950 is a reply to message #186024]

Wed, 16 August 2006 07:55

Chintu007
Messages: 10
Registered: February 2005

Junior Member

anacedent wrote on Fri, 04 August 2006 16:36

export/import is one way.

Any advise on this?????

Report message to a moderator

Re: 64 bit to 32 bit [message #188218 is a reply to message #187950]

Thu, 17 August 2006 08:21

kareem.sharawi
Messages: 1
Registered: August 2006

Junior Member

Hey Chintu,
What do u mean by "export/import" is only one way?
i'm facing the same problem, would be really glad to receive a reply.
Thanks.

Report message to a moderator

Re: 64 bit to 32 bit [message #188249 is a reply to message #186020]

Thu, 17 August 2006 10:29

nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...

Senior Member

exp/imp is a good way.

Install the 32 bit software on a different ORACLE_HOME perferably on a different server. Also install the net8 (netca) and start the listener and database.

exp the 64 bit database. ftp the file in binary mode to 32 bit machine. imp to the 32 bit database. Check for invalid views and other objects.

Now change the dns entry or otherwise make the clients look at the new 32 bit database.

We use a dns name in the host= parameter in the tnsnames.ora file, then change the dns entry to get all the clients to look at the new machine. Otherwise you might have to change every client's tnsnames.ora file.

Report message to a moderator

Previous Topic:	column level VPD
Next Topic:	how to resolve the error?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 25 13:23:04 CST 2025