Windows网络映射驱动器存放Oraclefile的问题

windows网络映射驱动器存放oraclefile的问题

applies to:

oracle database - enterprise edition - version 9.0.1.4 to 10.2.0.3 [release 9.0.1 to 10.2]

z*obsolete: microsoft windows

microsoft windows

goal

how to change db_recovery_file_dest to use network mapped drive?

alter system set db_recovery_file_dest = 'x:\dbbackup\database\flash_recovery_area' scope=both;

ora-02097: parameter cannot be modified because specified value is invalid

ora-01261: parameter db_recovery_file_dest destination string cannot be translated

ora-01263: name given for file destination directory is invalid

osd-04018:unable to access the specified directory or device. (oerr:osd.4018)

o/s-error: (os 3) the system cannot find the path specified.

solution

here the problem is that the oracle service started with a user that does not have the privilege to access this mapped drive, the following steps provide a solution for this problem.

1-set the oracle service to log on with the user who has privilege on the mapped drive.

2-restart the service

3-alter system set db_recovery_file_dest = 'x:\dbbackup\database\flash_recovery_area' scope=both;