Use the update updateConnectionpool
command to upload a modified JSON file containing updated connection pool values to a specific server instance.
Use the updateConnectionpool
command and the listConnectionpool
utility when you need to update more than one connection pool.
Use the listConnectionpool
command to create a JSON file containing a list of connection pools for a specific service instance. Modify the connection pool information in this file and then upload it to the service instance using the updateConnectionpool
command. Note that you must not modify the uid
and connPool
values in the file. See List Connection Pool Command for more information.
You execute the utility through a launcher script, datamodel.sh
on UNIX and datamodel.cmd
on Windows.
If the domain is installed in default folder then the location of the launcher script looks like the following:
Oracle_Home/user_projects/domains/Domain_Name/bitools/bin/datamodel.sh
or datamodel.cmd
on Windows
If the client install doesn't have domain names, the launcher script location is as follows:
Oracle_Home\bi\bitools\bin\datamodel.cmd
See What You Need to Know Before Using the Command for more information.
Syntax
The updateConnectionpool
command takes the following parameters:
updateConnectionpool -C <connectionpoolList.json> -SI <service_instance> -U <cred_username> [-P <cred_password>] [-S <hostname>] [-N <port_number>] [-SSL] [-H]
Where
C
specifies the name of the modified JSON file that you want to upload. Note this file must not contain modified uid
and connPool
values. See the example in the List Connection Pool Command for information about the correct syntax for the update connection pool input file.
SI
specifies the name of the service instance.
U
specifies a valid user's name to be used for Oracle BI EE authentication.
P
specifies the password corresponding to the user's name that you specified for U
. If you do not supply the password, then you will be prompted for the password when the command is run. For security purposes, Oracle recommends that you include a password in the command only if you are using automated scripting to run the command.
S
specifies the Oracle BI EE host name. Only include this option when you are running the command from a client installation.
N
specifies the Oracle BI EE port number. Only include this option when you are running the command from a client installation.
SSL
specifies to use SSL to connect to the WebLogic Server to run the command. Only include this option when you are running the command from a client installation.
H
displays the usage information and exits the command. Use -H
or run .sh
without any parameters to display the help content.
Example
datamodel.sh updateConnectionpool -C connpool.json -SI bi -U weblogic -P password -S server1.example.com -N 7777 -SSL