Installing the database schema

Describes the steps for installing the database schema.

About this task

The installation proceeds to install the database schema as follows.

Procedure

At the prompt, enter yes to install the database schema:

Would you like to perform task DB_SCHEMA_INSTALL ? [yes/no] >yes

At the prompts, enter the database SID:

Please, Enter the Virtuo Database SID:[vtdb]
---->
Database SID set to "vtdb"

At the prompt, enter the password for the database system user:

Please, Enter the Database sys user password:[<password>]---->
Database user sys password set to "<password>"

At the prompt, enter the password for the database virtuo user:

Please, Enter the Database virtuo user password:[<password>]---->
Database user virtuo password is set to "<password>"
.... Starting Database Schema 'core'
Creating Database Schema 'core' in SID 'vtdb'. This may take several minutes ...
..
.... Database Schema Creation finished successfully

What to do next

You might encounter the following error during installation of the database schema:

Creating database schema 'core' in SID 'vtdb'. This may take several minutes ...
\### ERROR: Database Schema Created with errors
.... Log file is located in /appl/virtuo/admin/oracle/schema/core/install_schema.log
Task DB_SCHEMA_INSTALL exited with value 7.  Quitting.

To resolve this issue, perform these tasks:

Edit the following file:
/appl/virtuo/admin/oracle/schema/core/install_schema
Change the following line:
```
LD_LIBRARY_PATH=/lib:/usr/lib
```
To
```
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/lib:/usr/lib
```

Run the following command:

# cd /appl
# ksh pmw_install -wmcr <WMCROOT> [-a]