Installation Jasper Server on Oracle Linux

If you would like to start development with Jasper Server, we have to download software which is ‘Tibco Jasper Server. This tool is easy to use. We can download its community version which is free to use. In this tutorial first, we will download and install in Oracle Linux.

 Please follow the steps given below: 

Step 1: Open your favorite browser and type https://community.jaspersoft.com/download press enter.

Step 2: On this page, we have two choices for download. First is a community edition which is free for use and has some limitation. Also, we have another option “Enterprise edition” to download. And it is available for 60-days free trial. If you are going to use commercially then you must purchase a license. If you are a student or just want to do some hands-on practice then you can proceed with the community edition version. In this tutorial, I am using a free version which is a community edition for learning purpose only.

Now click on the download button as shown in below image:

Then you will be redirected to another page which will look as given in below image with multiple jasper tools.

On this page you have to click on six download button which is “JasperReports Server CE” then again you will be redirected to another page where you have to click on the link to download actual setup.

Please see the image below:

Once you click the link, a popup message box will appear where you just click on “No thanks” to close this and the new web page will appear, here on this page, we will see the message that download is going to start in next 5 second. In the next 5 second *.run file will start downloading on your computer.

Downloading will take time as per your net connection speed. So please have Patience and wait for complete downloading.

Please see the below image.

Step 3: Once you download it then ftp this setup on linux server and change the permission for installation and run this setup as--

[oracle@erpclnapx jasperreport]$ ./jasperreports-server-cp-6.3.0-linux-x64-installer.run

 And finally you will see the very first setup popup window:

Now click on Next button. Then License agreement page will appear so just choose the “Yes” radio button and click to the next button. Please see the below image:

The next screen will appear. Please see the screenshot below. On this window, you have the option for installation type. By default “Install all components and samples” are selected. Leave this as it is and click on next button.

Now on the next window, it will ask you to select the installation folder path. If you want to install on any other directory so use browse button on choose. By default it will install in user /home/oracle directory. 

After selecting the installation path once you click the Next> button then you will see a progress bar on next window. In this step, the installer will start loading all required files on your system.

After completion of this progress bar you will see the next screen with a message like “Setup has finished installing jasper report server CP 7.1.0 Setup Wizard” and then click “FINISH” button. 

Once you click “FINISH” button Jasper server take to start and URL (http://erpclnapx.nicsi.in:8015/jasperserver/login.html) will open in chrome browser automatically and you will see this page. If you seeing this page that means your jasper server is installed successfully.

Here on this page, you have to enter user/password given below.

User: jasperadmin
Password: jasperadmin

After successful login, you will see the home page of the jasper server. Please see the screenshot below.

Congratulation!!! Installation is done successfully now you guys can proceed to start doing hands-on with jasper server.

URL http://erpclnapx.nicsi.in:8015/jasperserver

----Administrative User-------

Username: jasperadmin  

Password: jasperadmin

----Normal User--------------

Username: joeuser

Username: joeuser

[oracle@erpclnapx ~]$ cd /erp_ords/jasperreport

[oracle@erpclnapx jasperreport]$ ./ctlscript.sh stop

[oracle@erpclnapx jasperreport]$ ./ctlscript.sh start

[Solved]Oracle APPS DBA Errors and Log Message:

Error 1: (Doc ID 1675470.1)

While execute any query in SQL prompt then getting below error.

 alter tablespace APPS_TS_TX_DATA add datafile '/oradata1/oracle/TST/db/apps_st/data/apps_ts_tx_data15.dbf' size 15G

*

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 1

ORA-04031: unable to allocate 4160 bytes of shared memory ("shared

pool","unknown object","sga heap(3,0)","modification ")

 OR

Showing error in alert.log file.

 /oradata1/app/oracle/product/11.2.0/admin/TST_erptstdb01/diag/rdbms/tst/TST/trace/TST_m001_24889.trc  (incident=2110463):

ORA-04031: unable to allocate ORA-04031: unable to allocate 4160 bytes of shared memory

("shared pool","unknown object","sga heap(3,0)","modification ")

 bytes of shared memory ("","","","")

Solution:

To implement the solution, please execute the following steps: 

1. Please review Note: 146599.1 Diagnosing and Resolving Error ORA-04031. 
2. Flush shared pool. This should take care of the issue as it has come once.

ALTER SYSTEM FLUSH SHARED_POOL; 

if step 2 does not work:

3. Increase the shared memory or a simple DB bounce could resolve the issue. 

Error 2: (Doc ID 1276455.1)

1.  $ perl adcfgclone.pl dbTechStack then below error

 RC-00110: Fatal: Error occurred while relinking of ApplyDBTechStack

 Perl lib version (v5.8.4) doesn't match executable version (v5.10.0)

(Or)

Perl lib version (v5.8.8) doesn't match executable version (v5.10.0) at /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/Config.pm line 46.
Compilation failed in require at /clonedb/oradata/app/oracle/product/11.2.0/appsutil/clone/ouicli.pl line 35.
BEGIN failed--compilation aborted at  /clonedb/oradata/app/oracle/product/11.2.0/appsutil/clone/ouicli.pl line 35.

2. $ perl adpreclone.pl appsTier

Perl lib version (5.10.0) doesn't match executable version (v5.10.1) at /u03/oracle/DEV/apps/fs1/FMW_Home/webtier/perl/lib/5.10.0/x86_64-linux-thread-multi/Config.pm line 46.

Compilation failed in require at adpreclone.pl line 35.

BEGIN failed--compilation aborted at adpreclone.pl line 35.

Solution:

1. Setting the PERL5LIB environment variable on the Database tier.

 PERL5LIB=/clonedb/oradata/app/oracle/product/11.2.0/perl/lib/5.10.0:/clonedb/oradata/app/oracle/product/11.2.0/perl/lib/site_perl/5.10.0:/clonedb/oradata/app/oracle/product/11.2.0/appsutil/perl;

export PERL5LIB=/perl/lib/5.10.0:/perl/site_perl/5.10.0:/appsutil/perl

2.  export PATH=$ORACLE_HOME/perl:$ORACLE_HOME/perl/lib:$ORACLE_HOME/perl/bin:$PATH

Error 3:  (Doc ID 1638491.1)

$ perl adcfgclone.pl appsTier then below error

[AutoConfig Error Report]

The following report lists errors AutoConfig encountered during each

phase of its execution.  Errors are grouped by directory and phase.

The report format is:

      <filename>  <phase>  <return code where appropriate>

[SETUP PHASE]

AutoConfig could not successfully execute the following scripts:

Directory: /cloaneappl/inst/apps/CLONE_erpcloneappl/admin/install

      adgenjky.sh             INSTE8_SETUP       1

AutoConfig is exiting with status 1

AutoConfig execution completed on Wed May 1 13:59:46 2019

Solution:

$ cd /cloaneappl/inst/apps/CLONE_erpcloneappl/admin/install

$ ./ adgenjky.sh then check it’s log file

Log file showing that applprod.txt file Missing /Unable to open applprod.txt file in $APPL_TOP/admin.

So simply copy & past required files in that folder from source server.

Error 4: (Doc ID 1050646.1)

APP-FND-00362: Routine afpbep cannot execute request &REQUEST for program &PROGRAM

APP-FND-00362: Routine afpbep cannot execute request &REQUEST for program &PROGRAM, because the environment variable &BASEPATH is not set for the application to which the concurrent program executable &EXECUTABLE belongs.

Shut down the concurrent managers. Set the basepath environment variable for the application. Restart the concurrent managers. (VARIABLE=)

Routine AFPEOT cannot construct the name of an executable file for your concurrent request 4337779.

Check that the file name components are correct and valid on your system. Check that the environment for the person who started the concurrent manager

Solution:

Scenario:  There is a Custom Top registered and that top is not set in the ENV while starting the conc.

At the application tier check if CUSTOM_TOP is not set..

$ echo $CUSTOM_TOP

Request Name:   XXXXX ACCOUNT WISE

Query to Check whether the Env is set for the Particular request:

select variable_name,value from fnd_env_context e, fnd_concurrent_processes p, fnd_concurrent_requests r 

where p.concurrent_process_id =e.concurrent_process_id

and p.concurrent_process_id = r.controlling_manager 

and e.variable_name like '%CUSTOM_TOP%'

and r.request_id = &request_id;

Note: Above query return null value then set the custom top in custom environment file.

Add the respective Top in below  *.env files.

CUSTOM_TOP= /cloaneappl/apps/apps_st/appl/CUSTOM_TOP/12.0.0

export CUSTOM_TOP

1) $APPL_TOP/admin/adovars.env

Note: So that while running autoconfig it won’t remove every time.

2) Check the above custom top entry exist in $APPL_TOP/Custom<SID>_<hostname>.env

3) Bounce the Concurrent Manager or Bounce the Application services.

 Error 5:

 ORA-09925: Unable to create audit trail file

 $sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Fri Dec 6 12:51:17 2019
Copyright (c) 1982, 2014, Oracle.  All rights reserved.
ERROR:
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 30: Read-only file system
Additional information: 9925
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 30: Read-only file system
Additional information: 9925

 Solution:

Just the other day, I tried to connect to my test database server as SYSDBA. And I hit the following error. The server which runs on VMware in some case when run this df -h command then not seeing the file system it's just showing as below. Contact system administrator.
$ df -h
Filesystem Size Used Avail Use% Mounted on

 But in my case all mount point showing properly so we have simply reboot the system.