OraChk does not work when Parameter THREADED_EXECUTION=TRUE

Mar 2, 2016 4:10PM

As OraChk uses OS authentication, it fails when THREADED_EXECUTION is set to TRUE.

Please see example below:

racle@walhall:/u00/app/oracle/tools/orachk/ [TVD12] echo $ORACLE_SID

TVD12

oracle@walhall:/u00/app/oracle/tools/orachk/ [TVD12] sqlplus sys/manager as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Mon Feb 29 22:39:55 2016

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 2097152000 bytes

Fixed Size 2926320 bytes

Variable Size 671090960 bytes

Database Buffers 1409286144 bytes

Redo Buffers 13848576 bytes

Database mounted.

Database opened.

SQL> show parameter threaded

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

threaded_execution boolean TRUE

AHF - Autonomous Health Framework (TFA - ORACHK) (MOSC)