Monday, February 1, 2010

FRM-92020: Failed to connect to the Server: /forms/Iservlet-1

Hi All,

The "FRM-92020: Failed to connect to the Server: /forms/Iservlet-1" very common error message when trying to connect to application from "Internet Explorer 8" we can avoid this error through below mentioned solution.

1. The permanent solution is to be apply patches.

2. If we are not able to get the patches or unable to apply then use the following short workaround.

Workaround:
Open Internet Explorer
---------------->> go to "Tools" menu
------------------------------->> go to "Internet Options"
--------------------------------------->> choose "Security" tab
------------------------------------------->>click on "Custom Level"
------------------------------------------------>>disable "xss filter"
--------------------------------------------------->> click on "ok".

through the above workaround you can able to open "form" without any error message.

Thanks

Saturday, January 30, 2010

Changing SYSADMIN default password

Hi All,

This article is about "Reset of SYSADMIN password".

Steps:
1. Keep all the services running.
Do not shutdown appsTier Or dbTier application

2. Login to OS level via applmgr manager user
Login to application server via Operating System User.

3. Run environment scripts
a. cd $APPL_TOP
run APPLORA.env
$ . ./APPLORA.env

b. cd admin (folder)
run adovars.env
$. ./adovars.env

c. cd $FND_TOP/bin (folder)
run FNDCPASS to change the SYSADMIN password
(IMPORTANT: Change ONLY the SYSADMIN password)

eg:
FNDCPASS apps/apps 0 Y system/manager USER SYSADMIN {new password}

4. Restart the Apache,Forms,Reports, Listener & Concurrent Manager services
In short: Restart the dbTier Or appsTier services.

5. To test, login into the application as the SYSADMIN user and the new password.

6. Verify that a concurrent program such as Active Users runs.
eg: Login to application user and run the any concurrent reports.

Thanks

Friday, January 29, 2010

Changing APPS Schema Password

Hi All,

Yesterday i changed my Production box APPS (Default Password).

I want to share the step which i used for changing APPS Schema password.

1. Shutdown Application Servcies
$INST_TOP/admin/scripts/adstpall.sh

2. using FNDCPASS utility change the APPS schema password
login to APPLMGR user.
eg:
FNDCPASS [logon] 0 Y [system/password] SYSTEM [username] [new_password]

$FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS NEWPASS

NOTE: here i am changing the APPS Schema Default Password (Default password of apps schema is "apps" & default password of SYSTEM (ORACLE USER) is "manager")

Whenever we change the APPS schema password then APPLSYS password will also change by system. APPS or APPLSYS are same user.

3. run "adautocfg.sh" on dbTier as well as appsTier with NEW PASSWORD
3.1 logon on dbTier
$ORACLE_HOME/appsutil/admin/[SID_HOSTNAME]/adautocfg.sh apps/newpass

3.2 logon on appsTier
$INST_TOP/admin/scripts/adautocfg.sh apps/newpass

4. start APPLICATION services and login to application with new password.

5. In case of any doubt or query feel free to ask or mail @ star_taj @ yahoo. com