On the Database Type & Connection screen:
- For the Database Type option, choose one of the following:
- Oracle
- Oracle Autonomous Database (ATP)
- Microsoft SQL Server
- Enter the connection details for the database.
If your database is hosted on Oracle or Microsoft SQL:
- In the Database Host Address field, enter the server machine name or IP address where you installed the database.
- In the Database Host Port field, enter or verify the port number for your database.
The default for Oracle is 1521.
The default for Microsoft SQL Server is 1433.
- In the Database Name field, enter the name of your database.
- For Oracle only, select SID (for example, orcl) or Service (for example, orcl.us.oracle.com) based on the database you installed.
- In the Keystore Folder field, enter the location of the keystore.
The P6 EPPM wizard automatically detects keystores located in the primary database folder.
If your database is hosted on Oracle Autonomous Database:
- In the Database Wallet Location field, enter or browse to the location of the zipped Database Wallet.
- On the Service list, select the service to use.
- In the DBA Username field (when installing or upgrading) or Public Username field (when connecting to an upgraded database), enter or verify your user name.
The default username for Oracle is 'system'.
The default username for Oracle Autonomous Database is 'system'.
The default username for Microsoft SQL Server is 'sa'.
The default public username is 'pubuser'.
- In the DBA Password field (when installing or upgrading) or Public Password field (when connecting to an upgraded database), enter the password to log in to the database.
- Click Next.
Note: The Configure Oracle Read Only User option is only intended for use with cloud installations.