.ora-code.com

Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
Unable to create SPFILE.

Unable to create SPFILE.

2005-10-12       - By Chirag DBA
Reply:     1     2     3     4     5     6     7     8     9     10  

I put my audit_trail=os. wanted to change to DB, but unable to do that on
the fly.
SQL> alter system set audit_trail=DB;
alter system set audit_trail=DB
*
ERROR at line 1:
ORA-02095 (See ORA-02095.ora-code.com): specified initialization parameter cannot be modified
SQL> ALTER SYSTEM SET audit_trail=DB SCOPE=SPFILE;
ALTER SYSTEM SET audit_trail=DB SCOPE=SPFILE
*
ERROR at line 1:
ORA-32001 (See ORA-32001.ora-code.com): write to SPFILE requested but no SPFILE specified at startup

Now is it like, I startup my db with spfile and then do
alter system set audit_trail=DB scope=pfile;
create pfile from spfile;
hope this should work.
regards - chirag
On 10/12/05, Hallas, John, Tech Dev <John.Hallas@(protected)> wrote:
>
>  After restarting the database with the spfile if you do a show parameter
> spfile does it show that it is using the file in the location you specified?
>
>  If it is then alter system set audit_trail = DB scope =spfile; and
> reboot. Ensure that your initSID.ora file piles to the spfile
>
>  If that does not solve your problem then I am afraid I do not fully
> understand the issue
>
>  John
>
>   -- ---- ---- ---- ---- ---- --
>
> *From:* oracle-l-bounce@(protected) [mailto:
> oracle-l-bounce@(protected)] *On Behalf Of *Chirag DBA
> *Sent:* 12 October 2005 14:45
> *To:* Oracle-L Freelists
> *Subject:* Unable to create SPFILE.
>
>  I have started my Database with pfile and now want to create spfile.
>
>  I am using create spfile='location' from pfile;
>
>  When I see the audit parameters in pfile, it is AUDIT_TRAIL=DB,
>
> but in SPFILE it is showing as AUDIT_TRAIL=OS, set previously but changed
> now.
>
> same with few other parameters.
>
> I changed my init file, bounce DB with pfile and now creating spfile.
>
>  This is 9i with Solaris.
>
>  regards - chirag
>
>

<div>I put my audit_trail=os. wanted to change to DB, but unable to do that on
the fly.<br>&nbsp;</div>
<div>SQL&gt; alter system set audit_trail=DB;<br>alter system set audit_trail
=DB<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp; *<br>ERROR at line 1:<br>ORA-02095 (See ORA-02095.ora-code.com): specified
initialization parameter cannot be modified<br>&nbsp;</div>
<div>SQL&gt; ALTER SYSTEM SET audit_trail=DB SCOPE=SPFILE;<br>ALTER SYSTEM SET
audit_trail=DB SCOPE=SPFILE<br>*<br>ERROR at line 1:<br>ORA-32001 (See ORA-32001.ora-code.com): write to
SPFILE requested but no SPFILE specified at startup<br><br>Now is it like, I
startup my db with spfile and then do
</div>
<div>alter system set audit_trail=DB scope=pfile;</div>
<div>create pfile from spfile;</div>
<div>&nbsp;</div>
<div>hope this should work.</div>
<div>&nbsp;</div>
<div>regards - chirag</div>
<div>&nbsp;</div>
<div><span class="gmail_quote">On 10/12/05, <b class="gmail_sendername">Hallas,
John, Tech Dev</b> &lt;<a href="mailto:John.Hallas@(protected)">John
.Hallas@(protected)</a>&gt; wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0
.8ex; BORDER-LEFT: #ccc 1px solid">
<div>
<p><font face="Comic Sans MS" color="blue" size="2"><span style="FONT-SIZE:
10pt; COLOR: blue">After restarting the database with the spfile if you do a
show parameter spfile does it show that it is using the file in the location
you specified?
</span></font></p>
<p><font face="Comic Sans MS" color="blue" size="2"><span style="FONT-SIZE:
10pt; COLOR: blue">&nbsp;</span></font></p>
<p><font face="Comic Sans MS" color="blue" size="2"><span style="FONT-SIZE:
10pt; COLOR: blue">If it is then alter system set audit_trail = DB scope
=spfile; and reboot. Ensure that your initSID.ora file piles to the spfile
</span></font></p>
<p><font face="Comic Sans MS" color="blue" size="2"><span style="FONT-SIZE:
10pt; COLOR: blue">&nbsp;</span></font></p>
<p><font face="Comic Sans MS" color="blue" size="2"><span style="FONT-SIZE:
10pt; COLOR: blue">If that does not solve your problem then I am afraid I do
not fully understand the issue</span></font></p>
<p><font face="Comic Sans MS" color="blue" size="2"><span style="FONT-SIZE:
10pt; COLOR: blue">&nbsp;</span></font></p>
<p><font face="Comic Sans MS" color="blue" size="2"><span style="FONT-SIZE:
10pt; COLOR: blue">John</span></font></p>
<p><font face="Comic Sans MS" color="blue" size="2"><span style="FONT-SIZE:
10pt; COLOR: blue">&nbsp;</span></font></p>
<div>
<div style="TEXT-ALIGN: center" align="center"><font face="Times New Roman"
size="3"><span lang="EN-US" style="FONT-SIZE: 12pt">
<hr align="center" width="100%" size="2">
</span></font></div>
<p><b><font face="Tahoma" size="2"><span lang="EN-US" style="FONT-WEIGHT: bold;
FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</span></font></b><font face="Tahoma
" size="2"><span lang="EN-US" style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">
<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:oracle
-l-bounce@(protected)" target="_blank">oracle-l-bounce@(protected)</a>
[mailto:<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto
:oracle-l-bounce@(protected)" target="_blank">
oracle-l-bounce@(protected)</a>] <b><span style="FONT-WEIGHT: bold">On Behalf
Of </span></b>Chirag DBA<br><b><span style="FONT-WEIGHT: bold">Sent:</span></b>
12 October 2005 14:45<br><b><span style="FONT-WEIGHT: bold">To:
</span></b> Oracle-L Freelists<br><b><span style="FONT-WEIGHT: bold">Subject:<
/span></b> Unable to create SPFILE.</span></font><span lang="EN-US"></span></p><
/div>
<div><span class="e" id="q_106e52480854a3ea_1">
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">&nbsp;<
/span></font></p>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">I have
started my Database with pfile and now want to create spfile.</span></font></p>
</div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">&nbsp;<
/span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">I am
using create spfile='location' from pfile;</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">&nbsp;<
/span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">When I
see the audit parameters in pfile, it is AUDIT_TRAIL=DB,</span></font></p></div
>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">but in
SPFILE it is showing as AUDIT_TRAIL=OS, set previously but changed now.</span><
/font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">same
with few other parameters.</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">I
changed my init file, bounce DB with pfile and now creating spfile.</span><
/font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">&nbsp;<
/span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">This is
9i with Solaris.</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">&nbsp;<
/span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">regards
- chirag </span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">&nbsp;<
/span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">&nbsp;<
/span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">&nbsp;<
/span></font></p></div></span></div></div></blockquote></div><br>