OBIA installation part-7(Post installation steps,Errors & Solutions)

Post Installation steps After configuration of OBIA

Install ODI on client machine say in  (windows) machine

Note

• On the Select Installation Type screen, select Developer Installation as the installation type and both options under Developer Installation, that is, ODI Studio (with local agent) and ODI SDK.
• On the Repository Configuration screen, select the Skip Repository Configuration option.

1. We have to copy 2 files (1.cwallet.sso and 2. jps-config-jse.xml) from sever to ODI client machine.

The 2 files are located in the server are

MW_HOME/user_projects/domains/bifoundation_domain/odi-client-config/embedded

In our case 2 files are located in” /opt/oica/user_projects/domains/bifoundation_domain/odi-client-config/embedded”

Under this directory copy “1.cwallet.sso, 2.jps-config-jse.xml” and paste in

Client machine under “ODI_HOME/oracledi/client/odi/bin”

In our case it is “/opt/oica/Oracle_ODI/oracledi/client/odi/bin”

Now cwallet.sso and .jps-config-jse.xml also located in “/opt/oica/Oracle_ODI/oracledi/client/odi/bin” in the client ODI machine/system/node.

2. In the client ODI machine we have to a edit a file, located in

“ODI_HOME/oracledi/client/odi/bin/odi.conf”

In our case “Oracle_ODI/oracledi/client/odi/bin/odi.conf”

Edit odi.conf file add/modify following parameter.

·         AddVMOption -Doracle.security.jps.config=./jps-config-jse.xml

And save the file.

Connecting
to ODI studio in client Machine(in our case windows 8 machine)

Click on ODI studio icon 





 

   

It will open 





Click on ODI tab (top 5th tab) beside search tab
then click on connect





Click on connect



Step2:

The following Oracle
Data Integrator login window will open.





If you are first time login click on Add
button(green + button)/ click on edit button next to green plus button.

Then Repository
connection widow will open.

Then we have to enter our credentials
Then click on ok.
It will open Oracle Data Integrator login.

Then click on ok button

Then ODI initialization open window opens.

After ODI initialization it open

Step3:

Then the following screen will opens.

Now we can say that ODI client is connect to with ODI server, we can do our work.

 


Errors & WARNINGS
Database Installation


Oracle Database 11.2.0.2 is not compatible with
Oracle Enterprise Linux(OEL) 6.X

Where 11.2.0.2 is is compatible with 5.X
Note:On OEL 6.X 
we can install Oracle Database of 11.2.0.3 or higher version












RCU
Installation(11.1.1.7.0)

Even though respective package of “libXrender.so “ installed .Try to update to the  latest version of “libXrender.so “ package and  your error will be solved  and you can continue with the installation.

In linux you can update respective package as follows

If your logged in as super user/root user # prompt will be seen otherwise $ prompt for other than root user.

# yum install <packagename>

Ex:#yum install libXrender-0.9.8-2.1.el6.i686

Weblogic lock issue.

If  weblogic server  is forcely shutdown,when it start it again it will not  start properly and weblogic lock issue will arise for this to resolve  we have to create a file name called “boot.properites” in

“/opt/oica/user_projects/domains/bifoundation_domain/security”

Edit the file and give password =yyyyyyyy and username=xxxxx in the next line (xxx is weblogic respective username and yyyyy is respective password)

RCU for OBIA

If the following Add log failed dir error occurs while running RCU for OBIA.

This means that

We have to give 775 permissions to database and its associated directory.

In our case $chmod  -R 775 /opt/app/oracle/product/

Then the above issue will be resolved.

OBIA Configuration 11.1.1.9.1 version

Change the port numbers in the opmn.xml file located in

“/opt/oica/instances/instance1/config/OPMN/opmn”

As per the port range in

Login to the em webpage

“oracleobiee.com:7003/em

Click on Business intelligence tab(Left hand side) then click on core application then click on capacity management then click on scalability now check the port range from  and port range to as per this change in opmn.xml file .

2. Change the following parameter in NQSConfig.INI file by editing the file

FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = YES; to

FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = NO;

NQSConfig file is located in

“/opt/oica/instances/instance1/config/OracleBIServerComponent/coreapplication_obis1/”