The scripts assume they are run on a machine whose command path includes sqlplus. The network\admin\tnsnames.ora file must include a stanza such as the following:
eXchange_myOracleHostname.domain (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = myOracleHostname) (PORT = 1521)) ... ) ) (CONNECT_DATA = (SID = ORCL) ... ) ) |
Some scripts and samples assume defaults or supply values as shown in Table 2–2.
Table 2–2 Typical, Default, or Presupplied Values for eXchange Integrator Database Setup
Item |
Typical or presupplied value |
---|---|
UserID/password combination for Oracle system |
sys/manager or system/manager |
Name of eXchange database instance (see Creating and Configuring the eXchange Integrator Database Instance) |
eXchange |
SID (also called service ID, servicename, or database name) |
ORCL (or not presupplied) |
TNS name |
(not presupplied) |
UserID/password for administering the eXchange database |
ex_admin/ex_admin |
UserID/password for first generic eXchange end user |
ex510a/ex510a |
UserID/password for second generic eXchange end user |
ex510b/ex510b |