DBCA Using Virtual Account Incorrectly Sets The SPFILE Owner
Last updated on JULY 13, 2018
Applies to:Oracle Database Configuration Assistant - Version 188.8.131.52 to 184.108.40.206 [Release 12.2]
Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Oracle Database - Standard Edition - Version 18.104.22.168 and later
On : 22.214.171.124 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.
"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.
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