Rerunning Post Installation Database Update
If there are failures with Post Installation Database Update, then re-execute the PostInstallDBSetup utility in stand-alone mode, after fixing any errors, as shown in the following procedure.
Rerun Post Installation Database Update
- If required, update the setup.ini file in
C:\siebel\siebsrvr\binor equivalent location.The setup.ini file contains, for example, the following parameter definitions:
GENERATE_SCHEMA=N SIEBSRVR_ROOT=d:\Siebel\ses\siebsrvr REPOSITORY=Siebel Repository DBTYPE=mssql ODBC_DSN=siebel_dsn SIEBEL_DSN=ServerDataSrc TBLO=dbo TBLOUSER=SIEBEL SIEBUSER=SADMIN SSE_ROLE=SSE_ROLE UNICODEDB=Y PRIMARY_LANG_CD=ENU OTHER_LANG_CD=TRK,THA,SVE,RUS,PTG,PTB,PLK,NLD,KOR,JPN,ITA,HEB,FRA,FIN,ESN,DEU,DAN,CSY,CHT,CHS,ARA - Rerun PostInstallDBSetup.exe, located in
C:\siebel\siebsrvr\binor equivalent location, using the following command from the command line:PostInstallDBSetup.exe -i Setup.ini -p ******** -z ********where:
-iis the ini file name.-pis the Database Table Owner Password.-zis the Database Password.
Description of Parameters in the Setup.ini File
This table lists the parameters in the setup.ini file and provides sample values for these parameters:
| Setting | Sample Value | Comments |
|---|---|---|
| SIEBSRVR_ROOT | C:\siebel\siebsrvr | This should be the path to the "siebsrvr" folder, not a "bin" folder. |
| REPOSITORY | Siebel Repository | The name of the Repository against which PostInstallDBSetup should execute. |
| GENERATE_SCHEMA | N, Y, or A |
Possible values:
|
| DBTYPE | ORACLE, MSSQL, DB2UDB, DB2390 | |
| ODBC_DSN | Siebel_DSN | The name of the ODBC source to use to connect to the database. |
| TBLO | SIEBEL | The name of the tableowner. Note: For MSSQL, this will typically be "dbo". |
| TBLOUSER | SIEBEL | The actual username associated to the tableowner. Note: For MSSQL, this might be "SIEBEL". |
| SIEBUSER | SADMIN | A Siebel User with full administrative privileges. |
| SSE_ROLE | SSE_ROLE | The group that provides user access to Siebel schema objects. |
| UNICODEDB | Y | Indicates whether the existing database is Unicode-enabled. |
| PRIMARY_LANG_CD | ENU | The primary language for the Siebel Enterprise database. |
| OTHER_LANG_CD | DEU,JPN,FRA,HEB | A comma-separated list of any additional languages used in the Siebel Enterprise. |
| INDSPC | INDX | The Index Space as determined by the DBA. This is applicable for Oracle and DB2UDB only. |
| TBLSPC | DATA | The Table Space as determined by the DBA. This is applicable for Oracle and DB2UDB only. |
| TBLSPC16K | TBS_16K | 16K Tablespace. This is applicable for DB2UDB only. |
| TBLSPC32K | TBS_32K | 32K Tablespace. This is applicable for DB2UDB only. |
| 4KBUFFERPOOL | BP1 | 4K Buffer Pool. This is applicable to DB2 for z/OS only. |
| 8KBUFFERPOOL | BP8K1 | 8K Buffer Pool. This is applicable to DB2 for z/OS only. |
| 16KBUFFERPOOL | BP16K1 | 16K Buffer Pool. This is applicable to DB2 for z/OS only. |
| 32KBUFFERPOOL | BP32K1 | 32K Buffer Pool. This is applicable to DB2 for z/OS only. |
| DBNAMEPREFIX | D002 | The prefix to use for the objects in the database. This is applicable to DB2 for z/OS only. |
| DBCODE | ASCII or EBCDIC | Encoding for the database. This is applicable to DB2 for z/OS only. |
| INDEXBUFFERPOOL | BP2 | The name of the Index Buffer Pool. This is applicable to DB2 for z/OS only. |
| STOGROUPINDEXES | SYSDEFLT | The storage group for indexes. This is applicable to DB2 for z/OS only. |
| STOGROUPTABLES | SYSDEFLT | The storage group for tables. This is applicable to DB2 for z/OS only. |