How to grep recursively in Solaris

If you are from Linux background, you will find irritating that Solaris’s grep command does not support -r switch to perform recursive grep. But, don’t worry, there is a workaround in Solaris to perform grep recursively using the piped command as below.

find . | xargs grep 'Your Grep Value'

How to kill Oracle sessions

Killing Oracle sessions can be very destructive if you kill the wrong session, so be very careful when identifying the session to be killed. If you kill a session belonging to a background process you will cause an instance crash.

Identify the offending session using the [G]V$SESSION and [G]V$PROCESS views as follows.

SET LINESIZE 100
COLUMN spid FORMAT A10
COLUMN username FORMAT A10
COLUMN program FORMAT A45
 
SELECT s.inst_id,
       s.sid,
       s.serial#,
       p.spid,
       s.username,
       s.program
FROM   gv$session s
       JOIN gv$process p ON p.addr = s.paddr AND p.inst_id = s.inst_id
WHERE  s.type != 'BACKGROUND';
 
   INST_ID        SID    SERIAL# SPID       USERNAME   PROGRAM
---------- ---------- ---------- ---------- ---------- ---------------------------------------------
         1         30         15 3859       TEST       sqlplus@oel5-11gr2.localdomain (TNS V1-V3)
         1         23        287 3834       SYS        sqlplus@oel5-11gr2.localdomain (TNS V1-V3)
         1         40        387 4663                  oracle@oel5-11gr2.localdomain (J000)
         1         38        125 4665                  oracle@oel5-11gr2.localdomain (J001)
 
SQL>

Read More

JasperReports Server 4.0.0 Release

JasperReports Server Community Project is a high-performance, standalone and embeddable Business Intelligence (BI) platform that provides rich reporting capabilities. In addition, Jaspersoft OLAP provides OLAP data analysis, running on the same shared BI platform.

What’s new in JasperReports Server 4.0.0

Product Naming
Several changes have been made to Jaspersoft’s product names; in particular:

  • The former “JasperServer” is called “JasperReports Server”
  • The former “JasperAnalysis” is called “Jaspersoft OLAP”

Read More

How To Set Time Using NTP In Solaris

NTP is stand for Network Time Protocol. It is used for synchronizing the clocks of computer systems over packet-switched, variable-latency data networks. NTP uses UDP on port 123 as its transport layer.

Keeping the date/time synchronized throughout all computers / servers is really necessary. Solaris already comes with the ntp daemon, called “xntpd”.

  • Check whether NTP daemon status
    root@server:~# svcs -a | grep ntp
    disabled May_11 svc:/network/ntp:default

Read More

JasperServer Quick How-To

How to change the JasperServer login page?

Edit the $JASPER_ROOT/WEB-INF/bundles/jasperserver_messages.properties and change your desired text as below.

#Welcome Login Page
LOGIN_WELCOME_OS=Welcome to JasperServer Reporting System!

# the following 2 strings belong to the same sentence
LOGIN_ONLINE_DEMO_PRE=JasperServer is an open source business intelligence suite ....
LOGIN_ONLINE_DEMO=JasperReports is a powerful open source Java reporting tool ...

Now, replace the $JASPER_ROOT/WEB-INF/jsp/login_welcome.jsp with the one i attached here. You may see the differences before replace. Once the file replaced, the login page will look like below.
Read More