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)
      )
    )
  )

Note: The TNS entry supports both failover and load balancing.

Database port
Database server host name

Subtopics