Click here to Skip to main content
13,152,293 members (38,694 online)
Rate this:
Please Sign up or sign in to vote.
See more:
Hello everyone,

I have an instance of oracle 11g server installed on a workgroup network server,
it was perfect. A few days ago, I had been forced to install Active directory on that server, and then oracle seems to be dead.

services does not starting except the listener services. I used the 'net configuration assistant' to set it to use active directory, but still it doesn't work.

I searched the web a lot, but the most results are for the time that you didn't install the oracle yet.

i will appreciate if you can help me out.
Posted 16-Sep-12 2:11am
Bernhard Hiller 17-Sep-12 5:04am
Did the IP address of your server change? I faced many probelms when that happened...
Does the Oracle service run with the account of a (local) user of the server?
vahid_gian 17-Sep-12 5:09am
Hi Bernhard,

No, no IP changed and I have changed the service account to the domain controller Administrator and still not starting

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

You could have left the service accounts as "Local System" without any problems. It's not the service accounts that's your problem.

When you install Oracle it asks you for an account to use as a database administrator. This usually is the local administrator account.
Which doesn't exist anymore as you have installed active directory on your database server.

This account is belonging to a security group called ora_dba, that has all the file security set for the database files and the files needed to run many parts of Oracle.
This security group doesn't exist anymore as you have installed active directory on your database server.

The DBA account also needs a few other specific rights set to be able to work properly.
If you open up the "Local Security Policy" on your computer, which you find under "Administrative Tools", this DBA account needs to have the right to "Lock pages in memory", "Logon as batch job" and "Logon as service" besides being a local administrator.
But guess what, "Local Security Policy" doesn't exist on a domain controller.

Installing Active Directory is something that should never be done on a database server, ever! For many more reasons than that you f*** up your system. (I'll leave the explanation for that to google)

Solution one. Remove active directory, if you haven't messed up any other settings it will automagically work again.
Solution two. Hire an Oracle DBA to fix the mess.
vahid_gian 18-Sep-12 4:58am
Okay Jorgen,
thank you, absolutely I removed active directory.
Jörgen Andersson 18-Sep-12 5:26am
You're welcome

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web04 | 2.8.170924.2 | Last Updated 17 Sep 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100