no value

nobleit
nobleit used Ask the Experts™
on
why no value is displayed

SQL> show parameter spfile;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string
SQL>
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
You started the database with a pfile.

Startup pfile='somefile.ora';

All this is in the docs.
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
Should add: check the alert log for the last startup, it should tell you if you used a spfile or pfile.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial