Ad Widget

Collapse

Zabbix 5.4.2 Oracle DB creation Scripts gives ORA-01722: invalid number

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • beremour
    Junior Member
    • Jul 2021
    • 7

    #1

    Zabbix 5.4.2 Oracle DB creation Scripts gives ORA-01722: invalid number

    I've built zabbix from git tag 5.4.2. Oracle Database created with CHARACTER SET AL32UTF8 and NATIONAL CHARACTER SET UTF8.
    When I try to create Schema with database/oracle/schema.sql I am getting "invalid number" on table "services". Screen attached. What can I do with it ?



    Click image for larger version

Name:	Screenshot 2021-07-21 at 00.43.36.png
Views:	206
Size:	378.1 KB
ID:	428495

    Attached Files
  • Glencoe
    Zabbix developer
    • Oct 2019
    • 152

    #2
    What does this query say?
    Code:
    select * from NLS_DATABASE_PARAMETERS

    Comment

    • beremour
      Junior Member
      • Jul 2021
      • 7

      #3
      Thank you very much for reply! I found problem solution last night. It was NLS_LANG env variable on client side.
      I had:
      Code:
      NLS_LANG=AMERICAN_RUSSIA.UTF8
      I switched to:
      Code:
      NLS_LANG=AMERICAN_AMERICA.UTF8
      and BINARY_DOUBLEs began to work. But I think it's better to specify 9.99d instead on '9.99' for BINARY_DOUBLEs.

      Can you please look at another Oracle-scripts error at https://www.zabbix.com/forum/zabbix-...racle-database
      ? There are 2 of us with
      Code:
      ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion
      Thank you.
      Last edited by beremour; 21-07-2021, 16:49.

      Comment

      Working...