OBIEE 12c - Update Connection Pool

Adam Wickes

Hi all,

Does anyone know if there is an issue with the UpdateConnectionpool process listed here: https://docs.oracle.com/middleware/12212/biee/BIEMG/GUID-2A5F25A5-5E16-4EF0-97FF-3F378B740DA7.htm#conn_updt_pool_cmd

We have two environments (Prod and Disaster Recovery). Both of which are the same (Hardware spec, O/S, config etc).
I have set up a process whereby nightly, a BAR is exported from Prod and then imported to DR.
As part of this, I noticed that RPD conn pool details were not being migrated (even though I used the encryptionpassword parameter according to Oracle doco).
I have since used the listConnectionpool and updateConnectionpool process to output conn pool details to json and then import back in.
This looks to update the username info but leaves the password field blank.

Has anyone been able to achieve this by using the above process?
It seems like everything Oracle does, they break. Very frustrating!

Thanks,
Adam

vanantha komara-Oracle

Hi,

Kindly check the below steps, generated json file that have password encrypted and also check the server logs.

First, we need an actively deployed RPD in each of your environments that contains the correct and functional connection pool information. Yes, test your connections in all environments, just in case.

Now, for each environment, we execute datamodel.sh with the listConnectionpool argument:

datamodel.sh listConnectionpool -SI <service_Instance_Name> -U <admin_username> -P <admin_password> -V true -O <output_file_name>.json

The listConnectionpool argument writes the active connection pools (with encrypted passwords) and all variables that are used in connection pools to a json file. Let’s save this off to a safe directory where we can access it for reuse.

Now that we have saved our connection pools for each environment, we can now use the json file and datamodel.sh updateconnectionpool to update the connection pools for the specific (Dev, Test, Prod) environment:

datamodel.sh updateconnectionpool -C /tmp/connection_pools.json -SI <service_Instance_Name> -U <admin_username> -P <admin_password>

Adam Wickes

These are the steps I followed:

1. Exported BAR file from Prod
2. Exported connectionpool information using listConnectionpools
3. Imported BAR file into DR

4. Imported connectionpool information using updateConnectionpools

After step 3, the RPD has no username/password/db info etc.
After step 4, the RPD has username and db info but no password.

Adam Wickes

Note: I'm using Windows so using datamodel.cmd
Note2: The json file contains the encrypted passwords after exporting

vanantha komara-Oracle

Hi

what is the import command that you have used for importing password,

The import_bar.sh |. cmd command is deprecated in OBI 12.2.1.4.

With 12.2.1.4, use the importarchive.sh | .cmd command.

You may use the -h switch for syntax

Adam Wickes

I used "importarchive.cmd ssi barfilename.bar encryptionpassword=password" to import.

Adam Wickes

"export_service_instance.cmd ssi barfilename.bar" to export.

vanantha komara-Oracle

Do a restart of WLS and OBIEE and check the scenario, i think security is not copied properly.

Adam Wickes

Do you have to restart OBIEE after a BAR migration?
I wasn't sure. So automation process should be:

1. Export BAR
2. Export connection.json
3. Import BAR
4. Restart destination application
5. Import connection.json

Would you need to restart a 2nd time after the connection import?

Adam Wickes

Update:

Tried importing BAR file, restarting, then using updateConnectionpool and reloading metadata.
Still doesn't work. No password is saved in the connection pools.

Does this process write to any log file?

vanantha komara-Oracle

Hi adam,

Kindly check the server logs and managed server logs example, also rise MOs ticket for the mentioned issue if you are not sure.

oraclehome/user_projects/domains/bi/servers/obis1/logs (for BI Server)

oraclehome/user_projects/domains/bi/servers/AdminServer/logs (for JEE Administration server)