To edit the setenv command script (Sun B2B Suite eXchange Integrator User's Guide)

Sun B2B Suite eXchange Integrator User's Guide

To edit the setenv command script

Open a command prompt and change directories to the local directory where you saved the scripts in the previous procedure.

Use a text editor to edit the as-supplied version of setenv.cmd:

@REM SET YOUR DATABASE CONNECTION INFORMATION HERE
*
echo * This file should be edited to use appropriate
echo * database connection settings. *
echo * SETENV.CMD

 @REM TNS_NAME
@set TNS_NAME= TNS NAME        

@REM ORACLE_SID
@set ORACLE_SID=  SID  

@REM Oracle system login password
@set SYSTEMPWD=  PWD  

@set USERID=ex_admin
@set USERPWD=ex_admin

Supply the appropriate values for TNS_NAME, ORACLE_SID, and SYSTEMPWD. For example:

@set TNS_NAME=eXchange_myOracleHostname
@set ORACLE_SID=ORCL
@set SYSTEMPWD=manager
@set USERID=ex_admin
@set USERPWD=ex_admin

If your Oracle location is not c:\oracle\oradata, or if your database instance name (SID) is other then eXchange, then open the createtablespaces.sql file and make the appropriate change or changes in the first line.

Note –
The database user who runs the SQL scripts must have permission to create tables.