Amazon books

Friday, April 30, 2010

Blank page when trying to access forms on Oracle Applications

--Blank page when trying to access forms on Oracle Applications

Steps to reproduce the problem:
1-Login to Oracle Applications
2-Go to any Responsibility
3-Try to access any form and nothing happens
4-If you try to start or stop forms (adfrmctl.sh) or reports (adrepctl.sh), errors like these one are displayed.

#######################################################################

Executing service control script:
/u01/app/r11i/r11comn/admin/scripts/hmlr11_surucucu/adrepctl.sh start
script returned:
****************************************************

You are running adrepctl.sh version 115.33

Cannot reconnect to gateway

Cause: Application Object Library is unable to reconnect to your gateway ORACLE account after you unsuccessfully attempted to sign-on.

Action: Check that your gateway environment variable is set correctly.
starting Reports Server for hmlr11 on port 7070.
Cannot reconnect to gateway

Cause: Application Object Library is unable to reconnect to your gateway ORACLE account after you unsuccessfully attempted to sign-on.

Action: Check that your gateway environment variable is set correctly.

adrepctl.sh: exiting with status 0


.end std out.

.end err out.

#######################################################################
The first thing to check is if GUEST account is working fine using the SQL command below:

SQL> select fnd_web_sec.validate_login('GUEST','GUEST') from dual;

FND_WEB_SEC.VALIDATE_LOGIN('GUEST','GUEST')
--------------------------------------------------------------------------------
N


As you note, GUEST LOGIN is not working. Check the GUEST password in file $FND_TOP/secure/hostname_SID.dbc
# grep -i GUEST_USER_PWD /u01/app/r11i/r11appl/fnd/11.5.0/secure/surucucu_hmlr11.dbc

Check the GUEST user and password on your CONTEXT_FILE:
# grep guest $CONTEXT_FILE
GUEST
ORACLE

After checking and changing everything, run autoconfig.
cd $COMMON_TOP/admin/scripts/SID_hostname
./adautocfg.sh


Try to access your forms again.

Best Regards,
Paulo Portugal

No comments:

Post a Comment