What is .dbc file , where is it stored , what is the use of .dbc file ?

dbc as name says is database connect descriptor file which stores database connection information used by application tier to connect to database.

This file is in directory $FND_TOP/secure also set as environment $FND_SECURE.

#DB Settings
GUEST_USER_PWD=/ fnd_jdbc_stmt_cache_free_mem=TRUE
APPL_SERVER_ID=5D375CF531C0679FE044001A4BF0987654384481115129413024583113739894
APPS_JDBC_DRIVER_TYPE=THIN
fnd_jdbc_buffer_decay_interval=300
fnd_jdbc_usable_check=false
fnd_jdbc_plsql_reset=false
GWYUID=/ fnd_jdbc_buffer_min=1
APPS_JDBC_URL=jdbc\:oracle\:thin\:@(DESCRIPTION\=(LOAD_BALANCE\=YES)(FAILOVER\=YES)(ADDRESS_LIST\=(ADDRESS\=(PROTOCOL\=tcp)(HOST\=www.abc.com)(PORT\=1521)))(CONNECT_DATA\=(SERVICE_NAME\=ORADB)))
fnd_jdbc_buffer_max=5
FND_JDBC_STMT_CACHE_SIZE=200
TWO_TASK=ORADB
FND_MAX_JDBC_CONNECTIONS=500
fnd_jdbc_context_check=true
FNDNAM=APPS
fnd_jdbc_buffer_decay_size=5
DB_PORT=1521
DB_HOST=www.abc.com

This file could save our Oracle Apps DBA job in the end of the day. Remember to backup before you make any changes to .dbc files

Related Posts

• Oracle SQL Trace File And Explain Plan
• Oracle Applications Management Query