Hi , I have a load balancer for db between two servers :
| Server 1 | Server 2 |
|---|
| TESTDB01 | TESTDB02 |
| \\192.168.34.110 | \\192.168.34.111 |
I have a file text.xlsx which exists both in the paths
\\192.168.34.110\e$\temp
\\192.168.34.111\e$\temp
And I would like to make a copy of file on both servers as new_test.xlsx.
So I have a direcotry defined as follow :
CREATE OR REPLACE DIRECTORY TEST as 'E:\TEMP';
and the copy functionality works but it copy only on the running server (SELECT host_name FROM v$instance)
I am trying to make directories with the following ways
CREATE OR REPLACE DIRECTORY TEST1 AS '\\192.168.34.110\E:\TEMP';
CREATE OR REPLACE DIRECTORY TEST2 AS '\\192.168.34.111\E:\TEMP';
or
CREATE OR REPLACE DIRECTORY TEST1 AS 'TESTDB01\e$\temp';
CREATE OR REPLACE DIRECTORY TEST2 AS 'TESTDB01\e$\temp';
or
CREATE OR REPLACE DIRECTORY TEST1 AS '\TESTDB01\e$\temp';
CREATE OR REPLACE DIRECTORY TEST2 AS '\TESTDB02\e$\temp';
or
CREATE OR REPLACE DIRECTORY TEST1 AS '\\192.168.34.110\e$\TEMP';
CREATE OR REPLACE DIRECTORY TEST2 AS '\\192.168.34.111\e$\TEMP';
BEGIN
UTL_FILE.FCOPY ('TEST1',
'text.xlsx',
'TEST1',
'new_test.xlsx');
UTL_FILE.FCOPY ('TEST2',
'text.xlsx',
'TEST2',
'new_test.xlsx');
END;
/
But I get error
29283. 00000 - "invalid file operation"
*Cause: An attempt was made to read from a file or directory that does
not exist, or file or directory access was denied by the
operating system.
Any ideas please ?
Thanks in advance