How to change SADMIN/SIEBEL Passwords

Introduction
 
The purpose of this post is to describe step by step instructions on how to change SADMIN/SIEBEL and other user Database service account passwords.

Sequence for the Password changes

1.     Change the SADMIN password in the Database
2.     Change the SADMIN password in the Application.
3.     Bounce all servers.
4.     Test the entire application.
5.     Change the SIEBEL password in the Application.
6.     Change the SIEBEL password in the database
7.     Bounce all servers.
8.     Test the entire application.

Process of changing the SADMIN Password
====================================================================================
Pre-Requisites to start Password change process
1. Make sure application is up and running
2. Make sure that database level password complies with database password policy.
3. All environment details in hand
    a.Gateway name
    b.Enterprise Name
    c.Installation path 

Follow the below steps one by one.
1. backup namesrvr
    Log in to Siebel Manager (srvrmgr) with the following commands:
        E:\sba81\siebsrvr\bin\srvrmgr /g xxx_gateway_nameserver  /e enterprise_name -u sadmin
    After successfull connection to gateway server, issue the following command.
        srvrmgr > backup namesrvr

2. Change the password for SADMIN user
    1. Logon to srvmgr using the command prompt
    2. Change Siebel settings with new password by using below command:
        “change enterprise parameter Password=NEWPASSWORD”

3. Stop all Siebel Services using Restart Procedures:       
    1. Siebel App Servers
    2. Siebel Gateway Servers

4. Once the password is changed delete the exisiting siebel service.
    siebctl -d -S siebsrvr -i "siebel_server_name"


5. Create a new siebel service.
    siebctl -h “D:\Siebel\Server\siebsrvr\” -S siebsrvr -i "server_name" -a -g "-g  machine_name:2320 -e enterprise_Name -s SIEBEL  -u sadmin" -e NewPassword

Process of changing the SIEBEL Password
====================================================================================
1) Have DBAs Change Password
2) Log into a Siebel employee web application.
3) Click on Site Map Globe icon on the top left of the application.
4) Click on the “Administration - Server Configuration”  link
    a. Click on Enterprises.
5) Click the Parameters tab.
6) In the Enterprise Parameter, under the name column, scroll down to “Table Owner Password”
    a. Enter new password in the “Value” Column
7) Click on the “Menu” drop down.
8) Click “save record”. 

Enable/Disable Export on Applets

Scenario:

We want to enable the account export functionality to selected list of responsibility, we should be able to control the number of responsibility to add or remove.

Solution:

1. We will be using the LOV framework to define the list of responsibilities and tag each one of them with different display value, here the challenge is to write a responsibility name in the display value of LOV as it limits the 30 characters. We can use Language-Independent code as to write a responsibility name as we have 50 character limit.
2. Then we can write a script on applet Pre-Invoke method to get the LOV details and implement a logic to control the export enable or disable.

Here is the Code.

List down the responsibilities and applets which you want to give access and disable the export functionality. Define them in the in the LOV framework.

1. Site Map – Administration – Data – LOV Explorer.

Create a New LOV Type (EXPORT_STATUS_DE)

2. Site Map – Administration – Data – List of Values.

TYPE	Display Value	Language Independent Code	Active
EXPORT_STATUS_DE	EXP1	Resp_Name_1	TRUE
EXPORT_STATUS_DE	EXP2	Resp_Name_2	TRUE
EXPORT_STATUS_DE	EXP3	Resp_Name_3	TRUE

3. Now implement a script on the applet where you want to disable the export based on the responsibility.
4. Query the Applet Name in Siebel tools and Right click on it and Edit Server script and write a below script.

function WebApplet_PreCanInvokeMethod (MethodName, &CanInvoke)

{

   if(MethodName =="ExportQuery")

   {

                                try

        {

                                var primaryResp = TheApplication().GetProfileAttr("Primary Responsibility Name");

                                                var vDisplayValue = TheApplication().InvokeMethod("LookupValue"," EXPORT_STATUS_DE ", primaryResp);

                                vDisplayValue = vDisplayValue.substring(0,3);

                                        if(vDisplayValue == "EXP")

                                        {

                                                CanInvoke = "TRUE";

                        return (CancelOperation);

                                        }

                                        else

                                        {

                                                CanInvoke = "FALSE";

                        return (CancelOperation);

                                        }

                                        return (CancelOperation);

                                  }

                                  catch(e)             

                      {

                            throw(e);              

                      }

                      finally

                                  {

                                                                vDisplayValue = null;

                                  }

   }

   return (ContinueOperation);

}

Now Compile the object and test it.

Siebel Unix Installation Step By Step

how to Setup Siebel 8.1.1.X on Unix Environment on Multiple Boxes?
-----------------------------------------------------------------------------------------

1) The vpd.properties file MUST exist prior to the first Siebel installation being performed on a particular host

2) Create folder at /var/adm/siebel with 777 permission.

3) required to initiate GUI mode on Unix is

                set DISPLAY=xxx.xxx.xxx.xxx:0.0; export DISPLAY

How to Install Gateway Server ?

-----------------------------------------------------------------------------------------

1) Login with Gateway userid.

2) Run the installer by launching ./setupsol

3) Select Next to commence for installation

4) Enter the fully qualified path for gateway installation

                e.g. /siebelx/xxxxxxx/gtwy

5) Select Gateway Server

6) Select 'Typical'

7) Chose the language ‘enu’

8) Enter Gateway Port (e.g 2320)

9) Set Auto-start: No

10) To complete the installation, click Finish.

How to Install Gateway Server ?

-----------------------------------------------------------------------------------------

1) Login with Siebel1 user-id.

2) Run the installer by launching ./setupsol

3) Select Next to commence for installation.

4) Select, None, Install a new instance and press Next.

5) Enter enterprise install location  E.g. /siebel1/xxxxxx

6) Select Siebel Server from Product

7) Select ‘Typical’  install type

8) Select language ‘enu’ (Default)

9) Select, Neither for eBriefing & eContact (Default)

10) Verify the details provided earlier.

11) Put gateway details Hostname & Port (As per Tech-Spec)

12) Select component Groups to enable by default.

Siebel Server Setup

                Mention the Enterprise name (e.g. xxxxxx)

                Mention exact File System path (e.g. /siebelfs123)

                Description of the siebel server

                Synch' Manager IP Port, e.g. 40400

                Data matching s/w: None

                Server DB: Oracle

                Enter Oracle Connect string (e.g. dev1)

                DB table owner: siebel (Default)

                DB username used by SS etc: sadmin (Default)

                Enter sadmin PW ********

                Chartserver host: Null (Default)

                chart image format: png (Default)

                Encryption: None

                Enter Siebel Server name (e.g. siebesrv1)

                Enter brief Description

                SynchMgr static port override: No

                Config Search Server: Skip

                Autostart: No

                Start server now: No

                Deploy SSL : No

                Finish.

 

How to Install Database Server?

-----------------------------------------------------------------------------------------

1) Login with siebel1 user.

2) Run the installer by launching ./setupsol

3) Select, None, Install a new instance.

4) Enter dbsrvr installation location. (e.g. /siebel1/xxxxxx/dbsrvr)

5) Select Database Server

6) Select Custom install type

7) Un-check IBM DB2 and select only Oracle & Sample Database.

     [X] Oracle Database Enterprise Edition

     [ ] IBM DB2 UDB for Unix and Windows

     [X] Siebel Sample Database

8) Select enu

9) Review the installation selection & proceed.

10) Click Finish to complete the installation.

How to Install Siebel Web Server ?

-----------------------------------------------------------------------------------------

Before starting web-server installation (Web-Server - iPlanet SunOne WebServer)

Create a folder sunone-<environment_name> under /siebel1 folder.

1) Log in as the siebweb user

2) run setup by typing ‘./setup’

3) press return to select Yes to the commence install question

4) enter Yes to the license agreement question

5) enter 3 and return to select a custom install

6) enter the installation location using the following convention

                /siebel1/iplanet-XXX/servers

7) press return to select the default of All

8) press return to select 1,2,3

9) enter the hostname of the server

10) when prompted for a user to run the webserver as enter siebweb

11) Enter group e.g sbladm

12) User to run the admin webserver e.g siebweb

13) Admin account e.g. admin

14) Password for the admin account ****

15) Set the admin webserver port to e.g 8888 (Default)

16) Webserver port e.g. 61000

17) Root directoyr for webserver e.g. /siebel1/sunone-XXX/servers/docs

18) Installing your own jdk – No

19) press return to complete the install

Before starting with SWSE installation

1) Make sure SUN ONE web server (SPx) is already installed.

2) Prior to the installation of SWSE, the vpd.properties should have write access.

3) Make sure that the users ‘proxye’ & ‘guestcst’ account must be created at database level. 

Now Install the Siebel Web Server Extension ( SWSE )

-----------------------------------------------------------------------------------------------------

1) Login with siebweb user

2) Launch the installer by running ./setupsol

3) Select, None, Install a new instance.

4) Enter the Doc root Directory (e.g. /siebel1/sunone-XXX/SWSE)

5) Select Language enu

6) Enter iPlanet install directory (e.g. /siebel1/sunone-XXX/servers/https-hostname)

7) Select Load balancing Option

8) Enter host name for Siebel Application Server (e.g. machine name)

9) Enter port number for Siebel SCBrocker Component. (default 2321)

10) Enter Enterprise (e.g. xxxxxx)

11) Select encryption: none (default)

12) Select Compression type : none (default)

13) Enter http port (e.g. 8080)

14) Enter https port (e.g. 443 default)

15) Enter Employee Anonymous user ‘proxye’ & password ‘*****’

16) Enter Contact Anonymous user ‘guestcst’ & password ‘*****’

17) Enter update protection key ‘siebel77’

18) Deploy SSL in enterprise: No

19) Select Restart: No

20) Review the installation settings & click finish.