Siebel SQLs/Error Messages >  SBL-ESC-00006 Unable to connect to the database

SBL-ESC-00006 Unable to connect to the database

Server State disconnected - SBL-ESC-00006 Process exited with error - Unable to connect to the db

APPLIES TO:

Siebel System Software - Version 7.7.1 [18306] to 8.0.0.10 [20436] [Release V7 to V8]
z*OBSOLETE: Microsoft Windows 2000
Database: Oracle 9.2.0.4
Application Server OS: Microsoft Windows 2000 Advanced Server SP 3
Database Server OS: HP-UX 11.0

SYMPTOMS
SBL-ESC-00006

Installed new application server yesterday in production environment.

In Server management Admin screen, the new server state is "disconnected" - couldn't find anything in bookshelf or on support web to explain how to resolve this.

We are including server log file SCRMPRD.SDPRTPDAP01. Please respond as soon as possible.

CAUSE
Incorrect setting.

SOLUTION
For the benefit of others:

New Siebel Server has been added to the existing Enterprise and the enterprise server log showed the following error. The other existing 2 Siebel servers are working fine.

ServerLog ProcessExit 1 0 2004-12-29 12:02:59 BIIBWorkMon 1049 SBL-ESC-00006 Process exited with error - Unable to connect to the database.

In the Server Management Administration screen, the new server state also shows "disconnected"

We have confirmed the following:
1) Oracle Client for on the Siebel Server host is at the supported 9.2.0.4 for Siebel 7.7.1
2) tnsnames.ora entry is correct
3) odbcsql is successful
4) SQLPlus and odbc test connections work fine for sadmin

The issue was related to the Enterprise Parameter for the database password was incorrect.

The new Siebel Server was obtaining its sadmin database password at the Enterprise Parameter level while the 2 existing Siebel Servers have the password overridden at their Server Parameter level. These 2 servers have the correct password set.

Basically the Enterprise Parameter and Sever Parameter passwords should always match.
Now that the server level parameter passwords are overridden, one will have to always manually enter in the new password when it changes. Changing it only at the Enterprise Parameter level will not propagate down to the levels below, server > component etc.

A suggested option is to remove the server level password setting and let all Siebel Servers default to
the Enterprise Parameter password value.

It is easier to maintain and when the sadmin password changes, it only has to be dealt with at the Enterprise level.

There is a also delete parameter override command as per following document that can be used to inherit the parameter setting.