13.4 Creating an Oracle Database

When you use an Oracle database, your database administrator must create it for you. The Novell Vibe installation program cannot create an Oracle database.

BASIC VIBE INSTALLATION SUMMARY SHEET

Under Database Creation, make sure you have marked that you want your database administrator to manually create the Oracle database before installation.

Before you begin, you should be familiar with standard database maintenance procedures.

For more information about your Oracle database, see the following references:

The following database tool can be helpful:

  1. Review the Oracle database requirements listed in Section 2.2, Vibe 3.4 Server Requirements.

  2. Make sure that the Oracle database server software has been installed and configured properly.

    For more information, see Oracle Database.

  3. Set up the Oracle database character set to support Unicode character encodings.

    Vibe requires either the UTF-8 or AL32UTF8 character set for proper operation. Oracle recommends AL32UTF8, because it has increased support for certain Asian languages. For more information, see Choosing a Character Set in the Oracle Database Globalization Support Guide.

  4. Change to the directory where you copied the Oracle database scripts in Step 4 in Section 13.1, Preparing to Manually Create a Database.

  5. Edit the create-database-oracle.sql script with your Oracle database password.

    Original:

    drop user sitescape cascade;
    create user sitescape identified by sitescape;
    grant connect, resource to sitescape;
    connect sitescape/sitescape;
    

    SiteScape is the name of the company that previously owned the Vibe software.

    Updated:

    drop user sitescape cascade;
    create user sitescape identified by your_oracle_password;
    grant connect, resource to sitescape;
    connect sitescape/your_oracle_password;
    

    IMPORTANT:Unless you are very familiar with editing scripts, change only the password. Do not attempt to change the name of the database from the legacy default of sitescape.

  6. Enter the following commands to run the database creation script:

    sqlplus "/ as sysdba"
    SQL> spool create-database-oracle.out;
    SQL> @create-database-oracle;
    SQL> quit
    
  7. Check the resulting create-database-oracle.out file for errors and resolve them.

  8. If you created the Oracle database on the Vibe server, skip to Section 4.0, Installing and Setting Up a Basic Vibe Site or Section 10.0, Performing an Advanced Vibe Installation.

    IMPORTANT:On the Database Selection page in the Installation program, be sure to select Database already exists or has already been created.

    or

    If you created the Oracle database on a remote server, continue with Installing Vibe with a Remote Database.