Oracle tablespace agent section is blank and no errors

Troubleshooting
,
1

**CMK version:2.0.0p22
**OS version:Centos 8

Error message: No error message

Can you please advise what can be wrong ?

2

Read this first; Monitoring Oracle databases (checkmk.com)

Regards, Christian

3

I have already read this but didn’t find any cluse why the <<<oracle_tablespaces>>> section is blank. Also tried the debug mode of the oracle plugin which doesn’t provide any evidence why the tablespaces are not being queried.

4

Did you check ther rights of the oracle user? Have you add the configuration for the oracle instances as described?
Regards, Christian

5

Yes.Its exactly the same as described in the 2.1. Create a user.
All other sections appear and have data except the Oracle tablespace

6

Could you show us the output from ‘mk_oracle -t’?
Could you check the current state of all Tablespaces with sqlplus? (Script: https://raw.githubusercontent.com/Rendanic/SQL-Zauberkasten/master/sql/tbs/tbs.sql)
Does it take more then 10-20 seconds until the SQL shows a response?

Kind Regards
Thorsten

7

Hi @Rendanic
mk_oracle -t works without any problems.
I also queried my Oracle 19c Database with the SQL that you provided and the Tablespace information is showed pretty fast.
I noticed a wierd behaviour. When I do mk_oracle -l , then I see all the tablespaces listed under <<<oracle_tablespaces>>> in the command output. This only happens on RHEL8. On RHEL7, the same mk_oracle.cfg works without any problems.

8

So, If I put the sections under SYNC_SECTIONS, then this fixes the problem on 2.0.0p22 with Databases on RHEL8. I have no idea why. Did something changed recently on the agent side or plugin side ?

9

The Linux agent was modified very much over the last months.
Was there, on this machine, an older agent installed before?
Also it can have an impact if the agent runs as xinetd or systemd service.

10

Hi @andreas-doehler
The old agent was 2.0.0p17 and it was never modified. I just updated the agent to 2.0.0p22 which updated the agent + the agent plugin.
This behavior also occur when I manually execute the mk_oracle agent plugin from the command line. In my case, the agent always runs as systemd.

11

Hello,
I build a test environment:

DB-User c##check_mk

create user c##check_mk identified by Oracle123;
grant select_catalog_role,create session to c##check_mk;

omd version
OMD - Open Monitoring Distribution Version 2.0.0p22.cre

I copied the agent and mk_oracle from that installation. It should be the same as with cfe or cee version of checkmk.

mk_oracle configuration:

cat /etc/check_mk/mk_oracle.cfg

DBUSER=c##check_mk:Oracle123

cat /etc/check_mk/sqlnet.ora

LOG_DIRECTORY_CLIENT = /var/log/check_mk/oracle_client
DIAG_ADR_ENABLED = OFF

SQLNET.WALLET_OVERRIDE = FALSE
WALLET_LOCATION =
 (SOURCE=
  (METHOD = FILE)
  (METHOD_DATA = (DIRECTORY=/etc/check_mk/oracle_wallet))
 )

Test the plugin:
export MK_CONFDIR=/etc/check_mk

/usr/lib/check_mk_agent/plugins/mk_oracle -t

<<<oracle_instance>>>
<<<oracle_sessions>>>
<<<oracle_logswitches>>>
<<<oracle_undostat>>>
<<<oracle_recovery_area>>>
<<<oracle_processes>>>
<<<oracle_recovery_status>>>
<<<oracle_longactivesessions>>>
<<<oracle_dataguard_stats>>>
<<<oracle_performance>>>
<<<oracle_locks>>>
<<<oracle_systemparameter>>>
<<<oracle_tablespaces>>>
<<<oracle_rman>>>
<<<oracle_jobs>>>
<<<oracle_resumable>>>
<<<oracle_iostats>>>
<<<oracle_instance>>>
<<<oracle_processes>>>
<<<oracle_asm_diskgroup>>>

---login----------------------------------------------------------------
    Operating System:       Linux
    ORACLE_HOME (oratab):   /u01/app/oracle/product/19/db1
    Logincheck to Instance: DB1
    Version:                19.0
    Login ok User:          C##CHECK_MK on dbfs161.local Instance DB1
    SYNC_SECTIONS:          instance sessions logswitches undostat recovery_area processes recovery_status longactivesessions dataguard_stats performance locks systemparameter
    ASYNC_SECTIONS:         tablespaces rman jobs resumable iostats
------------------------------------------------------------------------

/usr/lib/check_mk_agent/plugins/mk_oracle -s tablespaces

<<<oracle_tablespaces:sep(124)>>>
DB1|/u02/oradata/DB1/datafile/o1_mf_undotbs1_k6bs8zx8_.dbf|UNDOTBS1|AVAILABLE|YES|100480|1048576|100352|6400|ONLINE|8192|ONLINE|512|UNDO|19.0.0.0.0
DB1|/u02/oradata/DB1/datafile/o1_mf_users_k6bs91w0_.dbf|USERS|AVAILABLE|YES|640|262144|512|6400|ONLINE|8192|ONLINE|296|PERMANENT|19.0.0.0.0
DB1|/u02/oradata/DB1/datafile/o1_mf_system_k6bs7d3w_.dbf|SYSTEM|AVAILABLE|YES|129280|524288|129152|6400|SYSTEM|8192|ONLINE|6296|PERMANENT|19.0.0.0.0
DB1|/u02/oradata/DB1/datafile/o1_mf_sysaux_k6bs8j2v_.dbf|SYSAUX|AVAILABLE|YES|108800|524288|108672|6400|ONLINE|8192|ONLINE|10144|PERMANENT|19.0.0.0.0
DB1.CDB$ROOT|/u02/oradata/DB1/datafile/o1_mf_temp_k6bsbkdd_.tmp|TEMP|ONLINE|YES|9344|524288|9216|6400|ONLINE|8192|ONLINE|9344|TEMPORARY|19.0.0.0.0

I am getting the tablespace data from the plugin. I miss the data from pdbs, because the monitoring user is lacking the priviledges to select the data from PDBs.

Please rename c##check_mk to check_mk for non CDB environments and don’t forget to change the username in mk_oracle.cfg as well.

Could you show us the data from mk_oracle -t and mk_oracle -s tablespaces?
State of Selinux?

Greetings
Thorsten

1 Like
12

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed. Contact an admin if you think this should be re-opened.