Documentation Center

Creating the designated ISOURCE database user

You must create the ISOURCE designated database user for the new database.

Procedure

  1. Optionally, copy the CD_Package/Applications/TriDK/Database/Oracle/create/isrcuser.i to a temporary location on your server.
    Make sure that the \Applications\TriDK\Database\Oracle\create\isrcuser.i file path in the command below is to the full file path of the file either on the CD or, if copied to your system, to the temporary location on your system.

    The example below is specific for Windows. Be sure to modify the path and command for your environment.

  2. Open a Command Prompt Window as Administrator and set the following variables:

    Set ORACLE_SID=ISH

    set oracle_home=c:\oracle\product\11.2.0\dbhome_1

  3. Make sure that the folder C:\oracle\admin\ISH\create exists before continuing.
  4. Start SQLPLUS /NOLOG from the same window:
    SQLPLUS /NOLOG
  5. At a command prompt where the variables for ORACLE_SID and ORACLE_HOME are set, type:
    SPOOL C:\oracle\admin\ISH\create\dbadmin2.log
    CONNECT SYS/CHANGE_ON_INSTALL AS SYSDBA
    @CD_Package\Applications\TriDK\Database\Oracle\create/isrcuser.i
    CONNECT ISOURCE/isource
    @?/RDBMS/ADMIN/catdbsyn.sql
    SPOOL OFF;