Configuration of Oracle Database

To configure the Oracle database, use the Oracle Configuration Assistant. Consult your Database Administrator on standard practices followed by your IT department to change the recommended structure according to your needs.

Prerequisites

• Ensure that all required environment variables are set. See Environment Variables.
• Ensure that Oracle Client Software Developer Edition or Enterprise Edition is installed on the computer hosting the application server ().
• Ensure that the sqlldr utility is available.
• Use the latest driver provided by Oracle.
• A valid and tested connect string should be present in the TNSNAMES.ora file. For example, the connection URL: jdbc:oracle:oci:@ORACLERAC

  where ORACLERAC is the TNS entry in the client’s TNSNAMES.ora file and oci drivers are used to support TAF.

TNSNAMES.ora file (client)

ORACLERAC =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hostname1.domainname.com)(PORT =       1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = hostname2.domainname.com)(PORT =       1521))
    )
    (FAILOVER=on)
    (LOAD_BALANCE = ON)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

• Database port
• Database server host name