I am using Developer 6i and Oracle 11g all is happy.But some users have problems that when they open reports that is called from Forms ask for username,password and sid. I droped that faulty (these were good in 6i-8i) users and create again but problem is same.
I am using Developer 6i and Oracle 11g all is
happy.But some users have problems
That alone mean's that all is NOT happy :-)
Forms 6i is not certified with database 11g nor supported, even if you get it connected, no one guarantees it will work properly. and your problem is a simple example.
Best thing to do is to upgrade your Forms Application, or use Oracle 10g with Forms 6i R2 patch 18, this is a certified combination.
If you decide to upgrade your application, you should read what's in [url http://www.oracle.com/technology/products/forms/htdocs/upgrade/index.html]Forms Upgrade center there are very useful information, tips and resources.
We have spent a week pondering over why open_form(session) stopped working on upgrading to 11 database. Strangely, it seemed OK for users whose password had not been changed since the upgrade (indicated by password_version in DBA_USERS).
Do you know of any other nasty surprises to look out for ?