Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OBIEE 12c - Update Connection Pool

Adam WickesFeb 2 2020 — edited Feb 4 2020

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

Added on Feb 2 2020

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

11 comments

598 views