Home » RDBMS Server » Server Administration » spfile creation from pfile (during upgrade from 11.2.0.1. to 11.2.0.3) (11g, 11.2.0.1, window7)
spfile creation from pfile (during upgrade from 11.2.0.1. to 11.2.0.3) [message #633266] Fri, 13 February 2015 04:15 Go to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear All,

During the upgrade process, I kept the pfile from one location to new location (where 11.2.0.3 software located).


C:\Users\3130738>set path=D:\app\product\11.2.0\dbhome_2\bin;

C:\Users\3130738>set oracle_sid=ashtest

C:\Users\3130738>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Fri Feb 13 12:48:41 2015

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount pfile='D:\app\product\11.2.0\dbhome_2\database\INITashtest.ora';
ORACLE instance started.

Total System Global Area  926969856 bytes
Fixed Size                  2181224 bytes
Variable Size             587204504 bytes
Database Buffers          331350016 bytes
Redo Buffers                6234112 bytes
SQL> sho parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string
SQL> sho parameter pfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string
SQL> create spfile from pfile='D:\app\product\11.2.0\dbhome_2\database\INITashtest.ora';

File created.


But it's not generating at 'D:\app\product\11.2.0\dbhome_2\database\'. Instead of it, it is creating on another location, E:\app\product\11.2.0\dbhome_1\database\ (where actual pfile is resided- 11.2.0.1)

Please let me know, why its is not generating at 'D:\app\product\11.2.0\dbhome_2\database' ??

Regards,
Ashish Kumar Mahanta


Edited by Lalit : fixed a trivial typo in the version in the topic title

[Updated on: Fri, 13 February 2015 08:10] by Moderator

Report message to a moderator

Re: spfile creation from pfile (during upgrade from 11.2.01. to 11.2.0.3) [message #633268 is a reply to message #633266] Fri, 13 February 2015 04:52 Go to previous messageGo to next message
cookiemonster
Messages: 13291
Registered: September 2008
Location: Rainy Manchester
Senior Member
What exactly is not generating at 'D:\app\product\11.2.0\dbhome_2\database\'?
Re: spfile creation from pfile (during upgrade from 11.2.01. to 11.2.0.3) [message #633269 is a reply to message #633266] Fri, 13 February 2015 05:28 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10690
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You have to set your ORACLE_HOME and use ORACLE_HOME\bin in PATH
or create it where you want.

create spfile='mypath\mydir\.." from pfile='...'

[Updated on: Fri, 13 February 2015 05:37]

Report message to a moderator

Re: spfile creation from pfile (during upgrade from 11.2.01. to 11.2.0.3) [message #633271 is a reply to message #633266] Fri, 13 February 2015 05:43 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3131
Registered: May 2013
Location: World Wide on the Web
Senior Member
You could also mention a non-default location.

CREATE SPFILE='your_location' from PFILE='D:\app\product\11.2.0\dbhome_2\database\INITashtest.ora';


But yes, as Mahesh said, you need to set your ORACLE_HOME correctly.

Edit : Didn't see Mahesh updated his post

[Updated on: Fri, 13 February 2015 05:44]

Report message to a moderator

Re: spfile creation from pfile (during upgrade from 11.2.01. to 11.2.0.3) [message #633274 is a reply to message #633271] Fri, 13 February 2015 06:22 Go to previous messageGo to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear All,

I have already set the path as ORACLE_HOME/bin .

C:\Users\3130738>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Fri Feb 13 17:42:36 2015

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount pfile='D:\app\product\11.2.0\dbhome_2\database\INITashtest.ora';
ORACLE instance started.

Total System Global Area  926969856 bytes
Fixed Size                  2181224 bytes
Variable Size             587204504 bytes
Database Buffers          331350016 bytes
Redo Buffers                6234112 bytes
SQL> create spfile='D:\app\product\11.2.0\dbhome_2\database' from pfile='D:\app\product\11.2.0\dbhome_2\databa
se\INITashtest.ora';
create spfile='D:\app\product\11.2.0\dbhome_2\database' from pfile='D:\app\product\11.2.0\dbhome_2\database\IN
ITashtest.ora'
*
ERROR at line 1:
ORA-27038: created file already exists
OSD-04010: <create> option specified, file already exists


SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

C:\Users\3130738>cd D:\app\product\11.2.0\dbhome_2\database

C:\Users\3130738>d:

D:\app\product\11.2.0\dbhome_2\database>dir
 Volume in drive D is New Volume
 Volume Serial Number is BE7A-F176

 Directory of D:\app\product\11.2.0\dbhome_2\database

13/02/2015  12:44 PM    <DIR>          .
13/02/2015  12:44 PM    <DIR>          ..
12/02/2015  06:03 PM    <DIR>          archive
12/02/2015  06:52 PM             2,048 hc_ashtst.dat
13/02/2015  11:53 AM               939 INITashtest.ORA
13/02/2015  12:39 PM               861 INITashtst.ORA
22/12/2005  04:07 AM            31,744 oradba.exe
12/02/2015  06:52 PM               198 oradim.log
13/02/2015  12:36 PM             1,536 PWDashtst.ora
13/07/2011  03:42 AM           219,360 utlu112i.sql
               7 File(s)        256,686 bytes
               3 Dir(s)  22,878,535,680 bytes free

D:\app\product\11.2.0\dbhome_2\database>cd E:\app\product\11.2.0\dbhome_1\database

D:\app\product\11.2.0\dbhome_2\database>e:

E:\app\product\11.2.0\dbhome_1\database>dir
 Volume in drive E is New Volume
 Volume Serial Number is 4883-D01A

 Directory of E:\app\product\11.2.0\dbhome_1\database

13/02/2015  05:42 PM    <DIR>          .
13/02/2015  05:42 PM    <DIR>          ..
03/02/2015  02:42 PM    <DIR>          archive
03/02/2015  02:49 PM             2,048 hc_ashtest.dat
13/02/2015  12:43 PM               939 INITashtest.ORA
22/12/2005  04:07 AM            31,744 oradba.exe
12/02/2015  11:28 AM             1,496 oradim.log
13/02/2015  11:15 AM             1,536 PWDASHTEST.ora
13/02/2015  05:42 PM             2,560 SPFILEASHTEST.ORA
               6 File(s)         40,323 bytes
               3 Dir(s)  90,133,159,936 bytes free

E:\app\product\11.2.0\dbhome_1\database>



Here, spfile is getting generated at E: drive instead of D: drive.
Re: spfile creation from pfile (during upgrade from 11.2.01. to 11.2.0.3) [message #633279 is a reply to message #633274] Fri, 13 February 2015 08:05 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3131
Registered: May 2013
Location: World Wide on the Web
Senior Member
create spfile='D:\app\product\11.2.0\dbhome_2\database\spfileORCL.ora' from pfile='D:\app\product\11.2.0\dbhome_2\database\INITashtest.ora'
Re: spfile creation from pfile (during upgrade from 11.2.01. to 11.2.0.3) [message #633280 is a reply to message #633279] Fri, 13 February 2015 08:22 Go to previous messageGo to next message
BlackSwan
Messages: 26204
Registered: January 2009
Location: SoCal
Senior Member
>Here, spfile is getting generated at E: drive instead of D: drive.

We can NOT change how Oracle behaves.
If you want different behavior, then submit Service Request to MOS
Re: spfile creation from pfile (during upgrade from 11.2.01. to 11.2.0.3) [message #633281 is a reply to message #633280] Fri, 13 February 2015 08:51 Go to previous message
Lalit Kumar B
Messages: 3131
Registered: May 2013
Location: World Wide on the Web
Senior Member
An SR regarding this issue wouldn't even reach the sustenance team, it would be closed by the first level support team itself.

[Updated on: Fri, 13 February 2015 09:05]

Report message to a moderator

Previous Topic: ORA-27102: out of memory, while increasing the size of SGA
Next Topic: Bigfile Tablespace
Goto Forum:
  


Current Time: Sun Oct 21 06:28:41 CDT 2018