Use the BIServerT2PProvisioner.jar Utility to Change Connection Pool Passwords
When moving your Oracle BI repository from one environment to another, you often need to change connection pool information for data sources, because the connection information in one environment is typically different from the connection information in another environments.
Although you can use BIServerT2PProvisioner.jar
to update connection pool passwords, Oracle's preferred method is the updateConnectionpool
command. See Update Connection Pool Command.
Connection pool passwords are encrypted and stored inside the encrypted repository file. Because of this, encrypt plain-text passwords before using with an Oracle BI repository.
You can use the BIServerT2PProvisioner.jar
utility to programmatically change and encrypt connection pool passwords in a repository. The utility only works with repositories in Oracle BI repository file (RPD) format; you can't use the utility with MDS XML-format repositories. In addition, the utility requires JDK 1.6.
To use the BIServerT2PProvisioner.jar
utility to change connection pool passwords:
The location of BIServerT2PProvisioner.jar
is:
Oracle_Home/bi/bifoundation/server
Oracle doesn't recommend leaving clear-text passwords available on the system. Instead, delete the input password file completely, or encrypt it to prevent seeing the password.