LOCATION :
11i dbc file is in $FND_TOP/secure
The R12 dbc file is in $INST_TOP/appl/fnd/12.0.0/secure, and only contains the APPLSYSPUB and guest passwords.
SIGNIFICANCE :
IMPORTANT POINTS :
> stands for database connect descriptor file
> To check dbc connectivity :
jre -v oracle.apps.fnd.security.AdminAppServer apps/<PASS> STATUS dbc=<DBC-FILE-PATH>
> To test the validity of the DBC file, try to run the Setup Test.
How to run the Setup Test
-------------------------
Type the following in your browser:
http://<hostname>:<port number>/OA_JAVA_SERV/oracle.apps.fnd.security.SetupTest
It checks the following:
1. The jdbc class files and library files have been added to the CLASSPATH and LD_LIBRARY_PATH.
2. System property APPS_OCI_LEVEL=7 has been set in the web server.
3. The $FND_TOP/secure directory has been setup correctly.
4. The file OA_JAVA/oracle/apps/env.html exists and contains the value of FND_TOP.
5. The DBC files have been setup correctly.
6. The value of GUEST_USER_PWD in all the DBC files is correct.
7. The right version of the JDBC Driver is installed
The results are displayed on the browser screen. If something is wrong, suggestions to correct it are displayed. Please follow them and retry the test until it reads Everything looks OK.
FILE :
#########################################################################################################
#DB Settings
#Tue Apr 14 14:34:24 EDT 2009
GUEST_USER_PWD=GUEST/ORACLE
Guest is an application user
#APPL_SERVER_ID=6788134EFF001D8EE04400306E0EB28552166210225567458681948764911469
FND_JDBC_BUFFER_DECAY_INTERVAL=300
APPS_JDBC_DRIVER_TYPE=THIN
The type of JDBC driver that should be used.
The default is the OCI (THICK) driver. For Release 11i, you MUST use the THIN driver.
FND_JDBC_BUFFER_MIN=1
GWYUID=APPLSYSPUB/PUB
FND_JDBC_BUFFER_MAX=5
APPS_JDBC_URL=jdbc\:oracle\:thin\:@(DESCRIPTION\=(LOAD_BALANCE\=YES)(FAILOVER\=YES)(ADDRESS_LIST\=(ADDRESS\=(PROTOCOL\=tcp)(HOST\=tned35nv.adr.corp.com)(PORT\=1553))(ADDRESS\=(PROTOCOL\=tcp)(HOST\=tned36nv.adr.corp.com)(PORT\=1553))(ADDRESS\=(PROTOCOL\=tcp)(HOST\=tned38nv.adr.corp.com)(PORT\=1553)))(CONNECT_DATA\=(SERVICE_NAME\=qat.adr.corp.com)))
FND_JDBC_STMT_CACHE_FREE_MEM=TRUE
FND_JDBC_STMT_CACHE_SIZE=200
TWO_TASK=qata
FND_MAX_JDBC_CONNECTIONS=500
Maximum number of open connections in the JDBC connection cache. This number is dependent on the amount of memory available, the number of processes specified in the init.ora file of the database.
FND_JDBC_USABLE_CHECK=true
FNDNAM=apps
FND_JDBC_PLSQL_RESET=false
FND_JDBC_CONTEXT_CHECK=true
FND_JDBC_BUFFER_DECAY_SIZE=5
DB_HOST=tned35nv.adr.corp.com
The host machine on which the database resides.
DB_PORT=1553
The port of the database.
==========================================================================================================
# $Header: template.dbc 115.4 2000/04/20 11:50:57 pkm ship $
# TEMPLATE.dbc
# Template database configuration file.
#
# Create one copy of this file for each database instance this
# Applications Server will connect to. Each file should have the name
# <database_instance_name>.dbc
# and be located in this directory ($FND_TOP/secure).
# Change each of the parameters below to values appropriate for
# the database instance. Do not change the syntax.
#
# This file can be gererated using the AdminAppServer tool.
# This is a java utility that can be run from the command line.
# Instructions to use this tool are documented in the Applications
# Sysadmin Manual.
#
# TWO_TASK
# SQL*Net name of database.
#
TWO_TASK=database
#
# FNDNAM
# Oracle User to be used for Oracle Applications connection.
# The FNDNAM Oracle User must have Oracle Applications privilege level
# 'Universal'.
#
FNDNAM=APPS
#
# GWYUID
# Oracle User/Password of the public account to be used for initial
# Oracle Applications connection.
# The GWYUID Oracle User must have Oracle Applications privilege level
# 'Public'.
#
GWYUID=APPLSYSPUB/PUB
#
# GUEST_USER_PWD
# Applications User/Password of the Guest user.
# The Guest Applications User is a public Applications user
# with no responsibilities assigned. If no such user exists,
# create one in the 'Define User' form. Do not use a user with
# any active responsibilities. Note: This parameter is for
# an applications user NOT an Oracle user. The Guest user
# is seeded with 11i.
GUEST_USER_PWD=GUEST/GUEST
# THE FOLLOWING PARAMETERS ARE RELEVANT ONLY
# IF JDBC IS BEING USED. IF THEY ARE NOT SUPPLIED, DEFAULTS
# WILL BE USED.
# APPS_JDBC_DRIVER_TYPE
# The type of JDBC driver being used. If no value is supplied,
# the thick (OCI) driver will be used. Give a value of THIN
# or THICK depending on the type of JDBC driver to be used.
# For a detailed discussion on the THIN vs the THICK driver,
# refer to the JDBC documentation. For Release 11i , this
# should be set to a value of THIN.
APPS_JDBC_DRIVER_TYPE=THIN
# DB_HOST
# The host machine on which the database resides. This parameter
# is required only if the THIN DRIVER is being used.
DB_HOST=host_name
# DB_PORT
# The port of the host machine on which the database resides.
# This is required only if the THIN driver is being used.
DB_PORT=port_number
# DB_NAME
# Database instance name.
# This is required only if the THIN driver is being used.
# If no value is provided, the TWO_TASK is used.
# DB_NAME=db_name