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…
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 system. You should be able to create a simple query to get a list of all users…
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…
Issue#6 White Screen Appearing after login in Siebel Thin Client Environment： OS:Solaris Sparc 11 Siebel Version: 16 Issue: In thin client, we are able to get the login page but application fails to load and blank screen appears. Able to connect to server manager and components are online. In console we can see below error message ERROR_CONNECTION_REFUSED Cause: I had mentioned port…