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 |