Creating the designated ISOURCE database user
You must create the ISOURCE designated database user for the new database.
Procedure
- If the folder C:\oracle\admin\ISH\create on the server does not exist, create it now.
- 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.
- 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.
- 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_1Note: 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. - 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 @C:\oracle\admin\ISH\create\isrcuser.i CONNECT ISOURCE/isource @?/RDBMS/ADMIN/catdbsyn.sql SPOOL OFF;Note: If the folder C:\oracle\admin\ISH\create is missing the error SP2-0606: Cannot create SPOOL file "C:\oracle\admin\ISH\create\dbadmin2.log, is displayed when issuing the command below.