Setting up the database

Before you begin, make sure that:

• The Oracle database is installed. For more information, see the documentation for Oracle.

• You have the createORA.sql file provided by your Lexmark representative.

Notes:

• A fresh installation of Fleet Tracker version 4.1 generates a self-signed certificate with a validity of 10 years. A fresh installation also lets the system run on the SSL port using the self-signed certificate. For more information on securing server communication, see Securing server communication.
• The PostgreSQL version 11.3 database is installed automatically when installing Fleet Tracker version 4.
• When using an older version of the PostgreSQL database, updating Fleet Tracker to version 4 also updates the database to version 11.3.
• When you install the Oracle database, make sure that the Global Database Name and the System Identifier (SID) are the same.
• Note the Global Database Name, URL or IP address, user name, and password. These data are required during the Fleet Tracker installation.
• Make sure that the Oracle administrator account and password are set up during the Oracle installation.

Before you install Fleet Tracker, create two database schemas by doing the following:

1. Save the createORA.sql file to a temporary directory.

2. Run the command prompt as an administrator.

3. At the command prompt, navigate to the temporary directory, and then type the following:

   sqlplus oracleadmin/oraclepassword @createORA.sql ID PW

   Where ID and PW are the database user ID and password. The Fleet Tracker server uses these credentials to access the database. Do not use the same administrator credentials for the Fleet Tracker server or the Oracle server.

Notes:

• The Oracle script creates two Oracle users needed for the Fleet Tracker installation. After running the script, make sure to restart the Oracle server.
• The password expiration policy of the database affects the frequency of revalidating your database account.