This content has been marked as final. Show 8 replies
We need to check the log files.
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?
The only log I could find with today's information was this:
2012-04-07 19:05:50.843: [ OCROSD]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]proprinit: Could not open raw device
2012-04-07 19:05:50.953: [ default]a_init:7!: Backend init unsuccessful : 
2012-04-07 19:05:50.953: [ CSSCLNT]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: 220.127.116.11
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
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:
Also test odbc connection with odbcsql, this can be used for oracle as well:
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  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).
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:
That can be the cause of database configuration wizard failure.
I forgot to mention, that I found the registry entry according to your link:
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.
Ok, the Siebel Client can work, but the Siebel Enterprise Server doesn't...