Remember that it is not your account that is creating the file, but the
account that runs the Oracle services. This is ususally SYSTEM - a local
account, not a domaion account. As such, this account has no privileges on
any other machine.
If you really want to do this (and I really do NOT recommend it), you'll
need to alter the Oracle service so that they are run by a suitably
privileged domain account. This isn't easy - getting the privilege set right
can be a problem. You'll need to make sure that the domain account has
access to the remote server's files. Given the high privileges required,
it's probably a good idea to set up the account so that no-one can log in as
this user (except, of course, the oracle service will be able to log in
because the account will have 'log on as a service' rights).
Why do I think this is a bad idea? Well, think about it. The validity of
your database is now dependent on at least one and probably two remote
servers as well as the network itself. If any of these fail, your database
will start having problems. For example...
1) If the oracle service can't contact the domain controller(s) to validate
the logon, then the oracle service won't start - so, no database!
2) If the network fails, or if someone inadvertently alters the access
permissions of the remote server, or if the server is down, then data
database won't be able to open the remote file and so won't start.
3) If the network or the remote server goes down, or an administrator on the
remote server disconnects the Oracle service's access to the file (eg while
diagnosing some other problem), then the database will start to experience
problems as sessions try to access the data in the file. The only solution
will be to re-start the database and PERFORM MEDIA RECOVERY ON THE FILE. OK,
this should be automatic, but be wary.
4) How are you going to ensure consistent backups? It's not impossible, but
it needs careful planning if you are not to find yourself with an
unrecoverable database!
In short, the error rate on the database is likely to be very high leaving
you with a high management workload.
-----Original Message-----
From: oraora oraora [mailto:[Email Address Removed] 31 January 2003 03:04
To: LazyDBA.com Discussion
Subject: how to create datafile in shared network drive ??
Guys,
the env. is 8.1.6/win2k.
SQL > alter tablespace test add datafile
'\\192.168.17.111\shared\test.dbf' size 100m;
ORA-01119: error in creating database file
'\\192.168.0.111\shared\test.dbf'
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: cannot open file.
O/S-Error: (OS 5) access denied.
But i have all access/permission to this drive.
i mapped this shared network drive and then tried once again.
even then i get the same error.
Is it possible to create a tablespace with datafile residing in a
shared network drive ??
TIA.
Prem.
--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page