ODBCSQL Error Occurs after Installing Siebel Gateway (Doc ID 2279827.1)

Last updated on JUNE 29, 2017

Applies to:

Siebel CRM - Version 16.0 [IP2016] and later
Information in this document applies to any platform.

Symptoms


ODBC error occurs while installing IP16

ODBCSQL is not getting connected and failing with below error.

[siebel@ze51-v-oradb bin]$ odbcsql /u XXXXX /p XXXX /s ZENBI_SIEBEL
ODBCSQL - ODBC SQL Interface program
Copyright (c) 1994,2015, Oracle. All rights reserved.

The Programs (which include both the software and documentation) contain
proprietary information; they are provided under a license agreement containing
restrictions on use and disclosure and are also protected by copyright, patent,
and other intellectual and industrial property laws. Reverse engineering,
disassembly, or decompilation of the Programs, except to the extent required to
obtain interoperability with other independently created software or as specified
by law, is prohibited.

Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of
Oracle Corporation and/or its affiliates. Other names may be trademarks
of their respective owners.

If you have received this software in error, please notify Oracle Corporation
immediately at 1.800.ORACLE1.

Type help for usage information.

Logging into "ZENBI_SIEBEL" as "XXXXXX" ...
ODBC error 00000 in SQLConnect:
Unknown ODBC error!
(native error 0).
Unable to login using specified ODBC parameters.

ERROR
-----------------------
ODBC error 00000 in SQLConnect




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Install Siebel Server and gateway.
2. Configure gateway.
3. Run dbuser.sql file and try to connect odbcsql by sourcing dbenv.sh file throughs below error.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot to ODBCSQL.

Changes

New Installation. 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms