Documentation Center

Creating the designated ISOURCE database user

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

Procedure

  1. If the folder C:\oracle\admin\ISH\create on the server does not exist, create it now.
  2. Copy CD_Package\Applications\TriDK\Database\Oracle\create\isrcuser.i (where CD_Package is the root folder of the CD package) to the folder C:\oracle\admin\ISH\create and make sure the file is writable.

    The examples are specific for Windows. Be sure to modify the paths, commands and username/passwords to match your environment.

  3. Open C:\oracle\admin\ISH\create\isrcuser.i in Notepad and if needed adapt the username and password of the designated user to match your environment.
  4. Open a Command Prompt and set the following variables:

    Set ORACLE_SID=ISH

    Set ORACLE_HOME as follows:
    set ORACLE_HOME=c:\oracle\product\12.1.0\dbhome_1
  5. Start SQLPLUS /NOLOG from the same window:
    SQLPLUS /NOLOG
  6. 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
    @C:\oracle\admin\ISH\create\isrcuser.i
    CONNECT ISOURCE/isource
    @?/RDBMS/ADMIN/catdbsyn.sql
    SPOOL OFF;