Search This Blog

Thursday, September 30, 2010

Installation of Oracle Identity Analytics 11g


1.      What is OIA?

3.      For Oracle Identity Analytics Installation :
Details:
a.      Java JDK 1.6.0_21 (http://java.sun.com/javase/downloads/)
b.       Tomcat Application Server6.0.29 (http://tomcat.apache.org/download-70.cgi)
c.       MySQL 5.1 Database (http://dev.mysql.com/downloads/mysql/)
4.      Installation Startup :
·        JAVA SETUP
1.      Install Java JDK on your machine
2.      Set   PATH in your environment variables
PATH=%JAVA_HOME%;%PATH%;C:\Windows;C:\Windows\system32;C:\Program Files\Java\jdk1.6.0_21\bin
3.      Set  JAVA_HOME = C:\Program Files\Java\jdk1.6.0_21
4.      Go to Command Prompt and java –version to verify everything is correct.
·         APPLICATION  SERVER SETUP (TOMCAT)
1.      Unzip Tomcat. Unzip tomcat-6.0.28-preconfigured.zip into your C/D/E drive.
2.      E.g. Location is : E:\apache-tomcat-6.0.29
3.      Set CLASSPATH in your environment variables
CLASSPATH = .;C:\apache-tomcat-6.0.29\lib\servlet-api.jar;C:\apache-tomcat-6.0.29\lib\jsp-api.jar;C:\apache-tomcat-6.0.29\lib\el-api.jar;C:\Servlets+JSP;..;..\..
4.      Test the Server: Go to E:\apache-tomcat-6.0.29\bin and click on startup –Serve r should be started.
5.      Check  http://localhost:8080

·         SETUP MYSQL  DATABASE
1.      Download the installation setup from the link provided above.
2.      Typical Setup
3.      Skip Sign-Up
4.      Make sure "Configure the MySQL Server now" is checked
5.      "Detailed Configuration"
6.      "Developer Machine"
7.      "Multifunctional Database"
8.      "InnoDB Tablespace Settings" - leave everything default
9.      "Decision Support (DSS)/OLAP"
10.   Make sure "Enable TCP/IP Networking" is checked and leave the port number at 3306 (at this point, if you have a firewall, it will usually try to access itself on the localhost)
Leave "Enable Strict Mode" checked
11.  "Standard Character Set"
12.  Check "Install as Windows Service" and I would recommend leaving "Launch the MySQL Server automatically" checked.
13.  Enter a root password (and remember/write it down) and I would recommend leaving "Enable root access from remote machines" unchecked
14.  Then hit "execute" and it'll install and set it up.

·         SETUP   ORACLE  IDENTITY ANALYTICS
1. Create a folder E:\OIA and copy the download installation from the link above and extract it. It should look like below:
db
sample
conf
reports
legal
rbacx.war




2. This will be your RBACX_HOME, set the environment variable.


                       3. From sample folder, copy import and export directories and paste it to RBACX_HOME.
4. Setup database for OIA, use the schema script from RBACX_HOME\db folder.
For e.g. to load schema on mySQL database, use script named rbacx11.1.1.3.0_mysql_schema.sql
Go to mySQL folder on your drive through command prompt.


5.      mysql> \.rbacx-11.1.1.3.0_mysql_schema.sql
6.      Go to RBACX_HOME\conf folder and copy jdbc.properties from folder of name of your db to conf folder.
For e.g in case of mysql, copy jdbc.properties file from RBACX_HOME\conf\mysql folder and paste it to conf folder.Edit this properties file as per your database details. For instance, in case of mysql, replace $SERVER_NAME with host name of your database and port with 3306 (default for mysql)

7.      Edit iam.properties  file in RBACX_HOME\conf folder by replacing $RBACX_HOME with path of RBACX_HOME (so for our eg. it will be E:/OIA)

Extract rbacx.war from RBACX_HOME into temp folder.(e.g. C:\temp) [What we will do is to make some changes, add couple of jars and repack it again and deploy on server]
Now navigate to C:\temp\WEB-INF directory and edit below entry in log4j.properties file
log4j.appender.file.file=logs/rbacx.log (default)
log4j.appender.file.file=E:/OIA/logs/rbacx.log
8.      Similarly make changes to conf-context.xml file in C:\temp\WEB-INF folder. Replace $RBACX_HOME with path of RBACX_HOME
            9.  Copy below jars to C:\temp\WEB-INF\lib folder
1. jasper-jdt.jar (http://dlc.sun.com/rolemanager/Certification_And_Reporting)
2. jdbc driver for your database(mysql drivers are already included in lib folder so no need to add them ) For Oracle it would be ojdbc5.jar or ojdbc6.jar
3. Jars for the connectivity of the provisioning server, you will integrate with OIA.
(If OIM is provisioning server then get jars from ext and lib folder of your OIM_HOME)
(They are also available at http://dlc.sun.com/rolemanager/Provisioning_Server_Connectivity/)

10: Pack the folder C:\temp
C:\> cd C:\temp
C:\> jar -cvfm rbacx.war .

Step12: Use this war to deploy on your application server. Copy rbacx.war in WebApps folder of Tomcat and start the server.
Start the server and access the console using url


Default user name is rbacxadmin and password is password.
 







6 comments:

  1. While creating the schema in MySql I am getting this error. I have not modified the sql in anyway. What's wrong with the syntax?

    ERROR 1064 (42000) at line 73: You have an error in your SQL syntax; check the m
    anual that corresponds to your MySQL server version for the right syntax to use
    near 'maxvalue varchar (512) ,
    defaultvalue varchar (512) ,
    minlength int ,
    maxlength ' at line 9

    ReplyDelete
    Replies
    1. Include those columns in double quotes(") or ` .

      Delete
  2. Hi, I'm aready installed.
    with Tomcat 6.0.32 + MySql 5.0.27.
    MySQL was work fine..

    When i restart tomcat and it try to deploy rbacx.war, but can not connect to db..

    11:09:21,671 ERROR [ContextLoader] Context initialization failed

    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'messageSource' defined in ServletContext resource [/WEB-INF/application-context.xml]: BeanPostProcessor before instantiation of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'DataSourceAdvisor' defined in ServletContext resource [/WEB-INF/dataaccess-context.xml]:
    .....

    org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'springNonTxDataSource.quartzSchedulerFactoryBeanTarget': java.sql.SQLException: Connections could not be acquired from the underlying database!
    .....

    Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.

    ReplyDelete
  3. Thanks for the post.It is more informative and explained in a detailed manner.

    Oracle Applications

    ReplyDelete
  4. When I try to login I'm getting the following error and the login fails:


    11:33:09,730 ERROR [SqlMapRbacxUserDao] org.springframework.jdbc.BadSqlGrammarException: SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
    --- The error occurred in com/vaau/rbacx/security/dao/ibatis/maps/RbacxUser.xml.
    --- The error occurred while applying a result map.
    --- Check the RbacxUser.rbacxUserResult.
    --- Check the result mapping for the 'ssoUserID' property.
    --- Cause: java.sql.SQLException: Column 'SSO_USERID' not found.

    ReplyDelete
  5. Is there any way to assign OIA user as a role owner? because whenever role membership workflow executes it always assign membership approval task to rabacxadmin or OIA user with access control permissions.

    And one more thing even if I assign Role owner as a OIM User when roles pushed to OIM from OIA — role owner always reflected as a system administrator. Is the way OIA behaves?

    ReplyDelete