ORA-12791: The oradism utility does not have proper permissions.

 login as: oracle

oracle@192.168.175.5's password:

Activate the web console with: systemctl enable --now cockpit.socket

Last login: Mon Oct  6 06:09:25 2025

[root@qtech bin]# su - oracle

[oracle@qtech ~]$

[oracle@qtech ~]$

[oracle@qtech ~]$ cd cd $ORACLE_HOME/bin

-bash: cd: too many arguments

[oracle@qtech ~]$ cd $ORACLE_HOME/bin

[oracle@qtech bin]$

[oracle@qtech bin]$

[oracle@qtech bin]$

[oracle@qtech bin]$ ls -l oradism

-rwsr-x---. 1 oracle oinstall 1867552 Jul 27  2021 oradism

[oracle@qtech bin]$ sqlplus / as sysdba

SQL*Plus: Release 21.0.0.0.0 - Production on Mon Oct 6 09:13:31 2025

Version 21.3.0.0.0

Copyright (c) 1982, 2021, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup

ORA-12791: The oradism utility does not have proper permissions.

SQL> exit

Disconnected

[oracle@qtech bin]$ su root

Password:

[root@qtech bin]#

[root@qtech bin]# ls -l /u01/app/oracle/product/21c/dbhome_1/bin/oradism

ls: cannot access '/u01/app/oracle/product/21c/dbhome_1/bin/oradism': No such file or directory

[root@qtech bin]# ls -l /u01/app/oracle/product/19.0.0/dbhome_1/bin/oradism

-rwxr-x---. 1 root oinstall 1867552 Jul 27  2021 /u01/app/oracle/product/19.0.0/dbhome_1/bin/oradism

[root@qtech bin]#

[root@qtech bin]# su - oracle

[oracle@qtech ~]$

[oracle@qtech ~]$ sqlplus / as sysdba

SQL*Plus: Release 21.0.0.0.0 - Production on Mon Oct 6 09:17:38 2025

Version 21.3.0.0.0

Copyright (c) 1982, 2021, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 2415916664 bytes

Fixed Size                  9688696 bytes

Variable Size             520093696 bytes

Database Buffers         1879048192 bytes

Redo Buffers                7086080 bytes

Database mounted.

Database opened.

SQL>

Employee Employment Date Filter

 /* Formatted on 10/3/2025 6:05:04 AM (QP5 v5.256.13226.35538) */

SELECT *

FROM (

  SELECT '101' emp_no, TO_DATE('01-JAN-2024','DD-MON-YYYY') date_of_employment, TO_DATE('10-JAN-2025','DD-MON-YYYY') date_of_leaving FROM DUAL

  UNION ALL

  SELECT '102', TO_DATE('01-FEB-2024','DD-MON-YYYY'), TO_DATE('10-JAN-2025','DD-MON-YYYY') FROM DUAL

  UNION ALL

  SELECT '103', TO_DATE('01-FEB-2025','DD-MON-YYYY'), TO_DATE('10-SEP-2025','DD-MON-YYYY') FROM DUAL

  UNION ALL

  SELECT '104', TO_DATE('01-JAN-2025','DD-MON-YYYY'), TO_DATE('10-SEP-2025','DD-MON-YYYY') FROM DUAL

  UNION ALL

  SELECT '105', TO_DATE('01-OCT-2025','DD-MON-YYYY'), TO_DATE('30-OCT-2025','DD-MON-YYYY') FROM DUAL

  UNION ALL

  SELECT '106', TO_DATE('01-FEB-2026','DD-MON-YYYY'), TO_DATE('01-MAY-2026','DD-MON-YYYY') FROM DUAL

  UNION ALL

  SELECT '107', TO_DATE('01-JAN-2025','DD-MON-YYYY'), NULL FROM DUAL

  UNION ALL

  SELECT '108', TO_DATE('01-OCT-2025','DD-MON-YYYY'), NULL FROM DUAL

  UNION ALL

  SELECT '109', TO_DATE('01-FEB-2026','DD-MON-YYYY'), NULL FROM DUAL

)

WHERE emp_no IN (NVL('&emp_no_', emp_no))

  AND TRUNC(date_of_employment) >= TO_DATE('&date_of_employment_','DD-MON-YYYY')

  AND (

        (date_of_leaving IS NULL AND date_of_employment <= TO_DATE('&date_of_leaving_','DD-MON-YYYY'))

        OR (TRUNC(date_of_leaving) <= TO_DATE('&date_of_leaving_','DD-MON-YYYY'))

      )