OraFAQ Forum: Forms » migration to 11g

Home » Developer & Programmer » Forms » migration to 11g (oracle forms& reports,11g,Linux64bit)

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

migration to 11g [message #524919]

Tue, 27 September 2011 08:05

rijo
Messages: 12
Registered: September 2011
Location: Noida

Junior Member

Dear Sir

I have created oracle forms&reports in 5i which is in oracle 8i database. I need to migrate the forms&reports as well as the database to oracle 11g andI need to run these in a 64 bit Linux 5.6. I kindly request you to please tell me the steps that i need to follow for migrating my 32bit(windows os made) forms and reports to Linux5.6 64 bit?

Report message to a moderator

Re: migration to 11g [message #524924 is a reply to message #524919]

Tue, 27 September 2011 08:58

Maaher
Messages: 7065
Registered: December 2001

Senior Member

You're moving to a web based environment so the first steps are:
- get your 11g database up and running.
- get your Weblogic Server (Oracle application server) up and running. You will need to compile all your forms/reports on this server.
- install Oracle Fusion Middleware 11g ( I think that is what Oracle calls it nowadays ), your Forms and Reports developer tools, on your client.

Once you've got that ready, you can start to migrate. But that's easier said than done. There are quite a few loopholes. For instance: code in PRE-FORM triggers might crash your Forms runtime process so you may want to clean your PRE-FORM as much as possible.

Good luck and feel free to come back if you have specific questions!

MHE

Report message to a moderator

Re: migration to 11g [message #524955 is a reply to message #524924]

Wed, 28 September 2011 00:44

rijo
Messages: 12
Registered: September 2011
Location: Noida

Junior Member

Sir

Thank you for your reply. But i need to know will there be any problem while migrating my 32bit(windows os made) forms and reports to Linux5.6 64 bit? This is what my exact query . The steps that you said was already applied. I just need To do this above migration to Linux 64bit. Please help me in this Sir..

With Regards

Rijo

Report message to a moderator

Re: migration to 11g [message #524987 is a reply to message #524955]

Wed, 28 September 2011 04:03

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Forget 32-bit/64-bit. That's not an issue here. Did you encounter problems?

I can give you some tips:
- Make sure you use proper casing (Initcap, UPPER, lower) in the names of your forms and libraries (both OLB and PLL) or the Linux compiler will fail to find the references.
- WHEN-NEW-FORM-INSTANCE triggers on block/item level won't work in 11g.
- PRE-FORM triggers (but I've mentioned that already in my previous reply).
- Be careful when using "synchronize": it causes a roundtrip from the client java applet to the application server. This might impact performance.

It's hard to tell because a lot of issues are specific to a particular version and might have been corrected now. Just do what we did:
- try to compile the form on your client.
- copy the FMB to the AS (weblogic server)
- compile the FMB on the Linux server
- test

MHE

Report message to a moderator

Re: migration to 11g [message #524994 is a reply to message #524987]

Wed, 28 September 2011 04:40

rijo
Messages: 12
Registered: September 2011
Location: Noida

Junior Member

Dear Sir

The tips you mentioned in your mail,it is helpful for successfully compiling the form&reports in 11g. But what i am asking is will there be any problem while migrating from 32bit to 64bit Linux. If any what are the steps should i have to follow?..

Thanking you in advance.

With Regards
Rijo

Report message to a moderator

Re: migration to 11g [message #524998 is a reply to message #524994]

Wed, 28 September 2011 04:49

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Forget 32bit/64bit. I said that before. You should be able to copy/move FMB files (which you have checked on your client 11g!) onto the Linux without any problem. Forms Compiler (whether it is 32 or 64 bit) should know how to handle it. Does that answer your question?

MHE

Report message to a moderator

Re: migration to 11g [message #525000 is a reply to message #524998]

Wed, 28 September 2011 05:18

rijo
Messages: 12
Registered: September 2011
Location: Noida

Junior Member

Hi MHE,

I had a previous experience in deploying forms and Reports on 64 bit box. There were few issues with 2 DLL's while running the reports.

That is why I am requesting if any such issues are there in migrating 32 bit windows based application into 64 bit Linux environment.

Further OLE components may cause another issue. So I need a complete list of such issues. If any such doc is available from oracle kindly share the same.

Thanks and Regards
Rijo

Report message to a moderator

Re: migration to 11g [message #525027 is a reply to message #525000]

Wed, 28 September 2011 06:58

Maaher
Messages: 7065
Registered: December 2001

Senior Member

DLL's? On a Linux box? I have no experience on migrating reports but isn't it just like Forms? I mean: copy the RDF files (not the precompiled REP files) to the Linux box and compile? As for OLE, you are right. You should move to Webutil or CLIENT_OLE (CLIENT_OLE2?). But perhaps Metalink can help out here.

MHE

Report message to a moderator

Re: migration to 11g [message #525029 is a reply to message #525027]

Wed, 28 September 2011 07:49

rijo
Messages: 12
Registered: September 2011
Location: Noida

Junior Member

Thank you for your reply . But i dont think that this can rectify my queries.. But still am very grateful to you.

With Regards
Rijo

Report message to a moderator

Re: migration to 11g [message #525042 is a reply to message #525029]

Wed, 28 September 2011 09:18

Maaher
Messages: 7065
Registered: December 2001

Senior Member

I'm sorry but without a specific question, I can't give you a specific answer. I know that Forms 11g no longer supports OS-specific item types like VBX, OLE, OCX, ... Perhaps this document can help?

I still have difficulties for the DLL problems you had because, well, Linux hasn't got the slightest idea what DLL's are.

MHE

Report message to a moderator

Previous Topic:	Form Abruptly Closing
Next Topic:	Summit office supply schema Forms 11g [merged 2]

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 07 13:03:48 CDT 2024