 | | | Unable to create SPFILE. | Unable to create SPFILE. 2005-10-12 - By Marquez, Chris
Chirag,
Here is the exact test below...only on 9205@(protected)
Your problem is that you do seem to be using the right file at the right time.
You need to understand the "order of precedence" and location of these
$ORACLE_HOME/dbs/spfile.ora
$ORACLE_HOME/dbs/init.ora
$ORACLE_HOME/dbs/spfile[SID].ora
$ORACLE_HOME/dbs/init[SID].ora
You need to dig a little (more)...I think the same answer (sample syntax) was
given several times, no?
hth
Chris Marquez
Oracle DBA
[oracle@(protected) dbs]$ cd /o01/app/oracle/product/9.2.0/dbs
[oracle@(protected) dbs]$ ls -ltr | grep orcl920
lrwxrwxrwx 1 oracle dba 51 May 16 23:52 initorcl920.ora -> /o01
/app/oracle/admin/orcl920/pfile/initorcl920.ora
-rw-r-- -- 1 oracle dba 4513792 Aug 10 21:28 snapcf_orcl920.f
[oracle@(protected) dbs]$ vi initorcl920.ora
...
audit_trail='DB'
"initorcl920.ora" 104L, 3203C written
[oracle@(protected) dbs]$ sqlplus '/ as sysdba'
SQL*Plus: Release 9.2.0.5.0 - Production on Wed Oct 12 11:13:52 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
SQL> startup pfile='/o01/app/oracle/product/9.2.0/dbs/initorcl920.ora';
ORACLE instance started.
Total System Global Area 202445952 bytes
Fixed Size 451712 bytes
Variable Size 167772160 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
SQL>
SQL> show parameter audit_trail
NAME TYPE
-- ---- ---- ---- ---- ---- ---- --- -- ---- ---- ---- ---- ---- -----
VALUE
-- ---- ---- ---- ---- ---- --
audit_trail string
DB
SQL>
SQL> show parameter spfile
NAME TYPE
-- ---- ---- ---- ---- ---- ---- --- -- ---- ---- ---- ---- ---- -----
VALUE
-- ---- ---- ---- ---- ---- --
spfile string
SQL> create spfile from pfile='/o01/app/oracle/product/9.2.0/dbs/initorcl920
.ora';
File created.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
[oracle@(protected) dbs]$ cd /o01/app/oracle/product/9.2.0/dbs
[oracle@(protected) dbs]$ ls -ltr | grep orcl920
lrwxrwxrwx 1 oracle dba 51 May 16 23:52 initorcl920.ora -> /o01
/app/oracle/admin/orcl920/pfile/initorcl920.ora
-rw-r-- -- 1 oracle dba 4513792 Aug 10 21:28 snapcf_orcl920.f
-rw-r-- -- 1 oracle dba 2560 Oct 12 11:15 spfileorcl920.ora
[oracle@(protected) dbs]$
[oracle@(protected) dbs]$ strings /o01/app/oracle/product/9.2.0/dbs/spfileorcl920.ora
| grep -i audit
*.audit_trail='DB'
[oracle@(protected) dbs]$ sqlplus '/ as sysdba'
SQL*Plus: Release 9.2.0.5.0 - Production on Wed Oct 12 11:18:34 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
SQL> startup;
ORACLE instance started.
Total System Global Area 202445952 bytes
Fixed Size 451712 bytes
Variable Size 167772160 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
SQL>
SQL> show parameter audit_trail
NAME TYPE
-- ---- ---- ---- ---- ---- ---- --- -- ---- ---- ---- ---- ---- -----
VALUE
-- ---- ---- ---- ---- ---- --
audit_trail string
DB
SQL> show parameter spfile
NAME TYPE
-- ---- ---- ---- ---- ---- ---- --- -- ---- ---- ---- ---- ---- -----
VALUE
-- ---- ---- ---- ---- ---- --
spfile string
?/dbs/spfile@(protected)
SQL>
-- --Original Message-- --
From: Reidy, Ron [mailto:Ron.Reidy@(protected)]
Sent: Wed 10/12/2005 11:02 AM
To: chiragdba@(protected); Marquez, Chris
Cc: Oracle-L Freelists
Subject: RE: Unable to create SPFILE.
You have to restart your DB using the spfile, and read the docs.
-- --Original Message-- --
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] On Behalf Of Chirag DBA
Sent: Wednesday, October 12, 2005 8: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
This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is
intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7232.39">
<TITLE>RE: Unable to create SPFILE.</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<BR>
<P><FONT SIZE=2>Chirag,<BR>
<BR>
Here is the exact test below...only on 9205@(protected)<BR>
<BR>
Your problem is that you do seem to be using the right file at the right time.
<BR>
You need to understand the "order of precedence" and location of
these<BR>
$ORACLE_HOME/dbs/spfile.ora<BR>
$ORACLE_HOME/dbs/init.ora<BR>
$ORACLE_HOME/dbs/spfile[SID].ora<BR>
$ORACLE_HOME/dbs/init[SID].ora<BR>
<BR>
You need to dig a little (more)...I think the same answer (sample syntax) was
given several times, no?<BR>
<BR>
hth<BR>
<BR>
Chris Marquez<BR>
Oracle DBA<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
[oracle@(protected) dbs]$ cd /o01/app/oracle/product/9.2.0/dbs<BR>
[oracle@(protected) dbs]$ ls -ltr | grep orcl920<BR>
lrwxrwxrwx 1 oracle dba
51 May 16 23:52 initorcl920.ora ->
/o01/app/oracle/admin/orcl920/pfile/initorcl920.ora<BR>
-rw-r-- -- 1 oracle dba
4513792 Aug 10 21:28 snapcf_orcl920.f<BR>
<BR>
<BR>
[oracle@(protected) dbs]$ vi initorcl920.ora<BR>
...<BR>
audit_trail='DB'<BR>
"initorcl920.ora" 104L, 3203C written<BR>
<BR>
[oracle@(protected) dbs]$ sqlplus '/ as sysdba'<BR>
SQL*Plus: Release 9.2.0.5.0 - Production on Wed Oct 12 11:13:52 2005<BR>
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.<BR>
Connected to an idle instance.<BR>
<BR>
SQL> startup pfile='/o01/app/oracle/product/9.2.0/dbs/initorcl920.ora';<BR>
ORACLE instance started.<BR>
Total System Global Area 202445952 bytes<BR>
Fixed Size
451712 bytes<BR>
Variable Size
167772160 bytes<BR>
Database Buffers
33554432 bytes<BR>
Redo Buffers
667648 bytes<BR>
Database mounted.<BR>
Database opened.<BR>
SQL><BR>
SQL> show parameter audit_trail<BR>
NAME
TYPE<BR>
-- ---- ---- ---- ---- ---- ---- --- -- ---- ---- ---- ---- ---- -----<BR>
VALUE<BR>
-- ---- ---- ---- ---- ---- --<BR>
audit_trail
string<BR>
DB<BR>
SQL><BR>
SQL> show parameter spfile<BR>
NAME
TYPE<BR>
-- ---- ---- ---- ---- ---- ---- --- -- ---- ---- ---- ---- ---- -----<BR>
VALUE<BR>
-- ---- ---- ---- ---- ---- --<BR>
spfile
string<BR>
<BR>
SQL> create spfile from pfile='/o01/app/oracle/product/9.2.0/dbs/initorcl920
.ora';<BR>
<BR>
File created.<BR>
<BR>
SQL> shutdown immediate;<BR>
Database closed.<BR>
Database dismounted.<BR>
ORACLE instance shut down.<BR>
SQL> exit<BR>
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production<BR>
With the Partitioning, OLAP and Oracle Data Mining options<BR>
JServer Release 9.2.0.5.0 - Production<BR>
<BR>
[oracle@(protected) dbs]$ cd /o01/app/oracle/product/9.2.0/dbs<BR>
[oracle@(protected) dbs]$ ls -ltr | grep orcl920<BR>
lrwxrwxrwx 1 oracle dba
51 May 16 23:52 initorcl920.ora ->
/o01/app/oracle/admin/orcl920/pfile/initorcl920.ora<BR>
-rw-r-- -- 1 oracle dba
4513792 Aug 10 21:28 snapcf_orcl920.f<BR>
-rw-r-- -- 1 oracle dba
2560 Oct 12 11:15 spfileorcl920.ora<BR>
[oracle@(protected) dbs]$<BR>
<BR>
<BR>
[oracle@(protected) dbs]$ strings /o01/app/oracle/product/9.2.0/dbs
/spfileorcl920.ora | grep -i audit<BR>
*.audit_trail='DB'<BR>
<BR>
<BR>
<BR>
[oracle@(protected) dbs]$ sqlplus '/ as sysdba'<BR>
SQL*Plus: Release 9.2.0.5.0 - Production on Wed Oct 12 11:18:34 2005<BR>
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.<BR>
Connected to an idle instance.<BR>
<BR>
SQL> startup;<BR>
ORACLE instance started.<BR>
<BR>
Total System Global Area 202445952 bytes<BR>
Fixed Size
451712 bytes<BR>
Variable Size
167772160 bytes<BR>
Database Buffers
33554432 bytes<BR>
Redo Buffers
667648 bytes<BR>
Database mounted.<BR>
Database opened.<BR>
SQL><BR>
SQL> show parameter audit_trail<BR>
<BR>
NAME
TYPE<BR>
-- ---- ---- ---- ---- ---- ---- --- -- ---- ---- ---- ---- ---- -----<BR>
VALUE<BR>
-- ---- ---- ---- ---- ---- --<BR>
audit_trail
string<BR>
DB<BR>
SQL> show parameter spfile<BR>
<BR>
NAME
TYPE<BR>
-- ---- ---- ---- ---- ---- ---- --- -- ---- ---- ---- ---- ---- -----<BR>
VALUE<BR>
-- ---- ---- ---- ---- ---- --<BR>
spfile
string<BR>
?/dbs/spfile@(protected)<BR>
SQL><BR>
<BR>
<BR>
<BR>
-- --Original Message-- --<BR>
From: Reidy, Ron [<A HREF="mailto:Ron.Reidy@(protected)">mailto:Ron
.Reidy@(protected)</A>]<BR>
Sent: Wed 10/12/2005 11:02 AM<BR>
To: chiragdba@(protected); Marquez, Chris<BR>
Cc: Oracle-L Freelists<BR>
Subject: RE: Unable to create SPFILE.<BR>
<BR>
You have to restart your DB using the spfile, and read the docs.<BR>
-- --Original Message-- --<BR>
From: oracle-l-bounce@(protected)<BR>
[<A HREF="mailto:oracle-l-bounce@(protected)">mailto:oracle-l-bounce
@(protected)</A>] On Behalf Of Chirag DBA<BR>
Sent: Wednesday, October 12, 2005 8:19 AM<BR>
To: Marquez, Chris<BR>
Cc: Oracle-L Freelists<BR>
Subject: Re: Unable to create SPFILE.<BR>
<BR>
<BR>
I have started with pfile, by changing audit_trail=DB.<BR>
<BR>
startup pfile='file name'.<BR>
show parameter audit.<BR>
audit_trail=DB<BR>
create spfile='location' from pfile;<BR>
File created..!!<BR>
<BR>
but when see the spfile, *.audit_trail='OS';<BR>
<BR>
I was thinking that while you do the create spfile, it is creating a<BR>
binary copy of pfile matching exactly with pfile.<BR>
<BR>
but this is something unexpected I am getting.<BR>
<BR>
regards - chirag<BR>
<BR>
<BR>
On 10/12/05, Marquez, Chris <cmarquez@(protected)> wrote:<BR>
<BR>
Sorry meant to say;<BR>
<BR>
SQL> startup pfile ='/[your
changed pfile]';<BR>
SQL> show parameter audit<BR>
SQL> create spfile='.....' from
pfile='....';<BR>
SQL> shutdown;<BR>
SQL> startup spfile ='/[your new
spfile]';<BR>
SQL> show parameter audit<BR>
<BR>
If this is a bug or feature this
will show it.<BR>
<BR>
<BR>
Chris Marquez<BR>
Oracle DBA<BR>
<BR>
<BR>
<BR>
-- --Original Message-- --<BR>
From: oracle-l-bounce@(protected)
on behalf of Marquez, Chris<BR>
Sent: Wed 10/12/2005 10:06 AM<BR>
To: chiragdba@(protected) ; Oracle-L
Freelists<BR>
Subject: RE: Unable to create SPFILE
.<BR>
<BR>
<BR>
You sure you are using the right
(default) pfile on startup?<BR>
<BR>
do this;<BR>
SQL> startup; [as you normaly
would]<BR>
SQL> show parameter audit<BR>
<BR>
???<BR>
<BR>
Something got to be a miss on your
end...or this would be a<BR>
scary (documented) bug?<BR>
<BR>
Chris Marquez<BR>
Oracle DBA<BR>
<BR>
-- --Original Message-- --<BR>
From: oracle-l-bounce@(protected)
on behalf of Chirag DBA<BR>
Sent: Wed 10/12/2005 9:45 AM<BR>
To: Oracle-L Freelists<BR>
Subject: Unable to create SPFILE.<BR>
<BR>
I have started my Database with
pfile and now want to create<BR>
spfile.<BR>
I am using create spfile=
'location' from pfile;<BR>
When I see the audit
parameters in pfile, it is AUDIT_TRAIL=DB,<BR>
but in SPFILE it is showing as AUDIT
_TRAIL=OS, set previously<BR>
but changed<BR>
now.<BR>
same with few other parameters.<BR>
I changed my init file, bounce DB
with pfile and now creating<BR>
spfile.<BR>
This is 9i with Solaris.<BR>
regards - chirag<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
This electronic message transmission is a PRIVATE communication which contains
<BR>
information which may be confidential or privileged. The information is
intended<BR>
to be for the use of the individual or entity named above. If you are not the
<BR>
intended recipient, please be aware that any disclosure, copying, distribution
<BR>
or use of the contents of this information is prohibited. Please notify the<BR>
sender of the delivery error by replying to this message, or notify us by
<BR>
telephone (877-633-2436, ext. 0), and then delete it from your system.<BR>
<BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>
|
|
|