| 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,
|
|
|
|
|
|
| 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,
|
|
|
|
|
|
|
|
| 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
