Hi guru's

That's it! When I type various combinations of the above command and
then type show parameter spfile the value is blank.

What gives guys?

RH Linux 4AS
Oracle 9i RAC

tb3101

On 9 Feb, 12:03, trub3101 <trub3...@sky.com> wrote:
> Hi guru's
>
> That's it! When I type various combinations of the above command and
> then type show parameter spfile the value is blank.
>
> What gives guys?
>
> RH Linux 4AS
> Oracle 9i RAC
>
> tb3101

Sorted!

Ok - I'm going to guess you did something like this:

create spfile='/opt/oracle/admin/O901/pfile/spfileO901.ora'from pfile='/opt/oracle/admin/O901/pfile/initO901.ora'

or like this

create spfile='c:\oracle\admin\O901\pfile\spfile0901.ora' from
pfile='c:\oracle\admin\O901\pfile\initO901.ora'

Shut the database down.

Create a pfile in the $ORACLE_HOME/dbs directory for the sid you are using and put one line in it stating where the spfile is located, e.g.,

spfile='/opt/oracle/admin/O901/pfile/spfileO901.ora'


Restart the database.

If you don't specify a file location when you create the spfile it gets created in the $ORACLE_HOME/dbs directory (in unix). In windows the spfile will get created in the $ORACLE_HOME/database directory.

If you don't specify a file location for the spfile (which subsequently gets created in the default location) then you don't have to create an init file in the $ORACLE_HOME/dbs (or $ORACLE_HOME/database) directory.

Corrections welcome.