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 PACKAGEROOT\Database\InfoshareCM\Common\Oracle\Create\isrcuser.i (where PACKAGEROOT is the root folder of the installation package) to the folder C:\oracle\admin\ISH\create\, and make sure the file is writable.
  3. Check the paths, commands, usernames and passwords in the file. The examples in the file are Windows-specific. Open the file in a plain-text editor and change the example values as needed, especially the username and password of the designated user, to match your environment.
  4. Open a command shell for your operating system.
  5. On the command prompt, define the following environment variables, with the following values:
    Environmet variableValue
    ORACLE_SIDISH
    ORACLE_HOMEthe full path of the location where you copied the application
  6. Start SQLPlus by entering the following on the command prompt: sqlplus SYS AS SYSDBA
  7. Enter the following commands from the same command prompt:
    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;