Hi all,
11.2.0.1
Our PROD database is operating 24x7 and if you request for downtime it must be short time only.
For example I need to change our db to OS logging. So your update to init.ora or spfile must be accurate and fast.
Can you explian why I can not update online my spfile, So that I can bounce back fast instead of editing a pfile?
This what I did:
C:\Users>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Nov 28 18:40:41 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-01821: date format not recognized
SQL> startup pfile='d:\initorcl.ora';
ORACLE instance started.
Total System Global Area 535662592 bytes
Fixed Size 1375792 bytes
Variable Size 318767568 bytes
Database Buffers 209715200 bytes
Redo Buffers 5804032 bytes
Database mounted.
Database opened.
SQL> create spfile from pfile='d:\initorcl.ora';
File created.
SQL> alter system set audit_file_dest='local0.info';
alter system set audit_file_dest='local0.info'
*
ERROR at line 1:
ORA-02096: specified initialization parameter is not modifiable with this
option
SQL> alter system set audit_file_dest='local0.info' scope=spfile;
alter system set audit_file_dest='local0.info' scope=spfile
*
ERROR at line 1:
ORA-32001: write to SPFILE requested but no SPFILE is in use
So I need to bounce the database so I can write to my spfile?
Thanks,
petra k.