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 moracle账号apped 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;