No question at this time
DBA Top 10
1 M. Cadot 5400
2 P. Wisse 1300
3 P. Tsongayinwe 1100
4 B. Vroman 500
4 J. Schnackenberg 500
6 M. Pagac 400
7 A. Deledda 200
7 D. Walgude 200
7 B. M 200
10 J. Alcroft 100
10 G. Trivedi 100
10 A. Hudspith 100
10 V. Sharma 100
10 L. Ywema 100
About
DBA-Village
Advertise here
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48742
Total active users1337
Act. users last 24h1
Act. users last hour0
Registered user hits last week108
Registered user hits last month471
Go up

RDS instance:- ORA-29283: invalid file operation: nonexistent file or path [29434]
Next thread: database can't open due to sysaux tablespace is full
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, 81 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, 81 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, 81 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, 81 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, 81 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, 81 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, 78 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, 78 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