Documentation Center

Setting up an Oracle database

Before you begin

You must have adequate permissions to access your Oracle instance and perform various operations.

Creating the Oracle instance and schema through sqlplus

Before installing WorldServer, you need to set up an Oracle instance and schema. This process requires full database permissions and should generally be performed by a database administrator (DBA).
  1. Create an Oracle database instance using the Oracle Database Configuration Assistant.
    • The Database Character Set must be a Unicode-based character set. Set the Database Character Set to AL32UTF8.
    • The National Character Set can be set to either UTF8 or AL16UTF16 based on the characteristics of the data you will be storing. See the Oracle documentation for recommendations about which encoding to use.
  2. Start sqlplus and log on as a DBA user (for example, system or sys) to create the Oracle instance in which the WorldServer schema will reside.
  3. Recommended: Create a tablespace and a temporary tablespace to hold the WorldServer schema data.
  4. To create a user and the schema associated with that user, enter the following:
    CREATE USER <username> IDENTIFIED BY <password>;
    If you created the tablespace and temporary tablespace above, use the following syntax:
    CREATE USER <username> IDENTIFIED BY <password>
    DEFAULT TABLESPACE <tablespace_name>
    TEMPORARY TABLESPACE <temporary_tablespace_name>;
    QUOTA UNLIMITED ON <tablespace_name>
  5. Assign the following roles to the database user:
    connect
    resource
  6. Grant the database user the following privileges:
    Create synonym
    Create view
    Create table
    Commit a grant statement that includes the following:
    GRANT CONNECT, CREATE VIEW, CREATE SYNONYM, CREATE TABLE, RESOURCE TO <username>;
  7. Optional: If you want to use the System Monitor tool, run the following commands:
    GRANT SELECT ON SYS.V_$SESSION TO <username>;
    GRANT SELECT ON SYS.V_$LOCKED_OBJECT TO <username>;
    GRANT SELECT ON SYS.V_$SQLTEXT_WITH_NEWLINES TO <username>;
    GRANT SELECT ON SYS.V_$SQL TO <username>;
    GRANT SELECT ON SYS.DBA_OBJECTS TO <username>;
    COMMIT;
    This ensures that the user has READ rights on the following tables:
    • SYS.V_$SESSION
    • SYS.V_$LOCKED_OBJECT
    • SYS.V_$SQLTEXT_WITH_NEWLINES
    • SYS.V_$SQL
    • SYS.DBA_OBJECTS
  8. Exit sqlplus.

Populating the database schema

You must set up an Oracle instance and schema before beginning the WorldServer installation process. To populate the schema, follow these instructions:

  1. Copy the following scripts from the sql directory of your WorldServer distribution into a working directory (for example, C:\ws_install or /tmp/ws_install):
    create.ora.sql
    setup.ora.sql
    create_sp.ora.sql
    create_tr.ora.sql
  2. Log on via sqlplus to the WorldServer database using the WorldServer database user.
  3. Run each of the scripts as follows:
    @ create.ora.sql
    @ setup.ora.sql
    @ create_sp.ora.sql
    @ create_tr.ora.sql
    commit;
  4. Exit sqlplus.
At this point, your database schema has been populated and can be used by WorldServer. You can now install WorldServer on the supported operating system of your choice.