Home » RDBMS Server » Server Administration » 64 bit to 32 bit
64 bit to 32 bit [message #186020] Fri, 04 August 2006 14:44 Go to next message
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,
Re: 64 bit to 32 bit [message #186024 is a reply to message #186020] Fri, 04 August 2006 15:36 Go to previous messageGo to next message
BlackSwan
Messages: 25049
Registered: January 2009
Location: SoCal
Senior Member
export/import is one way.
Re: 64 bit to 32 bit [message #187022 is a reply to message #186024] Thu, 10 August 2006 09:52 Go to previous messageGo to next message
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,
Re: 64 bit to 32 bit [message #187950 is a reply to message #186024] Wed, 16 August 2006 07:55 Go to previous messageGo to next message
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?????
Re: 64 bit to 32 bit [message #188218 is a reply to message #187950] Thu, 17 August 2006 08:21 Go to previous messageGo to next message
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.
Re: 64 bit to 32 bit [message #188249 is a reply to message #186020] Thu, 17 August 2006 10:29 Go to previous message
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.
Previous Topic: column level VPD
Next Topic: how to resolve the error?
Goto Forum:
  


Current Time: Fri Dec 09 11:50:10 CST 2016

Total time taken to generate the page: 0.08995 seconds