Monday, December 29, 2014

Siebel Database upgrade from 8.1.1.0 to 8.1.1.11 Fails - upgrep

Environment:
OS - Windows 2012
Siebel - 8.1.1.11 SIA
Upgrading from - 8.1.1.0 SEA
Database - Oracle 11.2.0.3

Issue:
While running the 'upgrep' process in the Database configuration for the upgrade from 8.1.1.0 SEA to 8.1.1.11 SIA, the process fails at step 27 with the following error:

[Item 27]
Status = Error
Item Name = File Execute Entry 26
SecondaryLanUpgrade = 3611514Unable to get schema version.Please verify that you have specified the correct Table Owner (siebel) and you have select access to the S_APP_VER table.

Upon checking the database permissions, everything looked okay and the user SIEBEL did have all the needed privileges on the table.

Solution:
The workaround is to replace the number in the master_upgrep_dev_81110 file by the installed languages :

Repeat For Language = 3611519
replace with
Repeat For Language = DEU,ENU for example.

If  the unique language installed is ENU:
Repeat For Language = ENU

Re-execute the upgrade wizard from siebsrvr/bin/master_*.ucf file.

This is a known product bug documented in 'Bug 18614385 - DATABASE CONFIGURATION WIZARD FAILS BECAUSE OF INCORRECT LANGUAGE 0ENU'

Oracle support document reference - 1668300.1

Monday, December 22, 2014

Unable to Configure Enterprise Siebel 8.1.1.0 64-bit - SES/OUI Installer

Environment
OS - Windows 2008 R2 64-bit
Siebel version - 8.1.1.0

I was trying to setup a Siebel 8.1.1.0 environment on Windows 2008 R2 (64-bit) server and the Siebel Enterprise configuration was failing each time while attempting to connect to the Gateway Name server. The software for the setup was downloaded from Oracle e-Delivery and looking up Siebel 64-bit installer for Windows.

The software that is available currently in eDelivery is the SES or OUI (Oracle Universal Installer) type of installer which has been in place since OpenUI was introduced. The previous version of the Siebel installer for the base 8.1.1.0 version was the InstallSheild one which I had successfully installed on many Windows 2008 servers. 

Upon further investigation with running the installer in verbose mode, it is found that many files are missing from the gtwysrvr\bin directory (eg, commonutil) which is breaking the configuration process. It has been confirmed by Oracle that the SES or OUI version of the Siebel 8.1.1.0 (base) installer is not supported as a standalone installer for Siebel anymore. If you need to setup the OUI installer, it has to be patched to a version 8.1.1.8 or higher before starting the Enterprise Configuration.

Solution:
Login to Oracle support (support.oracle.com) with your credentials and search for the patch number '15892740'. Download the required version of software depending upon your OS, this is the Install Shield version of Siebel 8.1.1.0 Base version which needs to be installed in case you are setting up a Base standalone environment.