Technical data

Oracle Database Installation
Database Installation 2-5
3. After setting up roles and users, the utility continues upgrading schema and system data
definitions. If an error occurs while executing an SQL or another utility, it logs and displays
the error message and allows you to re-execute the current step.
4. Run CDXDBI.exe from MDM/Install-Upgrade. The utility prompts you to enter values for
the following parameters:
• The name of the target database.
• The password for the SYSTEM user account in the database (in silent mode).
• The name of the owner of the Database Schema.
• The location of Java Home.
• The location of TUGBU JAR files.
• The password for the user (in silent mode).
• The Oracle user with read-write privileges to the Database Schema.
• The Oracle user with read-only privileges to the Database Schema.
• The Oracle database role with read-write privileges to the Database Schema.
• The Oracle database role with read-only privileges to the Database Schema.
5. If you chose to continue, CDXDBI first checks for the existence of each of the users
specified and prompts for their password, default tablespace, and temporary tablespace, if
they do not exist.
6. After setting up roles and users, the utility continues upgrading schema and system data
definitions. If an error occurs while executing an SQL or another utility, it logs and displays
the error message and allows you to re-execute the current step.
CDXDBI performs the following tasks:
• Interacts with the user to collect information about the name of Oracle account that will own
the application schema (for example, CISADM), password of this account, password of the
SYSTEM account in the database, and the name of the Oracle account that the application
user will use (for example, CISUSER), and the name of the Oracle account that will be
assigned read-only privileges to the application schema (for example, CISREAD).
• Connects to the database as SYSTEM account, checks whether the user already has the
application schema installed to verify whether this is an initial installation.
• Verifies whether tablespace names already exist in Storage.xml file (if not, the process will
abort).
• Installs the schema, installs the system data, and configures security.
• Maintains upgrade log tables in the database.
• Updates release ID when the upgrade is completed successfully.
• If an error occurs while executing a SQL script or another utility, it logs and displays the error
message and allows you to re-execute the current step. Log files CDXDBI###.log are
created in the same folder as CDXDBI and contains all the SQL commands executed against
the database along with the results. The log files are incremental so that the results are never
overwritten. If warning messages are generated during the upgrade, CDXDBI prompts the
user at the end of the process. Users should check the log files to verify the warning messages.
Warning messages are only alerts and do not necessary mean a problem exists.
• Stores the Schema owner and password in the feature configuration table. The password is
stored in encrypted format.