Run database configuration from the command line
You can run the database configuration from the command line using the dbconfig.exe command.
The following are the command line parameters for 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
-d<Database Name> For an Oracle database, 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 an SqlServer database, specify a valid SqlServer database name, such as PMDB.
For a Compression Server, specify
<CompressionServerDatabase Name><@HostName> or
<CompressionServerDatabase Name><@IPaddress><:Port[http]>.
-h<Host Name> Valid only for SqlServer. For SqlServer specify a valid Database <ServerName> or <IP Address, PORT>.
-u<Database pubuser name> Where <Database pubuser name> is the valid pubuser name.
90
-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.
When you use the dbconfig.exe command, open the command window in administrative mode. (Run as Administrator.)
For a 64-bit machine, open the command window from SysWOW64 folder.
Go to dbconfig.exe default location: C:\Program Files\Oracle\Primavera P6\P6 Professional.
Examples
The following example creates or modifies the sqlserver alias (mySqlServerAlias):
dbconfig -amySqlServerAlias -h10.140.179.3,1433 -upubuser -wpubuser -sMSSQL -dpmdb
The following two examples create or modify the oracle alias (myOraAlias):
dbconfig -amyOraAlias -upubuser -wpubuser -sORACLE -dxe In the example above, xe is the Oracle alias in tnsnames.ora.
dbconfig -amyOraAlias -upubuser -wpubuser -sORACLE -d//10.140.179.3:1521/xe In the example above, 10.140.179.3:1521/xe is the Oracle Ezconnect string.
The following example creates or modifies the compression server alias (myCSAlias):
dbconfig -amyCSAlias -upubuser -wpubuser -sPrCSdrv [email protected]:5555[http]
In the example above for compression server:
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.
Installing P6 Professional
91
5555 is the value for the Port part of the -d<Database Name> parameter.
Configuring Client Machines to Transfer Data Between P3 and P6 Professional In order to use P3 import/export functionality in P6 Professional with 32-bit operating systems, you must have P3 installed on the same machine where P6 Professional resides.
Note: If you install P3 after you install P6 Professional, if you do not want to install P3 on the same machine where P6 Professional is installed, or if you are using 64-bit operating systems, direct your P3 users to use a separate P3/XER import/export utility available from the P6 Professional installation location (by default, the path is local drive\Program Files\Oracle\Primavera P6\P6
Professional\Convert). Refer to the My Oracle Support's Knowledge Articles for more information.
Configuring P6 Professional to Connect to a Contract Management HTTPS URL If P6 Professional connects to Contract Management hosted at an HTTPS URL, additional client configuration is required.
To configure P6 Professional client machines:
1) Determine the P6 Professional client machines that will be used to import data from Contract Management.
2) Close P6 Professional on the client machines if necessary.
3) On each client machine, go to the following Web site:
http://www.slproweb.com/products/Win32OpenSSL.html 4) On the website, click the Visual C++ 2008 Redistributables link.
5) On the page that opens, click Download to download the Microsoft Visual C++ 2008 RedistributablePackage (x86).
6) For P6 Professional to communicate via HTTPS with the Contract Management server, an implementation of the OpenSSL libraries must be installed on all the client
machines. To install a version of OpenSSL from Shining Light Productions:
a. Go to the http://www.slproweb.com/products/Win32OpenSSL.html website, and click the Win32 OpenSSL v0.9.8k Light link. If v0.9.8k is not available, choose the latest version.
b. Follow the prompts in the Setup wizard to install OpenSSL.
92
Caution: In the Setup wizard, on the Select Additional Tasks dialog box, be sure to choose the Windows system directory option (this is selected by default).
Installing the P6 Professional SDK
The P6 Professional SDK makes P6 Professional data available for use by external
applications. In addition to data, the P6 Professional SDK provides application business rules and calculated values, and enforces application security. The P6 Professional SDK supports the Open Database Connectivity (ODBC) standard for connecting to the P6 Professional database. ODBC-compliant interfaces, such as OLE DB, are also supported.
Complete the following steps to install the P6 Professional SDK.
Related Topics
Installing the P6 Professional SDK Application... 92