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;