Windows 2008 and run database service as a different user then the "Local System" account, database will not start via service

From: Patrick Roozen <patrick.roozen_at_gmail.com>
Date: Tue, 13 Mar 2012 10:37:19 +0100
Message-ID: <CABLnbMTLS_0+g3M3sFp5F_UG50S7_9NKRUZYqv+4o9wcd9mZNg_at_mail.gmail.com>



Hi All,

We need to run the database as a different user then the "Local System" account because we need to make backups to an UNC share. Therefore we have created a domain user that is in the local administrator group on the windows machine. This user is allowed to use the UNC share as well.

We run Oracle 10.2.0.5 SE and Windows 2008 RC2 and followed this note on metalink/oracle support (Doc ID 457363.1).

When starting the database service the database will not mount the database and stops there. No extra messages in the alert file that suggest any problem.
When we logon to the windows machine with the same account and connect to the database we can start it manually (alter database mount/alter database open) without any problems.

Has anyone run into this problem before and been able to fix this? We have a SR with oracle but have not gotten any respons yet.

Regards,

Patrick
Oracle DBA

P.S. Off course running the service as "local system" will start the database without any problems. And we also change the service of the listener to run as the same user as the database service. If you don't you cannot connect to the database via sqlnet.

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 13 2012 - 04:37:19 CDT

Original text of this message