Oracle Apps 11i Deregistration /Registration with 10giAS RAC enabled Repository

Recently we converted single instance OID repository to RAC (2 instance) node. We performed following activity to register Oracle apps 11i to RAC enabled SSO (OID) repository.

1. Get TNS Entry from from SSO enabled OID repository (RAC) server

   JAISSOD =

   (DESCRIPTION =

   (ADDRESS_LIST =

   (ADDRESS = (PROTOCOL = TCP)(HOST = jai10901vip.orbit.org)(PORT = 1510))

   (ADDRESS = (PROTOCOL = TCP)(HOST = jai12101vip.orbit.org)(PORT = 1510)))

   (CONNECT_DATA =

   (SERVICE_NAME = JAISSOD))

   )

2. Ask Unix Admin to add SSO vip host expression in /etc/hosts file on all EBS server node. e.g. JAID1 (jai0504e).

   10.11.61.12     jai10901vip.orbit.org jai10901vip     # POCR WEB 1 BCD0109; JAISSOD - Single Sign On Dev

   10.11.61.13     jai12101vip.orbit.org jai12101vip     # POCR WEB 2 BCD0207; JAISSOD - Single Sign On Dev

3. Login to Applications and source A (JAID1)
4. Deregister SSO and OID as given below

   Deregister SSO

   $ txkrun.pl -script=SetSSOReg \

   > -registersso=Yes \

   > OTOCOL=TCP)(HOST=jai12101vip.orbit.org)(PORT=1510)))(CONNECT_DATA=(SERVICE_NAME=JAISSOD)))" \ <

   > -appspass=dr1veapp \

   > -orassopass=N16FKR0g \

   > -systempass=dr1veapp \

   > -ssosdkpass=ssosdk

   *** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS

   *** Log File = /opt01/app/oracle/jaid1comn/rgf/JAID1_jai0504e/sso/txkSetSSOReg_Thu_Oct_22_15_42_08_2009.log

   Program : /opt01/app/jaid1appl/fnd/11.5.0/patch/115/bin/txkSetSSOReg.pl started @ Thu Oct 22 15:42:08 2009

    

   *** Log File = /opt01/app/oracle/jaid1comn/rgf/JAID1_jai0504e/sso/txkSetSSOReg_Thu_Oct_22_15_42_08_2009.log

    

   ######################## WARNING ########################################

   This application works with SSOSDK version 9.0.2 or higher. If lower version

   (3.0.9) of SSOSDK was installed in your system and you have a registered

   partner application, this process will remove the 3.0.9 version of the SSOSDK

   schema and install the 9.0.2 version.

   ######################## WARNING ########################################

   Beginning input parameter validation for SSO registration.

   Beginning loading SSO SDK into database if necessary.

   Loading of SSO SDK into database is not required.

   Input parameter validation for SSO registration completed.

    

   BEGIN SSO REGISTRATION:

    

   Beginning to register partner application.

   Partner application has been registered successfully.

   Single Sign-On partner application registered successfully.

    

   End of /opt01/app/jaid1appl/fnd/11.5.0/patch/115/bin/txkSetSSOReg.pl : No Errors encountered

    

   Deregister OID

   $ txkrun.pl -script=SetSSOReg \

   > -deregisteroid=Yes \

   > -appspass=dr1veapp

   Checking preferences in the database.

   Enter the Oracle Internet Directory Administrator (orcladmin) Bind password ? ssotirisqa123

   *** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS

   *** Log File = /opt01/app/oracle/jaid1comn/rgf/JAID1_jai0504e/sso/txkSetSSOReg_Thu_Oct_22_15_12_27_2009.log

   Program : /opt01/app/jaid1appl/fnd/11.5.0/patch/115/bin/txkSetSSOReg.pl started @ Thu Oct 22 15:12:48 2009

    

   *** Log File = /opt01/app/oracle/jaid1comn/rgf/JAID1_jai0504e/sso/txkSetSSOReg_Thu_Oct_22_15_12_27_2009.log

    

   Beginning input parameter validation for OID de-registration.

   Following is the number of user subscriptions found to be deleted : 264

    

   ******************************** WARNING **********************************

    

   For better performance it is advisable to use bulk delete utility as

   described in Oracle Internet Directory Administrator's Guide, before

   continuing with the de-registration.

   This script will delete the subscriptions one at a time. Depending upon number of

   subscriptions, this action might take a long time but you can watch the progress

   in the log file in another terminal window.

    

   ******************************** WARNING **********************************

    

   Do you want to continue <Y/N> ? Y

   Input parameters validation for OID de-registration completed.

    

   BEGIN OID DE-REGISTRATION:

    

   No dangling provisioning profiles found.

   Beginning to delete provisioning profile for this application.

   Provisioning profile for this application has been deleted successfully.

   Following is the number of user subscriptions found to be deleted : 264

    

   USER SUBSCRIPTION DELETE LOG FILE : /opt01/app/oracle/jaid1comn/rgf/JAID1_jai0504e/sso/usrDelSubs_Thu_Oct_22_15_12_27_2009.out

   All user subscriptions have been deleted successfully.

   Beginning to de-register this application from Oracle Internet Directory.

   This application has been de-registered successfully from Oracle Internet Directory.

   End of /opt01/app/jaid1appl/fnd/11.5.0/patch/115/bin/txkSetSSOReg.pl : No Errors encountered

   [orairid1@jai0504e] /staging/patches/apps/SSO

5. Nullify applsys.fnd_user.user_guid column with null.

   create table apps.fnd_user_bkp as select * from apps.fnd_user;

   update apps.fnd_user set user_guid=null where user_name not in

   (

   'APPSMGR',

   'AUTOINSTALL',

   'CR_SCHEDULER',

   'GUEST',

   'IBE_GUEST',

   'IRISLDMON',

   'PORTAL30',

   'PORTAL30_SSO',

   'RAP_ADMINISTRATOR',

   'SYSADMIN',

   'IBE_ADMIN',

   'IEXADMIN',

   'IRC_EMP_GUEST',

   'IRC_EXT_GUEST',

   'OP_CUST_CARE_ADMIN',

   'OP_SYSADMIN',

   'SYSADMIN',

   'WIZARD',

   'ANONYMOUS',

   'AUTOINSTALL',

   'CONCURRENT MANAGER',

   )

   /

   Sql>commit;

    

6. Register SSO, OID. In SSO you need to specify "-infraconnst" as given below

   Register SSO

   txkrun.pl -script=SetSSOReg \

   -registersso=Yes \

   -infraconnstr="(DESCRIPTION=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jai10901vip.orbit.org)(PORT=1510))(ADDRESS=(PROTOCOL=TCP)(HOST=jai12101vip.orbit.org)(PORT=1510)))(CONNECT_DATA=(SERVICE_NAME=JAISSOD)))" \

   -appspass=dr1veapp \

   -orassopass=N16FKR0g \

   -systempass=dr1veapp \

   -ssosdkpass=ssosdk

    

   $ txkrun.pl -script=SetSSOReg \

   > -registersso=Yes \

   > OTOCOL=TCP)(HOST=jai12101vip.orbit.org)(PORT=1510)))(CONNECT_DATA=(SERVICE_NAME=JAISSOD)))" \ <

   > -appspass=dr1veapp \

   > -orassopass=N16FKR0g \

   > -systempass=dr1veapp \

   > -ssosdkpass=ssosdk

   *** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS

   *** Log File = /opt01/app/oracle/jaid1comn/rgf/JAID1_jai0504e/sso/txkSetSSOReg_Thu_Oct_22_15_42_08_2009.log

   Program : /opt01/app/jaid1appl/fnd/11.5.0/patch/115/bin/txkSetSSOReg.pl started @ Thu Oct 22 15:42:08 2009

    

   *** Log File = /opt01/app/oracle/jaid1comn/rgf/JAID1_jai0504e/sso/txkSetSSOReg_Thu_Oct_22_15_42_08_2009.log

    

   ######################## WARNING ########################################

   This application works with SSOSDK version 9.0.2 or higher. If lower version

   (3.0.9) of SSOSDK was installed in your system and you have a registered

   partner application, this process will remove the 3.0.9 version of the SSOSDK

   schema and install the 9.0.2 version.

   ######################## WARNING ########################################

   Beginning input parameter validation for SSO registration.

   Beginning loading SSO SDK into database if necessary.

   Loading of SSO SDK into database is not required.

   Input parameter validation for SSO registration completed.

    

   BEGIN SSO REGISTRATION:

    

   Beginning to register partner application.

   Partner application has been registered successfully.

   Single Sign-On partner application registered successfully.

    

   End of /opt01/app/jaid1appl/fnd/11.5.0/patch/115/bin/txkSetSSOReg.pl : No Errors encountered

    

   Register OID

   txkrun.pl -script=SetSSOReg \

   -provtmp=$FND_TOP/admin/template/ProvOIDToApps.tmp \

   -registeroid=Yes \

   -appspass=dr1veapp \

   -infradbhost=ssod.orbit.org \

   -orcladminpass=ssodpoc123 \

   -instpass=dr1veapp \

   -ldapport=3030 \

   -appname="JAID1_jai0504e" \

   -svcname="JAID1_jai0504e"

    

   $ txkrun.pl -script=SetSSOReg \

   > -provtmp=$FND_TOP/admin/template/ProvOIDToApps.tmp \

   > -registeroid=Yes \

   > -appspass=dr1veapp \

   > -infradbhost=ssod.orbit.org \

   > -orcladminpass=ssodpoc123 \

   > -instpass=dr1veapp \

   > -ldapport=3030 \

   > -appname="JAID1_jai0504e" \

   > -svcname="JAID1_jai0504e"

   *** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS

   *** Log File = /opt01/app/oracle/jaid1comn/rgf/JAID1_jai0504e/sso/txkSetSSOReg_Thu_Oct_22_16_19_22_2009.log

   Program : /opt01/app/jaid1appl/fnd/11.5.0/patch/115/bin/txkSetSSOReg.pl started @ Thu Oct 22 16:19:22 2009

    

   *** Log File = /opt01/app/oracle/jaid1comn/rgf/JAID1_jai0504e/sso/txkSetSSOReg_Thu_Oct_22_16_19_22_2009.log

    

   Beginning input parameter validation for OID registration.

   Input parameters validation for OID registration completed.

    

   BEGIN OID REGISTRATION:

    

   Beginning to register Application and Service containers if necessary.

   Application and Service containers were found and thus not created.

   Beginning to register application in Oracle Internet Directory.

   Registration of application in Oracle Internet Directory completed successfully.

   Beginning to register instance password in Oracle Internet Directory.

   Registration of instance password in Oracle Internet Directory completed successfully.

   Beginning to test application registration in Oracle Internet Directory.

   Testing of application registration in Oracle Internet Directory completed successfully.

   Beginning to register provisioning profile in Oracle Internet Directory.

   Registration of provisioning profile in Oracle Internet Directory completed successfully.

   Application is now registered successfully with provisioning in Oracle Internet Directory.

   End of /opt01/app/jaid1appl/fnd/11.5.0/patch/115/bin/txkSetSSOReg.pl : No Errors encountered

   [orairid1@jai0504e] /home/orairid1

7. Check logs generated using deregistration and registration
8. Start Applications Services
9. Try to login to applications. It should login without asking USERID and password.