My Oracle Support Banner

SPFILE Was Not Used When Service Is Restarted Or Server Rebooted In Windows (Doc ID 2398144.1)

Last updated on JANUARY 09, 2025

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Backup Service - Version N/A 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

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.