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 11.2.0.4 and later
Generic Windows

Symptoms

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.

 

Changes

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

Cause

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