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 environments is typically different from the connection information in another environments.
Note:
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, plain-text passwords must first be encrypted before they can be applied to 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 RPD format; you cannot 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