Configure Siebel Server for a new database

Siebel : After moving the Oracle database to a new machine, how to configure the Siebel Server to point to the new database.

The Oracle Database Administrator (DBA) may choose to move the Oracle database from machine A to machine B for a number of reasons. If this is a planned move, then the instructions below should be tested in Test environment first and a backup taken prior to a Production move.

The Siebel Administrator and Oracle DBA have two options for pointing the Siebel Server(s) and dedicated clients to the new database:

Option 1 – Only update the SQL*net TNS Alias
If the TNS alias name does not need to be changed then only the connection details, most probably the HOST and SERVICE_NAME (or SID), need to be updated. The following tnsnames.ora file is for information only, as Oracle Systems, Inc. recommends that changes to the tnsnames.ora be made using the Oracle supplied Net Manager Tool. Note that the DBA will be able to provide the new settings.

Change:

SiebelDB.SIEBEL.COM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = machineA)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SiebelDB) ) )

To:

SiebelDB.SIEBEL.COM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = machineB)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = NewSiebelDB) ) )

Option 2 – Create a new TNS Alias
If a new TNS Alias needs to be created then several steps need to be followed:
1. Create the new TNS alias using the Oracle supplied Net Manager Tool.

2. Modify the appropriate Configuration (CFG) file to reference the new TNS alias created in the above step. In the [ServerDataSrc] section, change the value of the parameter called ”ConnectString” to the new TNS alias. Make this change for all the dedicated client CFG files and all the CFG files under the SiebSrvr\bin directory (version 6.x) or SiebSrvr\bin\ (version 7.x).

3. Modify the Siebel Servers ODBC Data Source Name (DSN). Change the Server Name entry to use the new TNS alias using the ODBC Data Source Administrator on the machine where the Siebel Server is installed. The System DSN is in the format of SiebSrvr_.

4. Modify the ODBC Data Source Name (DSN) for any dedicated clients. Change the Server Name entry to use the new TNS alias using the ODBC Data Source Administrator on the machine where the dedicated client is installed. The User DSN is in the format of SEAW .

5. The Siebel Server will need to be stopped and restarted for this change to take effect.

For Siebel 7.x only
6. Update the gateway configuration information. By default the Object Managers no longer read the CFG files for the database connect string (see the OM parameter called ’OM – Read Configuration From Server Component Parameters’). Therefore the gateway configuration for that enterprise will need to be updated to reflect the new TNS alias. The commands to use are below, but first the Siebel Administrators will need to backup the Siebns.dat, either manually by copying the file or using the SRVRMGR backup nameserver command, for example:

SRVRMGR> backup nameserver SRVRMGR> change parameter DSConnectString= for named subsystem ServerDataSrc

Note: to change the ODBC Data Source Name using the client GUI, perform the steps as follows:
1. Navigate to View > Site Map > Server Administration > Enterprise Configuration. (version 7.x) or View> Site Map > Administration – Server Configuration > Enterprises (version 8.x).
2. Click on the Enterprise Profile Configuration tab (version 7.x) or Profile Configuration tab (version 8.x)..
3. Select ServerDataSrc in the top list applet.
4. In the lower applet, find the DSConnectString and change its value to the new TNS alias.
5. The Siebel Server will need to be stopped and restarted for this change to take effect.

Check All Siebel Administration Tutorials