Loading
Home » Archive

Articles in the Siebel Administration Category

Configuration, Siebel SQLs & Database »

[29 Dec 2011 | 5 Comments | ]

In new versions of Siebel CRM application, Oracle has encoded the audit trail to store it in encoded format in Siebel, instead of Separate columns of New and Old values. Hence it is not possible to get those values by directly reading the S_AUDIT_ITEM table.

So, I have created a Oracle SQL Procedure which will help you decode the audit trail and store in a temporary table, just like it was earlier. Here, you would need to provide Table, Column for which you want to grab the audit trail. You can specify multiple …

EAI, Siebel Administration, Web Services »

[4 Apr 2010 | 7 Comments | ]

Whenever we make use of HTTP Transport or Web Services based on HTTP transport, we need to secure that web service using the
digital certificates. Because, the information is exchanged over internet which is no more secure now.
Now question is, what is a digital certificate? Then answer is simple, just launch your http://mail.google.com in a browser.
Automatically, you will see the url will be redirected to “https” from “http”. Also, you will see a “Lock” on the browser url
on right side. Because google has configured a digital certificate on this site. So, …

Configuration, Siebel Administration, Siebel SQLs & Database, Uncategorized »

[15 Jun 2009 | 4 Comments | ]

This issues was faced by a developer, who asked for the solution, so here is something can be done at database level -
[a]
Create an Oracle profile and limit the number of sessions per database user, for example:
sql> CREATE PROFILE <profilename> limit SESSIONS_PER_USER 1;
sql> ALTER USER <username> <profilename>;
sql> ALTER SYSTEM SET RESOURCE_LIMIT=TRUE;
Using this approach, please be aware that dead connections will not always be detected by the database immediately, so users might occasionally not be able to login even a single time until a database administrator has killed their session. Also, …