-
Type:
Incident report
-
Resolution: Won't fix
-
Priority:
Major
-
None
-
Affects Version/s: 2.0.3
-
Component/s: Server (S)
-
Environment:OS:
cat /etc/centos-release
CentOS release 6.3 (Final)
ZABBIX:
zabbix_server -V
Zabbix server v2.0.3 (revision 30485) (03 October 2012)
Compilation time: Oct 22 2012 21:24:20
ORACLE:
select * from V$VERSION;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Prod
PL/SQL Release 10.1.0.4.0 - Production
CORE 10.1.0.4.0 Production
TNS for Linux: Version 10.1.0.4.0 - Production
NLSRTL Version 10.1.0.4.0 - Production
SQL*CLIENT (istant client):
rpm -qa | grep oracle-instant
oracle-instantclient11.2-devel-11.2.0.3.0-1.x86_64
oracle-instantclient11.2-basic-11.2.0.3.0-1.x86_64
oracle-instantclient11.2-sqlplus-11.2.0.3.0-1.x86_64
oracle-instantclient11.2-odbc-11.2.0.3.0-1.x86_64
oracle-instantclient11.2-jdbc-11.2.0.3.0-1.x86_64
sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Wed Jan 9 16:35:28 2013
NSL_LANG:
PARAMETER VALUE
----------------------------------------------------------------------------------------------------------------------------------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
PARAMETER VALUE
----------------------------------------------------------------------------------------------------------------------------------------------------------------
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
OS: cat /etc/centos-release CentOS release 6.3 (Final) ZABBIX: zabbix_server -V Zabbix server v2.0.3 (revision 30485) (03 October 2012) Compilation time: Oct 22 2012 21:24:20 ORACLE: select * from V$VERSION; BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Prod PL/SQL Release 10.1.0.4.0 - Production CORE 10.1.0.4.0 Production TNS for Linux: Version 10.1.0.4.0 - Production NLSRTL Version 10.1.0.4.0 - Production SQL*CLIENT (istant client): rpm -qa | grep oracle-instant oracle-instantclient11.2-devel-11.2.0.3.0-1.x86_64 oracle-instantclient11.2-basic-11.2.0.3.0-1.x86_64 oracle-instantclient11.2-sqlplus-11.2.0.3.0-1.x86_64 oracle-instantclient11.2-odbc-11.2.0.3.0-1.x86_64 oracle-instantclient11.2-jdbc-11.2.0.3.0-1.x86_64 sqlplus /nolog SQL*Plus: Release 11.2.0.3.0 Production on Wed Jan 9 16:35:28 2013 NSL_LANG: PARAMETER VALUE ---------------------------------------------------------------------------------------------------------------------------------------------------------------- NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CURRENCY $ NLS_ISO_CURRENCY AMERICA NLS_NUMERIC_CHARACTERS ., NLS_CALENDAR GREGORIAN NLS_DATE_FORMAT DD-MON-RR NLS_DATE_LANGUAGE AMERICAN NLS_SORT BINARY NLS_TIME_FORMAT HH.MI.SSXFF AM NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM PARAMETER VALUE ---------------------------------------------------------------------------------------------------------------------------------------------------------------- NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR NLS_DUAL_CURRENCY $ NLS_COMP BINARY NLS_LENGTH_SEMANTICS BYTE NLS_NCHAR_CONV_EXCP FALSE
Errors found in zabbix server log:
[Z3005] query failed: [-1] ORA-01425: escape character must be character string of length 1 [select host from hosts where host like 'servername.domain.net%' escape '!' and hostid between 0 and 99999999999999]
escape character used is '!'
Workaround used:
1) if you use escaped character all works good (select host from hosts where host like 'servername.domain.net%' escape '!' and hostid between 0 and 99999999999999)
2) if you set a logon trigger to set escape '!' all works good
3) Problems is the same using sqlplus. Add " set escape '!' " in the glogin.sql fine and all works good
- is duplicated by
-
-
- Closed
-