how to change default location of spfile to /new_location/new_sp.ora
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