Creating the designated ISOURCE database user
You must create the ISOURCE designated database user for the new database.
Procedure
- 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.
- 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
Note: All commands must be entered in the same window, ensuring that every environment variable set, is available throughout the process. The next steps presume that you use the same shell with these variables set correctly. - Make sure that the folder C:\oracle\admin\ISH\create exists before continuing.
Note: If the folder is missing the error SP2-0606: Cannot create SPOOL file "C:\oracle\admin\ISH\create\dbadmin2.log, is displayed when issuing the command below.
- Start SQLPLUS /NOLOG from the same window:
SQLPLUS /NOLOG
- 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;