SPFILE Was Not Used When Service Is Restarted Or Server Rebooted In Windows

(Doc ID 2398144.1)

Last updated on MAY 16, 2018

Applies to:

Oracle Database - Enterprise Edition - Version and later
Generic Windows


Database is starting with pfile although spfile exists, it only happened when db is started through service and during server reboot. If we start the database from sqlplus, spfile is used.



Database is created from create database script and spfile was created later using create spfile command


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms