NT Services and system account

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!