This discussion is archived
2 Replies Latest reply: Nov 5, 2012 2:09 PM by ibm kathryn arrell RSS

After patch installation 8.1.1.7 on Linux  server is not comming up

886740 Newbie
Currently Being Moderated
Hi all,
after installing siebel 8.1.1.7 (was 8.1.1.5) on a SUSE Linux Enterprise Server 10 the siebel server is not comming up.

The server crashed with error:
2021 2012-03-14 14:19:31 0000-00-00 00:00:00 +0100 00000000 001 003f 0001 09 GtwyNS 7464 1083001952 /opt/siebel/gtwysrvr/log/NameSrvr.log 8.1.1.7 [21238] ENU
DBCLog     DBCLogError     1     000000024f601d28:0     2012-03-14 14:19:31     SQL Warning, SQL State 639, 0, 523 638
SQLError     Statement     0     000000024f601d28:0     2012-03-14 14:19:31     SQL Statement:
select T2.NAME from SIEBEL.S_PER_RESP T1, SIEBEL.S_RESP T2, SIEBEL.S_USER T3 where T1.RESP_ID=T2.ROW_ID AND T1.PER_ID=T3.PAR_ROW_ID AND T3.LOGIN='SADMIN'

DBCLog     DBCLogError     1     000000024f601d28:0     2012-03-14 14:19:31     523 638

I try to deinstall 8.1.1.7. The the siebel server came up. Installing agin, same error.

Any ideas?

Angie
  • 1. Re: After patch installation 8.1.1.7 on Linux  server is not comming up
    WSiebel Pro
    Currently Being Moderated
    Angie,

    Not sure if it is related, but make sure you have a supported web server for 8.1.1.7 on linux:

    http://docs.oracle.com/cd/E11886_01/V8/CORE/SRSP_81/SRSP_81_ServerEnv8.html#wp1013532

    Also increase logging level for gateway and siebel server and send detailed logs:

    http://docs.oracle.com/cd/E14004_01/books/SysDiag/SysDiagSystemLogging3.html#wp1005234

    http://docs.oracle.com/cd/E14004_01/books/SysDiag/SysDiagEvntLogAdmin.html#wp1004800

    Thanks,

    Wilson
  • 2. Re: After patch installation 8.1.1.7 on Linux  server is not comming up
    ibm kathryn arrell Newbie
    Currently Being Moderated
    Dear support,

    I encountered the exact same problem. I also used odbcsql to execute the same sql statement, and it returns correct output.

    Here are my detailed log:

    SecAdptLog     API Trace     4     00000003509801e4:0     2012-11-05 13:48:34     Initialize ODBC security adapter.

    SecMgrLog     Debug     5     00000003509801e4:0     2012-11-05 13:48:34     SecAdptName = DBSecAdpt

    SecMgrLog     Debug     5     00000003509801e4:0     2012-11-05 13:48:34     SecAdptMode = 0

    SecMgrLog     Debug     5     00000003509801e4:0     2012-11-05 13:48:34     SecAdptDllName = sscfsaodbc

    SecMgrLog     Debug     5     00000003509801e4:0     2012-11-05 13:48:34     PropagteChange = TRUE

    SecMgrLog     Debug     5     00000003509801e4:0     2012-11-05 13:48:34     computed checksum of security adapter library = ''

    SecMgrLog     Debug     5     00000003509801e4:0     2012-11-05 13:48:34     HashUserPwd = FALSE

    SecMgrLog     Debug     5     00000003509801e4:0     2012-11-05 13:48:34     SaltUserPwd = FALSE

    SecMgrLog     Debug     5     00000003509801e4:0     2012-11-05 13:48:34     HashDBPwd = FALSE

    SecMgrLog     Debug     5     00000003509801e4:0     2012-11-05 13:48:34     HashAlgorithm = RSASHA1

    SecMgrLog     Debug     5     00000003509801e4:0     2012-11-05 13:48:34     bMFCShell = FALSE

    SecMgrLog     Debug     5     00000003509801e4:0     2012-11-05 13:48:34     datasourcename = ServerDataSrc

    SecAdptLog     Debug     5     00000003509801e4:0     2012-11-05 13:48:34     Invoking SecurityLogin with username=sadmin ...

    SecAdptLog     Debug     5     00000003509801e4:0     2012-11-05 13:48:34     ODBC security adapter configured: connectstring='siebel_DSN', tableowner='SIEBEL', GlobalConnections=.

    DBCLog     DBCLogDetail     4     00000003509801e4:0     2012-11-05 13:48:34     Dynamically loading ODBC library functions

    DBCLog     DBCLogDetail     4     00000003509801e4:0     2012-11-05 13:48:34     Successfully loaded ODBC library functions

    SQLTraceAll     SQLTraceAll     4     00000003509801e4:0     2012-11-05 13:48:34     (SQLAllocEnv) Env Handle: 813335624, Time: 0.266ms

    SQLTraceAll     SQLTraceAll     4     00000003509801e4:0     2012-11-05 13:48:34     (SQLAllocConnect) Env Handle: 813335624, Conn Handle: 813335912, Time: 0.004ms

    SQLConnectOptions     Allocate Connection     4     00000003509801e4:0     2012-11-05 13:48:34     (SQLAllocConnect) Conn Handle: 813335912, Time: 0.004ms

    SQLTraceAll     SQLTraceAll     4     00000003509801e4:0     2012-11-05 13:48:34     (SQLConnect) Conn Handle: 813335912, Time: 0.059s

    SQLTraceAll     SQLTraceAll     4     00000003509801e4:0     2012-11-05 13:48:34     (SQLGetInfo) Conn Handle: 813335912, Time: 0.026ms

    SQLTraceAll     SQLTraceAll     4     00000003509801e4:0     2012-11-05 13:48:34     (SQLGetInfo) Conn Handle: 813335912, Time: 0.008ms

    SecAdptLog     Debug     5     00000003509801e4:0     2012-11-05 13:48:34     username=sadmin : authentication succeeded.

    SecAdptLog     Debug     5     00000003509801e4:0     2012-11-05 13:48:34     username=sadmin : retrieving responsibilities...

    SQLTraceAll     SQLTraceAll     4     00000003509801e4:0     2012-11-05 13:48:34     (SQLAllocStmt) Conn Handle: 813335912, Time: 0.026ms

    SQLStatementOptions     Allocate Statement     4     00000003509801e4:0     2012-11-05 13:48:34     (SQLAllocStmt) Conn Handle: 813335912, Time: 0.026ms

    SQLSlowQuery     Statement     4     00000003509801e4:0     2012-11-05 13:48:34     select T2.NAME from SIEBEL.S_PER_RESP T1, SIEBEL.S_RESP T2, SIEBEL.S_USER T3 where T1.RESP_ID=T2.ROW_ID AND T1.PER_ID=T3.PAR_ROW_ID AND T3.LOGIN='SADMIN'


    SQLTraceAll     SQLTraceAll     4     00000003509801e4:0     2012-11-05 13:48:34     (SQLExecDirect) Conn Handle: 813335912, Stmt Handle: 813383704, Time: 0.004s

    DBCLog     DBCLogError     1     00000003509801e4:0     2012-11-05 13:48:34     SQL Warning, SQL State 639, 0, 523 638

    SQLParseAndExecute     Prepare + Execute     4     00000003509801e4:0     2012-11-05 13:48:34     Time: 0.004s, Rows: 0, Avg. Time: 0.004s [Row count does not apply to SELECT statements]

    SQLStatementOptions     ExecuteDirect     4     00000003509801e4:0     2012-11-05 13:48:34     (SQLExecDirect) Conn Handle: 813358380, Stmt Handle: 813360252, Time: 0.004s

    SQLError     Statement     0     00000003509801e4:0     2012-11-05 13:48:34     SQL Statement:
    select T2.NAME from SIEBEL.S_PER_RESP T1, SIEBEL.S_RESP T2, SIEBEL.S_USER T3 where T1.RESP_ID=T2.ROW_ID AND T1.PER_ID=T3.PAR_ROW_ID AND T3.LOGIN='SADMIN'


    DBCLog     DBCLogError     1     00000003509801e4:0     2012-11-05 13:48:34     523 638

    SecAdptLog     Debug     5     00000003509801e4:0     2012-11-05 13:48:34     username=sadmin : failed to retrieve responsibilities due to:
    523 638

    SQLTraceAll     SQLTraceAll     4     00000003509801e4:0     2012-11-05 13:48:34     (SQLFreeStmt) Conn Handle: 813335912, Stmt Handle: 813383704, Time : 0.013ms

    SQLStatementOptions     Free Statement     4     00000003509801e4:0     2012-11-05 13:48:34     (SQLFree Stmt) Conn Handle: 813335912, Stmt Handle: 813383704, Time: 0.013ms

    SQLStatementOptions     Free Statement Details     5     00000003509801e4:0     2012-11-05 13:48:34     (SQLFreeStmt) Option: SQL_RESET_PARAMS

    SQLTraceAll     SQLTraceAll     4     00000003509801e4:0     2012-11-05 13:48:34     (SQLFreeStmt) Conn Handle: 813335912, Stmt Handle: 813383704, Time : 0.003ms

    SQLStatementOptions     Free Statement     4     00000003509801e4:0     2012-11-05 13:48:34     (SQLFree Stmt) Conn Handle: 813335912, Stmt Handle: 813383704, Time: 0.003ms

    SQLStatementOptions     Free Statement Details     5     00000003509801e4:0     2012-11-05 13:48:34     (SQLFreeStmt) Option: SQL_UNBIND

    SQLTraceAll     SQLTraceAll     4     00000003509801e4:0     2012-11-05 13:48:34     (SQLFreeStmt) Conn Handle: 813335912, Stmt Handle: 813383704, Time : 0.495ms

    SQLStatementOptions     Free Statement     4     00000003509801e4:0     2012-11-05 13:48:34     (SQLFree Stmt) Conn Handle: 813335912, Stmt Handle: 813383704, Time: 0.495ms

    SQLStatementOptions     Free Statement Details     5     00000003509801e4:0     2012-11-05 13:48:34     (SQLFreeStmt) Option: SQL_CLOSE

    SQLTraceAll     SQLTraceAll     4     00000003509801e4:0     2012-11-05 13:48:34     (SQLFreeStmt) Conn Handle: 813335912, Stmt Handle: 813383704, Time : 0.047ms

    SQLStatementOptions     Free Statement     4     00000003509801e4:0     2012-11-05 13:48:34     (SQLFree Stmt) Conn Handle: 813335912, Stmt Handle: 813383704, Time: 0.047ms

    SQLStatementOptions     Free Statement Details     5     00000003509801e4:0     2012-11-05 13:48:34     (SQLFreeStmt) Option: SQL_DROP

    SQLSummary     Header     4     00000003509801e4:0     2012-11-05 13:48:34     *******************************************************************************

    SQLSummary     Stmt     4     00000003509801e4:0     2012-11-05 13:48:34     select T2.NAME from SIEBEL.S_PER_RESP T1, SIEBEL.S_RESP T2, SIEBEL.S_USER T3 where T1.RESP_ID=T2.ROW_ID AND T1.PER_ID=T3.PAR_ROW_ID AND T3.LOGIN='SADMIN'


    SQLSummary     Header     4     00000003509801e4:0     2012-11-05 13:48:34     Call Count Total Time Avg. Time Rows

    SQLSummary     Sep     5     00000003509801e4:0     2012-11-05 13:48:34     -------------------------------------------------------------------------------

    SQLSummary     ExecDir     5     00000003509801e4:0     2012-11-05 13:48:34     Exec Direct 1 0.004s 0.004s 0

    SQLSummary     Sep     5     00000003509801e4:0     2012-11-05 13:48:34     -------------------------------------------------------------------------------

    SQLSummary     Totals     4     00000003509801e4:0     2012-11-05 13:48:34     Total 1 0.004s 0.004s 0


    SQLTraceAll     SQLTraceAll     4     00000003509801e4:0     2012-11-05 13:48:34     (SQLDisconnect) Conn Handle: 813335912, Time: 0.583ms

    SQLConnectOptions     Disconnect     4     00000003509801e4:0     2012-11-05 13:48:34     (SQLDisconnect) Conn Handle: 813335912, Time: 0.583ms

    SQLTraceAll     SQLTraceAll     4     00000003509801e4:0     2012-11-05 13:48:34     (SQLFreeConnect) Conn Handle: 813335912, Time: 0.089ms

    SQLConnectOptions     Free Connection     4     00000003509801e4:0     2012-11-05 13:48:34     (SQLFreeConnect) Conn Handle: 813335912, Time: 0.089ms

    SQLProfiling     Statement     4     00000003509801e4:0     2012-11-05 13:48:34     ********************************* Begin 10 Worst Performing Queries *********************************

    SQLProfiling     Prepare + Execute     4     00000003509801e4:0     2012-11-05 13:48:34     Statement #1. Elapsed Time: 0.004s

    SQLProfiling     Statement     4     00000003509801e4:0     2012-11-05 13:48:34     select T2.NAME from SIEBEL.S_PER_RESP T1, SIEBEL.S_RESP T2, SIEBEL.S_USER T3 where T1.RESP_ID=T2.ROW_ID AND T1.PER_ID=T3.PAR_ROW_ID AND T3.LOGIN='SADMIN'


    SQLProfiling     Statement     4     00000003509801e4:0     2012-11-05 13:48:34     ********************************* End 10 Worst Performing Queries *********************************

    SQLProfiling     SQLProfiling     0     00000003509801e4:0     2012-11-05 13:48:34     ******************* Begin Db2 OS/390 Dangling Thread Analysis *******************

    SQLProfiling     SQLProfiling     0     00000003509801e4:0     2012-11-05 13:48:34     ******************* End Db2 OS/390 Dangling Thread Analysis *******************

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points