Yes "ALTER SYSTEM ... " is logged in alert.log,
But you can also see it in "update_comment " column of v$parameter
Igor Neyman, OCP DBA
ineyman@(protected)
-- --Original Message-- --
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] On Behalf Of Post, Ethan
Sent: Friday, February 20, 2004 10:46 AM
To: oracle-l@(protected)
Subject: RE: Shooting yourself in the spfile
Wouldn 't it be in the alert logs?
-- --Original Message-- --
From: Igor Neyman [mailto:ineyman@(protected)]
Sent: Friday, February 20, 2004 9:11 AM
To: oracle-l@(protected)
Subject: RE: Shooting yourself in the spfile
Actually you don 't have to have Word document to keep track of changes.
There is "UPDATE_COMMENT " column in v$parameter, and you set it
"COMMENT " clause when you run
ALTER SYSTEM SET ... COMMENT= 'whatever ' SCOPE=...
Well, there is a limitation of 255 characters for comment.
Igor Neyman, OCP DBA
ineyman@(protected)
-- --Original Message-- --
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] On Behalf Of Mercadante, Thomas F
Sent: Friday, February 20, 2004 9:54 AM
To: 'oracle-l@(protected) '
Subject: RE: Shooting yourself in the spfile
Niall,
Aren 't you glad that you still have the init.ora file? :)
As for the SPfile, Chris 's example is the only one that I 've seen so far
that makes any sense for using the Spfile. When you are managing
hundreds
of databases across many remote sites, the Spfile makes sense.
I just wish that the Spfile had a way of documenting when something was
changed. When I change the Init.ora, I leave notes within the file
detailing what changed and when for histories sake. The Spfile is just
a
mish-mash of the params not suitable for viewing. So now, I would need
to
update two things - the Spfile (via OEM or SqlPLus) and a Word document
keeping track off changes.
I 'm not sure if this is better or worse.
Tom Mercadante
Oracle Certified Professional
-- --Original Message-- --
From: Niall Litchfield [mailto:n-litchfield@(protected)]
Sent: Friday, February 20, 2004 9:36 AM
To: oracle-l@(protected)
Subject: RE: Shooting yourself in the spfile
Don 't you just love it when a demo goes even better than you anticipated
ORA-00381 (See ORA-00381.ora-code.com): cannot use both new and old parameters for buffer cache size
specification
SQL > oops
SP2-0042: unknown command "oops " - rest of line ignored.
SQL > create spfile from pfile
2 ;
create spfile from pfile
*
ERROR at line 1:
ORA-00600 (See ORA-00600.ora-code.com): internal error code, arguments: [908], [], [], [], [], [],
[], []
**********************************************************************
This email contains information intended for
the addressee only. It may be confidential
and may be the subject of legal and/or
professional privilege. Any dissemination,
distribution, copyright or use of this
communication without prior permission of
the sender is strictly prohibited.
**********************************************************************
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
