No question at this time
DBA Top 10
1 M. Cadot 7400
2 B. Vroman 1700
3 P. Wisse 1300
4 P. Tsongayinwe 1200
5 J. PĂ©ran 800
6 J. Schnackenberg 400
7 J. Alcroft 200
7 D. Walgude 200
7 B. M 200
10 A. Hudspith 100
10 L. Ywema 100
10 D. Johnson 100
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48726
Total active users1323
Act. users last 24h0
Act. users last hour0
Registered user hits last week35
Registered user hits last month263
Go up

RDS instance:- ORA-29283: invalid file operation: nonexistent file or path [29434]
Next thread:
Prev thread: DBTIMEZONE of both instances shows UTC.

Message Score Author Date
Dear All Facing " ORA-29283: invalid file opera...... dattatraya walgude Mar 14, 2023, 12:06
You may have the right to read the .txt file but...... Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts Michel Cadot Mar 14, 2023, 12:18
Thanks Michel, Will check OS right with TI team.... dattatraya walgude Mar 14, 2023, 12:30
I created one test csv file and it's able to rea...... dattatraya walgude Mar 14, 2023, 12:36
Check how the program create the file, especiall...... Michel Cadot Mar 14, 2023, 12:38
Ok... dattatraya walgude Mar 14, 2023, 12:40
Issue resolved , developer confirms that issue wit...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts dattatraya walgude Mar 17, 2023, 06:25
Thank you for the feedback. Regards Michel ... Michel Cadot Mar 17, 2023, 08:11

Follow up by mail Click here


Subject: RDS instance:- ORA-29283: invalid file operation: nonexistent file or path [29434]
Author: dattatraya walgude, India
Date: Mar 14, 2023, 12:06, 11 days ago
Os info: Any
Oracle info: 19c Enterprise Edition Release 19.0.0.0.0 Version 19.16.0.0.0
Message: Dear All

Facing " ORA-29283: invalid file operation: nonexistent file or path [29434] " while reading file through rdsadmin.rds_file_util.read_text_file.

Note: Able to read .txt file from same directory , but file created through proc not able to to read.


SQL> SELECT * FROM TABLE
(rdsadmin.rds_file_util.read_text_file(
p_directory => 'MYDIR',
p_filename => 'GL_2023122301.txt')); 2 3 4

TEXT
--------------------------------------------------------------------------------
23-DEC-2023|23-DEC-2023|INTEREST_ACCRUAL||C|973101|271.534|2023122301
23-DEC-2023|23-DEC-2023|INTEREST_ACCRUAL||D|212900|7294.042|2023122301
23-DEC-2023|23-DEC-2023|INTEREST_ACCRUAL||C|212910|7022.508|2023122301

SQL> SELECT * FROM TABLE(rdsadmin.rds_file_util.listdir(p_directory => 'MYDIR')) where filename like 'DDD%';

FILENAME
--------------------------------------------------------------------------------
TYPE FILESIZE MTIME
---------- ---------- ---------
DDD_2023_07_01.csv
file 1746 14-MAR-23


SQL> SELECT * FROM TABLE
(rdsadmin.rds_file_util.read_text_file(
p_directory => 'MYDIR',
p_filename => 'DDD_2023_07_01.csv')); 2 3 4
(rdsadmin.rds_file_util.read_text_file(
*
ERROR at line 2:
ORA-29283: invalid file operation: nonexistent file or path [29434]
ORA-06512: at "RDSADMIN.RDS_FILE_UTIL", line 124
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-06512: at "SYS.UTL_FILE", line 41
ORA-06512: at "SYS.UTL_FILE", line 478
ORA-06512: at "RDSADMIN.RDS_FILE_UTIL", line 98

Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: RDS instance:- ORA-29283: invalid file operation: nonexistent file or path [29434]
Author: Michel Cadot, France
Date: Mar 14, 2023, 12:18, 11 days ago
Score:   Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts
Message:
You may have the right to read the .txt file but not the .csv one at OS level.

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: RDS instance:- ORA-29283: invalid file operation: nonexistent file or path [29434]
Author: dattatraya walgude, India
Date: Mar 14, 2023, 12:30, 11 days ago
Message: Thanks Michel,
Will check OS right with TI team.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: RDS instance:- ORA-29283: invalid file operation: nonexistent file or path [29434]
Author: dattatraya walgude, India
Date: Mar 14, 2023, 12:36, 11 days ago
Message: I created one test csv file and it's able to read. but created through procedure from the same schema are giving problem.


SQL> DECLARE

fHandle UTL_FILE.FILE_TYPE;

BEGIN

fHandle := UTL_FILE.FOPEN('MYDIR', 'MYTEST.csv', 'w');

UTL_FILE.PUT_LINE(fHandle, 'This is the first line' );
UTL_FILE.PUT_LINE(fHandle, 'This is the second line');
UTL_FILE.PUT_LINE(fHandle, 'This is the third line' );

UTL_FILE.FCLOSE(fHandle);
END;
/

PL/SQL procedure successfully completed.

SQL> SELECT * FROM TABLE(rdsadmin.rds_file_util.listdir(p_directory => 'MYDIR')) where filename = 'MYTEST.csv';

FILENAME
--------------------------------------------------------------------------------
TYPE FILESIZE MTIME
---------- ---------- ---------
MYTEST.csv
file 70 14-MAR-23


SQL> SELECT * FROM TABLE
(rdsadmin.rds_file_util.read_text_file(
p_directory => 'MYDIR',
p_filename => 'MYTEST.csv')); 2 3 4

TEXT
--------------------------------------------------------------------------------
This is the first line
This is the second line
This is the third line

SQL> exec UTL_FILE.FREMOVE ('MYDIR', 'MYTEST.csv');

PL/SQL procedure successfully completed.

SQL>

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: RDS instance:- ORA-29283: invalid file operation: nonexistent file or path [29434]
Author: Michel Cadot, France
Date: Mar 14, 2023, 12:38, 11 days ago
Message:
Check how the program create the file, especially which privileges it gives.
You can first check the differences in the privileges between the file you created and the one the program did.

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: RDS instance:- ORA-29283: invalid file operation: nonexistent file or path [29434]
Author: dattatraya walgude, India
Date: Mar 14, 2023, 12:40, 11 days ago
Message: Ok
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: RDS instance:- ORA-29283: invalid file operation: nonexistent file or path [29434]
Author: dattatraya walgude, India
Date: Mar 17, 2023, 06:25, 8 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Issue resolved , developer confirms that issue with procedure.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: RDS instance:- ORA-29283: invalid file operation: nonexistent file or path [29434]
Author: Michel Cadot, France
Date: Mar 17, 2023, 08:11, 8 days ago
Message:
Thank you for the feedback.

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here