当前位置： 移动技术网 > IT编程>数据库>Oracle > Windows网络映射驱动器存放Oraclefile的问题

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

2018年12月10日  | 移动技术网IT编程  | 我要评论

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;

您可能感兴趣的文章:

如对本文有疑问， 点击进行留言回复！！

相关文章:

验证码：
最近更新的文章
大家感兴趣的文章
移动技术网