13.4 Creating an Oracle Database

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

BASIC TEAMING 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.

  1. Review the Oracle database requirements listed in Section 2.1, Teaming Server Requirements.

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

    For more information, see Oracle Database.

  3. Make sure that the Oracle database client is also installed on the Teaming server

    The Teaming Installation program needs the Oracle client in order to communicate with the remote Oracle database server.

  4. Make sure that you know the password for the Oracle database administrator user.

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

    Teaming requires either the UTF-8 or AL32UTF8 character set for proper operation. Oracle recommends the use of 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.

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

  7. 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;

    NOTE:SiteScape® is the name of the company that previously owned the Teaming 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.

  8. 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

  9. Check the resulting create-database-oracle.out file for errors and resolve them.

  10. Be familiar with standard database maintenance procedures.

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

    The following database tool can be helpful:

  11. (Conditional) If you created the Oracle database on the Teaming server, skip to Section 4.0, Setting Up a Basic Teaming Site or Section 10.0, Performing an Advanced Teaming Installation.

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

    or

    (Conditional) If you created the Oracle database on a remote server, continue with Installing Teaming with a Remote Database.