Is there an easy way to find out how many Oracle databases my company is running?
Going to Reports is the easiest way. You have several options to choose from in the reports menu.
I would start with the "All Oracle Databases" report. Once opened, you can also add columns from the column selector to customize your view.
As a general observation, please be aware of the difference between database and database instance. The term database and instance are closely related, but don't refer to the same thing.
The database is the set of files where the application data (the "reason" for the database) and meta data are stored.
An instance is the software (and memory) that Oracle uses to manipulate the data in the database. in order for the instance to be able to manipulate the data, the instance must open the database. A database can be opened (or mounted) by more than one instance, however, and instance can open at most one database.
From a licensing perspective it is more usefull to understand where your instances are running and what they are doing. You may be using functionality that requires a seperate license.
One way is to check in the Oracle Enterprise Manager, which comes free with any full use Oracle Database license and can be used to manage all Oracle databases. This will generally give you a good overview of the number of instances that a company has running.
A very good question.^
As I recall it, Snow cannot find Oracle databases (out of the box)
Probably because it is difficult/imposible to recognize an Oracle DB installation.
(some DB has a instance name that can be changed and then you end with an .exe file with a custom name)
Now I can see one standard report in my updated Snow SLM: Discovered Oracle database installations
Describtion: "Shows inventoried computers that potentially have an Oracle database installation and are not managed by the Oracle Management Option (OMO)"
Nice, I would have liked this when I had the need one year (or more) ago.
It seem to be looking at some .exe files that do not require a license, as fx tnsping.exe, oracle sql plus, developer
We tried OMO but that requires JAVA!!! A limitation we could not accept.
The devil is in the detail on this.
Yes the Snow agent requires JAVA to run the Oracle Scanner, but this can be executed remotely - i.e. The Servers in Question are scanned using Zero Footprint. Thus the remote server has Java, and remotely connects to each server and runs the scan
Retrieving data ...