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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.