...
- Replace **HOSTNAME** with database host name.
- Replace **PORT** with database listener port.
- Replace **SERVICE_NAME** with database service name.
- Replace **FD_ADMIN_PASSWORD** with password of fd_admin.
Key Points
...
- URL must be in the format listed in the example, the JDBC short format of host:sid:port should not be used.
...
- If RAC is used for the database, multiple nodes can be listed in the address list of the URL or it can point to the scan listener for the cluster. Example:
alias =(DESCRIPTION = CONNECT_TIMEOUT=120) (RETRY_COUNT=20) (RETRY_DELAY=3) (TRANSPORT_CONNECT_TIMEOUT=3) (ADDRESS_LIST =(LOAD_BALANCE=on) (ADDRESS = (PROTOCOL = TCP) (HOST=primary-scan) (PORT=1521))) (ADDRESS_LIST =(LOAD_BALANCE=on) (ADDRESS = (PROTOCOL = TCP) (HOST=secondary-scan) (PORT=1521))) (CONNECT_DATA=(SERVICE_NAME = gold-cloud)))-
- Type and factory must reference the UCP driver.
...
- Set CONNECT_TIMEOUT to a high value to prevent logon storms.
...
- DO NOT use RETRY_COUNT without RETRY_DELAY
...
- Set LOAD_BALANCE= ON per ADDRESS_LIST to balance SCANs
...
- Use one DESCRIPTION and more than one causes long delays