R12.2

[satish]

Hi erman,

We would like to know the importance of dbc file in R12.2,as we have  datasource for connections.

[ErmanArslansOracleBlog]

Here is 2 definitions of it.
Reference: oracle

A .dbc file is a text file which stores all the information required to connect to a particular Oracle Applications instance.

The .dbc file is contained on the web/applications server and holds information used by the database for authentication. The web/application server passes the information from the .dbc file, as well as login information, to the database server to authenticate the user. The authentication process is handled by the standard applications security feature.

[ErmanArslansOracleBlog]

It is a matter of choice to connect to the database using a dbc file.
It comes by design.
Some of the utilities in EBS, uses it to connect to the database. Like forms, like login page.
It provides you apps-style login.

For example, when we install HR ORG Chart, we provide a dbc file and a jar that is able to use it.
Using this jar, dbc file, HR ORG Chart can login to EBS using an FND User.

[ErmanArslansOracleBlog]

Also, a typical entry in dbc file is GUEST_USER_PWD .
So, you guess. When there is no apps session, apps authentication, Guest user is used.
so, dbc is needed there.

The code reads the guest and other values stored in dbc, thus it does the apps authentication. apps authentication here means fnd_user authentication, I mean Application User authentication.
Once authenticated, the database connection is built with the Apps db user anyways.

[satish]

Thanks for the update, guest is an application user and it is used to decrypt the apps password when ever required.Not sure if the initial login page need apps user/password.

The initial login page require db connection and applsyspub db user from Dbc file is used.

Also in R12.2,is there any use of fnd Max jdbc connections,fnd min jdbc connections in Dbc file because we are setting up the connection pool in datasource

Thanks,
Satish. G

[ErmanArslansOracleBlog]

Reference: Practical Oracle E-Business Suite (book)

Pool sizes can be tuned for JDBC connections, stateless session Enterprise Java Beans (EJBs ), and
 Message Driven Beans (MDBs ). Setting the pool sizes to the optimal values may increase the performance
of FMW, as it will avoid the delays created by the pooling activities. In this manner, as for the JDBC data
sources, you can increase the Maximum Capacity of Connection Pools setting to handle the probable
peaks in the concurrent connections, and you can also configure the connection pool to initialize all its
connections at server startup to avoid connection creation delays.

[satish]

In R12.1.3,we use dbc file for connection pool like fnd Max jdbc connection,fnd jdbc min connections,fnd buffer decay interval etc. But in R12.2 we have datasource where we configure connection pool. So in R12.2 dbc parameters which are mentioned above can be left at default values that comes with installation right?if yes there is no importance for these parameters in R12.2?

Thanks

[ErmanArslansOracleBlog]

EBS 12.2 uses FMW and that method you are mentioning is not directly applicable to EBS 12.2.

It is not documented, as well.
However, you can make fnd Max jdbc connection aligned with the connections pool's max size. (fnd min to connection pool's min size and etc..) I think, this will be a good move and it will be harmless.