Re: auditing CREATE DATABASE

Actually, there are a lot of different errors possible against the "CREATE DATABASE ...." statement.
A quick search for "CREATE DATABASE" in the Error Messages manual [9.2] returned a count of 43, of which some would be "CREATE DATABASE LINK ..."

I remember when I've entered the command "CREATE DATABASE LINKE ..." I have been given an error relating to "CREATE DATABASE" [I believe it was "ORA-02165 : invalid option for CREATE DATABASE"].

An SERVERERROR trigger would be the best way to catch "CREATE DATABASE" statements.

Unless, of course, you want to know who has created or attempted to create a database --
ie issued the command against a [then] non-existent instance. The statement would have then been logged in the instance's alert.log file, whether it be in the $ORACLE_HOME/rdbms/log or in the background_dump_dest.

Hemant

At 09:50 AM 17-10-02 -0800, you wrote:
>What a tongue-in-cheek answer: "only catches successful attempts"! I like
>his/her sense of humor...
>
>Issuing a CREATE DATABASE command against an already mounted and open
>database triggers an ORA-01501 error. If you are running Oracle8i or above,
>you could create an AFTER SERVERERROR database-event trigger to capture such
>errors and then log the occurrance in a table somewhere.
>
>Regardless of what version you are running, ORA-01501 gets logged to the
>"alert.log" file, so you can catch it that way, too...
>
>----- Original Message -----
>To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
>Sent: Thursday, October 17, 2002 10:41 AM
>
>
>Is there a way of capturing info on people who issue CREATE DATABASE
>statements?
>
>My Oracle Support technician says auditing won't catch this, only catches
>successful attempts.
>
>Regards,
>Patrice Boivin
>Systems Analyst (Oracle Certified DBA)
>
>Systems Admin & Operations | Admin. et Exploit. des systèmes
>Technology Services | Services technologiques
>Informatics Branch | Direction de l'informatique
>Maritimes Region, DFO | Région des Maritimes, MPO
>
>E-Mail: boivinp_at_mar.dfo-mpo.gc.ca
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Boivin, Patrice J
> INET: BoivinP_at_mar.dfo-mpo.gc.ca
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Tim Gorman
> INET: Tim_at_SageLogix.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).

Hemant K Chitale
My web site page is : http://hkchital.tripod.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hemant K Chitale
  INET: hkchital_at_singnet.com.sg

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).