Unable to create SPFILE.

Links

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

Thanx to all,
this is done now.
startup/shutdown couple of times with create pfile, create spfile.
Regards -Chirag

On 10/12/05, O'Donnell, Kevin <Kevin.ODonnell@(protected)> wrote:
>
> 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
>
>
>

<div>Thanx to all,</div>
<div> </div>
<div>this is done now.</div>
<div> </div>
<div>startup/shutdown couple of times with create pfile, create spfile.</div>
<div> </div>
<div>Regards -Chirag  </div>
<div>On 10/12/05, O
'Donnell, Kevin <<a href="mailto:Kevin.ODonnell@(protected)">Kevin
.ODonnell@(protected)</a>> wrote:
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0
.8ex; BORDER-LEFT: #ccc 1px solid">
<div>
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
 
 
<div>
<div style="TEXT-ALIGN: center" align="center">
<hr align="center" width="100%" size="2">
</div>
From:
 <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>] 
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.</div>
<div>
 
<div>
I have
started with pfile, by changing audit_trail=DB.</div>
<div>
 </div>
<div>
startup
pfile='file name'.</div>
<div>
show
parameter audit.</div>
<div>
audit
_trail=DB</div>
<div>
create
spfile='location' from pfile;</div>
<div>
File
created..!!</div>
<div>
 </div>
<div>
but when
see the spfile, *.audit_trail='OS';</div>
<div>
 </div>
<div>
I was
thinking that while you do the create spfile, it is creating a binary copy of
pfile matching exactly with pfile.</div>
<div>
 </div>
<div>
but this
is something unexpected I am getting.</div>
<div>
 </div>
<div>
regards
- chirag  </div>
<div>
On
10/12/05, Marquez, Chris <<a
onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:cmarquez
@(protected)" target="_blank">
cmarquez@(protected)</a>> 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: <a
onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:oracle-l
-bounce@(protected)" target="_blank">oracle-l-bounce@(protected)</a>
on behalf of Marquez, Chris Sent: Wed 10/12/2005 10:06 AM To: <a onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:chiragdba@(protected)" target="_blank">chiragdba@(protected)
</a>; 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:
<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:oracle-l
-bounce@(protected)" target="_blank">oracle-l-bounce@(protected)
</a> 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
 </div>
 </div></div></blockquote></div>