OraFAQ Forum: Forms » Oracle Forms 6i with Oracle DB 11g. Does it work?

Home » Developer & Programmer » Forms » Oracle Forms 6i with Oracle DB 11g. Does it work? (Oracle Forms)

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

Oracle Forms 6i with Oracle DB 11g. Does it work? [message #663337]

Tue, 30 May 2017 11:36

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

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Why upgrade from one unsupported DB version to another unsupported DB version?

Report message to a moderator

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

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

Littlefoot
Messages: 21823
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.

Report message to a moderator

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

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.

Report message to a moderator

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

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.

Report message to a moderator

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

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:

Change the character set of your database
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.

Report message to a moderator

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

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

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

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

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 02:20:36 CST 2025