Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

create new spfile

Cds MAXJun 9 2020 — edited Jun 10 2020

Hi,

On 11.2.0.4 on AIX,

spfile is

in $ORACLE_HOME/dbs:

lrwxrwxrwx 1 oracle dba 57 Jan 06 12:38 spfilemydb.ora -> /u1/oradata/admin/spfilemydb.ora

If I want to create a new one should I run:

CREATE SPFILE = '/u1/oradata/admin/spfilemydb.ora' FROM PFILE

Thanks.

This post has been answered by Marshall Pyle on Jun 9 2020

Jump to Answer

Added on Jun 9 2020

#general-database-discussions

11 comments

343 views