This blog contains different things for Oracle DBA, APPS DBA and Middleware technologies. All these things should be tested first on test environments before applying in the Prod environments, please follow the standard Change control to apply all the PreProd and Prod changes. Also to make this blog more useful, please give your comments and share your experience. Thanks
Search This Blog
Friday 25 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.
Subscribe to:
Posts (Atom)
Oracle 19c - patch 19.22 unavailability for Windows platform
Oracle 19c - patch 19.22 unavailability for Windows platform Having upgraded the Oracle 11g 11.2.0.4 database to Oracle 19c 19.3.0.0.0 whi...
-
Oracle 12c Installer error - [INS-10102] Installer initialization failed - no oraInstaller in java.library.path - make sure oraInst.lo...
-
Introduction: We use EMC BCV feature to clone our production database, and it was all working fine, but suddenly we started getting the erro...
-
Oracle 12c install error - Oracle Net Configuration Assistant keep searching the listener ports The installer will stuck on the Oracle Net ...