Oracle 12c Report server configuration

Oracle 12c Report server configuration
=================================================================
step-1 [ Create report server Tools ]
connect wlst.cmd
C:\Oracle\Middleware\Oracle_Home\oracle_common\common\bin\wlst.cmd

connect(“weblogic”,”tiger123″,”HVD12C:7001″)
createReportsToolsInstance(instanceName=’reptools1′,machine=’AdminServerMachine’)
exit()


At this moment reports builder can be used:
C:\app\oracle\config\domains\frs\reports\bin\rwbuilder.bat
=================================================================
step-2 [ add report tools information to default env ]
open
C:\Oracle\Middleware\Oracle_Home\user_projects\domains\fr\config\fmwconfig\servers\WLS_FORMS\applications\formsapp_12.2.1\config\default.env
Add this at last of default.env
FORMS=C:\Oracle\Middleware\Oracle_Home\forms
COMPONENT_CONFIG_PATH=C:\Oracle\Middleware\Oracle_Home\user_projects\domains\fr\config\fmwconfig\components\ReportsToolsComponent\reptools1
FORMS_DATETIME_LOCAL_TZ=GMT
FORMS_DATETIME_SERVER_TZ=GMT

COMPONENT_CONFIG_PATH=/home/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/fr/config/fmwconfig/components/ReportsToolsComponent/reptools1
FORMS_DATETIME_LOCAL_TZ=GMT
FORMS_DATETIME_SERVER_TZ=GMT
=================================================================
step-3 [ Create Report Server Instance ]
ref – https://windows7bugs.wordpress.com/2016/01/13/oracle-12c-forms-reports-configure-for-deployments/

connect wlst.cmd
C:\Oracle\Middleware\Oracle_Home\oracle_common\common\bin\wlst.cmd
connect(“weblogic”,”tiger123″,”HVD12C:7001″)

createReportsServerInstance(instanceName=’Rs215_1′,machine=’AdminServerMachine’)
createReportsServerInstance(instanceName=’Rs215_2′,machine=’AdminServerMachine’)
exit()
=================================================================
Step-4 [ set nodeManager Password ]
console>fr domain>>security tab>general tab> advance —- set user name. password.
=================================================================
step-5 [ set nodeManager Properties ]
C:\Oracle\Middleware\Oracle_Home\user_projects\domains\fr\nodemanager\nodemanager.properties
ListenAddress=HVD12C
=================================================================
step-6 [ set driver>etc]
C:\Windows\System32\drivers\etc\hosts
127.0.0.1 localhost
192.168.10.227 HVD12C
restart computer
linux
[root@orlinux ReportsServerComponent]# cat /etc/hosts
# 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
# ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6

127.0.0.1 localhost localhost.localdomain
192.168.10.211 orlinux orlinux.localdomain
=================================================================
Step-5 [ startComponent ]
C:\Oracle\Middleware\Oracle_Home\user_projects\domains\fr\bin\startComponent.cmd Rs215_1
C:\Oracle\Middleware\Oracle_Home\user_projects\domains\fr\bin\startComponent.cmd Rs215_2
=================================================================
Step-5 [Disable Security]
C:\Oracle\Middleware\Oracle_Home\user_projects\domains\fr\config\fmwconfig\components\ReportsServerComponent\Rs215_1\rwserver.conf
C:\Oracle\Middleware\Oracle_Home\user_projects\domains\fr\config\fmwconfig\components\ReportsServerComponent\Rs215_2\rwserver.conf



open rwserver.conf

       ---change to-->
      
disable it
<!--  -->
Disable it
<!--


-->


 



=================================================================
call a report

DECLARE
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status varchar2(20);
vjob_id VARCHAR2(100) :='';
v_rep_server varchar2(1000) := '';
v_url varchar2(1000) := '';
pl_id ParamList;
pl_name VARCHAR2(10) := 'CPL';
v_REPORT_DESNAME varchar2(2000) := '';
BEGIN
pl_id := Get_Parameter_List(pl_name);
IF Id_Null(pl_id) THEN
null;
else
destroy_Parameter_List(pl_name);
END IF;

pl_id := Create_Parameter_List(pl_name);
v_rep_server := loc_pkg_public.report_server_mis;

Add_Parameter(pl_id,’P_COMPANYID’,TEXT_PARAMETER,:PARAMETER.COMPANYID);
Add_Parameter(pl_id,’P_SDATE’,TEXT_PARAMETER,TO_CHAR(:CTL.SDATE,’DD-MON-RR’));
Add_Parameter(pl_id,’P_EDATE’,TEXT_PARAMETER,TO_CHAR(:CTL.EDATE,’DD-MON-RR’));
Add_Parameter(pl_id,’P_ISDETAIL’,TEXT_PARAMETER,:ctl.ISDETAIL);

repid := find_report_object(‘RP’);
SET_REPORT_OBJECT_PROPERTY(repid, REPORT_FILENAME, :parameter.P_REP_FILE_JSP);
SET_REPORT_OBJECT_PROPERTY(repid, REPORT_EXECUTION_MODE, BATCH);
SET_REPORT_OBJECT_PROPERTY(repid, REPORT_COMM_MODE, ASYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(repid, REPORT_SERVER, v_rep_server);
SET_REPORT_OBJECT_PROPERTY(repid, REPORT_DESTYPE, cache);
SET_REPORT_OBJECT_PROPERTY(repid, REPORT_DESFORMAT, :CTL.REP_FORMAT);

SET_REPORT_OBJECT_PROPERTY(repid,REPORT_OTHER, ‘buffers=9999′); ——–addition

v_rep := RUN_REPORT_OBJECT(repid,pl_name);
rep_status := REPORT_OBJECT_STATUS(v_rep);

v_rep := RUN_REPORT_OBJECT(repid,pl_name);
rep_status := REPORT_OBJECT_STATUS(v_rep);

vjob_id := substr(v_rep, 6, length(v_rep));
vjob_id := substr(v_rep,instr(v_rep,’_’,-1)+1);

if rep_status in (‘RUNNING’, ‘OPENING_REPORT’, ‘ENQUEUED’) then
WHILE TRUE LOOP
DBMS_LOCK.sleep(2);
IF REPORT_OBJECT_STATUS(v_rep) not in (‘RUNNING’, ‘OPENING_REPORT’, ‘ENQUEUED’) THEN
rep_status := REPORT_OBJECT_STATUS(v_rep);
EXIT;
END IF;
END LOOP;
end if;

if rep_status = ‘FINISHED’ then
message(‘Report Completed: ‘||get_report_object_property(repid, REPORT_FILENAME), no_acknowledge);
if :parameter.IS_PUBLIC_IP = ‘N’ then
WEB.SHOW_DOCUMENT(loc_pkg.local_REP_HTTP||’/reports/rwservlet/getjobid=’||ltrim(vjob_id,’_’)||’?server=’||v_rep_server,’_blank’);
else
WEB.SHOW_DOCUMENT(loc_pkg.public_REP_HTTP||’/reports/rwservlet/getjobid=’||ltrim(vjob_id,’_’)||’?server=’||v_rep_server,’_blank’);
end if;
else
message(‘Error Report: ‘||get_report_object_property(repid, REPORT_FILENAME), no_acknowledge);
end if;
EXCEPTION
WHEN OTHERS THEN
MESSAGE(‘Error ‘||get_report_object_property(repid, REPORT_FILENAME)||error_text||sqlerrm, no_acknowledge);
END;
=================================================================
step-6
C:\Oracle\Middleware\Oracle_Home\user_projects\domains\fr\config\fmwconfig\servers\WLS_REPORTS\applications\reports_12.2.1\configuration\rwservlet.properties
open rwservlet.properties
rep_wls_reports_winr
no
no
L2 —add this one
yes

C:\Oracle\Middleware\Oracle_Home\reports\conf\rwservlet.properties

=================================================================
step-7
Restart All (wls_reports, forms, everything)

=================================================================
Step-8
https://community.oracle.com/thread/3923456?start=15&tstart=0

1. Go to enterprise manager: http://localhost:7001/em
2. Click the Weblogic Domain menu item at the top left –> please specify here the weblogic domain memu name
3. Click Security from the menu
4. Click Application Roles from the submenu
5. Select Application Stripe = reports
6. Hit the Search button
7. Select RW_ADMINISTRATOR role from list queried
8. Click Edit
9. Click Add
10. Select Type = User from popup menu
11. Click Search to see users
12. Select your user account –> Which user account we have to select
13. Hit the OK button
14. Hit the OK button again
15. Restart WLS_REPORTS

=================================================================
step-9
check report server
http://192.168.10.179:7777/reports/rwservlet/getserverinfo?server=RptS12c2&authid=weblogic/tiger123
http://192.168.10.179:7777/reports/rwservlet/getserverinfo?server=RptS12c3&authid=weblogic/tiger123

=================================================================
step-10 — cgicmd.dat location
C:\Oracle\Middleware\Oracle_Home\user_projects\domains\fr\config\fmwconfig\servers\WLS_REPORTS\applications\reports_12.2.1\configuration\cgicmd.dat

Advertisements