Quick Learn | FAQ's | Technical Solutions

Windows: C:\Users\> hostname ABCDE000123   C:\Users\> wmic bios get serialnumber SerialNumber ABCD123 C:\>  ipconfig/flushdns Linux/Unix: $ uname -a Linux oam-ohs 4.18.0-193.el8.x86_64 #1 SMP Fri Mar 27 14:35:58 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux   $ hostnamectl    Static hostname: oam-ohs          Icon name: computer-vm            Chassis: vm         Machine ID: adaf69d723c14f179ff541b6d37a350b            Boot ID: 6d090b2d2d104957a5ccfffe178b65ca     Virtualization: vmware   Operating System: Red Hat Enterprise Linux 8.2 (Ootpa)        CPE OS Name: cpe:/o:redhat:enterprise_linux:8.2:GA             Kernel: Linux 4.18.0-193.el8.x86_64       Architect...

Troubleshooting OIM - ORA Error: 1] Catalog search in OIM showing error when user is clicking on Request access Error: IAM-7130125 : Search token caused Oracle text DRG issue, DB exception is :ORA-29902: error in executing ODCIIndexStart() routine ORA-20000: Oracle Text error: ORA-30576: ConText Option dictionary loading error ORA-04031: unable to allocate 24368 bytes of shared memory ("shared pool","CAT_TAGS","KGLH0^eaf287a9","drdmlpo:new policy") 29902 Cause: The error message you provided indicates that there was an issue with Oracle Text and a failure occurred during the execution of the ODCIIndexStart() routine. Additionally, there was a problem with loading the ConText Option dictionary, and the shared pool memory allocation failed. The ORA-29902 error typically occurs when there is a problem with the Oracle Text index. It could be caused by a variety of factors such as incorrect syntax in the query, missing or invalid index metadata, or in...

Download the Open-JDK from below site: JDK-8: for OIM-12c https://adoptium.net/temurin/archive/?version=8 JDK-7: for OIM-11g https://jdk.java.net/java-se-ri/7 https://download.java.net/openjdk/jdk7u75/ri/jdk_ri-7u75-b13-linux-x64-18_dec_2014.tar.gz Updating existing JDK path in OIM installed directory: 1. First Stop the Admin, SOA and OIM server 2. Download the required JDK version from above mentioned URL. In below steps just replace the respective JDK paths as per environment like 11g(JDK-7) or 12c(JDK-8). 3. Identify the existing JDK path and version on VM by using below commands. $ whereis java java: /usr/bin/java /usr/java/jdk1.8.0_291-amd64/bin/java /usr/share/man/man1/java.1 $ which java /usr/java/jdk1.8.0_291-amd64/bin/java $ java -version java version "1.8.0_291" Java(TM) SE Runtime Environment (build 1.8.0_291-b10) Java HotSpot(TM) 64-Bit Server VM (build 25.291-b10, mixed mode) 4. Navigate to below oracle home path to cross check on exact JDK path: e.g. /ho...

Error stack: Getting below error stack during weblogic startup. Cause: INFO: oracle.iam.platform.auth.impl.DBStore : getConnection() : Problem in getting JDBC connection to OIM Schema :  JNDI subsystem is not ready for use <14 Mar, 2023 2:35:30,726 PM IST> <Critical> <Security> <BEA-090403> <Authentication for user weblogic denied.> <14 Mar, 2023 2:35:30,743 PM IST> <Critical> <WebLogicServer> <BEA-000386> <Server subsystem failed. Reason: A MultiException has 6 exceptions.  They are: 1. weblogic.security.SecurityInitializationException: Authentication for user weblogic denied. 2. java.lang.IllegalStateException: Unable to perform operation: post construct on weblogic.security.SecurityService 3. java.lang.IllegalArgumentException: While attempting to resolve the dependencies of weblogic.jndi.internal.RemoteNamingService errors were found 4. java.lang.IllegalStateException: Unable to perform operation: resolve on weblogi...

Please follow below steps to perform SVN to GIT/Bitbucket migration: Prerequisites: 1. Must have a RHEL-7 or higher Linux server available to perform the steps. 2. The location where you decide to create new directory as “ git_migration ” must have enough disk space to hold the final GIT repository. Check the actual source SVN repo size /root/git_migration 3. Must have installed these software/tools in server Min. JDK-8, SVN and GIT client Installation commands, if you have access to internet from Linux server and subscription is in place: yum install subversion yum install git yum install git-svn 4. Its assumes that your SVN repo uses standard directory convention as   trunk/tag/branches 5. You must have a Bitbucket/Git account created and new repository as “ mygit ” is ready to add a new repo code base. Atlassian scripts to download for basic sanity on prerequisite environment is proper or not: https://bitbucket.org/atlassian/svn-migration-scripts/downloads/ https:...

 Please perform below steps to reset the system administrator(xelsysadm) password in OIM 1. First check in database table, if user name is locked or not? if yes then you can run below query and commit update usr set usr_login_attempts_ctr=0 where usr_login='XELSYSADM'; update usr set usr_locked=0 where usr_login='XELSYSADM'; commit;   If this doesn't help, you can try below approach, this should work for sure.  OIM-11g steps: 1.Go to the below directory. Here path may change based on your server configuration. OIM-11g path  :  /home/oracle/Oracle/Middleware/Oracle_IDM1/server/bin 2.Open the oimadminpasswd_wls.properties file. 3.Update the following variables in the above property  oimadminpasswd_wls.properties file. Enter correct java home path as per your server configuration, May be its JDK 1.8 depend on OIM version # JAVA_HOME set it to jdk6 or later. # e.g.: JAVA_HOME=/opt/softwares/shiphome/jdk160_24 JAVA_HOME=/usr/java/jdk1.7.0_80 # COMMON_COMPONENT...

The oraInst.loc file specified is not valid. ./opatch lsinventory Oracle Interim Patch Installer version 12.2.0.1.13 Copyright (c) 2019, Oracle Corporation.  All rights reserved. Oracle Home       : /u01/app/oracle/product/12.1.0.2/home_1 Central Inventory : /home/oracle/oraInventory    from           : /u01/app/oracle/product/12.1.0.2/home_1/oraInst.loc OPatch version    : 12.2.0.1.13 OUI version       : 12.1.0.2.0 Log file location : /u01/app/oracle/product/12.1.0.2/home_1/cfgtoollogs/opatch/opatch2019-10-09_10-12-49AM_1.log LsInventorySession failed: OPatch failed to locate Central Inventory. Possible causes are:     The Central Inventory is corrupted     The oraInst.loc file specified is not valid. OPatch failed with error code 73 Troubleshooting Verify the content of $ORACLE_HOME/oraInst.loc cat /u01/app/oracle/product/12.1.0.2/home_1/oraInst.loc inventory_loc=/home/or...

# User master table, consist of firstname, lastname, email etc. select  * from spt_identity # Entitlement select * from spt_identity_entitlement # Roles select * from spt_bundle # Application table details like HR, Finance, PAM application etc. select * from  spt_application # Managed attributes details like type entitlement, group etc. select * from  spt_managed_attribute # Profiles related table select * from  spt_profile select * from  spt_profile_constraints select * from spt_bundle # Request manage access table select * from spt_identity_request_item # Access request table - with completion status, requester, approver etc. select * from  spt_identity_request # Plugin listing table select * from  spt_plugin # Password policies select * from  spt_password_policy # Capabilities select * from  spt_capability select * from  spt_capability_rights select * from  spt_capability_children # Request Details SQL SELECT  SPT_IDE...