Tom,
I am setting up an Oracle 8.1.5 testing instance on an NT 4.0 server. I have been successful at creating the database when all of the files (control/rbs/data) are on the c: drive of the server. However, this scenario does not meet OFA recommendations. I wanted to move some of my data files to network drives so that I could reduce the vulnerability of the database to a crash of the c: drive.

I have an administrator account on the server and I am able to create files on the network drive (F:). The Oracle instance is named tnt1. I have changed the oracle NT service "oracleservicetnt1" to log on as my administrator account on the server. I then stop the service and reboot NT. The service is set to start automatically. I then perform the following in server manager:

SVRMGR> alter tablespace indx offline;
Statement processed.
SVRMGR> alter tablespace indx
2> rename datafile 'c:\app\oracle\oradata\tnt1\indx01.dbf'
3> to 'f:\oradata\tnt1\indx01.dbf'
4> ;
alter tablespace indx
*
ORA-01525: error in renaming data files
ORA-01141: error renaming data file 5 - new file 'f:\oradata\tnt1\indx01.dbf' not found
ORA-01110: data file 5: 'C:\APP\ORACLE\ORADATA\TNT1\INDX01.DBF'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 1326) Logon failure: unknown user name or bad password.
SVRMGR>


I am fairly certain this is a network type problem because when I move the datafile to another location on the c: drive it is successful.

SVRMGR>
SVRMGR> alter tablespace indx
2> rename datafile 'c:\app\oracle\oradata\tnt1\indx01.dbf'
3> to 'c:\app\oracle\oradata\tnt1b\indx01.dbf';
Statement processed.
SVRMGR>
SVRMGR> alter tablespace indx online;
Statement processed.
SVRMGR> select * from v$database;
DBID NAME CREATED RESETLOGS_ RESETLOGS PRIOR_RESE PRIOR_RES LOG_MODE
KPOINT ARCHIVE_CH CONTROL CONTROLFI CONTROLFIL CONTROLFIL CONTROLFI OPEN_RESETL VERS
OPEN_MODE
---------- --------- --------- ---------- --------- ---------- --------- -----------
------ ---------- ------- --------- ---------- ---------- --------- ----------- ----
----------
1513710746 TNT1 23-JUN-00 1 23-JUN-00 0 ARCHIVELOG
237300 197270 CURRENT 23-JUN-00 604 237330 29-JUN-00 NOT ALLOWED 23-J
READ WRITE
1 row selected.
SVRMGR>


When I talk to the NT folks they told me that when the service starts my account logs in again and is not mapping the network drives. One of the admins coded a bat file that ran as a login type script for the profile of my account. The bat file contained the "net use" command to map the network drive. However, when we started the service again the login of the account when starting the service would not execute this portion of the profile(login). The drive was not mapped.

I there any way to do what I am trying to accomplish. It seems that NT being a "network" operating system, that Oracle on NT should be able to read/write network disk drives.

One other questions is can you refer me to good reference material for coding bat files and scripts in NT/dos and a reference on NT/dos commands.

Thanks in advance! Pete Snyder