Re: O/S-Error: (OS 5) Access is denied.

On 7 May 2003 11:44:00 -0700, sjz_24_at_hotmail.com (Tina) wrote:

>Hello
>
>I have problem when I set: log_archive_dest_2='LOCATION=\\test\';
>
>Remote box name: test, win2k
>Local box: win2k, oracle 9i
>
>What I've done:
>1. Created same OS account on local box with adminstrator priviledge.
>2. Created same Oracle account with DBA priviledge.
>3. Changed oracle service logon username to the one I created above.
>I was able to map the remote box as a local drive.
>
>But I kept getting error message:
>ORA-09291: sksachk: invalid device specified for archive destination
>OSD-04018: Unable to access the specified directory or device.
>O/S-Error: (OS 5) Access is denied.
>
>Any help would be highly appreciated,
>Tina

Just because you can map the drive doesn't mean you have permission to write to it. Have you checked permissions? And it certainly doesn't mean this is a "good thing." If the remote machine goes down or you loose the network connection your database will hang. And what happens if some server admin type decides they have a better use for your chosen drive letter, and doesn't inform you that as of last week, 'x:' is defined corporate wide as pointing to a universally accessible folder for storing shared MS Office documents? And since that date an ADMINistrative ASSistant has been doing daily houskeeping in that folder, deleting anything that wasn't a .doc or .xls file?

If you have a MetaLink account (you *do* have a MetaLink account, don't you?) do a search on OSD-04018. You'll see several items describing your problem in excrutiating detail. Received on Wed May 07 2003 - 15:28:16 CDT