Database Administration (MOSC)

MOSC Banner

not able find spfile and pfile

edited Oct 10, 2012 6:37AM in Database Administration (MOSC) 6 commentsAnswered
Hi,

I started 10gr2 database with pfile. I am not able to find spfile and pfile. Please help me on it.

SQL> create spfile from pfile;


File created.

SQL> create pfile from spfile;

File created.

SQL> show parameter pfile;

SQL> SHOW PARAMETER PFILE;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string
SQL> SHOW PARAMETER SPFILE;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string
SQL> CREATE SPFILE FROM MEMORY;
CREATE SPFILE FROM MEMORY
                   *
ERROR at line 1:
ORA-00922: missing or invalid option

SQL> SELECT VALUE FROM V$PARAMETER WHERE NAME='spfile'
UNION
SELECT VALUE FROM V$PARAMETER WHERE NAME='pfile';  2    3

VALUE
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center