Use network mapped drive in Oracle of windows
Use of Network Drive of Windows in Oracle Database configuration with help of user which have mapped and having permission on X drive(mapped drive).
Error: during Mapped drive
SQL> ALTER SYSTEM SET log_archive_dest_1='X:\archive';
ALTER SYSTEM SET log_archive_dest_1='X:\archive'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
Solution
1. Open the Windows services.msc
2. Right click the Oracle DB service and change the logon user which has privilege on the mapped drive.
3. Restart the Oracle Service with changed user.
4. Now try the command with Mapped drive with windows.
ALTER SYSTEM SET log_archive_dest_1='X:\archive';
Note: Make sure your changed user has ORADBA group, add for dba functionality of Oracle.