Database Connectivity - Multi-User Oracle 2-Tier

Database Settings - Database Connectivity - 2-Tier Oracle

Database Connectivity

Connection Type

When connecting to the Oracle database, you can use the Native OCI Oracle Client or simple TCP/IP to communicate with the database. TCP/IP requires a little more information for connectivity but does not require the installation of an Oracle client. If you already have an Oracle client setup, we suggest the OCI method. Both connections should work identically.

- If using TCP/IP:

Oracle SID: Enter the SID for your IndySoft database.

Host IP: Enter the IP Address of the Oracle server (this is not required for an OCI connection)

Port: Enter the Port # you will use to communicate with your Oracle server. The default is 1521. (this is not required for an OCI connection)

- If using OCI:

Oracle SID: Enter the SID for your IndySoft database.

Home Name (Optional): Enter the Home name of the Oracle server

Database User I.D. - Enter the Oracle username that should be used for logging in to the Oracle database. Note: this login differs from the user name input from the IndySoft login screen (when logging into the main screen). IndySoft has its own user list maintained in the Profile Manager. This is the actual Oracle user name that IndySoft will use 'behind the scenes' for connecting to the database. It is suggested that this username be set to the owner of the IndySoft database objects in Oracle.

Database Password - Enter the password associated with the 'Database User ID' above to connect to the IndySoft Oracle database. Note that this password is encrypted when saved locally.

Show Encrypted Version of Password

Use this button to display a dialog that lists an encrypted version of the currently input password (setting above). This encrypted password is a unique text value that can be used to pass along the password to other IndySoft users - so they can set up their Workstation Setup database connectivity without knowing the actual Oracle database password. When this button is pressed, the following dialog (example) will display.

Note that the encrypted password is copied to the Windows clipboard. Pass along this encrypted password text to other IndySoft users - be sure to remind them to check the 'Encrypt Password' checkbox (described below) when using this password text.

Encrypt Password - Turn on this checkbox if you have pasted in an encrypted password that was created from the 'Show Encrypted Version of Password' button (likely created from a different workstation)

Hour Difference From DB Server - if your client installation runs in a different time zone than the database server, you should enter the hour difference here. This setting is essential for client caching to function correctly. This value should be left at zero if you are in the same time zone as the database server. If you are on the West Coast and the database is on the East Coast, you would be 3 hours behind and should enter -3 into this field. The hour difference should be a positive number if you are ahead of the database server location.

If you want to test the connectivity based on the previously entered options, press the 'Test Connection' button. If your connection is successful, you will see a confirmation. If an error occurs, you will also be alerted.

Optional Database Options
Modifying these settings is typically unnecessary - please do not modify them unless instructed by your System Administrator.

Database Date Format - this field stores the default date format used by your database.

Database Time Format - this field stores the default time format used by your database. (This should almost always be the same as the default database date format)

Database Owner Name - this field stores a database owner name that will be prefixed onto any table name reference from within IndySoft. This field defaults to the standard default owner name.

Database Functions Owner - this field stores a database owner name that will be prefixed onto any function reference from within IndySoft. This field defaults to the standard default owner name.

Database Date Initialization - this field stores an optional initialization string for your database's date format. |