asked on 12/10/2014

One application ... accessing 2 different databases

Come across an interesting situation; one application is connecting to 2 different databases, where as it should connect to only one, now how to figure it out, which one is the good & correct one.

Application has different kind of users, some accessing one db, but others 2nd db, now need to figure it out, which one is the good and acceptable one.

Please advise/suggest, what should be the best possible course of action, in order to figure it out, which one is the correct one.

Need to proof this from different perspectives; data/changes, active/logged in sessions and DDL basis too.

Please guide, thanks in advance.

Linux Oracle Database SQL

Last Comment

Mushfique Khan

12/21/2014

Jim Dettman (EE MVE)

12/10/2014

<<Application has different kind of users, some accessing one db, but others 2nd db, now need to figure it out, which one is the good and acceptable one.>>

I am not sure anyone here can answer that for you. If users are writing data to two different databases each with the same tables, then neither would be correct.

It would become a job then of analyzing and merging the data between the two to get a "good" database.

Jim.

Jim Dettman (EE MVE)

12/10/2014

Note too that it may be as it was designed. There is nothing that says you cannot use more than one data source.

If each group of users do different functions, and those functions are not duplicated between the two DB's, then both are correct and needed.

Jim.

Mushfique Khan

12/11/2014

ASKER

thanks Jim, but basically there are couple of issues, I just need to tell, who is connecting from where and what users/sessions are doing on the db.

Is there any way to find all these information, some kind of logging info, we don't have login trigger, but is there any Oracle view, which can give me all these data?

SOLUTION