Search This Blog

Wednesday, June 27, 2007

Manage Oracle Report Server ( 10.1.2.0.2 Windows)

The scenario , assume you have 2 report servers on host1 and host2 on windows 2003
To see he status of the application server , Login as remote desktop on Host[1..2], open a CMD terminal and
write the following command
opmnctl status


dcm-daemon | dcm-daemon | 3012 | Alive
HTTP_Server | HTTP_Server | 4660 | Alive
WebCache | WebCache | 1440 | Alive
WebCache | WebCacheAdmin | 2968 | Alive
OC4J | home | 1464 | Alive
OC4J | OC4J_BI_Forms | 4428 | Alive
OC4J | OC4J_BI_Forms | 2260 | Alive
reportServer2 | ReportsServer | 4720 | Alive

ALIVE for all the components

To see the status and availability of report servers ,open a CMD terminal and
write the following command

rwdiag -findall

Broadcast mechanism used to locate servers
------------------------------------------
Channel address = 228.5.6.7
Channel port = 14021

(1) Name = reportserver2 : Type = server : Host = host1.domain.local
(2) Name = reportserver1 : Type = server : Host = host2.domain.local


If the above is TRUE and some report server is not working open a CMD terminal and
write the following command ( The example below restart the reportServer2)
opmnctl stopproc ias-component=reportServer2 process-type=ReportsServer
opmnctl startproc ias-component=reportServer2 process-type=ReportsServer


To restart the application server components open a CMD terminal and write the following commands with the following order:
dcmctl stop
opmnctl stopall
dcmctl start
opmnctl startall

Verify if working

opmnctl status
rwdiag -findall

In order to see the reports' server job use the following URL for each server

http://host1.domain.local/reports/rwservlet/showjobs?server=reportServer2
http://host2.domain.local/reports/rwservlet/showjobs?server=reportServer1




*