tags:

views:

95

answers:

1
+1  Q: 

How to setup Oracle on Windows not to run as local system user

I need my Oracle database (single instance 10GR2) to be able to access certain files on the network. Running the service under the local system account prevents this. I will be using UNC paths so I won't run into any drive mapping issues.

What account should I use? How do I setup such an account?

Any expriences are welcome.

+1  A: 

Go to the Services manager (Start -> Run -> "services.msc") Select the Oracle services you need to change, right-click, and choose "Properties" Click the "Log On" tab

You can set it to any account you like there.

FerretallicA  2010-01-12 08:15:32
Thanks, what I would like to know is if there are any properties this uaccount must have. What pitfalls are there? Password expire etc.
Rene  2010-01-12 08:26:22
Those are more serverfault questions as they are administrative in nature, no?
Adam Hawkes  2010-01-12 14:27:26
As long as the account you assign it to has permission to access the network shares you need, I can't think of anything special that would apply which isn't just common sense (like you already pointed out password expiry).
FerretallicA  2010-01-12 22:54:41

related questions

Is there a Way to use Linq to Oracle
NHibernate and Oracle connect through Windows Authenication
Boolean Field in Oracle
How do you manage schema upgrades to a production database?
How do I deal with quotes ' in SQL
When do you use table clusters?
Oracle write to file
MS SQL Server 2008 "linked server" to Oracle : schema not showing
Develop on local Oracle instance
Resources for an Oracle beginner
What strategies have you employed to improve web application performance?
Automate Syncing Oracle Tables With MySQL Tables
Best way to encapsulate complex Oracle PL/SQL cursor logic as a view?
What Content Management does your workplace use?
What is the difference between oracle's 'yy' and 'rr' date mask?
SQL/Query tools?
How to make Pro*C cope with #warning directives?
Oracle SQL Developer not responsive when trying to view tables (or suggest an Oracle Mac client)
How big would such a database be?
Oracle - What TNS Names file am I using?
What is a good way to open large files across a WAN?
How do I find the high water mark (for sessions) on Oracle 9i
SQL Case Statement Syntax?
cx_Oracle - what is the best way to iterate over a result set?
cx_Oracle - How do I access Oracle from Python?