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 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.
- 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.
- Open a command shell for your operating system.
- On the command prompt, define the following environment variables, with the following values:
Environmet variable Value ORACLE_SIDISHORACLE_HOMEthe full path of the location where you copied the application - Start SQLPlus by entering the following on the command prompt:
sqlplus SYS AS SYSDBA - 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;Note: If you receive the error "SP2-0606: Cannot create SPOOL file C:\oracle\admin\ISH\create\dbadmin2.log", then you have no folder C:\oracle\admin\ISH\create\.