| 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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
