2008 – SWKB.NET

Siebel: Server Manager Notes (srvrmgr)

Post author:admin
Post published:August 20, 2008
Post category:Siebel: How To Examples
Post comments:0 Comments

Some useful commands for srvrmgr:

C:\sba80\siebsrvr\BIN>
srvrmgr /g  /e  /s  
/u SADMIN /p SADMIN

list servers
set server SBLAPP1
unset server SBLAPP1
unset server
list component groups

disable component group Workflow

assign component group Remote to server 
enable component group Remote for server 

shutdown appserver 
startup appserver 
[stop and restart system service...]

list evtloglvl for component eCommunicationsObjMgr_enu
change evtloglvl Error=5 for component eCommunicationsObjMgr_enu

change evtloglvl GenericLog=1, Performance=1, Trace=0, TaskConfig=0, SrmRouting=0, SQLParseAndExecute=1, 
SQLSlowQuery=4, Perf=1, ProcReq=1 for comp WorkMon

activate component definition GenNewDb for server 

spool c:\spool.txt
spool off  (more…)

Oracle PL/SQL: Find specific value in a table / tables

Post author:admin
Post published:August 12, 2008
Post category:Oracle PL/SQL: How To Examples
Post comments:0 Comments

The procedure below helps in order to find a specific value in the tables declared at TABLES_SET cursor: CREATE procedure OLTP_SIA.find_specific_value (theString IN VARCHAR2) is match_count INTEGER; the_table VARCHAR2(150); CURSOR…

Oracle PL/SQL: Find invalid number in number column

Post author:admin
Post published:August 12, 2008
Post category:Oracle PL/SQL: How To Examples
Post comments:0 Comments

The procedure below helps to find which record has text instead of number, so it produces "ORA-01722: invalid number" when you try to join with another number field. DECLAREEMPLID VARCHAR2(15);LAST_EMPLID…

PHP: Get informed by e-mail when someone visits your site

Post author:admin
Post published:August 12, 2008
Post category:PHP: How To Examples
Post comments:0 Comments

The code below sends e-mail when someone visits your site (except yourself, assuming that you are testing locally): if(!empty($_REQUEST)){ $theRemoteAddr = $_SERVER['REMOTE_ADDR']; $theRemoteHost = gethostbyaddr($_SERVER['REMOTE_ADDR']); //send mail: $receiver="myself@mymail.com"; $from="info@swkb.net"; $subject="someone…

Oracle 10g: Set NLS_LANG

Post author:admin
Post published:August 11, 2008
Post category:Oracle DB: How To Examples
Post comments:0 Comments

SELECT * FROM NLS_SESSION_PARAMETERSALTER SESSION SET NLS_LANGUAGE=Greek;alter session set nls_lang=GREEK_GREECE.EL8MSWIN1253

Oracle PL/SQL: Find Null Columns

Post author:admin
Post published:August 11, 2008
Post category:Oracle PL/SQL: How To Examples
Post comments:0 Comments

With the procedure below you can find which columns are totally null, without data. It is useful, when you need an empty column e.g. for a new field: BEGIN DECLARE…

Oracle PL/SQL: Insert into Table using Cursor

Post author:admin
Post published:August 11, 2008
Post category:Oracle PL/SQL: How To Examples
Post comments:0 Comments

The following insert statement is used to fill an interface table from a remote database, using a dblink (tblCalls_v1@sqlserverdb). It commits every 500: BEGIN DECLARE CURSOR C1 IS SELECT "ContactID"…

Java: Primitive Data Types

Post author:admin
Post published:August 11, 2008
Post category:Java: Fundamentals
Post comments:0 Comments

Primitive Type Size Range of Values (inclusive) byte 8 bits –128 to 127 short 16 bits –32768 to 32767 int 32 bits –2147483648 to 2147483647 long 64 bits –9223372036854775808…

Java: Wooden Language

Post author:admin
Post published:August 9, 2008
Post category:Java: How To Examples
Post comments:0 Comments

The program below uses the typical expressions of the so called "wooden language" which is actually talking with impressive expressions but finally say nothing. I was originally inspired from the…

Java: Connect to DB and fetch data

Post author:admin
Post published:August 9, 2008
Post category:Java: How To Examples
Post comments:0 Comments

With the code below you can connect to an Oracle database using JDBC driver and fetch some data: (you can find the libraries needed below) import java.sql.*;import java.util.Date;import java.util.Properties;public class…