Logo Background

.dbc File Location In Oracle Applications

  • By on March 31, 2009 | No Comments

    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

    Previous
    Next
    » FND_TABLES Table Name, FND_COLUMNS Column Name
Leave a Comment