8 Replies Latest reply: Apr 11, 2012 2:26 AM by user878954 RSS

    Siebel Database Configuration Wizard closes automatically

    user878954
      hi all,

      Siebel Database Configuration Wizard closes automatically at step when asked if the GRANTUSR.SQL script was alredy run. Before running the Wizard I already installed the Siebel Enterprise, Siebel Gateway, Siebel Server, SWSE Logical Profile and configurated them. The Siebel Database is available, tablespaces were created and I run the grantusr.sql and everything was OK.

      I chose the option 'already run the grantusr.sql'. By doing this the Wizard closes automatically. No idea what's going on here.

      Can anybody please help me? I've been sitting for hours trying to find out what happens.
        • 1. Re: Siebel Database Configuration Wizard closes automatically
          Robert Ponder
          Hi,

          We need to check the log files.

          Robert Ponder
          • 2. Re: Siebel Database Configuration Wizard closes automatically
            user878954
            Where can I find the log files to the Siebel Database Configuration Wizard so I can mention here which the exact errors in the logs are?
            • 3. Re: Siebel Database Configuration Wizard closes automatically
              user878954
              The only log I could find with today's information was this:

              2012-04-07 19:05:50.843: [  OCROSD][1944]utgdv:1:could not open registry key SOFTWARE\Oracle\ocr os error The system could not find the environment option that was entered.

              2012-04-07 19:05:50.953: [  OCRRAW][1944]proprinit: Could not open raw device
              2012-04-07 19:05:50.953: [ default][1944]a_init:7!: Backend init unsuccessful : [33]
              2012-04-07 19:05:50.953: [ CSSCLNT][1944]clsssinit: error(33 ) in OCR initialization

              and under D:\Oracle\product\10.2.0\db_3\<machine_name>\client.

              My version of Oracle on a Windows XP Service Pack 2, according to Google, 32 Bit machine is:

              Oracle Database 10g Enterprise Edition Release
              10.2.0.1.0 - Prod PL/SQL Release 10.2.0.1.0 - Production
              CORE 10.2.0.1.0 Production
              TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
              NLSRTL Version 10.2.0.1.0 - Production

              Version of Siebel: 8.0.0.0

              The Wizard gives me the option to choose Oracle Database 10g Enterprise Edition (CBO)

              Can anybody help me?

              Edited by: user878954 on 07.04.2012 10:46

              Edited by: user878954 on 07.04.2012 11:02

              Edited by: user878954 on 07.04.2012 11:13
              • 4. Re: Siebel Database Configuration Wizard closes automatically
                WSiebel-Oracle
                Oracle logs may not be related with the problem you are facing.

                Siebel wizard logs should be available under \siebsrvr\log or \siebsrvr\logarchive folders, search for files with name similar to sw_cfg_util.log. Provide the contents of this file.

                What is the Operating System you are using for the siebel server, is it the same as oracle client?

                Test ODBC connection for the siebel server odbc and confirm if registries are set as below:

                http://docs.oracle.com/cd/B40099_02/books/SiebInstWIN/SiebInstCOM_ConfigSES19.html#wp1601061

                Also test odbc connection with odbcsql, this can be used for oracle as well:

                http://docs.oracle.com/cd/B40099_02/books/SiebInstWIN/SiebInstCOM_ConfigSES20.html#wp2227262

                Thanks,

                Wilson
                • 5. Re: Siebel Database Configuration Wizard closes automatically
                  user878954
                  hi WSiebel,

                  thanks for the explanation. I checked the logfile under \siebsrvr\log:

                  2021 2012-04-08 20:35:05 0000-00-00 00:00:00 +0200 00000000 001 003f 0001 09 sw_cfg_util 1524 2812 D:\sba80\siebsrvr\log\sw_cfg_util.log 8.0 [20405] ENU
                  NameServerLayerLog     Error     1     000000024f8105f4:0     2012-04-08 20:35:05     Unable to connect to the gateway server.
                  GenericLog     GenericError     1     000000024f8105f4:0     2012-04-08 20:35:06     NSS - ErrCode 5009 SysErr 0
                  GenericLog     GenericError     1     000000024f8105f4:0     2012-04-08 20:35:06     Validation failed : C028: Connection with Siebel-Gateway-Namenserver 粑GenericLog     GenericError     1     000000024f8105f4:0     2012-04-08 20:35:06     ValidateFailed for Gateway Nameserver-Adresse, error : C028: Connection with Siebel-Gateway-Namenserver 粑NameServerLayerLog     Error     1     000000024f8105f4:0     2012-04-08 20:35:17     Unable to connect to the gateway server.
                  GenericLog     GenericError     1     000000024f8105f4:0     2012-04-08 20:35:17     NSS - ErrCode 5009 SysErr 0
                  GenericLog     GenericError     1     000000024f8105f4:0     2012-04-08 20:35:17     Validation failed : C028: Connection with Siebel-Gateway-Namenserver 粑GenericLog     GenericError     1     000000024f8105f4:0     2012-04-08 20:35:17     ValidateFailed for Gateway Nameserver-Adresse, error : C028: Connection with Siebel-Gateway-Namenserver 粑NameServerLayerLog     Error     1     000000024f8105f4:0     2012-04-08 20:35:21     Unable to connect to the gateway server.
                  GenericLog     GenericError     1     000000024f8105f4:0     2012-04-08 20:35:21     NSS - ErrCode 5009 SysErr 0
                  GenericLog     GenericError     1     000000024f8105f4:0     2012-04-08 20:35:21     Validation failed : C028: Connection with Siebel-Gateway-Namenserver 粑GenericLog     GenericError     1     000000024f8105f4:0     2012-04-08 20:35:21     ValidateFailed for Gateway Nameserver-Adresse, error : C028: Connection with Siebel-Gateway-Namenserver 粑

                  I don't think, that that is the cause of my problem. Even when I started the Siebel gateway, the database configuration wizard doesn't work appropriately.

                  Sievel server and Oracle Database are in the same machine (a Windows XP Professional, 32-bit-virtual machine). I haven't installed the Oracle 10g Enterprise edition. Should I install the Oracle client as well?.

                  In my case the ODBC connection, the DSN Name is Enterprise Name_DSN: Siebel_test_DSN and points to the Driver: Oracle in OraDb10g_home3. The connection works for siebel/siebel, sadmin/sadmin, but not for sys/mypassword (sorry I am not a Database crack).

                  I also tested the connection with the odbcsql as in your email indicated. The connection works when trying with siebel/siebel and sadmin/sadmin (user/password).
                  • 6. Re: Siebel Database Configuration Wizard closes automatically
                    WSiebel-Oracle
                    Hi,

                    Windows XP is not a supported/certified platform for the Siebel Server 8.0.x, check link below for a list of supported OS's:

                    http://docs.oracle.com/cd/E11886_01/V8/CORE/SRSP_80/SRSP_80_ServerEnv2.html#wp1009117

                    That can be the cause of database configuration wizard failure.

                    Wilson
                    • 7. Re: Siebel Database Configuration Wizard closes automatically
                      user878954
                      I forgot to mention, that I found the registry entry according to your link:

                      [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\EnterpriseName_DSN]

                      But the registry keys are not listed for this registry entry. According to the Bookshelf these values are required in order for the ODBC driver to behave correctly.

                      PacketSize = 0
                      EnableScrollableCursors = 0
                      ColumnsAsChar = 1
                      ColumnSizeAsCharacter = 1

                      no registry keys neither values are listed.
                      I was sure that Windows XP was supported by Siebel 8.0...I could install the Siebel Web Client, Siebel Tools and the Sample Database. They work without problems on the Windows XP virtual machine.
                      • 8. Re: Siebel Database Configuration Wizard closes automatically
                        user878954
                        Ok, the Siebel Client can work, but the Siebel Enterprise Server doesn't...