Recreating DBC file

Posted by Vasudev Seeram on November 22, 2006 Leave a comment (0) Go to comments

Problem: While installing vision instance, the post-install check “JSP Check” fails with the message “DBC file may be invalid”.

Solution: Recreate DBC file.

Note: Run these commands from $FND_TOP/secure. Also, source environment file first.

To create a DBC file and server ID:
java oracle.apps.fnd.security.AdminAppServer apps/apps@vis ADD FNDNAM=apps GWYUID=applsyspub/pub TWO_TASK=vis SECURE_PATH=%FND_TOP%secure GUEST_USER_PWD=guest/guest APPS_JDBC_DRIVER_TYPE=THIN DB_HOST=eam.clientnetwork.com DB_PORT=1522

To check status:
java oracle.apps.fnd.security.AdminAppServer apps/apps@vis STATUS DB_HOST=eam.clientnetwork.com DB_PORT=1522

To delete DBC file:
java oracle.apps.fnd.security.AdminAppServer apps/apps@vis DELETE DB_HOST=eam.clientnetwork.com DB_PORT=1522

Also, you can run adgendbc.sh, located in $COMMON_TOP/admin/install/

For Database Connectivity problems, ensure that the hosts file is set up properly:

127.0.0.1 localhost.localdomain localhost hostname.domainname hostname

On Windows, use java. On Linux/Unix, use JRE.

Reference:
Metalink Doc ID: 108865.1 (How To Create a Database Connection(DBC) File and Troubleshooting Common Problems)