Database connection properties
The following table summarizes the portal.properties values for the Oracle users and passwords that are used by the portal.
Table: Portal properties with description.
Portal Property | Description |
|---|---|
db.driver | This value is customized by the Portal installer and should not be modified. |
db.url | This is the address where the IT Analytics database resides. Depends on what was entered during the installation. This may need to be modified when there is a host name change. |
db.user | The application DB user ID. Default value is portal and cannot be changed. |
db.password db.password.encrypted= | Enter a password to be used with the DB user. The default value is . The password initially is stored in clear text, but after the restart of the Tomcat Portal services, the password is saved in the encrypted format and the clear text password is removed from portal.properties. |
db.connection.max | Use this property to specify the maximum database connections allowed. The default value is 25. |
db.connection.min | Use this property to specify the minimum number of database connections that the Portal can have. The default value is 25. |
db.connection.expiration | When a Portal report initiates a long-running database query, this value (in minutes) establishes when the report will time out if the query takes too long to complete. The default value is 5. |
db.ro_user_password db.ro_user_password.encrypted= | The Oracle database read-only user password for the IT Analytics database tables. The preset value is aptaresoftware123. The password initially is stored in clear text, but after the restart of the Tomcat Portal services, the password is saved in the encrypted format and the clear text password is removed from |
db.sysdba_user | The Oracle database System DBA for the IT Analytics database tables. The preset value is system. |