Sun B2B Suite eXchange Integrator User's Guide

ProcedureTo directly run the SQL scripts that install the schema


Note –

These steps are an alternative to the command scripts described in the previous procedure. Do not use both procedures.


  1. Open a command prompt and change directories to the local directory where you saved the .sql scripts in the previous procedure.


    Note –

    If your Oracle location is not c:\oracle\oradata, or if your database instance name (SID) is other then eXchange Integrator, then open the createtablespaces.sql file and make the appropriate change or changes in the first line.


  2. Enter the following SQL*Plus command:


    path\sqlplus system/SYSTEMPWD@TNSNAME@createtablespaces.sql

    where:

    SYSTEMPWD is the password for the system login ID

    TNSNAME is the name of the Oracle database instance you created for eXchange Integrator.

    Here are two examples of valid commands, depending on the password and name:


    C:\oracle\ora92\bin\sqlplus system/manager1@eX50 @createtablespaces.sql
    sqlplus system/oraclePW@eXchange @createtablespaces.sql

    When this finishes, you have created new tablespaces.

  3. In the command prompt, enter the following SQL*Plus command:


    sqlplus system/SYSTEMPWD@TNSNAME@createuser.sql

    where, as before, SYSTEMPWD is the password for the system login ID and TNSNAME is the name of the Oracle database instance you created for eXchange Integrator.

    Here is an example of a valid command:


    \oracle\ora92\bin\sqlplus system/myPassWd@eX505DB @createuser.sql
  4. In response to the system prompt for value #1, enter the username. For example: ex_admin

  5. In response to the system prompt for value #2, enter the password. For example: ex_admin

  6. Repeat steps Running Database Scripts to Set Up the eXchange IntegratorDatabase and Running Database Scripts to Set Up the eXchange IntegratorDatabase as needed to create user/password entries for eXchange Integrator users.

  7. After you run the createtablespaces and createuser SQL scripts, there is one more. In the command prompt, enter the following SQL*Plus command:


    sqlplus ex_admin/ex_admin@TNSNAME @createdb.sql

    where, as before, TNSNAME is the name of the eXchange Oracle database instance, and your eXchange Integrator administrator username and password are both ex_admin.

    After the createdb.sql script ends, you are done — you do not need to run any further SQL scripts. The system populates the tables, and you are ready to use the database instance as your eXchange Integrator database. End users can create Oracle OTDs based on this database, and can use it for message tracking and other eXchange Integrator functions.