Using this query you can find your physical spfile location.
SQL> CONN /AS SYSDBA
Connected.
SQL> select value from v$parameter where name = 'spfile';
VALUE
--------------------------------------------------------------------------------
D:\APP\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBRMAN.ORA
SQL>
SQL> CONN /AS SYSDBA
Connected.
SQL> select value from v$parameter where name = 'spfile';
VALUE
--------------------------------------------------------------------------------
D:\APP\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBRMAN.ORA
SQL>
No comments:
Post a Comment