Re: NT Services and system account

Do you have the Oracle service running under a local or domain account? If you have a domain, use a domain account. Hopefully both machines are in the same domain. You can check by going to Control Panel > Network > Identification. If they are in different domains, talk to your NT admins about trusts. If they are not in a domain, then ensure the account you created exists on both machines, and has the same password. Both are case-sensitive.

Also, mapped drive letters are only accessible to the interactive user. Services cannot get to them. Try to use the Universal Naming Convention (UNC) path to the file. Assuming that you have J: mapped to sharename Share1 on Server1, the UNC path is \\Server1\share1 If the target share is on an NTFS partition, ensure the account that your Oracles service is running under has permissions at the file-system level.

--
Christopher Payne, MCSE

"mgumbs" <mgumbsNOmgSPAM_at_hotmail.com.invalid> wrote in message news:0a0133f8.8231b4b2_at_usw-ex0107-043.remarq.com...
> Hi,
>
> I have a problem (one of a few at the mo!). Let me summarise....
>
> I am trying to use utilities such as utl_file and dbms_lob on an oracle
> database on Windows NT. Oracle is stored on one box and other apps,
> including the web server is on a sister box. Both boxes have fixed
> drives (c:) and mapped network drives (j: k:).
>
> If i wanted to write something to a file using utl_file to c:\temp,
> that works fine since c: is a physical drive. If I try to write to a
> mapped drive (j:\temp) that fails because j: is a mapped drive.
>
> Oracle says the service OracleService<SID> by default runs under the
> system account which doesn't have the necessary NT permissions to
> access shared drives. They suggested to create an NT user with the
> necessary privs and under Control Panel > Services >
> OracleService<SID>, in the startup option, put this NT user under the
> 'Log In As' box.
>
> I did this but although the servise said it has started, oracle didn't
> (ie No new entried in the alert log and cannot connect in sql*plus).
>
> Has anyone done this successfully?
> Is there something i didn't do permission wise? (Bear in mind that i'm
> not an NT administrator by ay means!)
>
> Any help welcome, replies by email also.
>
> Mark
>
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Tue Nov 16 1999 - 21:37:38 CST