Configuring a Oracle Database Connection From the Command Line

You can configure the database connection by opening a command window as an Administrator and running dbconfig.exe.

The following are default location for dbconfig.exe:

<local drive>\Program Files\Oracle\Primavera P6\P6 Professional (with the 32-bit version of P6 Professional on a 32-bit operating system)
<local drive>\Program Files (x86)\Oracle\Primavera P6\P6 Professional (with the 32-bit version of P6 Professional on a 64-bit operating system)
<local drive>\Program Files\Oracle\Primavera P6\P6 Professional (with the 64-bit version of P6 Professional on a 64-bit operating system)

Use the following command line parameters with dbconfig.exe:

Parameter	Description
`-a<Alias Name>`	Where <Alias Name> is any valid Alias Name value.
`-s<Driver type>`	The following are valid values for <Driver type>: Oracle, MSSQL, or PrCSdrv. Driver Type values are case-sensitive.
`-d<Database Name>`	Specify the Oracle tnsname or Ezconnect string. Specify the Ezconnect string as `<//ServerName>`, representing the server name, or as `<//IP Address:PORT/ServiceName>`, representing the IP address, port, and service name. For a Compression Server, specify `<CompressionServerDatabase Name><@HostName>` or `<CompressionServerDatabase Name><@IPaddress><:Port[http]>`.
`-u<Database pubuser name>`	Where `<Database pubuser name>` is the valid pubuser name.
`-w<Database pubuser's password>`	Where `<Database pubuser's password>` is the valid pubuser's password.
`-b<Public Group ID>`	Optional. A valid value is any integer. The default is 1.

Notes:

The parameters can be positioned in any order.
Ensure there is no space after each parameter keyword and its value, and ensure there is one space between each parameter. For example, this is correct: -amyOracleAlias -sOracle.
The following example is incorrect because there is a space between the parameter keyword and its value: -a myOracleAlias -s Oracle.
The following example is incorrect because there is no space between parameters: -amyOracleAlias-sOracle.

Examples

The following examples create or modify the oracle alias (myOraAlias).

In this example, xe is the Oracle alias in tnsnames.ora.
dbconfig -amyOraAlias -upubuser -wpubuser -sORACLE -dxe
In this example, 10.140.179.3:1521/xe is the Oracle Ezconnect string.

dbconfig -amyOraAlias -upubuser -wpubuser -sORACLE -d//10.140.179.3:1521/xe

The following example creates or modifies the compression server alias (myCSAlias):

dbconfig -amyCSAlias -upubuser -wpubuser -sPrCSdrv -dMyCompressionServer@10.140.162.174:5555[http]

where:

MyCompressionServer is the value for the CompressionServerDatabase Name part of the -d<Database Name> parameter.
10.140.162.174 is the value for the IPaddress part of the -d<Database Name> parameter.
5555 is the value for the Port part of the -d<Database Name> parameter.