Home » Developer & Programmer » Forms » Oracle Forms 6i with Oracle DB 11g. Does it work? (Oracle Forms)
Oracle Forms 6i with Oracle DB 11g. Does it work? [message #663337] Tue, 30 May 2017 11:36 Go to next message
vnekkanti
Messages: 3
Registered: May 2017
Junior Member
We have a client who is looking to continue to use Forms 6i and want to migrate their DB from 8i to 11g. They want to use Forms 6i until they re-write in another technology.
Will that work? or Do you see any issues with this database upgrade?
Have you guys ever done this?

Please Suggest.

Thanks
Re: Oracle Forms 6i with Oracle DB 11g. Does it work? [message #663343 is a reply to message #663337] Tue, 30 May 2017 18:04 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Why upgrade from one unsupported DB version to another unsupported DB version?
Re: Oracle Forms 6i with Oracle DB 11g. Does it work? [message #663351 is a reply to message #663343] Wed, 31 May 2017 01:35 Go to previous messageGo to next message
vnekkanti
Messages: 3
Registered: May 2017
Junior Member
That is our client Requirement. They want to stick with Forms 6i until they re-write them in another technology in a year or so.
So we are exploring to see if their 6i application work with 11g database.

Thanks

[Updated on: Wed, 31 May 2017 02:14]

Report message to a moderator

Re: Oracle Forms 6i with Oracle DB 11g. Does it work? [message #663362 is a reply to message #663351] Wed, 31 May 2017 09:58 Go to previous messageGo to next message
Littlefoot
Messages: 21802
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
We've got an old Forms 6i application which now connects to 11gR2. It was my colleague who took care of it, but - as far as I can remember - he didn't have too much trouble to make it work. I believe that - if you just "let it be" (i.e. don't modify it) - it should work as usual.

There must be a certification matrix somewhere (Metalink?) which clearly states that so - search for it.
Re: Oracle Forms 6i with Oracle DB 11g. Does it work? [message #663367 is a reply to message #663362] Wed, 31 May 2017 12:27 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Forms6 was released last Century & preceded V11 DB by many years.
I serious doubt that OP has any support contract with Oracle Corp.
Re: Oracle Forms 6i with Oracle DB 11g. Does it work? [message #663368 is a reply to message #663351] Wed, 31 May 2017 13:13 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
vnekkanti wrote on Wed, 31 May 2017 02:35
That is our client Requirement. They want to stick with Forms 6i until they re-write them in another technology in a year or so.
If you are switching in a year or so, don't upgrade anything, because upgrading to another unsupported version doesn't gain you anything except some new features. Since you'll have to test that everything works the way you want for months, what is the point?
For example, 8i had the side effect of sorting results in group by order, but that is not the case in 10g and above, so any queries that "worked" before might not work the way you want them now.
Re: Oracle Forms 6i with Oracle DB 11g. Does it work? [message #663750 is a reply to message #663368] Thu, 15 June 2017 16:27 Go to previous messageGo to next message
Betaroot
Messages: 4
Registered: June 2017
Junior Member
I did it, on a test enviroment. I remember that you must to set up two things:


  1. Change the character set of your database
  2. Turn Off Case Sensitive Passwords on DB
If this helps, try it:
--Changing the CHARACTER SET
SHUTDOWN IMMEDIATE; 
STARTUP MOUNT; 
ALTER SYSTEM ENABLE RESTRICTED SESSION; 
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; 
ALTER SYSTEM SET AQ_TM_PROCESSES=0; 
ALTER DATABASE OPEN; 
ALTER DATABASE CHARACTER SET INTERNAL_USE UTF8; 
SHUTDOWN; 
STARTUP RESTRICT; 
SHUTDOWN; 
STARTUP; 

And this:
SQL> ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE;

I clarify that is not the best practice, but evaluate if it works to you without affecting anything else.
Re: Oracle Forms 6i with Oracle DB 11g. Does it work? [message #663752 is a reply to message #663750] Fri, 16 June 2017 00:33 Go to previous messageGo to next message
Michel Cadot
Messages: 68596
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

First post and this is b......t.
What do you think "INTERNAL_USE" mean?

NEVER EVER DO THAT.
The only result is to screw your database and lose it.


Re: Oracle Forms 6i with Oracle DB 11g. Does it work? [message #663754 is a reply to message #663752] Fri, 16 June 2017 01:13 Go to previous messageGo to next message
Betaroot
Messages: 4
Registered: June 2017
Junior Member
Nice answer for a "Senior Member" and the "account moderator". I'm really surprised, he is asking about "someone that has done this" and i'm sharing my experience.
Michael, have you ever done this?
Or just trying to be a cool guy that refuses things that never done before?

I answer the post, there is a way to do it, not the best one because its a test enviroment. But maybe you can tell us if there is a better way instead of refusing the one that i propose, that is still working.

Forms6i is running on Virtualbox, i have tested this on W7 64 bits version (there are two libraries required for sucess work of Forms6i runtime). The Database is 11G XE and its running on a W10 Workstation. It works, no problem at the moment.

[Updated on: Fri, 16 June 2017 01:15]

Report message to a moderator

Re: Oracle Forms 6i with Oracle DB 11g. Does it work? [message #663755 is a reply to message #663754] Fri, 16 June 2017 02:15 Go to previous message
Michel Cadot
Messages: 68596
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Tell me what is the relation between the title and your answer?

I remark you didn't answer my previous question.
Maybe you will answer this one.

The fact I didn't give a solution to OP (as I am not skilled for this) doesn't imply I can't estimate the value of your post.
I maintain my opinion on it.

Previous Topic: Adding rows dynamically to the tabular view
Next Topic: how to reset all values in item without loop in oracle forms
Goto Forum:
  


Current Time: Thu Feb 22 06:19:08 CST 2024