The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.
COURSE of the MONTH
13 days, left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
One application ... accessing 2 different databases
Posted on 2014-12-10
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.
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.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
3
2
2
7 Comments
Active today
<<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.
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.
Active today
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.
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.
Active 3 days ago
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?
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?
Active today
v$session will tell you about existing sessions.
There are many columns in that view but the basics about what you are asking is here:
select username,program,machine,o
The online docs will explain the rest of the columns.
The listener.log file on the database server should show all connections over time and not just the current ones.
Unless you have auditing turned on I don't think you can get the rest of the information you are wanting.
There are many columns in that view but the basics about what you are asking is here:
select username,program,machine,o
The online docs will explain the rest of the columns.
The listener.log file on the database server should show all connections over time and not just the current ones.
Unless you have auditing turned on I don't think you can get the rest of the information you are wanting.
Active 3 days ago
Can see log.xml file under listener log folder, how to find stuff from there? Or is this the correct file?
Active today
There are many ways to view an XML file. For example: Internet Explorer should be able to open it. As far as extracting data from it, there are also many tools that will allow you to parse an XML file. You just need to find one that will work for you.
All that said:
look up a directory level from where the log.xml file is and you should see a trace folder. In there is the old style listener.log that that is plain text and can be opened with just about anything.
All that said:
look up a directory level from where the log.xml file is and you should see a trace folder. In there is the old style listener.log that that is plain text and can be opened with just about anything.
Featured Post
Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Google Drive is extremely cheap offsite storage, and it's even possible to get extra storage for free for two years. You can use the free account 15GB, and if you have an Android device..when you install Google Drive for the first time it will give…
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
- Query Syntax
- SQL
- Databases
- MySQL Server
- MongoDB
- NoSQL Databases, Percona
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Get a first impression of how PRTG looks and learn how it works. This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
- Linux
- Windows OS
- Networking
- Paessler
- Network Management
- Network Analysis, Network Operations
Suggested Courses
Course of the Month13 days, left to enroll
777 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.