Create/Check dbc file in r12

Create/Check DBC file


· (Hostname_SID).dbc not (Context Name).dbc file exist on both the nodes in application Tier.

· This File exists in $FND_TOP/secure

· Login as Application user (On both the nodes)

· When you create a file it’s name is .dbc. You might need to copy it as .dbc .



java oracle.apps.fnd.security.AdminAppServer apps/ STATUS DB_HOST== DB_PORT=1521 DB_NAME=DBC=.dbc


OUTPUT


Database Server

---------------

DATABASE_ID:

AUTHENTICATION: SECURE

Application Server

------------------

APPL_SERVER_STATUS: VALID/INVALID

APPL_SERVER_ID:051D72DC25AE30D5E0440003BAA9A29B24326414774079047273642913323149


· To Create the DBC File


o echo $FNDNAM

This will give the value for FNDNAM. In our case it gives ‘APPS’

o There should be no space on both side of ‘=’

o This will create a file .dbc. You might need to copy it as .dbc .


java oracle.apps.fnd.security.AdminAppServer apps/ ADD FNDNAM=apps GWYUID=applsyspub/pub TWO_TASK= SECURE_PATH=$FND_TOP/secure GUEST_USER_PWD=guest/oracle APPS_JDBC_DRIVER_TYPE=THIN DB_HOST= DB_PORT=1521

With more options
java oracle.apps.fnd.security.AdminAppServer
apps/apps
ADD FNDNAM=apps
GWYUID=applsyspub/pub
TWO_TASK=TEST
SECURE_PATH=$FND_TOP/secure
GUEST_USER_PWD=guest/oracle
APPS_JDBC_DRIVER_TYPE=THIN
DB_HOST=
DB_PORT=

For 11i.

Ref:
http://bysanirajesh.blogspot.com/2012/08/dbc-file-administration.html