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

"Tina" <sjz_24_at_hotmail.com> 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.

I bet that you haven't. I bet you now have 2 accounts LOCAL\ORACLEACCOUNT and TEST\ORACLEACCOUNT. If you were doing this the appropriate account to use would be a domain account and not a local one.

> 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.

For the reasons that Sybrand specifies I'd strongly suggest that you either reconsider this scheme OR make archive destination 2 optional.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK