Monday 9 May 2016

Configuring OHS to run on port 80

Hi All,

Recently I was working on a issue where I needed to change the port from 8080 to 80(default) of Siebel Application’s url. There were the following observation.

  1. Since the port was to be changed so the change was to be made in Web Server in my case (Oracle Http Server).
  2. Web server is Installed with non-root user
  3. Port 0 to 1024 cannot be set by a non-root user
  4. On Unix any service (including OHS) that runs on port < 1024 must be run as root-user. You must re-configure OHS so that service is started as root user
  5. And web server should be reconfigured only with the person who installed it
So, the situation was we need to change port by non-root user to 80 from 8080 which is less than 1024 and this is not allowed.

In UNIX systems, if you change the Oracle HTTP Server Listen port number to a value less than 1024, you must enable Oracle HTTP Server to run as root, for this we need to follow:
  •  Login with root user
  •  Navigate to ORACLE_HOME/ohs/bin and change the owner and permission of file .apachectl chown root .apachectl  (dot infront of apachectl specify that this is hidden file) chmod 6750 .apachectl
  • In the same location locate script file apachectl Add the line LD_LIBRARY_PATH=Siebel_home_dir/sweapp/bin:Siebel_home_dir/sweapp/bin/enu above the lines:    #set ulimit for OHS to dump core when it crashes ulimit -c unlimited
                                     apachectl

  •  Exit root user and login in user who installed OHS and Make changes in eapps.cfg file under Siebel_home_dir/sweapp/bin and httpd.config file under ORACLE_HOME/instance/config/ohs
                                   eapps.cfg

                                  httpd.confg


  •  Restart OHS.
Commands to restart OHS:

$ORACLE_INSTANCE/bin/opmnctl stopproc process-type=OHS

$ORACLE_INSTANCE/bin/opmnctl startproc process-type=OHS

Hope this was helpful .. 

Thursday 5 May 2016

Unable to access file system using Siebel Scripting

Hello All,

Recently i faced a issue where i was trying to call a sql script from a Business Service but got the following error .
"Error occurred while creating file in filesystem. Please contact your system administrator.(SBL-SVC-00184) "
after some debugging and searching Oracle support i found out that this is because of some security changes in siebel version 8.1.1.11 and above.
 as stated in the below document by oracle.

Siebel eScript: "Access Denied: Cannot access file system file or shell" error in file i/o method of the Clib object (Doc ID 1594198.1)

In Siebel CRM version 8.1.1.11 and onwards a server side code is no more allowed access file system/perform shell operations.
This applies to the following Clib functions:
fopen()
rename()
remove()
mkdir()
rmdir()
system()
WORKAROUND: 


  • If one need to allow compiled Siebel eScript code to access the file system,  add following System preference of Siebel Application (Name = Value):
          Allow File System Access = TRUE
  • This will only function for Siebel eScript code, compiled in Siebel Tools, so any client side BS must be compiled.
for more details kindly refer oracle bookshelf.


Siebel GoTo View - Handling Realtime cases

 Hello All,  We all must have used GoTo view functionality of siebel to navigate to a particular view from current view. What if the require...