Oracle Configuration Guidelines

  • ODBC versions are neither forward nor backward compatible.
  • Database aliases configured on the client node should also be configured on the server node.

Note: Configuring the aliases on both nodes helps avoid confusion about the database name.

  • The Oracle server's IP address must be in the CIMPLICITY computer's HOST file if DNS or Wins resolution is not being used.
  • In the ODBC Datasource Administrator dialog box, use the Microsoft ODBC for Oracle Driver and enter the database alias name in the Server Name field.
  • Starting with Oracle 9i, the Oracle services are started by default.