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 O'Donnell, Kevin

Reply:     1     2     3     4     5     6     7     8     9     10  

Try this



Startup

Show parameter spfile

Create pfile='file name' from spfile='file name'

Shutdown immediate

Edit your pfile

Startup pfile='file name'

Show parameter audit

Create spfile='file name from show pram' from pfile='file name that you
used for startup'

Shutdown immediate

Startup

Show parameter audit



That should do it





__ ____ ____ ____ ____ ____ ____

From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] On Behalf Of Chirag DBA
Sent: Wednesday, October 12, 2005 10:19 AM
To: Marquez, Chris
Cc: Oracle-L Freelists
Subject: Re: Unable to create SPFILE.



I have started with pfile, by changing audit_trail=DB.



startup pfile='file name'.

show parameter audit.

audit_trail=DB

create spfile='location' from pfile;

File created..!!



but when see the spfile, *.audit_trail='OS';



I was thinking that while you do the create spfile, it is creating a
binary copy of pfile matching exactly with pfile.



but this is something unexpected I am getting.



regards - chirag



On 10/12/05, Marquez, Chris <cmarquez@(protected)> wrote:

Sorry meant to say;

SQL> startup pfile ='/[your changed pfile]';
SQL> show parameter audit
SQL> create spfile='.....' from pfile='....';
SQL> shutdown;
SQL> startup spfile ='/[your new spfile]';
SQL> show parameter audit

If this is a bug or feature this will show it.


Chris Marquez
Oracle DBA



-- --Original Message-- --
From: oracle-l-bounce@(protected) on behalf of Marquez, Chris
Sent: Wed 10/12/2005 10:06 AM
To: chiragdba@(protected) ; Oracle-L Freelists
Subject: RE: Unable to create SPFILE.


You sure you are using the right (default) pfile on startup?

do this;
SQL> startup; [as you normaly would]
SQL> show parameter audit

???

Something got to be a miss on your end...or this would be a scary
(documented) bug?

Chris Marquez
Oracle DBA

-- --Original Message-- --
From: oracle-l-bounce@(protected) on behalf of Chirag DBA
Sent: Wed 10/12/2005 9:45 AM
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







<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft
-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http:
//www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@(protected)
  {font-family:Tahoma;
  panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
  {margin:0in;
  margin-bottom:.0001pt;
  font-size:12.0pt;
  font-family:"Times New Roman";}
a:link, span.MsoHyperlink
  {color:blue;
  text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
  {color:blue;
  text-decoration:underline;}
p
  {mso-margin-top-alt:auto;
  margin-right:0in;
  mso-margin-bottom-alt:auto;
  margin-left:0in;
  font-size:12.0pt;
  font-family:"Times New Roman";}
span.EmailStyle20
  {mso-style-type:personal-reply;
  font-family:Arial;
  color:navy;}
@(protected) Section1
  {size:8.5in 11.0in;
  margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
  {page:Section1;}
-->
</style>

</head>

<body lang=EN-US link=blue vlink=blue>

<div class=Section1>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Try this <o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Startup<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Show parameter spfile<o:p></o:p></span><
/font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Create pfile=&#8216;file name&#8217; from
spfile=&#8216;file name&#8217;<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Shutdown immediate<o:p></o:p></span></font
></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Edit your pfile<o:p></o:p></span></font><
/p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Startup pfile=&#8217;file name&#8217;<o:p>
</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Show parameter audit<o:p></o:p></span><
/font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Create spfile=&#8217;file name from show
pram&#8217; from pfile=&#8217;file name that you used for startup&#8217;<o:p><
/o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Shutdown immediate<o:p></o:p></span></font
></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Startup<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Show parameter audit<o:p></o:p></span><
/font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>That should do it<o:p></o:p></span></font>
</p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<div>

<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>

<hr size=2 width="100%" align=center tabindex=-1>

</span></font></div>

<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Chirag DBA<br>
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, October 12, 2005
10:19 AM<br>
<b><span style='font-weight:bold'>To:</span></b> Marquez, Chris<br>
<b><span style='font-weight:bold'>Cc:</span></b> Oracle-L Freelists<br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: Unable to create
SPFILE.</span></font><o:p></o:p></p>

</div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>I have started with pfile, by changing audit_trail=DB.<o:p></o:p></span
></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>startup pfile='file name'.<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>show parameter audit.<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>audit_trail=DB<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>create spfile='location' from pfile;<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>File created..!!<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>but when see the spfile, *.audit_trail='OS';<o:p></o:p></span></font><
/p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>I was thinking that while you do the create spfile, it is creating a
binary copy of pfile matching exactly with pfile.<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>but this is something unexpected I am getting.<o:p></o:p></span></font>
</p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>regards - chirag <br>
<br>
&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><span class=gmailquote><font size=3 face="Times New Roman">
<span
style='font-size:12.0pt'>On 10/12/05, <b><span style='font-weight:bold'>Marquez,
Chris</span></b> &lt;<a href="mailto:cmarquez@(protected)">cmarquez
@(protected)</a>&gt;
wrote:</span></font></span> <o:p></o:p></p>

<p style='margin-bottom:12.0pt'><font size=2 face="Times New Roman"><span
style='font-size:10.0pt'>Sorry meant to say;<br>
<br>
SQL&gt; startup pfile ='/[your changed pfile]';<br>
SQL&gt; show parameter audit<br>
SQL&gt; create spfile='.....' from pfile='....';<br>
SQL&gt; shutdown;<br>
SQL&gt; startup spfile ='/[your new spfile]'; <br>
SQL&gt; show parameter audit<br>
<br>
If this is a bug or feature this will show it.<br>
<br>
<br>
<span class=q>Chris Marquez</span><br>
<span class=q>Oracle DBA</span><br>
<br>
<br>
<br>
<span class=q>-- --Original Message-- --</span><br>
<span class=q>From: <a href="mailto:oracle-l-bounce@(protected)"
target="_blank">oracle-l-bounce@(protected)</a> on behalf of Marquez, Chris<
/span><br>
<span class=q>Sent: Wed 10/12/2005 10:06 AM</span><br>
<span class=q>To: <a href="mailto:chiragdba@(protected)" target="_blank"
>chiragdba@(protected)
</a>; Oracle-L Freelists</span><br>
<span class=q>Subject: RE: Unable to create SPFILE.</span><br>
<br>
<br>
<span class=q>You sure you are using the right (default) pfile on startup?<
/span><br>
<br>
<span class=q>do this;</span><br>
<span class=q>SQL&gt; startup; [as you normaly would]</span><br>
<span class=q>SQL&gt; show parameter audit </span><br>
<br>
<span class=q>???</span><br>
<br>
<span class=q>Something got to be a miss on your end...or this would be a scary
(documented) bug?</span><br>
<br>
<span class=q>Chris Marquez</span><br>
<span class=q>Oracle DBA</span><br>
<br>
<span class=q>-- --Original Message-- --</span><br>
<span class=q>From: <a href="mailto:oracle-l-bounce@(protected)"
target="_blank">oracle-l-bounce@(protected)</a> on behalf of Chirag DBA</span
><br>
<span class=q>Sent: Wed 10/12/2005 9:45 AM</span><br>
<span class=q>To: Oracle-L Freelists</span><br>
<span class=q>Subject: Unable to create SPFILE.</span><br>
<br>
<span class=q>I have started my Database with pfile and now want to create
spfile. </span><br>
<span class=q>&nbsp;I am using create spfile='location' from pfile;</span><br>
<span class=q>&nbsp;When I see the audit parameters in pfile, it is
AUDIT_TRAIL=DB,</span><br>
<span class=q>but in SPFILE it is showing as AUDIT_TRAIL=OS, set previously but
changed</span><br>
<span class=q>now.</span><br>
<span class=q>same with few other parameters. </span><br>
<span class=q>I changed my init file, bounce DB with pfile and now creating
spfile.</span><br>
<span class=q>&nbsp;This is 9i with Solaris.</span><br>
<span class=q>&nbsp;regards - chirag</span><br>
<br>
<br>
</span></font><o:p></o:p></p>

</div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

</div>

</body>

</html>