CODEWITHSUNDEEP
databaseoracle-database
Andrew
Andrew

Reputation: 9

how do i determine oracle database name of data source

I've been searching around and haven't found anything on my scenario that I understand:

I have a list of all of the Oracle databases and corresponding servers that my company owns (about 80 servers 150 databases). I am trying to figure out which one a specific file is being downloaded from (from a webpage).

I am mechanical engineer, not in software so if you could eli5 that would be very helpful.

Specifically I need the SID name, but figuring out the server name would also be helpful.

Upvotes: 1

Views: 161

Answers (1)

Jegg
Jegg

Reputation: 549

Your question is kind of tricky here. if your downloading the file from web application(I assuming it is a Java webapp), oracle database could act as either the data store or a report server that can generate the oracle reports directly

In the first case, you need to find out if what kind of file you are downloading? is it a PDF? is it a excel file? or just text file or anything? the best idea is to check out the file link and then decide what software generating this file. it could be any software in back end to generate the file like, POI(for generating excel file), or even a direct file link, but not oracle at all.

Also, In this case, the file is usually generated at backend by server-let. You need ask the developer which report or file generating engine they are employing. and if oracle database is also being used, it is usually providing the data fro that report or file engine.

In the second case, you can just check out the the URL and give it to the webmaster asking them which oracle server it is using. it is usually configured in the web server.

Upvotes: 2

Related Questions