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

sjz_24_at_hotmail.com (Tina) wrote in message news:<9f3b69d5.0305071044.5eb36ba_at_posting.google.com>...
> 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

Keep it simple, it always pays off.

Let the Oracle do what it is supposed to do WITHOUT being dependent on a remote machine...i.e. Write archives to a local fixed disk. Read up on OFA to determine your disk layout for datafiles, redologs, archives etc.

Let the OS do what it does best... i.e. setup a scheduled/cron job to copy/move archive files (sorted by age... oldest first) to a remote machine. It is simple to write a batch script to do that.

Regards
/Rauf Sarwar Received on Thu May 08 2003 - 23:28:58 CDT