Tuesday, March 24, 2009

Cannot login from the personal homepage in 11i

Problem Scenario:
=================


when accessing through the Normal URL we cannot access the forms. But while we access forms directly through the dev60cgi/f60cgi URL we can access.

Normal URL :
http://oratest.doyensys.com:8000/
Forms Direct URL :
http://oratest.doyensys.com:8000/dev60cgi/f60cgi

Solution:
=========


1. Login Via Forms Direct URL and login as a system Admin responsibility.
2. Navigate to PROFILE --> system.
3. Query for %FORMS%LAUNCH% in the Profile and click Find.




4. You will find the Profile option name as ICX:Forms Launcher and the Value for site level is http://oratest.doyensys.com:8000/dev60cgi/f60cgi


5. If there is any other thing at responsibility level, Remove that. It should be at site level only.

Note : If you are using RAC Node, Then if the site level value is set to single Node then it wont works . For example your test Node has two apps node named
oraapptest1 and oraapptest2 but when it navigates it should be oratest as a instance name.
So, In site level if it is set to
http://oraapptest1.doyensys.com:8000/dev60cgi/f60cgi , Then it won't Launch the forms.
So that it will Automatically Navigates to Oraapptest1 or oraapptest2 Nodes.

Reference:
-------------
145019.1 - Database Login Failed" When Tying to Login From Personal Homepage


1 comment:

Unknown said...

I have also heard about another sql 2005 recovery application that repairs corrupted database files