Install Siebel 15.0.0.0
8.1. Validate database for Siebel User and ODBC
0. Download right Siebel software
1. Unzip your software
2. Install Oracle database for Siebel
3. Install 32-bit Oracle Client
4. Prepare for Siebel Installation
5. Install Siebel gateway server, Enterprise Server, Siebel server
6. Configure Gateway server
7. Configure Siebel Enterprise on Gateway server
8.1. Validate database for Siebel User and ODBC
8.2. Configure database server for Siebel
9. Configure Siebel Server
10. Install web server extension
11. Configure Siebel Web Server Extension
12. Install Web client
13. Configure web server(IIS) and Launch URL
14. Install Siebel tools(if needed)
A. Ensure you have appropriate TNS and Listener configuration
tnsnames.ora ->
siebeldb =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Siebel)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(sid = siebeldb)
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Siebel)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(sid = siebeldb)
)
)
Listener.ora ->
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = siebeldb)
(ORACLE_HOME = C:\Oracle64\product\11.2.0\dbhome_1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Siebel)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
(SID_LIST =
(SID_DESC =
(SID_NAME = siebeldb)
(ORACLE_HOME = C:\Oracle64\product\11.2.0\dbhome_1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Siebel)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
B. Validate DB parameters
show parameter cursor_sharing -- Value should be "EXACT"
show parameter db_file_multiblock_read_count -- Value should be "8"
show parameter memory_target -- value should be 5GB at least
show parameter nls_date_format --- The date format you are expecting
show parameter nls_date_language --- The language you are expecting
show parameter open_cursor -- value should be 1200
show parameter optimizer_features_enable --- value should be your DB version
show parameter optimizer_index_cost_adj --- value should be 100
show parameter optimizer_mode --- value should be ALL_ROWS
show parameter db_file_multiblock_read_count -- Value should be "8"
show parameter memory_target -- value should be 5GB at least
show parameter nls_date_format --- The date format you are expecting
show parameter nls_date_language --- The language you are expecting
show parameter open_cursor -- value should be 1200
show parameter optimizer_features_enable --- value should be your DB version
show parameter optimizer_index_cost_adj --- value should be 100
show parameter optimizer_mode --- value should be ALL_ROWS
C. Create Tablespace for Siebel(DATA/INDEX/TEMP)
create tablespace s_data datafile 'C:\ORACLE64\ORADATA\SIEBELDB\SIEBELDATA01.DBF' size 10G autoextend ON;
create tablespace s_index datafile 'C:\ORACLE64\ORADATA\SIEBELDB\SIEBELIDX01.DBF' size 10G autoextend ON;
alter database tempfile 'C:\ORACLE64\ORADATA\SIEBELDB\TEMP01.DBF' resize 5g;
create tablespace s_index datafile 'C:\ORACLE64\ORADATA\SIEBELDB\SIEBELIDX01.DBF' size 10G autoextend ON;
alter database tempfile 'C:\ORACLE64\ORADATA\SIEBELDB\TEMP01.DBF' resize 5g;
D. Run Grantusr script
This will create Siebel user to store Siebel data.
sqlplus / as sysdba
@C:\Siebel\15.0.0.0.0\ses\dbsrvr\ORACLE\grantusr.sql
Enter value for temp_tablespace: TEMP
Enter value for siebel_tablespace: s_data
Grant unlimited quota on new tablespace to Siebel user
alter user siebel quota unlimited on s_data;
alter user siebel quota unlimited on s_index;
@C:\Siebel\15.0.0.0.0\ses\dbsrvr\ORACLE\grantusr.sql
Enter value for temp_tablespace: TEMP
Enter value for siebel_tablespace: s_data
Grant unlimited quota on new tablespace to Siebel user
alter user siebel quota unlimited on s_data;
alter user siebel quota unlimited on s_index;
E. Validate ODBC connection for your DSN
Ensure, you are able to see Oracle 32-bit driver in ODBC as Siebel uses 32-bit driver
Control Panel -> Administrative tools -> Data Sources (ODBC)