Saturday 26 June 2010

dbc file recreation for Oracle APPS R12

Introduction: In this post, we would see how can we create the "dbc" file, if it is missing for some reason. Cookbook: The "dbc" file location in Oracle APPS R12 is $FND_SECURE. If for some reason it is missing or invalid, then it can be recreated. Following is the command which can be used to recreate the "dbc" file. java oracle.apps.fnd.security.AdminAppServer apps/apps ADD FNDNAM=apps GWYUID=applsyspub/pub TWO_TASK=VIS SECURE_PATH=$FND_TOP/secure GUEST_USER_PWD=guest/oracle APPS_JDBC_DRIVER_TYPE=THIN DB_HOST=appsdemo.test.com DB_PORT=1531 The only thing needs to be taken care is replace the values with respect to the environment, like the values for $FNDNAM, hostname, port number etc.

 Oracle Weblogic 12.2.1.3.0 60820: Select a domain which is a compatible with this environment. stopComponent.sh and start Component.sh give...