![]() | |
IS B2B: ECXpert and TradingXpert 3.6.3 Installation Guide |
Chapter 3
Installing ECXpert and TradingXpertThis chapter describes how to use the Sun ONE Integration Server B2B Installer to install ECXpert and TradingXpert on the Solaris and Windows platforms. It covers the following topics:
Refer to the Installation Worksheet in Table 2-8 as you perform these tasks. Make sure that you have installed all needed dependent software, as described in Chapter 2, "Preinstallation Tasks," before you install either ECXpert or TradingXpert.
All the instructions in this chapter are written for a new install of ECXpert and TradingXpert. It is assumed that ECXpert and TradingXpert have either not been previously installed on the target system or that you have deleted all files and directories from any previous installation.
If you are upgrading from ECXpert version 3.6.2, see Appendix A, "Upgrading to ECXpert 3.6.3."
If you are upgrading from TradingXpert version 3.6.2, see the ECXpert Release Notes, at http://docs.sun.com/coll/S1_IntegrationServer_B2B_363.
If you are re-installing ECXpert Version 3.6.3, see Appendix B, "Reinstalling ECXpert."
Starting the Sun ONE Integration Server B2BInstallerTo start the Installer on Solaris
- You should already be logged in as the ECXpert admin user.
- Make sure that the Oracle database is running:
%ps -ef | grep ora
- If you are installing ECXpert remotely, from a C shell window, set your remote host to display on your local host.
On the local host, enter:
# setenv DISPLAY hostname:0.0
where hostname is the name of the machine on which you are physically located.
On the remote host, enter:
# /usr/openwin/bin/xhost +
- Make sure you have a valid host name and domain name.
To verify this, enter:
# /bin/hostname
# /bin/domainname
Consult your system administrator if either your host name or domain name does not have a valid value.
- Change to the /cdrom directory.
# cd /cdrom/ECXpert
If this command does not work, enter the following command:
# cd /cdrom/cdrom0
- Start the installer by running the setup executable.
Do not run setup as a background process.
# ./setup
The Sun ONE Integration Server B2B Installer starts. This installer is based on the Setup SDK installer and works on both Solaris and Windows platforms.
The figures in this chapter are taken from the Solaris Installer, and all paths are in Unix format. Ex: keylime/ecx_3_6_3. Some screens are only available on the Solaris platform, and are noted as such in the installation procedure.
To start the Installer on Windows
- Log in as a user with administrative privileges.
- Make sure you have a valid host name and domain name.
Consult your system administrator if either your host name or domain name does not have a valid value.
- Select the CD drive in the Explorer.
- Start the installer by double-clicking the setup.exe file.
A Setup dialog box appears momentarily while some installer files are copied temporarily to your hard drive from the CD.
The Sun ONE Integration Server B2B installer starts. This installer is based on the Setup SDK installer and works on both Solaris and Windows platforms.
The figures in this chapter are taken from the Solaris installer, and all paths are in Unix format. Ex: keylime/ecx_3_6_3. Some screens are only available on the Solaris platform, and are noted as such in the installation procedure.
Installing ECXpert and TradingXpertAfter starting the Sun ONE Integration Server B2B Installer as described in Starting the Sun ONE Integration Server B2BInstaller, the installer displays the Welcome Dialog as shown inFigure 3-1.
Figure 3-1 Sun ONE Integration Server B2B installer welcome dialog
- Click Next to continue with the installation.
The installer displays the Sun license agreement as shown in Figure 3-2.
Figure 3-2 Sun License Agreement
- Click Yes (Accept Agreement) to continue with the installation.
The installer displays system requirements for Integration Server B2B on Solaris as shown in Figure 3-3. The system requirements for Integration Server B2B on Windows are shown in Figure 3-4.
Figure 3-3 Integration Server B2B Solaris system requirements dialog
Figure 3-4 Integration Server B2B Windows system requirements dialog
You can continue to install ECXpert and TradingXpert from this point if your machine does not have the amount of recommended RAM, but you may not be able to operate in a high-volume production environment without the recommended amount of RAM.
- Click Next to continue with the installation.
The Installation Directory dialog appears as shown in Figure 3-5.
Figure 3-5 Integration Server B2B Installation Directory Dialog
Caution
If you are upgrading from an earlier version of ECXpert or TradingXpert do not simply install the current version over the old one.
If a version of ECXpert is already installed in the default installation location, click Browse to specify a different directory into which to install the new version. For more information on reinstalling ECXpert, see Appendix B.
For more information on upgrading TradingXpert, see the ECXpert Release Notes.
- To install ECXpert into a different directory than the default, click Browse to select the directory you want, and then click Next. Otherwise, simply click Next.
The installer displays the Component Selection dialog as shown in Figure 3-6.
Figure 3-6 Integration Server Component Selection Dialog
- Select the Integration Server B2B components to install and click Next.
- If you want to install TradingXpert on the same machine with ECXpert, it is recommended that you install it with ECXpert at the same time.
- If you want to install TradingXpert on a separate machine from ECXpert, select ECXpert only, complete the installation process for ECXpert, and read Configuring TradingXpert to Run on a Different Machine from ECXpert after completing the ECXpert installation.
- If you are installing just TradingXpert on your machine, select TradingXpert and skip ahead to Step 18.
For more information about ECXpert/TradingXpert configurations, see ECXpert/TradingXpert Configurations.
The installer displays the Java Version dialog as shown inFigure 3-7.
Figure 3-7 ECXpert Java Version Dialog
- To point to a Java Runtime Environment (JRE) that is already installed on your system: click Browse, locate the JRE’s bin directory, and click Next. Otherwise, click Next to install the bundled JRE.
The installer displays the UserID and GroupID information dialog as shown in Figure 3-8.
Note
The JRE selected must be the supported version number or higher. For the supported version of the JRE, consult the Sun ONE Integration Server B2B certification matrix at:
http://docs.sun.com/coll/S1_IntegrationServer_B2B_363.
Figure 3-8 UserId and GroupID Information Dialog
- Fill inUserID and GroupID fields for the machine that will host ECXpert and click Next. Consult the values you specified in Table 2-8.
The installer displays the Secure Trading Agent Configuration dialog as shown in Figure 3-9.
Figure 3-9 Secure Trading Agent Configuration Dialog
- Fill in the Secure Trading Agent configuration fields and click Next. Consult the values you specified in Table 2-8.
If you do not want to install the Secure Trading Agent feature, select Skip Secure Trading Agent Configuration and click Next.
If you are installing on Solaris, the installer displays the Partner Agent Server Configuration dialog as shown inFigure 3-10. If you are installing on Windows, skip to Step 10.
Figure 3-10 Partner Agent Server Configuration Dialog
- If you plan to use the ECXpert Partner Agent server, you must enter the port numbers that the server will use. You can specify any port number that is not in use; the port number must be greater than 1024.
The installer displays the Database Configuration Parameters dialog as shown in Figure 3-11.
Note
If you do not use Partner Agent, you must still supply the port numbers as shown in Figure 3-10. You can use these ports for other purposes, but to proceed with the ECXpert installation, you must supply this information.
Figure 3-11 Database Configuration Parameters Dialog
- Fill in the Database fields and click Next.
- For the Database entries, consult the values you specified in Table 2-8 when you installed and configured your Oracle database.
If a value for Oracle Home is already listed, you can leave it as is. Otherwise, specify the directory path where you installed the Oracle database you want to use with ECXpert.
The installer displays the Oracle Schema Configuration dialog as shown in Figure 3-12.
Table 3-4 Oracle Configuration fields
Oracle Home
(ORACLE_HOME)
Enter the directory that contains the Oracle software. This is the ORACLE_HOME path name. Instructions for installing Oracle are given in Installing Oracle.
Solaris: /oracle/ora81
/oracle/ora92Windows: D:\oracle\ora81
D:\oracle\ora92Oracle SID
(ORACLE_SID)
Enter the Oracle SID, which is the name of the Oracle Server Instance. To get this value, see Installing Oracle.
Solaris: myOracleSID
Windows: myOracleSID
NLS Language
Enter the NLS _LANG character set. To get this value, see Table C-1.
If you are using an Oracle 8 database, use AMERICAN_AMERICA.US7ASCII.
If you are using an Oracle 9 database, use
on Solaris:
AMERICAN_AMERICA.WE8ISO8859P1
on Windows:
AMERICAN_AMERICA.WE8MSWIN1252Note that the character set specified by this value must match the character set specified for your Oracle installation. If these values do not match, you will not be able to install ECXpert.
SQL*Net TNS Alias
(Solaris)
Server (Windows)
Find this value in the tnsnames.ora file. This value is also known as the SQL*Net Connect String.
ECXpert Oracle User
(Windows)
Database user
(Solaris)
Enter the name of the user who owns the ECXpert tables in the database.
Solaris: Specify the value you used when you created the Oracle user in Create the Oracle ECXpert User Account.
Windows: Specify the value you used when you created the Oracle user in Create the Oracle ECXpert User.
Database password
Enter the password of the user who owns the ECXpert tables in the database.
Solaris: Specify the value you used when you created the Oracle user password in Create the Oracle User.
Windows: Specify the value you used when you created the Oracle user password in Create the Oracle User.
Figure 3-12 Oracle Schema Configuration Dialog
- Select Drop Tables and Create New to automatically run the SQL scripts that drop the database schema for the ECXpert database.
Caution
If you are upgrading or reinstalling ECXpert, stop here. If you select this option and click Next, your existing database will be overwritten.
The installer displays the Mail Server Settings dialog as shown in Figure 3-13.
Figure 3-13 Mail Server Settings Dialog
- Enter values to configure the mail server: you have a choice of using SENDMAIL or POP3.
- If you choose Sendmail, you must supply a value for the Mail Spool file entry in the following format:
/var/mail/ECX_user_name
The Mail Spool file will default to the Mail Host directory if it is not specified. Make sure that the user specified as the ECX user is part of the mail group so that this user can send and receive mail.
- If you choose POP3, you must also specify the POP3 user name and password, as shown in Figure 3-13.
The installer displays the AS2 Configuration dialog as shown in Figure 3-14.
Figure 3-14 AS2 Configuration Dialog
- Fill in the AS2 configuration fields and click Next. Consult the values you specified in Table 2-8. If you want to Skip AS2 configuration, check Skip AS2 Configuration and click Next.
The installer displays the Additional Parameters for AS2 dialog as shown in Figure 3-15. If you chose to skip AS2 configuration, go to Step 16.
Table 3-5 Values for the AS2 Configuration Fields
Field
Value
Web Server ROOT
The path to the Web Server to be used for AS2 communication.
AS2 Web Server Instance
The name of the Web server instance you specified in Creating an AS2 or AIAG Protocol Listener on the Web Server
AS2 Server Port
Port to use to connect to the AS2 Web Server you specified Creating an AS2 or AIAG Protocol Listener on the Web Server.
This port should be a unique number greater than 1024.
Keystore Path (optional)
Path to the Java Keystore file used by AS2.
Example: /export/ecx_keystore.jks
Keystore Password (optional)
The password for an AS2 keystore.
HTTP Proxy Host (optional)
Name of proxy host for AS2 communication through a proxy server.
HTTP Proxy Port (optional)
Port number for AS2 communication through a proxy.
Figure 3-15 Additional Parameters for AS2 Dialog
- Fill in additional Receiver and Sender information for AS2 communication between ECXpert and the AS2 Web Server and click Next.
The installer displays the AIAG Configuration dialog as shown in Figure 3-16.
Note
AIAG configuration is only supported on the Solaris platform. If you are installing ECXpert on Windows, skip to Step 17.
Figure 3-16 AIAG Configuration Dialog
- Fill in values for AIAG Configuration and click Next.
The Automotive Industry Action Group (AIAG) protocol is intended only for partners that trade with other AIAG members. If you do not need to use AIAG as a protocol, check Skip AIAG Configuration and click Next.
The installer displays the Configure ECXpert Startup on Reboot dialog, as shown in Figure 3-17.
Table 3-7 Values for AIAG Configuration Dialog
Field
Value
Web Server ROOT
The path to the Web Server to be used for AIAG communication.
AIAG Web Server Instance
The name of the Web server instance you specified in Creating an AS2 or AIAG Protocol Listener on the Web Server.
In the example, the instance is aiagws.
Figure 3-17 Configure ECXpert Startup on Reboot Dialo
If you ran the installer as a root user on Solaris or as an Administrator on Windows, you can configure ECXpert to startup on reboot.
- Select Configure Startup on Reboot and click Next to configure ECXpert to restart when you reboot or restart your machine. Otherwise, click Next.
The installer displays the ECXpert Configuration path dialog, as shown in Figure 3-18.
Figure 3-18 EXC Configuration Path Dialog
- Enter the path to the mounted ECXpert home (BDGHOME) installation you want to associate with TradingXpert and click Next to proceed with the installation.
This field is only available to you when you are installing TradingXpert on a different machine than ECXpert. For more information, see Configuring TradingXpert to Run on a Different Machine from ECXpert.
In a default installation, the path to BGDHOME is
ECX_Inst_Dir/NS-apps/ECXpertwhere ECX_Inst_Dir is the directory where you installed ECXpert.
Note
If you are installing only ECXpert, the Path to ECXpert Home (BDGHOME) field is unavailable to you. Proceed to Step 21.
The installer displays the Application Server Configuration dialog for TradingXpert, as shown in Figure 3-19.
Figure 3-19 Application Server Configuration Dialog
- Fill in the values for the Application Server instance on which TradingXpert will be installed and click Next.
Select SSL enabled for if SSL is turned on for the Application Server.
The Application Server is used by the TradingXpert client to trade documents with ECXpert.
The WebMail Configuration dialog appears, as shown in Figure 3-20.
Figure 3-20 WebMail Configuration Dialog
- Fill in the WebMail configuration values and click Next.
If you do not want to configure WebMail, check Skip WebMail Configuration and click Next.
The installer displays the ECXpert Information Verification dialog, as shown in Figure 3-21.
Figure 3-21 ECXpert Information Verification Dialog
- Scroll through the collected information for the Integration Server B2B installation. If you are satisfied with the values collected, click Install Now. Otherwise click Back to navigate to the screen that contains the values you want to change.
Once you click Install Now, the installer displays the Installing... progress dialog, as shown in Figure 3-22.
Figure 3-22 Integration Server B2B Installing... Progress Dialog
Click Stop at any time to abort the installation. When the installation is complete, the Installation Summary dialog appears, as shown in Figure 3-23.
Figure 3-23 Integration Server B2B Installation Summary Dialog
Click View Log to view the installation log file created during the installation.
- Click Next to receive post-installation instructions.
The installer displays the Post Installation Configuration dialog, as shown in Figure 3-24.
Figure 3-24 Post Installation Configuration Dialog
- Click Finish to complete the installation.
- Read and follow the post installation instructions referenced in the postinstall.txt file in the ECXpert install directory.
Post-Installation TasksECXpert Configuration Tasks
To configure Sun ONE Web Server files
The postinstall.txt file contains instructions that you must follow to modify two configuration files: magnus.conf and obj.conf, for the Sun ONE Web Server. Information in these files is used to support the browser-based ECXpert Administration interface.
Follow the instructions shown in the postinstall.txt file to edit the files magnus.conf, and obj.conf. For these changes to take effect, you will need to shut down and restart the Web Server. See the section Applying Web Server Configuration File Changes to apply the configuration changes to the Web Server.
TradingXpert Configuration Tasks
If you installed TradingXpert, the postinstall.txt file contains additional instructions that you must follow to configure TradingXpert.
After you complete the instructions in the postinstall.txt file, you must stop and then start the Application Server and restart the machine hosting TradingXpert for your changes to take effect.
Applying Web Server Configuration File Changes
Follow these steps to apply the changes you have made to the web server configuration files obj.conf, and magnus.conf.
- Start your web browser and go to the following URL.
http://machine_name:port#/admin-serv/bin/index
- Enter the user ID and password.
Enter a user ID and password for a Sun ONE Web Server user with administrative privileges.
- Apply any changes you made to the web server configuration files.
- A message window appears telling you that you must apply your changes. Click OK.
- In the Sun ONE Web Server bar at the top of the screen, click Apply. The Apply Changes screen appears.
- Click Load Configuration Files for the Sun ONE Web Server.
- If the changes are successfully applied, a “success” message window appears. Click OK to continue.
- Exit your web browser.
Set Up Environment Variables
Setting Environment Variables On Solaris
The routine operation of the ECXpert system, require the BDGHOME and NSBASE environment variables be properly set.
The value of BDGHOME is
Root_ECX_Install/NS-Apps/ECXpert
Root_ECX_Install is the directory that you specified as the directory for ECXpert at installation time.
The value of NSBASE is
Root_ECX_Install
Root_ECX_Install is the directory that you specified as the directory for ECXpert at installation time.
You must set the BDGHOME and NSBASE variables explicitly if you plan to start ECXpert from the command shell. If you start ECXpert from a browser, you do not need to set the variable.
To set the BDGHOME and NSBASE environment variables
- Change to the ECXpert Administrator user. For example:
# su - ecxadmin
- Determine the environment file to edit.
# echo $SHELL
The output of this command determines which environment file you must edit:
Output
Shell Being Used
Environment File
/sbin/sh
Bourne
.profile
/sbin/csh
C
.cshrc
/sbin/ksh
Korn
.profile or .kshrc
- Edit the definitions of BDGHOME and NSBASE into the shell startup file according to the following instructions:
- Save the file and exit the text editor.
- Enable the BDGHOME and NSBASE environment variables.
Adding BDGHOME and NSBASE to the environment file for the ECXpert Administrator user ensures that it is enabled every time the ECXpert Administrator user logs in. You can now enable BDGHOME and NSBASE by switching to another user and then switching back. For example:
# su - root
# su - ecxadminAlternatively, you could restart your system and log in as the ECXpert Administrator user.
Setting Enviroment Variables On Windows
Parts of the installation process, as well as the routine operation of the ECXpert system, require the $BDGHOME and $NSBASE environment variable be properly set.
To set the BDGHOME variable
- From the Windows NT or Windows 2000 task bar, select Start > Settings > Control Panel > System.
- In the System Properties window, select the Environment tab.
- In the Variable input field, type BDGHOME.
- In the Value input field, type the full path you specified for the directory into which you installed ECXpert (Root_ECX_Install), and append “\NS-apps\ECXpert” to the end of the path.
For example, if you had specified the path c:\foo\bar\mumble as the value of the Root_ECXInstall environment variable, you would set BDGHOME as
c:\foo\bar\mumble\NS-apps\ECXpert
You do not neet to reboot the machine to have these variable settings take effect; however, only new command-shell windows will see the changes.
To set the NSBASE variable
- From the Windows NT or Windows 2000 task bar, select Start > Settings > Control Panel > System.
- In the System Properties window, select the Environment tab.
- In the Variable input field, type NSBASE.
- In the Value input field, type the full path you specified for the directory into which you installed ECXpert (Root_ECX_Install).
For example, if you had specified the path c:\foo\bar\mumble as the value of the Root_ECXInstall environment variable, you would set NSBASE as
c:\foo\bar\mumble
You do not neet to reboot the machine to have these variable settings take effect; however, only new command-shell windows will see the changes.
Starting the ECXpert Administration ServerTo start the ECXpert Administration Server
- Start up a Web browser
- Display the ECXpert Administration home page.
Enter the URL hostname:port_number, where hostname is the name of the machine on which your web server resides, and port_number is the number of the port on which your web server is listening.
The ECXpert Main Screen appears, as shown in Figure 3-25.
Figure 3-25 ECXpert Main Menu
- Save the URL to the ECXpert Main Menu as a bookmark.
- Click Admin to start the ECXpert Administration Server.
The ECXpert Administration Server is not pre-configured with password protection. Use the Sun ONE Web Server Administration interface to enable this feature, if desired.
The Management screen appears, as shown in Figure 3-26 when the ECXpert Administration Server is On. If your screen shows the ECXpert Administration Server Off, click the On portion of the button’s toggle to turn on the server.
Figure 3-26 ECXpert Administration Screen: Main Menu
- Click the UpdateScreen button to refresh the screen.
- Check that the following buttons are turned on. If they are not, turn them on now.
- Click Support in the top right corner.
- Enter the default ECXpert user name and password (ECX, ECX) as directed.
This will confirm that the directory server and database connections are functioning properly.
Enabling Special FeaturesThe following sections explain how to do the following:
Enable the Billing Code Feature
The billing code feature in this release requires customers to update the database stored procedure.
To use the Billing Code feature
- Navigate to your Oracle directory:
On Solaris
cd $BDGHOME/dbadmin/oracleOn Windows
cd %BDGHOME%\dbadmin\oracle- Start sqlplus using a command line with the following:
sqlplus myaccount/mypassword@myserver
where myaccount/mypassword@myserver is your configured account and its password.
For example:
sqlplus ECX36/ECX36@myHost
- From the sqlplus prompt, run the script:
sqlplus> @ora_pkgbody.sql
- Restart ECXpert.
Enable the AIAG Feature
ECXpert 3.6.3 supports the AIAG E-5 2000 protocol standard on the Solaris platform. If your site uses this standard for business document processing, you will need to install support for documents exchanged with this protocol. The AIAG_setup.sh script creates or purges the AIAGTransaction Table, based on which option you specify. The syntax for invoking the AIAG_setup.sh script from a Bourne shell command line is:
% AIAG_setup.sh oracle_userame oracle_password tns_alias {create|purge}
Where:
- oracle_username is the login name used to login to oracle (e.g. oracle)
- oracle_password is the password used to log in to the oracle database. (e.g. oracle.sunone)
- tns_alias is the TNS alias string used to identify the oracle instance (e.g. ORAINST.SUNONE)
- {create|purge} where the create option creates the AIAG Transaction table if it does not exist, and the purge option deletes all records from AIAGTransaction Table
Configuring TradingXpert to Run on a Different Machine from ECXpertThis section provides additional configuration tasks required if TradingXpert is installed on a machine different from ECXpert, as shown in Figure 3-27. The tasks described assume the following scenario:
- “TX Host” is the host for TradingXpert. This includes, also, the Sun ONE Application Server and an Oracle client.
- “ECX Host” is the host for ECXpert and can also host an Oracle client (if Oracle is running on a remote host).
- “Oracle Host” is the host for the Oracle database server. (Oracle might also be running locally on ECX Host.)
Figure 3-27 TradingXpert and ECXpert on Different Machines
The general procedures required to set up this configuration are detailed in the following sections for each platform.
Configuring TradingXpert to run on a machine different from ECXpert
To configure TradingXpert to run on a machine different from ECXpert
- Set up TX Host as if ECXpert were installed locally. This involves setting up a BDGHOME environment variable and mounting the ECXpert installed directory when installing TradingXpert on the TX Host machine. See Setting up TX Host as if ECXpert Were Installed Locally.
- Set up TX Host to access the Oracle database used by ECXpert (it is assumed that ECX Host is already set up to access the database). See Setting up TX Host to Access the Oracle Database Used by ECXpert.
These procedures apply to an initial installation of TradingXpert on a separate machine, or to a migration of TradingXpert away from the machine hosting ECXpert. They allow TradingXpert to submit document files to ECXpert, retrieve documents from ECXpert, and access the partnership and process tracking information stored in the Oracle database.
Setting up TX Host as if ECXpert Were Installed Locally
To set up TX Host as if ECXpert were installed locally
- Mount the ECX Host’s ECXpert installed directory structure (the directory referenced by BDGHOME) on TX Host.
- Give the TradingXpert user privileges to access (read) ECXpert’s BDGHOME/data directory.
- Install TradingXpert on the TX Host machine using the Integration Server B2B installer.
- Follow the postinstall.txt instructions for the TX Host.
This includes:
- updating the Application Server’s Instance Server Native library path to point to the ECXpert libraries installed on the TX Host
- making changes to the server.policy file for the Application Server instance on which TradingXpert is installed.
Stop and then start the Application Server for these changes to take effect.
- setting the BDGHOME and NSBASE environment variables on TX Host.
The BDGHOME environment variable on TX Host should point to the same directory as the BDGHOME environment variable on ECX Host
The NSBASE environment variable on TX Host should point to the root directory for the ECXpert installation.
- Edit the ecx.ini file on ECX Host to specify a static TCP/IP port for communication with ECXpert (this is used to submit documents to ECXpert):
- Open the ecx.ini file.
The file is located in the BDGHOME/config directory
- Modify the [tcpip-connector] section as follows:
port_location = static
admin_port_type = manual
admin_port = any unused port
listener_port_type = manual
listener_port = any unused port- Restart ECXpert for these changes to take effect.
- Modify TradingXpert’s TXproperties file on TX Host.
If you are upgrading from TradingXpert 3.6.2 to TradingXpert 3.6.3, the FXproperties file is now called TXproperties. You must run a script to migrate from the old file to the new one. For more information, see ECXpert Release Notes.
- Turn on the TXremoteSubmission property:
TX.remoteSubmission: TRUE
- Set the TXremoteECXPathPrefix property to specify the ECXpert mount point in Step 1.
This path is to be pre-pended to directory paths specified in the ecx.ini file for the retrieval of ECXpert documents. For example, if the mountpoint is /h/ECX_Host, then TradingXpert will retrieve files from ECXpert at /h/ECX_Host/BDGHOME/data...
- Restart the TradingXpert machine for environment variables and property edits to take effect.
Setting up TX Host to Access the Oracle Database Used by ECXpert
To set up TX Host to access Oracle
- Install the Oracle client on TX Host, if not already installed.
- Give the TradingXpert user privileges to access Oracle client software.
- Edit the tnsnames.ora file to reference the Oracle Server
- Check that the ORACLE_HOME and ORACLE_SID variables are properly set on ECX Host.
These entries are found in the [ORACLE_ENV] section of the ecx.ini file, locate the DB_SERVER parameter.
- Check the DB_SERVER parameter of the ecx.ini file.
In the [DB_SECTION] section of the ecx.ini file, locate the DB_SERVER parameter. If not already included, enter the following lines in the [DB_SECTION] section:
[DB_SECTION]
DB_SERVER=Oracle DB alias
DB_USER=Oracle username
DB_SERVER=Oracle passwordwhere Oracle DB alias is the Oracle database alias from the tnsnames.ora file in Step 3.
Where To Go NextIf you have installed a working instance of ECXpert, continue to the next chapter, Chapter 4, "Testing Your ECXpert Installation," to test your ECXpert installation.
If you have installed TradingXpert and the test of your ECXpert installation is successful, continue on to Chapter 5, "Testing Your TradingXpert Installation," to test your TradingXpert installation.