OBIEE 12c SSL configured environment – Issue with uploadrpd and downloadrpd


Not able to uploadrpd or downloadrpd in SSL configured OBIEE 12c environment

<DOMAIN_HOME>/bitools/bin

./datamodel.sh uploadrpd -I SampleApp.rpd -W Admin123 -U weblogic -P Welcome1 -SI ssi -S testmachine.us.oracle.com -N 9503 -SSL
Connection failed, the host name, port number or protocol (http/https) may be incorrect.

./datamodel.sh downloadrpd -O SampleApp.rpd -W Admin123 -U weblogic -P Welcome1 -SI ssi -S testmachine,us.oracle.com -N 9503 -SSL
Connection failed, the host name, port number or protocol (http/https) may be incorrect.

The root cause is SSL communication failure.

The command, ./datamodel.sh  needs to be executed with Keystore used for SSL communication.

By default the command uses Demo Keystore for SSL communication

If SSL is configured with Custom Keystore, it needs to be included in the command option for successful SSL handshake.

The following patch 24967379 is needed to get the command options to include the Custom Keystore.

The new command options are [-TS trustStore jks filename location] [-TSP trust store password]

 

./datamodel.sh uploadrpd -I SampleApp.rpd -W Admin123 -U weblogic -P Welcome1 -SI ssi -S testmachine.us.oracle.com -N 9503 -SSL -TS /refresh/home/ssl/customkeystore.jks -TSP Welcome1

./datamodel.sh downloadrpd -O SampleApp.rpd -W Admin123 -U weblogic -P Welcome1 -SI ssi -S testmachine,us.oracle.com -N 9503 -SSL -TS /refresh/home/ssl/customkeystore.jks -TSP Welcome1

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s