What an interesting requirement. I won't ask why you feel the need to be
alerted to such a thing -- doubtless you have good reasons, and most likely
I don't want to know what they are. :-)
I am not personally aware of any monitoring tool that will detect -- let
alone alert on -- the sudden appearance of a previously unknown database.
On UNIX, you could implement a custom monitoring script by checking for the
sudden appearance of a new shared memory segment, but that would be highly
unreliable, I think. Perhaps it would be better to watch for the
appearance of a new "PMON" process tied to a previously unknown
ORACLE_SID. Of course, that would fail to alert in cases where somebody
has created a "new" database but reused an old (e.g., "retired") ORACLE_SID.
On Windows, I guess you would need to check for the appearance of a new
database "service".
If you implement your check this way, it will be *almost* version
independent. Although 12c with the CDB/PDB architecture will probably
cause you grief. (Do you need to be able to report on new PDBs?)
On Tue, Apr 28, 2015 at 4:03 PM, Jeff Chirco <backseatdba@xxxxxxxxx> wrote:
What would be the best way to get an alert anytime a database is created
on a particular server. Is something like this possible from EM 12c, or
any other way.
Oh and currently this for checking against Windows 2008 servers, 11g.
Thanks,
Jeff