Ad Widget

Collapse

Oracle DB Template for Zabbix Agent 2 not working.

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Aviad
    Junior Member
    • Oct 2020
    • 17
    #1

    Oracle DB Template for Zabbix Agent 2 not working.

    Hello all,
    i am using the new zabbix agent2 with the Oracle Template for agent .
    i link the Template to my oracle host server in the frontend and i get the following issue in the discovery rules:
    please help to solve this issue.
    1. Tablespace discovery oracle.ts.discovery["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE. PASSWORD}","{$ORACLE.SERVICE}"] - Cannot fetch data: dpiStmt_execute: ORA-00907: missing right parenthesis.
    2. PDB discovery oracle.pdb.discovery["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE. PASSWORD}","{$ORACLE.SERVICE}"] - Cannot fetch data: dpiStmt_execute: ORA-00907: missing right parenthesis.
    3. ASM disk groups discovery oracle.diskgroups.discovery["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE. PASSWORD}","{$ORACLE.SERVICE}"] - Cannot fetch data: dpiStmt_execute: ORA-00907: missing right parenthesis.
    4. Database discovery - oracle.db.discovery["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE. PASSWORD}","{$ORACLE.SERVICE}"] - Cannot fetch data: dpiStmt_execute: ORA-00907: missing right parenthesis.
    5. Archive log discovery - oracle.archive.discovery["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE. PASSWORD}","{$ORACLE.SERVICE}"] - Cannot fetch data: dpiStmt_execute: ORA-00907: missing right parenthesis.
    Attached Files
    Tags: agent2, oracle, plugin, zabbix, zabbix server
    • Aviad
      Junior Member
      • Oct 2020
      • 17
      #2
      Anyone know how to solve this issue?

        Comment

        • Aviad
          Junior Member
          • Oct 2020
          • 17
          #3
          hi, please help to solve this issue.

            Comment

            • AVP.Riga
              Member
              • Oct 2020
              • 59
              #4
              Good morning,

              Please check request. Seems something is wrong with syntax. For example some parameters are empty.
              You can also check Oracle and Zabbix logs for investigation.
              Last edited by AVP.Riga; 26-10-2020, 09:09.

                Comment

                • Aviad
                  Junior Member
                  • Oct 2020
                  • 17
                  #5
                  Originally posted by AVP.Riga
                  Good morning,

                  Please check request. Seems something is wrong with syntax. For example some parameters are empty.
                  You can also check Oracle and Zabbix logs for investigation.
                  Hello and thanks for your respond.
                  i have check the logs and i can find only the same error i see in the discovery rules.
                  this template was downloaded from zabbix and i change only the macro value per my oracle system.
                  please try to help on this

                    Comment

                    • AVP.Riga
                      Member
                      • Oct 2020
                      • 59
                      #6
                      Hello,

                      Did you change/add necessary macros values?
                      Click image for larger version Name: macros.PNG Views: 4647 Size: 32.4 KB ID: 411534

                        Comment

                        • Aviad
                          Junior Member
                          • Oct 2020
                          • 17
                          #7
                          Originally posted by AVP.Riga
                          Hello,

                          Did you change/add necessary macros values?
                          Click image for larger version Name: macros.PNG Views: 4647 Size: 32.4 KB ID: 411534
                          yes,
                          i add to the template 1 host to test if it is working and configure the {$ORACLE.PASSWORD} & {$ORACLE.USER} value in the template and not in the host.
                          i will add it on the host when i see that it is working and need to add more then 1 server.
                          working with $ORACLE.PASSWORD} & {$ORACLE.USER} value in the template and not in the host can be the issue?

                            Comment

                            • Aviad
                              Junior Member
                              • Oct 2020
                              • 17
                              #8
                              any help on this?

                                Comment

                                • Aviad
                                  Junior Member
                                  • Oct 2020
                                  • 17
                                  #9
                                  Originally posted by Aviad
                                  Hello all,
                                  i am using the new zabbix agent2 with the Oracle Template for agent .
                                  i link the Template to my oracle host server in the frontend and i get the following issue in the discovery rules:
                                  please help to solve this issue.
                                  1. Tablespace discovery oracle.ts.discovery["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE. PASSWORD}","{$ORACLE.SERVICE}"] - Cannot fetch data: dpiStmt_execute: ORA-00907: missing right parenthesis.
                                  2. PDB discovery oracle.pdb.discovery["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE. PASSWORD}","{$ORACLE.SERVICE}"] - Cannot fetch data: dpiStmt_execute: ORA-00907: missing right parenthesis.
                                  3. ASM disk groups discovery oracle.diskgroups.discovery["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE. PASSWORD}","{$ORACLE.SERVICE}"] - Cannot fetch data: dpiStmt_execute: ORA-00907: missing right parenthesis.
                                  4. Database discovery - oracle.db.discovery["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE. PASSWORD}","{$ORACLE.SERVICE}"] - Cannot fetch data: dpiStmt_execute: ORA-00907: missing right parenthesis.
                                  5. Archive log discovery - oracle.archive.discovery["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE. PASSWORD}","{$ORACLE.SERVICE}"] - Cannot fetch data: dpiStmt_execute: ORA-00907: missing right parenthesis.


                                  anyone face this issue and know who to solve this ?

                                    Comment

                                    • AVP.Riga
                                      Member
                                      • Oct 2020
                                      • 59
                                      #10
                                      For example the user may not have sufficient rights to receive data. Try to reach necessary data just from terminal on your server.

                                        Comment

                                        • DReadushka
                                          Junior Member
                                          • Dec 2020
                                          • 1
                                          #11
                                          I faced with it. It doesn't work with Oracle 12.1 and work with 12.2. SQL from src work if I run it manual from SQL Developer.

                                            Comment

                                            • psabadim
                                              Junior Member
                                              • Apr 2022
                                              • 1
                                              #12
                                              Hello all,

                                              I am facing same problem here, nothing works with Agent 2. Same error Cannot fetch data: dpiStmt_execute: ORA-00907: missing right parenthesis.

                                              Anyone has any idea?

                                              Thanks

                                                Comment

                                                • Qbik
                                                  Junior Member
                                                  • Apr 2022
                                                  • 2
                                                  #13
                                                  Originally posted by psabadim
                                                  Hello all,

                                                  I am facing same problem here, nothing works with Agent 2. Same error Cannot fetch data: dpiStmt_execute: ORA-00907: missing right parenthesis.

                                                  Anyone has any idea?

                                                  Thanks
                                                  Good morning,

                                                  I faced the same problem

                                                  Found the answer about the version
                                                  We’ll be back soon!
                                                  https://www.zabbix.com/forum/zabbix-help/411199-zabbix-agent2-and-oracle


                                                  I haven't updated yet

                                                  I have oracle version 11.2.0.4

                                                    Comment

                                                    Previous template Next
                                                    Working...