10 Replies Latest reply: Jan 26, 2013 12:39 PM by Kevin Pinsky RSS

    how to delete a DBUM connector cloned - OIM 11g R1 ?

    DianaOrd
      Hi,
      I have a DBUM connector cloned, sometimes the cloning process wasn't successfully and now i have to delete the wrong cloned connectors .
      Looking for information i found how to delete a connector, but this is for the big connector and i need when is a cloned connector.

      any idea?
      thank you.!
        • 1. Re: how to delete a DBUM connector cloned - OIM 11g R1 ?
          BikashBagaria
          Check the Connector Uninstall utility or you can look inside the oracle.iam.connectormgmt.uninstall.ConnectorUninstall class.

          -Bikash
          • 2. Re: how to delete a DBUM connector cloned - OIM 11g R1 ?
            DianaOrd
            hi, where i can find this .class??

            thank you.!
            • 3. Re: how to delete a DBUM connector cloned - OIM 11g R1 ?
              DianaOrd
              i found this .class,
              But now in a virtual Machine i could delete the dbum connector cloned.
              But when i tried to do the same in a production ambient , OIM show me this error:

              25 Jan 2013 15:43:09 DEBUG Stored Procedure Call= {call XL_PKG_RemoveObject.XL_SP_RemoveRO(?,?)}
              25 Jan 2013 15:43:11 DEBUG Exiting the deleteResource method of UninstallUtility
              25 Jan 2013 15:43:11 DEBUG Messsage Returned by the SP: null

              any idea???
              • 4. Re: how to delete a DBUM connector cloned - OIM 11g R1 ?
                Rajiv Dewan
                These are just DEBUG statements not ERRORS.
                • 5. Re: how to delete a DBUM connector cloned - OIM 11g R1 ?
                  DianaOrd
                  thank you.
                  But why this is happening ? .. i couldn't remove the connector clonned in my production ambient.

                  ... and i dont understand why...
                  • 6. Re: how to delete a DBUM connector cloned - OIM 11g R1 ?
                    Rajiv Dewan
                    Paste the error logs. These statements are like simple SOP which don't tell anything.
                    • 7. Re: how to delete a DBUM connector cloned - OIM 11g R1 ?
                      DianaOrd
                      25 Jan 2013 15:41:42 DEBUG Logger Initialized
                      25 Jan 2013 15:41:42 DEBUG Exiting Method: validateAndInitiazeLogger of Class: ConnectorUninstall
                      25 Jan 2013 15:41:42 DEBUG Exiting Method: loadPropertyFileAndLogger of Class: ConnectorUninstall
                      25 Jan 2013 15:41:42 DEBUG Start of ConnectorUninstall Utility.
                      25 Jan 2013 15:41:42 DEBUG Entering Method: getDBPassword of Class: ConnectorUninstall
                      25 Jan 2013 15:41:48 DEBUG Exiting Method: getDBPassword of Class: ConnectorUninstall
                      25 Jan 2013 15:41:48 DEBUG Entering Method: getOIMAdminUserName of Class: ConnectorUninstall
                      25 Jan 2013 15:41:51 DEBUG Exiting Method: getOIMAdminUserName of Class: ConnectorUninstall
                      25 Jan 2013 15:41:51 DEBUG Entering Method: getOIMAdminPassword of Class: ConnectorUninstall
                      25 Jan 2013 15:41:55 DEBUG Exiting Method: getOIMAdminPassword of Class: ConnectorUninstall
                      25 Jan 2013 15:41:55 DEBUG Entering Method: getOIMServerT3URL of Class: ConnectorUninstall
                      25 Jan 2013 15:42:02 DEBUG Exiting Method: getOIMServerT3URL of Class: ConnectorUninstall
                      25 Jan 2013 15:42:02 DEBUG Entering Constructor of Class: UninstallUtility.
                      25 Jan 2013 15:42:02 DEBUG Validating Properties File..
                      25 Jan 2013 15:42:02 DEBUG Entering Method: validateAndPopulateDBAndConnectorParameters of Class: UninstallUtility
                      25 Jan 2013 15:42:02 DEBUG Exiting Method: validateAndPopulateDBAndConnectorParameters of Class: UninstallUtility
                      25 Jan 2013 15:42:02 DEBUG Valdiation Succeeded.. All the properties have been loaded.
                      25 Jan 2013 15:42:02 DEBUG Getting the Database Connection
                      25 Jan 2013 15:42:02 DEBUG Entering Method: getDatabaseConnection of Class: UninstallUtility
                      25 Jan 2013 15:42:02 DEBUG jdbc:oracle:thin:@192.168.12.57:1521:ban26
                      25 Jan 2013 15:42:16 DEBUG Connection established
                      25 Jan 2013 15:42:16 DEBUG Exiting Method: getDatabaseConnection of Class: UninstallUtility
                      25 Jan 2013 15:42:16 DEBUG Setting the OIMClient
                      25 Jan 2013 15:42:16 DEBUG Entering Method: setOIMClient of Class: UninstallUtility
                      25 Jan 2013 15:42:25 DEBUG Exiting Method: setOIMClient of Class: UninstallUtility
                      25 Jan 2013 15:42:25 DEBUG Successful in setting the OIMClient
                      25 Jan 2013 15:42:25 DEBUG Exiting Constructor of Class: UninstallUtility.
                      25 Jan 2013 15:42:25 DEBUG Entering Method: doObjectDeletion of Class: ConnectorUninstall
                      25 Jan 2013 15:42:32 DEBUG Entering Method: validateObjectDeletion of Class: UninstallUtility
                      25 Jan 2013 15:42:32 DEBUG Exiting Method: validateObjectDeletion of Class: UninstallUtility
                      25 Jan 2013 15:42:32 DEBUG Entering Method: getTokens of Class: ConnectorUninstall
                      25 Jan 2013 15:42:32 DEBUG Exiting Method: getTokens of Class: ConnectorUninstall
                      25 Jan 2013 15:42:32 DEBUG Entering the getROList method of UninstallUtility
                      25 Jan 2013 15:42:33 DEBUG List of Resource object fetched from database: [Oracle DB User, Oracle DB Trusted, AD Group, AD Organizational Unit, AD User, AD User Trusted, UNIX User Trusted, UNIX User, TB_BAN23_SIC_GTC, iPlanet Organisation Unit, iPlanet User, iPlanet Group, iPlanet Role, RSA Auth Manager Token, RSA Auth Manager User, Xellerate User, Xellerate Organization, Installation, Oracle DB User 1, Oracle DB Trusted 1, TB_BAN24_SUB_GTC, TB_BAN24_AUR_GTC, TB_BANE_AURO_GTC, TB_BAN24_CUD2_GTC, TB_PRUBAN24_GTC, OracleBAN26, Oracle DB Trusted ban26, OracleBAN23, Oracle DB23 Trusted, OracleSICBan23, OracleBAN25jano, Oracle DB Trusted mfnsys DCV, Oracle DB Trusted Usu Esp Bane, TB_BAN23_JAN_GTC, TB_BAN23_MAS_GTC, TB_BAN23_SEC_EXT_GTC, TB_BAN23_SECE_GTC, TB_BAN24_CUD_GTC, TB_BANE_AUR2_GTC, TB_SIPEC_GTC, TBBAN24_CUD_ESP_GTC, TBBAN25_AUR_ESP_GTC, TBBAN23_AUR_ESP_GTC, TBBANE_SISEC_ESP_GTC, TB_MFNSYS_DCV_4_GTC, TB_MFNSYS_DCV_5_GTC, OracleBANE, OracleBAN23Sic, Oracle DB Trusted Ban23 SIC, OracleBAN24cud, Oracle DB Trusted ban25 JANO, OracleBANEsisec, Oracle DB Trusted bane SISEC, Usu Esp OracleBAN25, Oracle DB Trusted Usu Esp Ban25, Oracle DB Trusted Usu Esp Ban26, SPRU1A Trusted, SPRU1A User, TB_BAN23_AURA_GTC, TB_BAN25_AUR_GTC, TB_BAN25_SIM_GTC, TB_BANE_AUR_GTC, TB_BANE_SIS_GTC, TB_BAN26_MAS_GTC, TB_BANE_SISEC_GTC, TB_BANE_SIS_2_GTC, TB_MFNSYS_DCV_2_GTC, TB_MFNSYS_DCV_3_GTC, TBBAN24_AUR_ESP_GTC, TBBANE_AUR_ESP_GTC, TBBAN25_JANO_ESP_GTC, TBBAN26_MAS_ESP_GTC, TBBAN23_SIC_ESP_GTC, TBBAN24_CUD_ESP_2_GTC, Oracle_Ban27, Oracle_Ban27_Trusted, OracleBAN24, Oracle DB24 Trusted, OracleBAN25, Oracle DB25 Trusted, OracleBAN27, Oracle DB27 Trusted, Oracle DBBANE Trusted, Oracle DBMFNSYS Trusted, Oracle DB Trusted SIC Ban23, OracleBAN23praxis, Oracle DB Trusted Ban23 PRAXIS, Oracle DB Trusted ban24 CUD, OracleBAN26master, Oracle DB Trusted ban26 MASTER, OracleMFNSYSdcv, Usu Esp OracleBAN23, Usu Esp OracleBAN24, Oracle DB Trusted Usu Esp Ban24, Usu Esp OracleBAN26, Usu Esp OracleBANE, TB_BAN23_AUR_GTC, TB_BAN25_SMV_GTC, TB_BAN25_JAN_GTC, TB_BAN26_AUR_GTC, TB_BANE_UPLO_GTC, TB_BANE_UPDU_GTC, TB_BAN26_MAS_2_GTC, TB_PRUEBA_C_GTC_GTC, TB_MFNSYS_DCV_GTC, TB_BAN25_SMV_2_GTC, TB_BAN27_IDMUSER_GTC, TB_ACH_CENIT_GTC, TBBAN26_AUR_ESP_GTC, TBBAN24_CUD_ESP_3_GTC, TB_MFNSYS_DCV_6_GTC, Oracle DB User ban24, Oracle DB Trusted ban24, Usuario BD ban23, Oracle DB Trusted ban23, OracleMFNSYS, Oracle UsuEspDB23 Trusted, SUCED USUARIOS_GTC, SUCED USUAUTORIZADOS_GTC]
                      25 Jan 2013 15:42:33 DEBUG Exiting the getROList method of UninstallUtility
                      25 Jan 2013 15:42:33 DEBUG Entering Method: doResourceObjectDeletion of Class: ConnectorUninstall
                      25 Jan 2013 15:42:33 DEBUG Entering Method: checkAccessPolicies of Class: UninstallUtility
                      25 Jan 2013 15:42:33 DEBUG Checking the access policy related to the resource object(s): [OracleBAN25jano]
                      25 Jan 2013 15:42:33 DEBUG Exiting Method: checkAccessPolicies of Class: UninstallUtility
                      25 Jan 2013 15:42:33 DEBUG There are no Access Policies Associated with the Resource
                      25 Jan 2013 15:42:33 DEBUG Closing all the Requests Associated with the Resource
                      25 Jan 2013 15:42:33 DEBUG Entering Method: closeRequest of Class: UninstallUtility
                      25 Jan 2013 15:42:33 DEBUG Getting the RequestService Handler
                      25 Jan 2013 15:42:33 DEBUG Entering Method: getRequestService of Class: UninstallUtility
                      25 Jan 2013 15:42:33 DEBUG Exiting Method: getRequestService of Class: UninstallUtility
                      25 Jan 2013 15:42:33 DEBUG Successful in getting the RequestService Handler
                      25 Jan 2013 15:42:33 DEBUG Prepared Statement that would be executed : select distinct(request_beneficiary_entities.rbe_request_key) from request_beneficiary_entities request_beneficiary_entities, obj obj, request request, request_beneficiary request_beneficiary where request_beneficiary_entities.rbe_entity_type='Resource' and request_beneficiary_entities.RBE_ENTITY_KEY = obj.obj_key and obj.obj_name=? and request.REQUEST_KEY = request_beneficiary.REQUEST_KEY and request_beneficiary.REQUEST_KEY = request_beneficiary_entities.rbe_request_key and request_beneficiary.BENEFICIARY_KEY = request_beneficiary_entities.RBE_BENEFICIARY_KEY and request.REQUEST_STATUS not in ('Operation Initiated', 'Template Approval Rejected', 'Request Approval Rejected', 'Operation Approval Rejected', 'Request Closed', 'Request Withdrawn', 'Request Completed', 'Request Failed', 'Request Partially Failed', 'Operation Completed', 'Post Operation Processing Initiated', 'Request Completed with Errors')
                      25 Jan 2013 15:42:33 DEBUG Executing the Prepared Statement for the ResourceObject: OracleBAN25jano
                      25 Jan 2013 15:42:35 DEBUG Successfully executed the Prepared Statement for the ResourceObject: OracleBAN25jano
                      25 Jan 2013 15:42:35 DEBUG Exiting Method: closeRequest of Class: UninstallUtility
                      25 Jan 2013 15:42:35 DEBUG Entering Method: checkAndPrintRequestTemplate of Class: UninstallUtility
                      25 Jan 2013 15:42:35 DEBUG Prepared Statement that would be executed : select distinct(request.REQUEST_TEMPLATE_NAME) from request_beneficiary_entities request_beneficiary_entities, obj obj, request request, request_beneficiary request_beneficiary where request_beneficiary_entities.rbe_entity_type='Resource' and request_beneficiary_entities.RBE_ENTITY_KEY = obj.obj_key and obj.obj_name=? and request.REQUEST_KEY = request_beneficiary.REQUEST_KEY and request_beneficiary.BENEFICIARY_KEY = request_beneficiary_entities.RBE_BENEFICIARY_KEY
                      25 Jan 2013 15:42:35 DEBUG Executing the Prepared Statement for the ResourceObject: OracleBAN25jano
                      25 Jan 2013 15:42:35 DEBUG Successfully executed the Prepared Statement for the ResourceObject: OracleBAN25jano
                      25 Jan 2013 15:42:35 DEBUG Exiting Method: checkAndPrintRequestTemplate of Class: UninstallUtility
                      25 Jan 2013 15:42:35 DEBUG Proceeding for the Deletion...
                      25 Jan 2013 15:42:35 DEBUG =====================================================================
                      25 Jan 2013 15:42:35 DEBUG Invoking Object Deletion:
                      25 Jan 2013 15:42:35 DEBUG =====================================================================
                      25 Jan 2013 15:42:35 DEBUG Entering the deleteResource method of UninstallUtility
                      25 Jan 2013 15:42:35 DEBUG Entering the removeDeletedResourceObject method of UninstallUtility
                      25 Jan 2013 15:42:35 DEBUG Exiting the removeDeletedResourceObject method of UninstallUtility
                      25 Jan 2013 15:42:35 DEBUG List of resource object selected for deletion: [OracleBAN25jano]
                      25 Jan 2013 15:42:35 DEBUG Entering Method: checkAndPrintAttestationTask of Class: UninstallUtility
                      25 Jan 2013 15:42:35 DEBUG Prepared Statement that would be executed : SELECT DISTINCT apd.apd_name FROM apd,atr,apt,atd,oiu,obi,obj WHERE apd.apd_key = atr.apd_key AND atr.atr_key = apt.atr_key AND apt.apt_key = atd.apt_key AND atd.oiu_key = oiu.oiu_key AND oiu.obi_key = obi.obi_key AND obi.obj_key = obj.obj_key AND obj.obj_name = ?
                      25 Jan 2013 15:42:35 DEBUG Executing the Prepared Statement for the ResourceObject: OracleBAN25jano
                      25 Jan 2013 15:42:35 DEBUG Successfully executed the Prepared Statement for the ResourceObject: OracleBAN25jano
                      25 Jan 2013 15:42:35 DEBUG Exiting Method: checkAndPrintAttestationTask of Class: UninstallUtility
                      25 Jan 2013 15:42:35 DEBUG Entering Method: deleteReconciliationData of Class: UninstallUtility
                      25 Jan 2013 15:42:35 DEBUG Getting ReconConfigService instance.
                      25 Jan 2013 15:42:35 DEBUG Successful in getting ReconConfigService instance.
                      25 Jan 2013 15:42:35 DEBUG Deleting the reconciliation profile for the resource object: OracleBAN25jano
                      25 Jan 2013 15:43:09 DEBUG Deleted the reconciliation profile for the resource object: OracleBAN25jano
                      25 Jan 2013 15:43:09 DEBUG Exiting Method: deleteReconciliationData of Class: UninstallUtility
                      25 Jan 2013 15:43:09 DEBUG Stored Procedure Call= {call XL_PKG_RemoveObject.XL_SP_RemoveRO(?,?)}
                      25 Jan 2013 15:43:11 DEBUG Exiting the deleteResource method of UninstallUtility
                      25 Jan 2013 15:43:11 DEBUG Messsage Returned by the SP: null
                      • 8. Re: how to delete a DBUM connector cloned - OIM 11g R1 ?
                        DianaOrd
                        this is the log

                        Thnk you
                        • 9. Re: how to delete a DBUM connector cloned - OIM 11g R1 ?
                          Rajiv Dewan
                          In this logs everything worked fine but at the last point it returns Null. It seems that Error handling is not properly done. You can raise an SR with Oracle.

                          And enable Database logs XELLERATE.DATABASE and capture those logs. You may see some exception there.
                          • 10. Re: how to delete a DBUM connector cloned - OIM 11g R1 ?
                            Kevin Pinsky
                            Did you not read this in the documentation?

                            WARNING:
                            Do not use this utility in production. This utility deletes data from the Oracle Identity Manager database directly and is meant to be used in development/staging environments.

                            -Kevin