2 Replies Latest reply on Jul 14, 2020 4:52 PM by Sven W.

    KUP-04027: file name check failed: qopatch_log.log

    Aji Thomas

      on 18c XE on windows we face the following:

       

      SQL> select * from OPATCH_XML_INV ;

      ERROR:

      ORA-29913: error in executing ODCIEXTTABLEOPEN callout

      ORA-29400: data cartridge error

      KUP-04027: file name check failed: qopatch_log.log

       

      Also in alert log we notice issues

       

       

      2020-06-17T10:01:45.774350+03:00

      QPI: opatch file present, opatch.bat

      QPI: qopiprep.bat file present

      Unable to obtain current patch information due to error: 20001, ORA-20001: Latest xml inventory is not loaded into table

      ORA-06512: at "SYS.DBMS_QOPATCH", line 2333

      ORA-06512: at "SYS.DBMS_QOPATCH", line 856

      ORA-06512: at "SYS.DBMS_QOPATCH", line 939

      ORA-06510: PL/SQL: unhandled user-defined exception

      ORA-06512: at "SYS.DBMS_QOPATCH", line 934

      ORA-29913: error in executing ODCIEXTTABLEOPEN callout

      ORA-29400: data cartridge error

      KUP-04027: file name check failed: qopatch_log.log

      ORA-06512: at "SYS.DBMS_QOPATCH", line 921

      ORA-06512: at "SYS.DBMS_QOPATCH", line 2292

      ORA-06512: at "SYS.DBMS_QOPATCH", line 819

      ORA-06512: at "SYS.DBMS_QOPATCH", line 2315

       

      ===========================================================

      Dumping current patch information

      ===========================================================

      Unable to obtain current patch information due to error: 20001

      ===========================================================

      2020-06-17T10:01:46.680597+03:00

      Errors in file C:\ORACLE\PRODUCT\18.0.0\diag\rdbms\xe\xe\trace\xe_m001_10620.trc:

      ORA-27037: unable to obtain file status

      OSD-04011: GetFileInformationByHandle() failure, unable to obtain file info

      O/S-Error: (OS 5) Access is denied.

      2020-06-17T10:01:46.758720+03:00

      Errors in file C:\ORACLE\PRODUCT\18.0.0\diag\rdbms\xe\xe\trace\xe_m001_10620.trc:

      ORA-27037: unable to obtain file status

      OSD-04011: GetFileInformationByHandle() failure, unable to obtain file info

      O/S-Error: (OS 5) Access is denied.

        • 1. Re: KUP-04027: file name check failed: qopatch_log.log
          Aji Thomas

          Trace file C:\ORACLE\PRODUCT\18.0.0\diag\rdbms\xe\xe\trace\xe_m001_10620.trc

          Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production

          Version 18.4.0.0.0

          Build label:    RDBMS_18.4.0.0.0DBRU_WINDOWS.X64_190202.XE

          Windows NT Version V6.2 

          ORACLE_HOME =  C:\oracle\product\18.0.0\dbhomeXE

          Node name           : RSRV2

          CPU                 : 2 - type 8664, 2 Physical Cores

          Process Affinity    : 0x0x0000000000000000

          Memory (Avail/Total): Ph:2075M/6143M, Ph+PgF:7396M/11519M

          VM name             : VMWare Version (6)

          Instance name: xe

          Redo thread mounted by this instance: 1

          Oracle process number: 41

          Windows thread id: 10620, image: ORACLE.EXE (M001)

           

           

          *** 2020-06-17T10:01:46.618100+03:00

          *** SESSION ID:(780.22610) 2020-06-17T10:01:46.618100+03:00

          *** CLIENT ID:() 2020-06-17T10:01:46.618100+03:00

          *** SERVICE NAME:(SYS$BACKGROUND) 2020-06-17T10:01:46.618100+03:00

          *** MODULE NAME:(MMON_SLAVE) 2020-06-17T10:01:46.618100+03:00

          *** ACTION NAME:(CLI Partition execution) 2020-06-17T10:01:46.618100+03:00

          *** CLIENT DRIVER:() 2020-06-17T10:01:46.618100+03:00

           

          *********** START A RUN OF [CLI Partition execution] *************

          *** MODULE NAME:(MMON_SLAVE) 2020-06-17T10:01:46.618100+03:00

          *** ACTION NAME:(Monitor Tablespace Thresholds) 2020-06-17T10:01:46.618100+03:00

           

          *********** START A RUN OF [Monitor Tablespace Thresholds] *************

          Error in computing freespace for file 0000017C76547918 C:\ORACLE\PRODUCT\18.0.0\ORADATA\XE\SYSTEM01.DBF

          ORA-27037: unable to obtain file status

          OSD-04011: GetFileInformationByHandle() failure, unable to obtain file info

          O/S-Error: (OS 5) Access is denied.

          • 2. Re: KUP-04027: file name check failed: qopatch_log.log
            Sven W.

            Just for clarification: Which exact windows OS did you use?

             

             

            From

            https://docs.oracle.com/en/database/oracle/oracle-database/18/xeinw/requirements.html#GUID-20C6E0B0-84F5-418B-8D55-05F7C…

            Oracle Database XE for Windows x64 is supported on the following operating system versions:

            • Windows 7 x64 - Professional, Enterprise, and Ultimate editions
            • Windows 8.1 x64 - Pro and Enterprise editions
            • Windows 10 x64 - Pro, Enterprise, and Education editions
            • Windows Server 2012 x64 - Standard, Datacenter, Essentials, and Foundation editions
            • Windows Server 2012 R2 x64 - Standard, Datacenter, Essentials, and Foundation editions
            • Windows Server 2016 x64 - Standard, Datacenter, and Essentials editions

             

            ...

             

            3.2 Permission Requirement for Installing Oracle Database XE

            You must be part of the Administrators group on Windows to install Oracle Database XE. If you are logged in as a domain user, ensure sure that you are connected to the network before you install Oracle Database XE.

            Note that for example Windows 10 Home or Windows NT  is not supported.