Change Oracle service account in MSCS cluster

[GuidovK]

Hi,

Has anyone ever done this? We have Oracle running on an active/passive mscs cluster. The Oracle Database services are running under the system account. However, to get access to UNC shares, we need the Oracle services to run under a domain user account. Does anyone know of a document describing this procedure or does anyone have any experience with changing the Oracle service account on a cluster?

Thx,

Guidovk

 

[mrdenny]

I haven't done an Oracle account, but I have changed many cluster service accounts. The Oracle service is simply a service configured on each host server. All you need to do it change the login information for the service on both machines.

Make sure the account has the log on as a service right and the log on as a batch process right.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[mrdenny]

I haven't done an Oracle account, but I have changed many cluster service accounts. The Oracle service is simply a service configured on each host server. All you need to do it change the login information for the service on both machines.

Make sure the account has the log on as a service right and the log on as a batch process right. That is in addition to any rights that an account running an Oracle service needs.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[GuidovK]

Thanks.

I've got an Oracle document describing the procedure to change the service accounts for a single, non-clustered server. According to this document, I should change the service account, then stop the database and then restart the services and the database.

In a cluster this would mean to first stop the passive node to prevent failover, then perform the outlined procedure on the active node, then change the accounts on the passive node and finally reenable the passive cluster node. Is this correct? And, if correct, should I just pause the passive node or should I stop the cluster service?

 

[mrdenny]

To stop the service simply stop the service from within the Cluster Administrator GUI. Then edit the services on both nodes and then restart the services.

You can infact edit the services on the passive node, fail over to it, then edit the services on the other node. You can then fail back if you so desire.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com