Category: Siebel Administration

Steps to Extract Local Database in Siebel & Common Issues

Encountered many issues while working on Local Database Extract on Unix environment, with this post I want to share all issues and its solution as well. Steps for DB Extract in Unix Environment: Step 1.  Create User -> Employee with required fields(Position & Responsibilities) Step 2. Register user in Siebel Remote->Mobile client Step 3. Open Command  Prompt and connect to server manager…

How to get count of all concurrent logged in Users in Siebel ?

If you want to know all agents connected to Siebel database, just run select count(*) from v$session where username not in (‘SADMIN, any other system login ids) and program = ‘siebel.exe’   And to get the list of active users in a specific timeline, The column LAST_LOGIN_TS on the table S_USER shows the last time a user logged into the…

Troubleshooting Open Cursor Issues

Troubleshooting Open Cursor Issues Similar to any application that uses Oracle Database as backend repository, Oracle Identity Manager runs several SQL statements. For every SQL statement execution in Oracle Database, certain area in the memory is allocated. Oracle PL/SQL allows you to name this area. This private SQL area is called context area or cursor. These cursors take up space…

Siebel IP2016 – Siebel Enterprise Server Config Issues Part 5

Issue#5 HTTP Error 500.0 Internal Server Error Environment: OS:Windows Server 2012R2 Siebel Version: 16 Issue: The Gateway and Siebel server is installed and running. The SWSE also installed without any issues. But accessing Thin application URL gives below error “HTTP Error 500.0 Internal Server Error The page cannot be displayed because an internal server error has occurred.” Cause: Microsoft Windows Server…

Siebel IP2016 – Siebel Enterprise Server Config Issues Part 4

Issue#4 Siebel Server fails to start after new configuration Environment: OS:Windows Server 2012R2 Siebel Version: 16 Issue: Siebel Server installation and configuration completed successfully Tools is connecting properly but thin client gives “Server busy” error Siebel server crashed after few minutes of start    SRBroker.log 2021 2016-06-10 15:28:50 0000-00-00 00:00:00 +0300 00000000 001 003f 0001 09 SRBroker 2097154 17496 1 /u01/SBA_81/siebsrvr/enterprises/SBA_81/xx/log/SRBroker_0002_2097154.log…

Siebel IP2016 – Siebel Enterprise Server Config Issues Part 2

Issue#1 Unable to connect to the gateway server (SBL-GEN-05009) Environment: OS:Solaris Sparc 11 Siebel Version: 16 Issue: Siebel Gateway Configuration (2nd step of Enterprise Configuration) failed with below error.   Gaetway.log NameServerLayerLog Error 1 000000024f4c19ce:0 2012-02-28 09:36:10 Unable to connect to the gateway server. GenericLog GenericError 1 000000024f4c19ce:0 2012-02-28 09:36:10 NSC – ErrCode 5009 SysErr 0 GenericLog GenericError 1 000000024f4c19ce:0 2012-02-28…

Siebel IP2016 – Siebel Enterprise Server Config Issues Part 3

Issue#3 Siebel Gateway Configuration failed with error SBL-GEN-05009 Environment: OS:Windows Server 2012 R2 Siebel Version: 16 Issue: Siebel Gateway Name Server Configuration failed with error. Please see the files for details. Gateways name server windows services not created properly after this error. Cause: Installation User don’t have full admin rights to create windows services. Solution: We need to deactivate UAC (User Account…

Siebel IP2016 – Siebel Enterprise Server Config Issues Part 1

Issue#1 Siebel Gateway Configuration failed with error SBL-GEN-05009 Environment: OS:Solaris Sparc 11 Siebel Version: 16 Issue: Siebel Gateway Name Server Configuration failed with error. Please see the files for details. Siebel.log 2021 2016-06-01 17:29:49 2016-06-01 17:29:49 +0300 0000000f 001 003f 0001 09 siebel 26438 1 /u01/SBA_81/gtwysrvr/log/siebel.log 16.0.0.0 [23057] ENU NameServerLayerLog Info 3 00000002574e6746:0 2016-06-01 17:29:49 1: CSSNSClient::CSSNSClient() successfully initialized, m_bNewLocking: True NameServerLayerLog…

Siebel IP2016 – Siebel Enterprise Server Installation Part 3

  Siebel IP2016 – Siebel Enterprise Server Installation Part 1 Siebel IP2016 – Siebel Enterprise Server Installation Part 2   Step 6: Configuring Siebel Server Navigate to $SIEBSRVR_ROOT folder /u01/SBA_81/siebsrvr Source . ./cfgenv.sh File in order to continue the configuration Navigate to $SIEBEL_ROOT/config folder Run ./config.sh –mode siebsrvr [su_slider source=”media: 1121,1122,1123,1124,1125,1126,1127,1128,1129″ link=”lightbox” target=”blank” width=”1220″ height=”600″ autoplay=”0″]   Step 7: Installing…