| spfile creation from pfile (during upgrade from 11.2.0.1. to 11.2.0.3) [message #633266] |
Fri, 13 February 2015 04:15  |
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 #633274 is a reply to message #633271] |
Fri, 13 February 2015 06:22  |
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.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
