Monthly Archives: January 2012

Install OIA 11.1.1.5.0 on Linux

Official link :  http://docs.oracle.com/cd/E24179_01/doc.1111/e23378/PreparingtoInstallOracleIdentityAnalytics.htm#CIHICFCD

install weblogic 10.3.5 , Orace DB 11gR2,

Configure Weblogic 

configure a weblogic domain , OIA will be deployed on Managed Server

 

 

Leave the setting for Admin as default , and create a Manager server for OIA , set the port to 7003

 

create a machine , set the address to be the value of the machine hostname

assign Admin and Managed Server to the machine created above

then  wait for weblogic to finish.

edit setDomainEnv.sh located at /u01/app/oracle/product/fmw/user_projects/domains/base_domain/bin

locate the variable “WLS_MEM_ARGS_64BIT=”-Xms512m -Xmx512m” ” . note that I used JRokect so make sure you find the right place

change the value to  “WLS_MEM_ARGS_64BIT=”-Xmx2048m -Xms2048m” ” , save and exit

Add the following JVM option to enforce the IPv4 preference over IPv6:

-Djava.net.preferIPv4Stack=true  ( you can set it via weblogic admin server, firstly start up admin server and set the value for oia_server1)

Server->oia_server1-> startup -> Arguments

 

Configure System and OIA binaries  

edit ~/.bashrc , export  RBACX_HOME=/u01/app/oracle/product/oia

unzip oia_install_package.zip -d /u01/app/oracle/product/oia  

Copy the import and export folders (located in the sample folder) to $RBACX_HOME. The import and export folders should be at the same level as conf.indexes, and reports 

 Download Third Party Libs

There are Third Party Libs that OIA relies on

Oracle JDBC Driver , ojdbc5.jar if JDK v1.5 , ojdbc6.jar if JDK 1.6

http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html

jasper-jdt.jar

http://tomcat.apache.org/dev/dist/m2-repository/org/apache/tomcat/jasper-jdt/6.0.18/

or

http://dlc.sun.com/rolemanager/Certification_And_Reporting/

The CloverETL Library

http://download.berlios.de/cloveretl/cloverETL.rel-1-8-1.zip

The jxl-2.5.9.jar File

http://www.andykhan.com/jexcelapi/

The Web Services Description Language for Java Toolkit (WSDL4J)

http://sourceforge.net/projects/wsdl4j/files/WSDL4J/1.6.1/

after download do the following steps :

create the CloverETL JAR file.

Before You Begin – You will need the unzip utility and at least a Java 5 JDK.

  1. Create a working directory named files and then open the directory:mkdir filescd files
  2. Check the integrity of the .zip file and then expand it:unzip -tq ../cloverETL.rel-1-8-1.zipunzip -q ../cloverETL.rel-1-8-1.zip
  3. Remove the log4j.properties file to prevent a file conflict in OIA:rm log4j.properties
  4. Go to the parent directory:cd ..
  5. Create the JAR manifest input file clover.mf, which consists of these lines:
    Implementation-Version: 1.8.1
    Implementation-Title: jETeL/Clover
    Implementation-URL:http://download.berlios.de/cloveretl/cloverETL.rel-1-8-1.zip
    Implementation-Vendor-Id: org.jetel
  6. Create the JAR file:jar cmf clover.mf cloverETL-1.8.1.jar -C files .
  7. Copy the cloverETL-1.8.1.jar file to the OIA_LIB folder.   // note : this is the official process , however i didn’t follow it as i couldn’t get jar command to run successfully due some weird invalid header error , but since that this is just a jar file , we should be able to use it straight away by putting it in the classpath

 

For WSDL4J Jar files

Download the wsdl4j-bin-1.6.1.zip file from this site:

http://sourceforge.net/projects/wsdl4j/files/WSDL4J/1.6.1/

Next, follow these steps to extract the wsdl4j.jar file and copy it to the OIA_LIB
folder.

Extract the wsdl4j.jar file:

Copy the JAR file to the OIA_LIB folder and rename it to include the version
number:
mv wsdl4j-1_6_1/lib/wsdl4j.jar $OIA_LIB/wsdl4j.jar

again above is the exact copy of the words, however i didn’t follow it , just extrac the wsdl4j.jar file and put it in OIA_LIB folder

Ok , should be right to go further

create a folder

put lib files above to a folder /u01/app/oracle/product/oia/oia_libs

export OIA_LIB=/u01/app/oracle/product/oia/oia_libs

 

DataBase Schema prepare 

really long post hm ~~~ , now it’s time to configure DB.

Note: the ORACLE_SID here is set to ORCL which is kind of standard Oracle SID

SQLPLUS sys/password as system

create user rbacxservice identified by password ;

invoke SQL Script : @/u01/app/oracle/product/oia/db/oracle//u01/app/oracle/product/oia/db/oracle/rbacx-11.1.1.5.0_oracle_schema.sql

wait until script finishes.

Now verify the schema  via DB em , note you must start it using emctl start dbconsole before you can access

Configure Oracle Identity Analytics for Standalone Deployment

Now let’s go configure OIA

Create OIA Back up

mkdir oia_backup
cp rbacx.war oia_backup/.

Create an rbacx_staging folder under $RBACX_HOME

mkdir rbacx_staging

cd rbacx_staging

jar -xvf ../rbacx.war

cd rbacx_staging/WEB-INF

 

create a logs folder /u01/app/oracle/product/oia/logs

edit log4j.properties

update  log4j.appender.file.file=/u01/app/oracle/product/oia/logs /rbacx.log

edit jasper.properties

it seesm like there isn’t a such file under under the WEB-INFO folder , so we need to create one and add the line to the file

net.sf.jasperreports.compiler.classpath=/u01/app/oracle/product/oia/rbacx_staging/WEB-INF/lib/jasperreports-2.0.5-javaflow.jar

In a text editor, open WEB-INF/etl-context.xml and uncomment the etlManager bean definition.

In a text editor, open WEB-INF/iam-context.xml and uncomment the etlManager bean reference in the property list of the file bean definition

Copy thrid party libs to rbacx_staging/WEB-INF/lib/.

there are steps in regards to how to configure multi-instances OIA in same subnet, however the steps are not listed here as it’s a single server deployment

we can enable WebService in OIA if we need to later .

If you are using OIA Web Services, uncomment its configuration.
See the API Guide for Oracle Identity Analytics, “Enabling Web Services.”

cd /opt/Oracle/OIA_Install/rbacx_staging
jar cvfM ../rbacx.war .

cp conf/oracle/jdbc.properties conf/.

set jdbc.url=jdbc:oracle:thin:@localhost:1521:orcl  //set the value according to the real environment

add  jdbc.password=YourClearTextDatabasePassword

Invoke following command

java -jar ../rbacx_staging/WEB-INF/lib/vaau-commons-crypt.jar -encryptProperty -cipherKeyProperties ./cipherKey.properties -propertyFile ./jdbc.properties -propertyName jdbc.password

remove staging folder

rm -rf rbacx_staging

edit iam.properties

replace $RBAC_HOME with /u01/app/oracle/product/oia

Deploying on WebLogic

need to extract to a staging folder first ( don’t know why it was deleted in  previous step )

mkdir rbacx_staging

cd rbacx_staging

jar xvf ../rbacx.war

Startup Admin Server and browse to Admin console

  1. In a browser log in to the WebLogic administrative console:http://Hostname:Port-Number/console/login/LoginForm.jsp
  2. Click Deployments, located under Domain Structure.
  3. Click Install, located in the main panel under Deployments.The Install Application Assistant opens.
  4. On the Locate Deployment To Install And Prepare For Deployment page, navigate to the rbacx_staging directory created in step two and select the folder such that it lists the contents of rbacx.war.
  5. Select the rbacx_staging directory and click Next.
  6. Select the Install This Deployment As An Application option and  choose  oia_server1 as app server to be deployed on,  click Next.
  7. On the Optional Settings page, do the following:
    1. Ensure that the deployment is named rbacx.
    2. Under Security, select DDOnly: Use Only Roles And Policies That Are Defined In This Deployment.
    3. Under Source Accessibility, select Use The Defaults Defined By The Deployment’s Targets.
    4. Click Next.
  8. On the Review Your Choices And Click Finish page, click Yes, Take Me to the Deployments Configuration Screen.Click Finish.
  9. On the Settings for rbacx page, click Save.
  10. Click Deployments in the left panel.The Summary of Deployments panel opens.

A status of Active indicates that Oracle Identity Analytics has been successfully deployed.

 

Now log on OIA as rbacxadmin and default password : password to verify OIA function normally