r12.2

[satish]

Hi Erman,

In EBS R12.2,How the jdbc connections are established.Is this using apps_jdbc_url from dbc file or using url in datasource?

Thank you

[ErmanArslansOracleBlog]

What jdbc connections are you talking about exactly?
In EBS, we have multiple components that connect to the database..
please revise your question accordingly.

And what is your issue with these jdbc connections?

[satish]

Hi Erman,

Take oacore as an example,will this use url parameter from EBSdatasource or use apps_jdbc_url from dbc file?

[satish]

In r12.1.3,oacore use apps_jdbc_url from dbc file to connect but in r12.2 will it uses jdbc url from datasource or from dbc file?if it uses from datasource then what is the use of dbc file in r12.2?is it only used during mail login process.can you clarify..

[ErmanArslansOracleBlog]

Datasources of EBS, which is used by Weblogic Manage servers use directly the APPS schema. Apps schema credentials are there in  the datasource/connection pool.

a dbc file is used to authenticate EBS(fnd_user). There is no need for that in case of a EBS datasource.

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.

As for jdbc urls , again -> EBS is a big application system, the connection style and connection type differ from one component to another.

[satish]

When datasource is targetted on forms server,why it will use dbc file for connection?

It will take connection from datasource and not dbc file right?

[ErmanArslansOracleBlog]

Which server are you talking about? Tell me the name

[satish]

you said forms/login will use dbc file right.forms will use jdbc from datasource and not dbc file?can you correct if it wrong

[ErmanArslansOracleBlog]

Basically, dbc+datasource should be available for forms services to work.
Forms services means forms servlet + forms runtime process.

So, in weblogic, you need to have the datasource up&ready.
In the apps tier filesystem, you need the dbc to be there.

Don't try to separate these connection things.
If you have a problem with form, then first go to weblogic and ensure the datasource is okay and your forms WLS server is up & running. Then you go to the apps node and check your dbc.

Also, ofcourse, there are plenty other reasons that can make forms services to fail.

[satish]

Good explanation

I think forms runtime processess will use dbc file?am i right

[ErmanArslansOracleBlog]

Answering this specific question requires detailed analysis, because it is not documented and we don't have the source code of forms server and the runtime process.

What I can tell you is, "oacore" uses dbc.. I mean oacore WLS managed server named oacore_server uses dbc and datasource, both.
I concluded that by using lsof command. lsof|grep <SID>.dbc showed me that oacore was using the dbc file..
However, I could not see the same lsof output for forms ( both for forms runtime and forms WLS server processes)

But, again as I said already; dbc+datasource should be available for forms services to work.
Forms services means forms servlet + forms runtime process.

So, in weblogic, you need to have the datasource up&ready.
In the apps tier filesystem, you need the dbc to be there.

Don't try to separate these connection things.
If you have a problem with forms, then first go to weblogic and ensure the datasource is okay and your forms WLS server is up & running. Then you go to the apps node and check your dbc.

[satish]

Thanks for your time