2 Replies Latest reply: Nov 18, 2012 6:57 AM by Nishith Nayan RSS

    User database in OIM

    973714
      Is there an internal user database where OIM stores the user information- what is this database?
      Any info would be helpful.
        • 1. Re: User database in OIM
          Dhananjay Neeraj2
          Yes... The OIM uses an Internal Database...

          If it is OIM 11G R1 and R2, you can find the database information in the following location:-

          *$MIDDLEWARE_HOME/user_projects/domains/oimdomain/config/jdbc*

          In this jdbc folder, there are some xml files.. One of them in oimOperationsDB-0237-jdbc.xml

          Here you will find the following entries:-

          <jdbc-driver-params>
          <url> jdbc:oracle:thin:@oim.database.host.com:1521/oimdb </url>
          <driver-name>oracle.jdbc.xa.client.OracleXADataSource</driver-name>
          <properties>
          <property>
          <name>user</name>
          <value> DEV_OIM </value>
          </property>
          <property>
          <name>oracle.net.CONNECT_TIMEOUT</name>
          <value>10000</value>
          </property>
          </properties>
          *<password-encrypted>{AES}d2ersr32wer2r2rder2ncksnurr21uGWblbdB+/rcmgUk6F9iQI77JM8pK8owrtk=</password-encrypted>*
          </jdbc-driver-params>


          So there is one database on host machine oim.database.host.com, at port 1521... The SID is oimdb...

          And DEV_OIM is the name of the OIM Schema user...

          Consult your Database Administrator to obtain the decrypted value of the encrypted password..

          With these values you can use SQL Developer to connect to OIM Database...

          In this you will find USR table...

          In this table OIM stores the User Information you were looking for.


          --------------------------------------------------------------
          --------------------------------------------------------------

          And if it is OIM 9102,

          the xellerate/server/config/xlconfig.xml contains Database information:-

          <DirectDB>
                    <driver>oracle.jdbc.driver.OracleDriver</driver>
                    <url> jdbc:oracle:thin:@oim.database.host.com:1521:oimdb </url>
                    <username>oimdb</username>
                    <password encrypted="true">ZlsdyCP213ddr32r4xXWkZZ+A==</password>
                    <maxconnections>5</maxconnections>
                    <idletimeout>360</idletimeout>
                    <checkouttimeout>1200</checkouttimeout>
                    <maxcheckout>1000</maxcheckout>
               </DirectDB>
          • 2. Re: User database in OIM
            Nishith Nayan
            yes, All user information is being stored in Oracle database. there are multiple schema/user is being used for OIM 11g. However, DEV_OIM(default name for dev machine) is used for user information.

            Most of the data is stored under USR table under DEV_OIM user. In case of your env, you can approach to the admin team for db detail or yourself try to locate as mentioned by other poster.

            most of the user info are stored in a plain text but password and security question/answers are stored in encrypted format.