DBCA Using Virtual Account Incorrectly Sets The SPFILE Owner

(Doc ID 2410452.1)

Last updated on JULY 13, 2018

Applies to:

Oracle Database Configuration Assistant - Version 12.2.0.1 to 12.2.0.1 [Release 12.2]
Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Oracle Database - Standard Edition - Version 12.2.0.1 and later
Generic Windows

Symptoms

On : 12.2.0.1 version, RDBMS

When attempting to create database with DBCA, the owner of all the SPFILEs becomes the account that is used to start the service
the following error occurs.

ERROR
-----------------------
"ORA-01565: Unable to ope Spfile "


Steps to reproduce -
-----------------------
1. Install Oracle Database 12.2 using OUI, select the new "Virtual Accounts" option

2. Create database "DB1" using DBCA
3. Create database "DB2" using DBCA

After step 2, the virtual account OracleServiceDB1 is granted read/write permissions on the SPFILE, CONTROL FILE and DATA FILES of database DB1.

After step 3, the owner of DB1's spfile is restricted to SYSTEM, Administrators and OracleServiceDB2. So the service OracleServiceDB1 is not allowed to read it's own datafiles/spfile/backup.

 

Changes

 

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