欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

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

程序员文章站 2022-07-04 09:40:53
windows网络映射驱动器存放oraclefile的问题 applies to: oracle database - enterprise edition - version 9.0.1.4 to...

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;