Hi all,I have to move an Oracle database from Windows 32 bit to Linux 64 bit (ie from 9i to 11g R2).The source database is in noarchivelog mode(NO RMAN) I am left with export option.I have planned to export the whole database dump from Windows (exp) and transfer the dump using winscp to Linux server. Startup / basic database is created @ destination (Linux machine).Then create schema's, tablespace (for schema's created) & import (imp)Need your suggestions as to what steps I have assumed are right or I need to look into other parameters, etc. To do it.Mohib.
How To Install Oracle 9i In Windows 7 64 Bit
1) why 1120x and not 12c?2) what specific version of 11g3) how big4) how many segment-owning schemas5) how many roles/profiles/grant-methods - this is important for 'prep'prep'1) pre-create object-owning schemas, roles, profiles etc and capture GRANTinfo2) pre-create tablespaces3) associate object-owning schemas with the tablespacesimport, gets stats, test1) do schema/schema imports one at a time, fix errors2) collect stats ala 11g3) run tests.most important.did it work 100%?no, drop DB and do it again. I'm with Alan: RMAN expects Oracle versions to be identical.If you have access to ORACLE binaries you can try the upgrade path, but you are pretty late for upgrading a version 9i.In my opinion exp/imp is the way to go. But don't do a full import into 11g too much has changed!When creating your 11g DB, be sure to set the compatibility startup parameter to your 9i version, otherwise strange behavior might happen, especially with sorting routines, hints, etc.Moreover, check for customized encrypted PL/SQL code, as this might not be compatible in 11g.Wish you a successful migration. Do you have root access to the linux machine?
Oracle 9i Download Filehippo
If you do, please run the following command./etc/rc.d/init.d/iptables status.It should result in the followingiptables: Firewall is not running.If firewall is running you can do the following to disable firewall.go to System Administration Firewall. and disable it.After this I would shutdown the Oracle and listener and any otherservice/process on the Linux box and rebootand check again to make sure that Firewall changes have survived being disabled. Hi rjngh2005 and Prathap Kattekola,Thanks for tips, actually I used 'trial & error' methods to get the solution.:PActually in out local servers I found out ALL 'ACCEPT' in 1 Linux server, then another had 2-3 'REJECT' but is working 101% fine. So I felt the above settings are not wrong.Anyways all I did was change HOST from IP address to 'hostname' it worked just fine.Although the TNSPING is not working as the IP address changes once I get remote, will update on this status once its set back into LAN(no internet connection ie no web access).Hopefully once the developers are able to connect to DB will move the DB dump from windows to Linux.Syed.