2 Replies Latest reply: Nov 5, 2012 4:09 PM by ibm kathryn arrell RSS

    After patch installation 8.1.1.7 on Linux  server is not comming up

    user2336973
      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-Oracle
          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
            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 *******************