Application Object Library is unable to reconnect to your gateway ORACLE account
While starting Apache (Web Server) in E-Business Suite 11i using “adapcctl.sh start“, I got below error message
***********
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.
***********
My first attempt was to check in metalink where I found note “413529.1 Apache adstrtal.sh adstpal.sh Scripts Give Cannot Reconnect To Gateway With Wrong Apps Username or Password“.
I was using “adapcctl.sh start” (No apps password, I don’t remember ever using apps password with Apache) so Metalink Note 413529.1 was not good hit.
My next suspect was GSM (Generic Service Manager – 210062.1 ) so started looking in to adapcctl.sh ($OAD_TOP/ admin/ scripts/ $CONTEXT_NAME) and realized that culprit was FNDSVCRG .
FNDSVCRG : is executable under $FND_TOP/bin introduced as part of seeded GSM services and provides improved coordination between the GSM monitoring of services (like Apache) and their command-line control scripts (like adapcctl.sh)
FNDSVCRG uses dbc file in $FND_SECURE to connect to database using GUEST account. Entry in dbc file was wrong and quick fix was to run AutoConfig (More on Autoconfig Here) to regenerate dbc file.
.
Workaround
If for some reason you do not want to run Autoconfig then remove FNDSVCRG and start Apache.
mv $FND_TOP/bin/FNDSVCRG $FND_TOP/bin/FNDSVCRG.bak
.
Entry in adapcctl.sh
if test “$control_code” = “start”; then
pre_command=”PRESTART”
post_command=”POSTSTART”
sh -c ‘. $ORA_TOP/8.0.6/$SID_$hostname.env; $FND_TOP/bin/FNDSVCRG $pre_command APACHE $HOST $Apaceh_Port’
svcrg_code=$?
sh -c ‘. $ORA_TOP/8.0.6/$SID_$hostname.env; $FND_TOP/bin/FNDSVCRG $post_command APACHE $HOST $Apaceh_Port’
svcrg_code=$?
.
References
- 413529.1 Apache adstrtal.sh adstpal.sh Scripts Give “Cannot Reconnect To Gateway” With Wrong Apps Username or Password
- 210062.1 Generic Service Management (GSM) in Oracle Applications 11i