Pages

Wednesday, April 6, 2016

The .DBC File In Oracle Applications

The .DBC File In Oracle Applications

The .dbc file is mostly used to define database parameters, stands for database connect descriptor file, used to connect to database, it authenticate users against database in FND_USER table.

Let’s check how it work’s

The .dbc file is actually the database connector descriptor file used to connect to database and this file is by-default located in $FND_TOP/secure directory, this file is quite important as whenever any program likes to connect to database like forms, it uses .dbc file where there you find the Guest_user_pwd, when the guest user connect it does not allow it to directly connect to the database but it first connect goes via this file and cross verify the password of the guest which is kept in this file.

Webserver checks that username and passwords need to authenticate against database FND_USER table, so it needs first some user to check client’s username password in database, it uses ( GUEST/ORACLE have you ever noticed why this user is there, Hope you know it now it Uses Guest User to autenticate your user in database )

This file is in directory $FND_TOP/secure also called as FND_SECURE

Location of dbc file in 11i

cd $FND_TOP/SECURE OR $FND_SECURE

Location of dbc file in R12

cd $INST_TOP/appl/fnd/12.0.0/secure

Things that we need to look for in .dbc file:

GUEST_USER_PWD –> (Guest username & passwd)
APPL_SERVER_ID –> Used to Identify the Databse by Server ID
GWYUID–> (APPLSYSPUB user name and passwd)
DBhostname
dbport

Other than this there are some of other things that will be there in dbc file . which wil impact the
Performance

applmgr@acer ACER_acer]$ grep -i fnd acer.dbc
FND_JDBC_BUFFER_DECAY_INTERVAL=300
FND_JDBC_BUFFER_MIN=1
FND_JDBC_BUFFER_MAX=5
FND_JDBC_STMT_CACHE_FREE_MEM=TRUE
FND_JDBC_STMT_CACHE_SIZE=200
FND_MAX_JDBC_CONNECTIONS=500
FND_JDBC_USABLE_CHECK=false
FNDNAM=APPS
FND_JDBC_PLSQL_RESET=false
FND_JDBC_CONTEXT_CHECK=true
FND_JDBC_BUFFER_DECAY_SIZE=5

These Are The Default values.. sometimes these values will effect the performace.

Example:









No comments:

Post a Comment