Configuring a Reports Server in Oracle WebLogic Forms & Reports 12.2.1

Configuring a Reports Server in Oracle WebLogic Forms & Reports 12.2.1 


Step 1 - Execure the wlst.sh script


[weblogic@testserver-k app]$ cd /u01/app/oracle/product/12.2.1/oracle_common/common/bin/
[weblogic@testserver-k bin]$ ./wlst.sh

Step 2 - Connect using the correct credentials and execute the following commands.


wls:/offline> connect ("weblogic","<weblogic_pwd>","<hostname>:7001")
wls:/frsdomain/serverConfig/> createReportsServerInstance(instanceName='repserver1',machine='AdminServerMachine')

Step 3 - Configure the reports server instance created.


[weblogic@testserver-k app]$ vi $DOMAIN_HOME/config/fmwconfig/servers/WLS_REPORTS/applications/reports_12.2.1/configuration/rwservlet.properties

<?xml version="1.0" encoding="UTF-8"?>
<rwservlet xmlns="http://xmlns.oracle.com/reports/rwservlet/" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<server>repserver1</server> #Instance name you used above
<singlesignon>no</singlesignon>
<inprocess>yes</inprocess>
<webcommandaccess>L2</webcommandaccess>
</rwservlet>

[weblogic@testserver-k u01]$ cd $DOMAIN_HOME/reports/bin

If you cannot locate the reports directory within the DOMAIN_HOME try starting the reports server using the below command:

[weblogic@testserver-k u01]$ cd $DOMAIN_HOME/bin

[weblogic@testserver-k u01]$ ./startComponent.sh repserver1

Then check again to see whether the reports directory is present within the DOMAIN_HOME.

[weblogic@testserver-k bin]$ vi reports.sh

FROM:

## setting for Reports Runtime
RW=${ORACLE_HOME}/reports; export RW
REPORTS_PATH=${ORACLE_HOME}/reports/templates:${ORACLE_HOME}/reports/samples/demo:${ORACLE_HOME}/reports/printers:${DOMAIN_HOME}/reports/fonts:${REPORTS_PATH}; export REPORTS_PATH

TO:

## setting for Reports Runtime
RW=${ORACLE_HOME}/reports; export RW
#REPORTS_PATH=${ORACLE_HOME}/reports/templates:${ORACLE_HOME}/reports/samples/demo:${ORACLE_HOME}/reports/printers:${DOMAIN_HOME}/reports/fonts:${REPORTS_PATH}; export REPORTS_PATH
REPORTS_PATH=/u01/SOURCES/LIVE/CLASSIC/REPORTS; export REPORTS_PATH

Step 4 - Edit the rwserver.conf file and add the report paths


[weblogic@testserver-k u01]$ cd $DOMAIN_HOME/config/fmwconfig/servers/CLASSIC_REPORTS/applications/reports_12.2.1/configuration

[weblogic@testserver-k configuration]$ vi rwserver.conf

<engine id="rwEng" class="oracle.reports.engine.EngineImpl" maxEngine="5" minEngine="1" engLife="50" >
      <property name="sourceDir" value="path/to/the/location/of/the/reports"/>
      <property name="tempDir" value="/u01/tmp_rep_classic"/>
      <!--property name="keepConnection" value="yes"/-->
   </engine>
   <engine id="rwURLEng" class="oracle.reports.urlengine.URLEngineImpl" maxEngine="1" minEngine="0" engLife="50" />

Step 5 - Add correct entries to the tnsnames.ora file located at the following directory


[weblogic@testserver-k FORMS]$ cd /u01/app/oracle/product/12.2.1/user_projects/domains/classic_new_domain/config/fmwconfig

[weblogic@testserver-k fmwconfig]$ vi tnsnames.ora

<tns-alias> =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = <ip-address>)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = <service-name>)
    )
  )


Comments

Post a Comment

Popular posts from this blog

Installing Oracle Database 19c on Linux 8 (OL8) Server

Image
Installing Oracle Database 19c on Linux 8 (OL8) Server Step 1 - Install the Relevant Software Install the Oracle Database 19c Enterprise Edition 19.3.0.0.0 from Oracle Software Delivery Cloud or any other method you prefer. (If your server has an internet connection you can use the wget method to install the software) As a best practice create a separate directory named 'SOFTWARES' where you can move installation files. Step 2 - Add the following lines to the ' /etc/sysctl.conf ' file as root user. fs.file-max = 6815744 kernel.sem = 250 32000 100 128 kernel.shmmni = 4096 kernel.shmall = 1073741824 kernel.shmmax = 4398046511104 kernel.panic_on_oops = 1 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 net.ipv4.conf.all.rp_filter = 2 net.ipv4.conf.default.rp_filter = 2 fs.aio-max-nr = 1048576 net.ipv4.ip_local_port_range = 9000 65500 Step 3 - Add the following lines to a file called ' etc/security/lim...
Read more

Solution for [INS-08101] Unexpected error while executing the action at state: ‘supportedOSCheck'

This error occurs when running an installation wizard in Oracle Linux 8.1 (OL8.1) servers. Edit file ' ORACLE_HOME/cv/admin/cvu_config ' and add a new line ' CV_ASSUME_DISTID=OEL8.1 ', followed by saving the file. [oracle@testserver-k ~]$ vi $ORACLE_HOME/cv/admin/cvu_config #CV_ASSUME_DISTID=OEL5 CV_ASSUME_DISTID=OEL8.1 [oracle@testserver-k ~]$  cat $ORACLE_HOME/cv/admin/cvu_config | grep -i CV_ASSUME_DISTID #CV_ASSUME_DISTID=OEL5 CV_ASSUME_DISTID=OEL8.1 Re-run the installer.
Read more

Graphical Display Not Appearing when Running Install Wizards - Linux

Graphical Display Not Appearing when Running Install Wizards 1. Use MobaXterm which has X display built in to it. 2. Check whether the X11Forwarding parameter is set to yes in the ' sshd_config ' file and restart it. [root@testserver-k ~]# vi /etc/ssh/sshd_config X11Forwarding yes [root@testserver-k ~]# systemctl restart sshd 3. Install the following dependencies. [root@testserver-k ~]# yum install xorg* [root@testserver-k ~]# yum install xclock (We can use xclock to verify if the graphical display works before executing the wizard) 4. Connect to the server directly through the user that is running the wizard not using 'sudo su -' or 'su -' 5. Export the display variable [oracle@testserver-k ~]$ export DISPLAY = :10 6. If the following error occurs do the below mentioned steps: [oracle@testserver-k ~]$ xclock MoTTY X11 proxy: No authorisation provided Error: Can't open display: localhost:10.0 Execute the following command and find a valid port for the displa...
Read more