Informix 11.7 db migration to oracle 12c RAC database

Hi Team, I am planning to migrate my current informix 11.7 database to oracle 12c database RAC. Could you please help me out to start this migration. Kindly note, i am very new to informix database. Thanks, Srinivas. ------------------------------ Srinivasarao K ------------------------------ #Informix

Sorry but I personnally will never help for such a migration. I cannot help someone to migrate to a worse solution Eric ------------------------------ [eric] [Vercelletto] [] [Founder] [kandooerp.org] [Pont l'Abbé] [France] [+33 626 52 50 68] Disclaimer: My own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. ------------------------------

Srinivasarao: Welcome to the Informix Community! So sad that you are migrating away! Depending on the specific data types in your current schema this may either be trivial or very hard. Oracle does not have direct support for some Informix types. If your Informix schema includes some of those, then you may have to massage the data quite a bit. We can help if you run into anything that isn't obvious. IBM used to have a White Paper on migrating the other way, from Oracle to Informix. That might have some hints for you about what you will have to do if you can find a copy. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.

Oh, forgot two things: 1 - You may find that Oracle does not perform as well as Informix for many workloads. 2 - Might we know why your are migrating away from Informix? Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.

Probably better off asking in a 'Orrible forum

Hi Srinivas, you and your client will be happy, if yo learn Informix and forgot the O things. ------------------------------ Henri Cujass leolo IT, CTO Germany ------------------------------

Henri: you said in a nice way what I told in a bad and almost rude way: I see no advantage in spending (lots of) time and money to migrate from informix to Oxxcle, to have at the end a more costly solution in terms of hardware and staffing, all on a product that is probably not as fast, flexible and robust as Informix, and a good number of years behind in terms of technology. And migrating to another database is always a big risk, mainly because who made the decision won't assume any responsibility when problems and delays arise, the migration team will immediately designated as responsible for the trouble :-) But hey, cowboys don't fear anything as long as they are far away in case of problems :-) ------------------------------ [eric] [Vercelletto] [] [Founder] [kandooerp.org] [Pont l'Abbé] [France] [+33 626 52 50 68] Disclaimer: My own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. ------------------------------

Hi Srini, Just from my personal experience. I was also an Oracle guy, but when I started working on Informix, my love for Informix started increasing. And today I never think of going back to oracle. I find commands are very user friendly and very short with all the details you are looking for in one command by just remembering the flags... There are many differences I have seen in Informix as compare to oracle which are very cool. Later I migrated many customers from Oracle to Informix and even they all were happy till date. They have seen performance improvement by 20-30% in Informix. Believe me, you will regret if you have moved to oracle. Don't think I am just trying to stop one user. But as per my exp I have seen the difference. So it would be good if you start learning Informix. You can go for some training like Informix sysadmin and DBA and see the amount you can save for your company. ------------------------------ Gaurav Kumar ------------------------------

Hi Guys, Thank you one and all for your reply. Hope guys are having different mind here from my question. Just i am curious to get some details about informix database but no luck here. Kindly note, we need multiple db's now to manage data. Either by type of data, cost of licence, need for archive data to store etc... And many.. No need to stick into one db. Once again thank you so much for your support!! Thanks, Srinivas

And BTW, in this group, you just have access to all the Informix gurus on this planet. Cheers Eric Eric Vercelletto Data Management Architect and Owner / Begooden IT Consulting Board of Directors, International Informix Users group IBM Champion 2013,2014,2015,2016,2017,2018,2019,2020 Tel: +33(0) 298 51 3210 Mob : +33(0)626 52 50 68 skype: begooden-it Google Hangout: eric.vercelletto@begooden-it.com Email: eric.vercelletto@begooden-it.com www : http://www.vercelletto.com www https://kandooerp.org

Srinivas: So, I think that we all got off on the wrong foot or two. Let's start again. I think that it would be good if you asked specific questions and we will give you answers. You asked how to migrate your Informix data to Oracle. Obviously few of us, as Informix fanatics, have done that, but I at least did give you some sense that it may be trivial or may be hard depending on how dependent on Informix specific data your database is. Beyond that, what do you need/want to know? Informix is a very easy to use RDBMS and the latest releases (currently v14.10FC4W1) is highly extensible and very capable. Informix is probably the fastest OLTP engine on the planet. It is also very easy to administer (Walmart maintains over 20,000 Informix instances with fewer than 10 DBAs, The Home Depot is similar). SO, ask specific questions and we will gladly answer. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.

Hi Art, I am trying to start informix database stuff for administration. Could any one please let me know where n how can start. I have experienced on oracle, postgreSQL, Vertica db's.. Can I relates my knowledge with informix and get it in less time. Thanks Srinivas

Srinivas: This link: https://docs.oracle.com/cd/B10501_01/win.920/a97251/ch2.htm#:~:text=Informix%20Dynamic%20Server%20users%20are,authentication%2C%20usually%20through%20the%20database. is an Oracle doc page that describes some differences between the two systems. Obviously it is Oracle centric and pushes Oracle's way of doing things as superior. As obviously we in the Informix community have different opinions. However, I provide the link because at the bottom of the page is a list of terms in both and how they correspond. Here also is a link to the IBM Redbook that I mentioned (OK it's not a white paper) about migrating from Oracle to Informix: https://www.redbooks.ibm.com/redbooks/pdfs/sg247730.pdf Here are the most important Informix administration tools listed. All of these tools will report their usage if you run them with -? and most if run with no arguments as well: oninit - the engine process and what you run to start up an Informix instance. onmode - the Informix instance management utility. onmode -ky to shutdown the instance for example. onstat - Informix server status reporting tool with hundreds of reporting options. oncheck - check or report on the internal consistency of an Informix instance's data structures on disk. Capable of some repairs as well. ontape - the simpler of Informix's two archiving utilities. onbar - a more powerful archiving utility that works with any XBSA compliant backup system. A simple one, PSA, is supplied with Informix and configured by default. archecker - archive validation tool. Also capable of partially restoring data from an archive. dbaccess - Informix query tool. dbschema - Informix schema reporting tool. cdr - replication management tool for Enterprise Replication and related technologies like distributed/sharded tables, post commit triggers, etc. Another resource you can avail yourself of is training. Informix basic DBA training and Advanced Informix Performance Tuning training is available from Advanced DataTools Corp. an IBM partner (full disclosure: I co-teach the Advanced course with Lester Knutsen, ADTC's President). www.advancedatatools.com The Informix online documentation is at this link: https://www.ibm.com/support/knowledgecenter/SSGU8G_14.1.0/com.ibm.welcome.doc/welcome.htm I hope this helps. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.

Many thanks for your info Art. Thanks Srinivas