Database Administration (MOSC)

MOSC Banner

Oracle spfile default location

edited Oct 25, 2018 1:22AM in Database Administration (MOSC) 28 commentsAnswered

Hi,

I was told in Linux, the Oracle spfile default location is located at $ORACLE_HOME/dbs ,

I have a database with spfile in ASM

SQL> show parameter spfile

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

spfile                               string      +DATA/DBTEST2/PARAMETERFILE/spfile.300.990280177

and there is no initdbtest2.ora in the dbs ,

when I start the database with sqlplus, the database somehow know the spfile location in ASM,

is there any others configuration file control this?

SQL> startup

ORACLE instance started.

Total System Global Area 8589934592 bytes

Fixed Size                  8641256 bytes

Variable Size            1543505176 bytes

Database Buffers         7012876288 bytes

Redo Buffers               24911872 bytes

Database mounted.

Database opened.

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