Database Administration (MOSC)

MOSC Banner

ORA-27040 OSD-04002 O/S-Error When create spfile from pfile

edited Feb 6, 2019 11:54AM in Database Administration (MOSC) 7 commentsAnswered ✓

Hi all,

I have a problem with the spfile on oracle 12c on Windows.

i have 2 database instance in the same oracle_home, one of this runs correctly, while the second has this problem:

SQL> startup pfile='D:\app\oracle\product\12.2.0\dbs\INITMAST701.ORA';

end it start fine

SQL> show parameters spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string
SQL> alter system set spfile='D:\app\oracle\product\12.2.0\database\SPFILEMAST701.ORA';
alter system set spfile='D:\app\oracle\product\12.2.0\database\SPFILEMAST701.ORA'
*
ERRORE alla riga 1:
ORA-02097: impossibile modificare il parametro perchÚ il valore specificato non Þ valido
ORA-01565: errore nell'identificazione del file 'D:\app\oracle\product\12.2.0\database\SPFILEMAST701.ORA'

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