Skip to main content

SSO Registration Fails With Error: Unable to open Simple (No SSL) connection with Infra DB Host

Issue:

 SSO registration fails with the following error:

*** ERROR : Unable to open Simple(No SSL) connection with Infra DB Host. : <IP address>
[Root exception is java.net.ConnectException: Connection refused]

The txkSetSSOReg_.xml log file shows:

'Failed to get NON SSL LDAP Connection using :<IP address>:<port number>'
...
'javax.naming.CommunicationException: : <IP address>:<port number>
[Root exception is java.net.ConnectException: Connection refused]'
...
'oracle.apps.fnd.txk.ias.SsoOidException: Unable to open Simple(No SSL) connection with Infra DB Host. : 
[Root exception is java.net.ConnectException: Connection refused]'
Cause:

 The host where Oracle iAS Infrastructure database is installed (infradbhost) is different 
that the one where OID is implemented (ldaphost).

In interactive mode the SetSSOReg script set default value of ldaphost as infradbhost
however in some cases Infrastruture database and OID can be on different servers hence ldaphost is different than infradbhost.
Solution:

 $FND_TOP/bin/txkrun.pl \
-script=SetSSOReg \
-registerinstance=yes \
-infradbhost=<infra host name> \
-ldapport=<port number> \
-ldapportssl=<port number> \
-ldaphost=<ldap host name> \
-oidadminuser=cn=orcladmin \
-oidadminuserpass=<orcladmin password> \
-appspass=<apps password>


In non interactive mode it is possible to set different values for infradbhost and ldaphost parameters.
Labels:

Comments

Post a Comment

Popular posts from this blog

Node id does not exist for the current application server id

Issue: After completing cloning procedure, you generally may across the following issue. "Node id does not exist for the current application server id". Solution: First stop the application. Run adgendbc.sh script to configure apps tier dbc file with the correct id from the database instance. Start the application and test your issue. Location of script: 11i: $COMMON_TOP/admin/install/$CONTEXT_NAME R12: $INST_TOP/admin/install [appldev@erptest install]$ sh adgendbc.sh (Note: It will prompt you to give apps username and apps password.)
Post a Comment
Read more

How to change EBS R12 database and application port number

On Database Tier 1. Logon as oracle database user and source environment for R12 RDBMS ORACLE_HOME 2. Start database instance for which you want to change R12 port 3. Backup contextfile 4. Change as below in contextfile         dbport  : Change database port from 1521 to 1541         db_ons_localport : 6300 to 6320         db_ons_remoteport : 6400 to 6420         cmanport : 1521 to 1541 5. Run adautocfg.sh On Apps Tier Change Application port from 8000 to 8020 1. Logon as application manager user and source environment for R12 2. Backup contextfile 3. Run adpreclone    $ perl ./adpreclone.pl appsTier 4. Run adcfgclone and choose new port pool    $ cd $COMMON_TOP/clone/bin    $ perl ./adcfgclone.pl appsTier 5. Check new application URL SQL> select home_url from icx_parameters; HOME_URL ----------...
Post a Comment
Read more

Oracle R12 : You are trying to access a page that is no longer active

Login fails “You are trying to access a page that is no longer active.” The issue can be reproduced at will with the following steps: Issue : After cloning process the login page of Oracle E-Business Suite R12 show the above error. Solution :  For this you need to update the new hostname in the  icx_parameteres table 1.   SQL> SELECT SESSION_COOKIE_DOMAIN FROM icx_parameters; SESSION_COOKIE_DOMAIN --------------------- erp.local.com (This is hostname of Source Application Tier) 2. SQL>update icx_parameters set SESSION_COOKIE_DOMAIN = ‘target.local.com’; 1 row updated. SQL> commit; Commit complete. (This has changed the SESSION_COOKIE_DOMAIN of target application to target hostname.domain_name) 3. SQL> SELECT SESSION_COOKIE_DOMAIN FROM icx_parameters; SESSION_COOKIE_DOMAIN --------------------- target.local.com
Post a Comment
Read more