HOW TO CREATE DBC FILE IN ORACLE APPS R12 EBS?

 

   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.

DBC file is quite important as whenever Java or any other program like forms want to connect to database it uses dbc file.

For OAF page development, we need to get the DBC file of development environment.


Method 1:

On Application Node 

Navigate to $INST_TOP/admin/install directory and run adgendbc.sh script.

It will generate .dbc file under $INST_TOP/appl/fnd/12.0.0/secure

Spool:

[applprod@nadhans install]$ sh adgendbc.sh

adgendbc.sh started at Wed Aug 25 10:18:44 EDT 2021


Enter the APPS username: apps

Enter the APPS password:

SQL*Plus: Release 10.1.0.5.0 - Production on Wed Aug 25 10:18:52 2021

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter value for 1: Enter value for 2: Enter value for 3: Connected.
[ APPS_DATABASE_ID ]
Application Id : 0
Profile Value  : NADHAN
Level Name: SITE
INFO           : Updated/created profile option value.
.

PL/SQL procedure successfully completed.


Commit complete.

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters and Automatic Storage Management options


==============================
* * * * DBC PARAMETERS * * * *
==============================
fnd_jdbc_buffer_min=1
fnd_jdbc_buffer_max=5
fnd_jdbc_buffer_decay_interval=300
fnd_jdbc_buffer_decay_size=5
fnd_jdbc_usable_check=false
fnd_jdbc_context_check=true
fnd_jdbc_plsql_reset=false

====================================
* * * * NO CUSTOM PARAMETERS * * * *
====================================

Unique constraint error (00001) is OK if key already exists

Creating the DBC file...
Application server ID already exists for this host - loading..
ADD executed successfully - /ua1001/app/inst/apps/NADHANS_prod/appl/fnd/12.0.0/secure/NADHANS.dbc

Updating Server Security Authentication
AUTHENTICATION SECURE executed successfully - $FND_SECURE/NADHANS.dbc

adgendbc.sh ended at Wed Aug 25 10:19:03 EDT 2021

adgendbc.sh exiting with status 0
ERRORCODE = 0 ERRORCODE_END


Method 2:

On Application Node 

java oracle.apps.fnd.security.AdminAppServer apps/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=nadhans.com DB_PORT=1521


Method 3:

We can also do it Via Browser URL.

In case, if we don’t have access to the server we can get it with other easy way.
Open a web browser and go to the homepage Application URL and append “/OA_HTML/jsp/fnd/aoljtest.jsp” to it like below.


This will open the page and enter the required details.
If all the details are correct entered you will get an overview page with all details, and at bottom of screen you will get a link “Enter AOL/J Setup Test”. click that link.

This will redirect you to page from where you can Locate DBC file under connection test from left side Menu list.

On the right side you will get the contents of the DBC file. Copy/paste this to a VISION.dbc file and place it in your JDeveloper JDEV_USER_HOME/dbc_files/secure.