Weblogic JDBC ORCL connection over SSL

If you want to create a jdbc data source in weblogic or convert an existing jdbc data source in weblogic to connect to an oracle database over SSL then follow these simple steps

Step 1 : get the Oracle DB certificate chain in a .pem format

Step 2 : create a JKS wallet

• source the setDomainEnv.sh or setDomainEnv.cmd in a command window depending on the OS you are on its located at WL_HOME\user_projects\domains\DOMAIN_NAME\bin
• cd to FMW_HOME/Oracle_BI1/jdk/bin
•  import cert using command
•  ./keytool -import -keystore /path/mystore.jks -file /path/cert.pem -alias cert_chain  
• provide a pwd when prompted

Step 3 :Edit the URL of  jdbc connection pool in weblogic to look like this

Current
jdbc:oracle:thin:@SERVER:1300/service_name

to

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=server)(PORT=1310))(CONNECT_DATA=(SERVICE_NAME=service_name)))

Step 4 : in the properties box where you already have the statement user=some_user add the following lines

javax.net.ssl.trustStoreType=JKS
javax.net.ssl.trustStore=/path/mystore.jks
javax.net.ssl.trustStorePassword=myPassword

save and test ...:-) all done

WL Version used : 10.3.6

Clear OBIEE Cache Usign DAC Task Actions

1. Login To DAC

2. Navigate to Setup >> Physical Data Sources and set up connection to the BI server

Optional >> In the extended properties tab add the connection pool ( Note it should match the connection pool name in your RPD)

3. Click Test Connection to test the connection

4. Navigate to Tools >> Seed Data >> Actions >> Task Action and click new to create a new action to populate aggregate Enter a name

5. 

Click on the Value filed to open the dialog and add a command to be run by nqcmd

call sapurgeallcache();

6. Navigate to Tools >> Seed Data >> Logical Data Sources and create a source for the BI Server

7. Goto Design >> Task and create a new task and associate the action created above in the command for incremental and full load, choose the logical data source created above

8. Add the task to a execution plan in the Following Task tab

9. In the execution plan connectivity parameter subtab click generate and map the logical datasource to the Physical Data source

 10.Rebuild the plan and fire away J