Oracle-L: RE: Oracle on NT

From: Michael P Sale <Michael.Sale_at_oracle.com>
Date: Tue, 04 Jun 2002 16:43:25 -0800
Message-ID: <F001.004746FE.20020604164325@fatcity.com>

Although Oracle _usually_ works fine with UNCs throughout, but I suggest that you map a drive to avoid potential problems. The local system account should NOT be used if you are attempting to perform some type of priveleged activity that would require adding privs (e.g. accessing anything via the network).

If you do change the user running the Oracle service make sure that you also change the listener(s) for that service to run under the same account because the listener spawns the user thread in the oracle.exe process. Thus if you leave it as the low priv local system account it will fail to connect to you to the database.

This is also an issue you will run into with OEM activities that work with mounted drives as the agent runs with the local system account.

Shameless plug: All of this is covered in my book.

Regards,

Michael Sale
Consulting Technical Specialist
PLBDE
Oracle Corporation
Author: Oracle9i for Windows(R) 2000 Tips & Techniques http://www.amazon.com/exec/obidos/ASIN/0072194626

-----Original Message-----
Beth
Sent: Tuesday, June 04, 2002 5:17 PM
To: Multiple recipients of list ORACLE-L

Hi Paul,

I believe you are correct on all counts. I have not used RMAN on NT, but if it will handle UNCs that might be the way to go.

I believe that the local system account runs with the profile of the .Default user. If you could get the drive map into that profile that might work for you also.

Beth

-----Original Message-----
Sent: Tuesday, June 04, 2002 6:48 PM
To: Multiple recipients of list ORACLE-L

A couple of basic questions, if you'll indulge me:

Does the Oracle service on Win2K run in the security domain of its login user (LocalSys)? 2. If so, would that explain why RMAN can't write to a network drive that's mapped by a different user who is logged in to the domain rather than the local machine?

Side question: Am I correct in my belief that the Oracle service must be running before an Oracle instance can start, and that it keeps running even when the instance is shut down?

Many TIA.

Paul Baumgartel

Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Paul Baumgartel
INET: treegarden_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Seefelt, Beth
INET: Beth.Seefelt_at_TetleyUSA.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Michael P Sale
INET: Michael.Sale_at_oracle.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------