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

About the Author Atul Kumar

Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Specialising in Design, Implement, and Trainings.

follow me on:

Leave a Comment:

6 comments
Ahmed Khan says March 9, 2009

Hi

I am getting the error in 11i (11.5.10) “JSP error” Java out of memory can any one help me.

regards
Ahmed

Reply
Atul Kumar says March 9, 2009

Restart apache , adapcctl.sh stop ; adapcctl.sh start

Reply
JP says April 3, 2010

Cannot reconnect to gateway

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

Reply
JP says April 3, 2010

Cannot reconnect to gateway

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

Reply
Jayaraj says October 4, 2016

Dear Mr. Atul,

thanks it worked for me. your document was really helpful….

but i would like to know, how it happened…

thanks,
Jayaraj

Reply
Add Your Reply

Not found