Siebel srvrmgr Will Not Connect - ORA-01017: invalid username/password - Caused by Dollar Symbol in Password (Doc ID 1931241.1)

Last updated on JULY 20, 2016

Applies to:

Siebel CRM - Version 8.1.1.11 [IP2013] and later
Information in this document applies to any platform.
*** Checked for relevance on 16-Mar-2016 ****

Symptoms

Unable to connect srvrmgr on a new Siebel enterprise.

 

The log is showing :

 

GenericLog GenericError 1 00000006541f27dc:0 2014-09-22 12:00:20 (secmgr.cpp (2824) err=4597527 sys=0) SBL-SEC-10007: The username or password you have entered is not correct. Enter your username and password again.
GenericLog GenericError 1 00000006541f27dc:0 2014-09-22 12:00:20 (client.cpp (392) err=4597527 sys=0) SBL-SEC-10007: The username or password you have entered is not correct. Enter your username and password again.
SisnTcpIp SisnSockError 1 00000006541f27dc:0 2014-09-22 12:00:20 1447562096: [TCPIP-server] recv() failed for sd=-1 (err=9 | Bad file descriptor)
SisnTcpIp SisnSockError 1 00000006541f27dc:0 2014-09-22 12:00:20 1447562096: [TCPIP-server] send() failed for sd=-1 (err=9 | Bad file descriptor)

 

This was further narrowed to be specific to the odbcsql connection.  SQLPlus was working correctly :

 

$ odbcsql /s SIEBEL_DSN /u sadmin /p xxxxxxx
ODBCSQL - ODBC SQL Interface program
Copyright (c) 1994-2012, 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 "SIEBEL_DSN" as "sadmin" ...
ODBC error 46 in SQLConnect:
[DataDirect][ODBC 20101 driver][20101]ORA-01017: invalid username/password; logon denied
(native error 1017).
Unable to login using specified ODBC parameters.


Using same username and password to the same DB, using SQLPlus - work successfully :


$ sqlplus sadmin@siebeldb

SQL*Plus: Release 11.2.0.3.0 Production on Mon Sep 22 13:44:52 2014

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

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