Database Administration (MOSC)

MOSC Banner

how to change default location of spfile to /new_location/new_sp.ora

edited Feb 14, 2020 11:46AM in Database Administration (MOSC) 4 commentsAnswered ✓

How to change default location of spfile?

Default location is $ORACLE_HOME/dbs/ , I want to change that to /New_Location/spfile_new_name.ora without need to use --- startup spfile="...."  ----, I just want to use -- startup --

I don't want to use

startup spfile='...'

I just want to use

startup

I have

Stand Alone (not RAC)

Oracle 19c

Linux 7.7

I don't think it has been possible except if you enter value for *.spfile parameter in default location of init pfile but that is a spaghetti situation and you have to use the text pfile parameter that will point to the spfile

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