I have a problem when monitoring all the databases on my servers.
I will explain a little about the process I have done. I currently have two Oracle Linux servers and on each of them I have databases installed. The point is that, I already installed the checmk agent and discovered the services of each of the hosts… and it monitors network services, operating system… But, on a host it does recognize the databases to monitor but On host number two, only the Oracle SID of one database recognizes me and it does not recognize that of the other databases. When I try to log in to find out what the problem is, I get the following message:
Error message: [set_ora_env] ORA-99999 ORACLE_HOME for SID ‘pepito’ not found or not existing!
I already tried to set the ORACLE_HOME for each ORACLE_SID of the databases in: oratab (on linux /etc/oratab).
But, this didn’t work, can anyone help me with this problem?
CMK version: OMD - Open Monitoring Distribution Version 2.2.0p14.cce OS version: Oracle Linux 7.9
I tried the manual connection with the same credentials that are configured mk_oracle.cfg, this makes the connection correctly.
Is tnsnames.ora and sqlnet.ora accessible by the plugin? … How can I know that? I think yes, because when I am trying to obtain the result of this command ./mk_oracle -t it recognizes an instance that currently does not have access credentials…
I leave you the output of the command ./mk_oracle -t . To put you in context, on this server I have 4 instances… instance1, instance2, instance3 and instance4… but it only recognizes instance4 and the others don’t.
[root@server02 plugins]# ./mk_oracle -t
<<<oracle_instance>>>
<<<oracle_performance>>>
<<<oracle_processes>>>
<<<oracle_sessions>>>
<<<oracle_longactivesessions>>>
<<<oracle_logswitches>>>
<<<oracle_undostat>>>
<<<oracle_recovery_area>>>
<<<oracle_recovery_status>>>
<<<oracle_dataguard_stats>>>
<<<oracle_tablespaces>>>
<<<oracle_rman>>>
<<<oracle_jobs>>>
<<<oracle_resumable>>>
<<<oracle_locks>>>
<<<oracle_systemparameter>>>
<<<oracle_instance>>>
<<<oracle_processes>>>
<<<oracle_asm_diskgroup>>>
Logindetails: /@server02.server.server:1521/+ASM2 as SYSASM
Logindetails: /@server02.server.server:1521/instance4
./mk_oracle: line 624: : No such file or directory
./mk_oracle: line 624: : No such file or directory
./mk_oracle: line 624: : No such file or directory
—login----------------------------------------------------------------
Operating System: Linux
ORACLE_HOME (GI): /u01/app/19.3.0/grid
Logincheck to Instance: +ASM2
Version:
Error Message: +ASM2|FAILURE|ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect
SYNC_SECTIONS: instance processes
ASYNC_SECTIONS: asm_diskgroup
—login----------------------------------------------------------------
Operating System: Linux
ORACLE_HOME (GI): /u01/app/oracle/product/19.0.0/dbhome_1
Logincheck to Instance: instance4
Version:
Error Message: instance4|FAILURE|ERROR: ORA-12578: TNS:wallet open failed SP2-0751: Unable to connect to Oracle. Exi
SYNC_SECTIONS: instance performance processes sessions longactivesessions logswitches undostat recovery_area recovery_status dataguard_stats tablespaces rman jobs resumable locks systemparameter
ASYNC_SECTIONS:
[root@server02 plugins]# ./mk_oracle -l
Logging to file: /var/lib/check_mk_agent/log/mk_oracle.log
<<<oracle_instance>>>
<<<oracle_performance>>>
<<<oracle_processes>>>
<<<oracle_sessions>>>
<<<oracle_longactivesessions>>>
<<<oracle_logswitches>>>
<<<oracle_undostat>>>
<<<oracle_recovery_area>>>
<<<oracle_recovery_status>>>
<<<oracle_dataguard_stats>>>
<<<oracle_tablespaces>>>
<<<oracle_rman>>>
<<<oracle_jobs>>>
<<<oracle_resumable>>>
<<<oracle_locks>>>
<<<oracle_systemparameter>>>
<<<oracle_instance>>>
<<<oracle_processes>>>
<<<oracle_asm_diskgroup>>>
./mk_oracle: line 624: : No such file or directory
2024-03-14 16:17:27 [2] [instance1] [set_ora_env] ORA-99999 ORACLE_HOME for SID ‘instance1’ not found or not existing!
./mk_oracle: line 624: : No such file or directory
2024-03-14 16:17:28 [2] [instance2] [set_ora_env] ORA-99999 ORACLE_HOME for SID ‘instance2’ not found or not existing!
./mk_oracle: line 624: : No such file or directory
2024-03-14 16:17:28 [2] [instance3] [set_ora_env] ORA-99999 ORACLE_HOME for SID ‘instance3’ not found or not existing!
<<<oracle_instance:sep(124)>>>
+ASM2|FAILURE|ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor SP2-0751: Unable to connect to Oracle. Exiting SQL*Plus
<<<oracle_instance:sep(124)>>>
instance4|FAILURE|ERROR: ORA-12578: TNS:wallet open failed SP2-0751: Unable to connect to Oracle. Exiting SQL*Plus
Sections to run in the background, at a slower interval cached
ASYNC_SECTIONS=‘’
Sections to run in foreground for ASM
SYNC_ASM_SECTIONS=‘instance processes’
Sections to run in the background for ASM
ASYNC_ASM_SECTIONS=‘asm_diskgroup’
Cache time (i.e. check interval) for async sections
CACHE_MAXAGE=600
###########################################
NOTE: In the check configuration I only have instance1 configured to do the tests. But as you can see, instance4 that is recognizing is not configured.
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.
