Use network mapped drive in Oracle of windows

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.

This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply