On Windows, enter:
install_root\bin\wsadmin -f create_ds_Oracle.jacl
[-node <nodeName>] -server <serverName>
[-driverType ( oci8 | thin ) ]
[-dbServer <dbServerName>] [-dbPort <port>]
-dbPath <databasePath> [-tnsName <databaseName>]
-userid <userid> -password <password>
On UNIX, enter:
install_root/bin/wsadmin.sh -f create_ds_Oracle.jacl
[-node <nodeName>] -server <serverName>
[-driverType ( oci8 | thin ) ]
[-dbServer <dbServerName>] [-dbPort <port>]
-dbPath <databasePath> [-tnsName <databaseName>]
-userid <userid> -password <password>
Where:
- wsadmin
- is located in the bin subdirectory of the IBM WebSphere Application
Server installation directory.
- create_ds_Oracle.jacl
- is the script file that performs the configuration within WebSphere. It
is located in the ProcessChoreographer subdirectory of the IBM WebSphere
Application Server installation directory. For example, on a default Windows
installation, it is in the directory c:\Program Files\WebSphere\AppServer\ProcessChoreographer.
- nodeName
- is the optional node name.
- serverName
- is the application server name.
- oci8 or thin
- indicates which JDBC driver to configure for the database access. If nothing
is specified oci8 is the default, which selects the Oracle
OCI JDBC driver. thin selects the Oracle thin JDBC driver.
For performance reasons, oci8 is recommended.
- dbServerName
- is the machine name of the server that hosts the database. This is only
required for the thin driver.
- port
- is the port number where the database server listens to JDBC requests.
This is only required for the thin driver. If no value is
specified, the default value 1521 is used.
- databasePath
- is the location where your Oracle system is installed. Note: On Windows
you must use forward slashes (/) instead of back slashes (\) to specify the
path, for example, "c:/oracle/ora90".
- databaseName
- is the TNS name. This is only required for the oci8 driver
and must match the name used for the process choreographer database in the
file tnsnames.ora. If no value is specified the default used is BPEDB.
- userid
- is the user ID for accessing the database. This must be the same user
ID that was used to create the database.
- password
- is the password for userid.
For example, on Windows:
install_root\bin\wsadmin -f create_ds_Oracle.jacl
-server server1 -dbPath "c:/oracle/ora90" -tnsName BPEDB
-userid system -password OraclePassword