Lion Soft Inc. | Monthly Archives: August 2015

How to run java-rep2excel as Windows service

August 24, 2015 williamsvoon Monitoring

The java-Rep2excel is web-based application, although you can control it via Win32 GUI application. You may want the java-Rep2excel to be running even though you log off the Windows desktop. So you need to run java-Rep2excel as service.

How TO

The following steps guide you through the installation of Windows service.

Open java-Rep2excel GUI manager, click Server, and then “Install/Uninstall Service”.
The service will be installed. And in case the server has been installed before, and the server will be uninstall if you click the button again.
Run services.msc, you will see the entry of java-rep2excel server in the list of service (local). You can start/stop the service by this command:

net start “j-Rep2excel Server”

net stop “j-Rep2excel Server”

Note

Please upgrade the version 1.60 or above in case you need the feature. Because there is bug in the version prior to version 1.60.

Oracle tablespace growth and usage monitoring by EasyHA

August 13, 2015 williamsvoon Monitoring

I want to create a mechanism to monitor growth of our oracle tablespaces and how much space is used in them.

Step by Step Guide

1. Configure JDBC connections.

Provided you have install the free version of EasyHA, before you monitor your database Description: build-conn-helper.png s and business data (like tablespace usage), you should please create JDBC database connection to your Oracle database.

To create JDBC connection, please click “Setup” menu, and then click “Databases Overview” button. In the “Jdbcs” page, please click “Add Jdbc” button.

The “New Jdbc” form appears, it is very easy to fill in the form. You can also click “Help” link if you don’t know how to fill in URL box.

Now I have created a connection named gnbsprd-ozq. The settings of the connection is listed below:

2. Create item that will monitor your tablespace usage.

Click “Items” menu.
Now you will see the list of items.
Click “Add Item” button in right upper corner.
Select “Biz Data Monitor” from item type list.
Select DB and fill in the SQL statement.
Fill other fields like interval and description of field #1.
Submit the form and review the item. The item looks like this:

The SQL statement is very critical. This is sample SQL.

SELECT
　　D.TOT_GROOTTE_MB "SIZE MB",
　　D.TOT_GROOTTE_MB – F.TOTAL_BYTES "USED SPACE MB"
　　FROM (SELECT TABLESPACE_NAME,
　　ROUND(SUM(BYTES) / (1024 * 1024), 2) TOTAL_BYTES,
　　ROUND(MAX(BYTES) / (1024 * 1024), 2) MAX_BYTES
　　FROM SYS.DBA_FREE_SPACE
　　GROUP BY TABLESPACE_NAME) F,
　　(SELECT DD.TABLESPACE_NAME,
　　 ROUND(SUM(DD.BYTES) / (1024 * 1024), 2) TOT_GROOTTE_MB
　　FROM SYS.DBA_DATA_FILES DD
WHERE dd.TABLESPACE_NAME='TABLESPACE1'
　　GROUP BY DD.TABLESPACE_NAME) D
　　WHERE D.TABLESPACE_NAME = F.TABLESPACE_NAME
ORDER BY 1

If you want to monitor specified table, for example named “emp”, the sql like:

SELECT SUM(bytes)/1024/1024 Mbytese
FROM dba_segments
WHERE tablespace_name ='TABLESPACE1'
AND SEGMENT_NAME='EMP'
ORDER BY Mbytese DESC

3. View the tablespace growth a few days later.

Click “View” manu.
Click “Graph View” button.
Select item, and fill in date range, and click submit button.

The graph looks like:

Call RepExpert by Http Link

August 12, 2015 williamsvoon Rep2excel

Perhaps you are using web-based oracle reports. Generally speaking, you will call Oracle Reports Server from your Web-based Oracle Forms or other application, the oracle form (or your application) will open the http link, then the default browser of client computer will open the link, and the report output is displayed in browser. The http link looks similar to:

http://server-name:7777/dev60cgi/rwcgi60?….
http://server-name/reports/rwservlet/getjobid….

As RepExpert is professional printing tool for oracle reports. So you are better off using RepExpert as default viewer/printer of Oracle Report output.

The RepExpert can be launched by web-based forms and web pages.

How it works

The RepExpert contains an add-on for IE named RepExpert IEHelper, you can see this add-on in IE.

Repexpert IEHelper add-on will monitor the navigation activity of IE (Internet Explorer), and analyze the URL and determine whether the URL is link to a file of report output.

If the URL contains all pre-defined keywords, the Repexpert IEHelper add-on will execute RepExpert and it will download the file and open it instead of IE.

Requirements

1. The default browser should be IE (Internet Explorer v6/7/8/9/10/11).
2. The RepExpert IEHelper add-on should be enabled.
3. The URL should contain predefined keywords.

Configure RepExpert to be launched by URL

There are 2 ways to configure RepExpert to be launched by URL.

No. 1

1. Execute RepExpert, Click Settings Menu -> URL Keywords Setup -> Group #1/2/3/4

Description: https://www.lv2000.com/re/help/helpimg/keyword-setup.jpg

2. Fill in your keywords.

The keyword is sub-string of the URL, it can be used to identify the URL to oracle report output.

3.Click OK.

To disable one group of keywords, please clear all keywords and click OK.

No. 2

The RepExpert contains a built-in keyword: &callrepexpert=yes. So every URL contains this keyword will be used to invoke RepExpert.

So, please just append &callrepexpert=yes to your URL, and then the URL can launch RepExpert.

See the sample below:

declare
v_url varchar2(1000);
begin
v_url:='http://SVR_NAME:7777/dev60cgi/rwcgi60?';
v_url:=v_url||'server=rep_svr&report=test_report.rdf';
v_url:=v_url||'&userid=scott/tiger@test&destype=cache&desformat=HTMLCSS';
v_url:=v_url||'&callrepexpert=yes';
web.show_document(v_url,'_blank');
end;

Troubleshooting

First, please make sure that the IE is default browser of client computer. If you are using Windows 8 or above, please set IE as default browser, other than Microsoft Edge.

If the RepExpert is not launched as you want, you should first check the keyword settings.

The following link contains built-in keyword "&callrepexpert=yes", please click it.

https://www.lv2000.com/examples/getreport.php?file=00001.htm&mime=text/html&callrepexpert=yes

If you want to know whether Repexpert IEHelper works properly, please download the tool from https://www.lv2000.com/products/IeHelperSts.zip

The file is helpful for you diagnosing the error.

How to set Internet Explorer as the default browser:

Internet Explorer is the default browser on Windows computers. If you click a link in another program on your computer, like an email client, it will open in Internet Explorer. If you've set another web browser as the default, you can choose to switch back to Internet Explorer.

Click the Tools button in the top-right corner of the browser, then select Internet Options.
The Internet Options dialog box will appear. Select the Programs tab.
Locate and select Make Internet Explorer the default browser, then click OK. Any link you open on your computer will now open in Internet Explorer.

FAQ

Q: Does RepExpert support Windows 10?

A: RepExpert supports Windows 10 (both 32 & 64bit). However, the default browser should be set as Internet Explorer (IE). Perhaps you use Microsoft Edge as default browser.

Q: Does RepExpert support IE11?

A: Yes.

Q: Does RepExpert support other browser except for IE? Such as Chrome and firefox.

A: Not support other browser till now. You can also contact the vendor support@lv2000.com if you have any special needs. We will develop new features according the customer’s needs.