Can't login to Siebel Server through SWEAPP - getting SBL-SEC-10018 and ORA-12154 (Doc ID 537417.1)

Last updated on NOVEMBER 05, 2014

Applies to:

Siebel System Software - Version 8.0.0.1 [20408] to 8.2.2.2 SIA[23016] [Release V8]
HP-UX Itanium
Product Release: V8 (Enterprise)
Version: 8.0 [20405]
Database: Oracle 10.2.0.2
Application Server OS: HP-UX 11i
Database Server OS: HP-UX 11i

This document was previously published as Siebel SR 38-3305708611.

***Checked for relevance on 14-Feb-2013***

Symptoms

After completing an installation of Siebel 8.0 using Oracle 10g database the customer was unable to launch the CallCenter application.

The object manager log file shows the following errors:
ObjMgrLog    Error    1    0000000745ff3358:0    2007-03-20 14:12:04    (oracon.cpp (3165)) SBL-DBC-00107: An Oracle database error has occurred.
Please continue or ask your systems administrator to check your application configuration if the problem persists.
GenericLog    GenericError    1    0000000745ff3358:0    2007-03-20 14:12:04    (secmgr.cpp (2483) err=4597538 sys=0) SBL-SEC-10018: An Oracle database error has occurred.
Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DBC-00107)
ORA-12154: TNS:could not resolve the connect identifier specified

When connect with swse to callcenter_enu get follow error:

The server you are trying to access is either busy or experiencing difficulties. Please close the Web browser, open a new browser window, and try logging in again.[14:51:12]

But statistic page is correctly presented.

http://espivm37/callcenter_enu/mondor_stats.swe

If I check in srvrmgr SCCObjMgr_enu work fine.

list comp SCCObjMgr_enu show CC_ALIAS, CP_DISP_RUN_STATE

CC_ALIAS       CP_DISP_RUN_STATE
------------- -----------------
SCCObjMgr_enu Online

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