dbms_sqldiag.import_sql_testcase fails with ORA-20006 ORA-39000 ORA-31640 ORA-27037 (Doc ID 2963436.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

SQL> begin
  dbms_sqldiag.import_sql_testcase(directory=>'TCB_DIR', filename =>'oratcb_0_<sql_id>_1_080B2E870001main.xml');
end;
/

*
ERROR at line 1:
ORA-20006: ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "<directory>/oratcb_0_<sql_id>_1_080B2E870001dpexp.dmp" for read
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
tain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
ormation: 7
ORA-06512: at "SYS.DBMS_SQLTCB_INTERNAL", line 3940
ORA-06512: at "SYS.DBMS_SQLTCB_INTERNAL", line 6244
ORA-06512: at "SYS.DBMS_SQLDIAG", line 1096
ORA-06512: at line 2

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.