rasti.hil@hilandco.com +41 79 367-9677

Search This Blog

Oracle Reports 12.1 / 12.2 /19

Url for Test Report 


http://localhost:9001/reports/rwservlet?server=rpt01+report=blank_template.jsp+desformat=html+DESTYPE=cache



Start Stop Create Reports Server Instance 


cd %DOMAIN_HOME%\bin\

setUserOverridesLate.cmd

set WLS_USER=weblogic
set WLS_USER_PWD=welcome1
set WLS_URL=t3://weblogic:7001/
set DOMAIN_NAME=FRM_SH_Dx03
set DOMAIN_HOME=C:\\appl\\wls\\FRM_DOM
set NM_NAME=AdminServerMachine
set NM_URL=weblogic.host
set NM_PORT=5556
set RPT_PORT=9002
set RPT_HOST=weblogic.host
set REPORTSSERVER_LIST=RPT_01,RP_02

create_ReportsServerInstance.cmd

call %DOMAIN_HOME%\bin\setDomainEnv.cmd
cd C:\appl\wls\%DOMAIN_HOME%\bin\
@echo off
for %%a in ("%REPORTSSERVER_LIST:,=" "%") do (
    echo %%~a
set RPT_PREFIX=%%~a
    /opt/ora/frm/oracle_common/common/bin/wlst.cmd %DOMAIN_HOME%\bin\create_ReportsServerInstance.py
)

create_ReportsServerInstance.py

#!/opt/ora/product/frm/oracle_common/common/bin/wlst.sh
import os, sys
try:  
   os.environ["WLS_USER"]
except KeyError: 
   print "Please set the environment variable WLS_USER"
   sys.exit(1)


try:
   os.environ["WLS_USER_PWD"]
except KeyError:
   print "Please set the environment variable WLS_USER_PWD"
   sys.exit(1)

try:
   os.environ["WLS_URL"]
except KeyError:
   print "Please set the environment variable WLS_URL"
   sys.exit(1)

try:
   os.environ["DOMAIN_NAME"]
except KeyError:
   print "Please set the environment variable DOMAIN_NAME"
   sys.exit(1)

try:
   os.environ["NM_NAME"]
except KeyError:
   print "Please set the environment variable NM_NAME"
   sys.exit(1)

try:
   os.environ["RPT_PREFIX"]
except KeyError:
   print "Please set the environment variable RPT_PREFIX"
   sys.exit(1)

vWlsUser=os.environ['WLS_USER']
vWlsUserPWd=os.environ["WLS_USER_PWD"]
vWlsUrl=os.environ["WLS_URL"]
vInstanceName=os.environ["RPT_PREFIX"]
vMachine=os.environ["NM_NAME"]


connect(vWlsUser, vWlsUserPWd, vWlsUrl )
createReportsServerInstance(instanceName=vInstanceName,machine=vMachine)

delete_ReportsServerInstance.cmd

call %DOMAIN_HOME%\bin\setDomainEnv.cmd
cd %DOMAIN_HOME%\bin\
@echo off
for %%a in ("%REPORTSSERVER_LIST:,=" "%") do (
    echo %%~a
set RPT_PREFIX=%%~a
    /opt/ora/frm/oracle_common/common/bin/wlst.cmd %DOMAIN_HOME%\bin\delete_ReportsServerInstance.py
)

delete_ReportsServerInstance.py


#!/opt/ora/product/frm/oracle_common/common/bin/wlst.sh
import os, sys
try:  
   os.environ["WLS_USER"]
except KeyError: 
   print "Please set the environment variable WLS_USER"
   sys.exit(1)


try:
   os.environ["WLS_USER_PWD"]
except KeyError:
   print "Please set the environment variable WLS_USER_PWD"
   sys.exit(1)

try:
   os.environ["WLS_URL"]
except KeyError:
   print "Please set the environment variable WLS_URL"
   sys.exit(1)

try:
   os.environ["DOMAIN_NAME"]
except KeyError:
   print "Please set the environment variable DOMAIN_NAME"
   sys.exit(1)

try:
   os.environ["NM_NAME"]
except KeyError:
   print "Please set the environment variable NM_NAME"
   sys.exit(1)

try:
   os.environ["RPT_PREFIX"]
except KeyError:
   print "Please set the environment variable RPT_PREFIX"
   sys.exit(1)

vWlsUser=os.environ['WLS_USER']
vWlsUserPWd=os.environ["WLS_USER_PWD"]
vWlsUrl=os.environ["WLS_URL"]
vInstanceName=os.environ["RPT_PREFIX"]
vMachine=os.environ["NM_NAME"]


connect(vWlsUser, vWlsUserPWd, vWlsUrl )
deleteReportsServerInstance(instanceName=vInstanceName,machine=vMachine)

startReportsServerInstance.cmd

call %DOMAIN_HOME%\bin\setDomainEnv.cmd
cd %DOMAIN_HOME%\bin\
/opt/ora/frm/oracle_common/common/bin/wlst.cmd %DOMAIN_HOME%\bin\startReportsServerInstance.py

startReportsServerInstance.py


#!/opt/ora/product/frm/oracle_common/common/bin/wlst.sh
import os, sys
try:  
   os.environ["WLS_USER"]
except KeyError: 
   print "Please set the environment variable WLS_USER"
   sys.exit(1)


try:
   os.environ["WLS_USER_PWD"]
except KeyError:
   print "Please set the environment variable WLS_USER_PWD"
   sys.exit(1)

try:
   os.environ["WLS_URL"]
except KeyError:
   print "Please set the environment variable WLS_URL"
   sys.exit(1)

try:
   os.environ["DOMAIN_NAME"]
except KeyError:
   print "Please set the environment variable DOMAIN_NAME"
   sys.exit(1)
   
try:
   os.environ["NM_NAME"]
except KeyError:
   print "Please set the environment variable NM_NAME"
   sys.exit(1)


try:
   os.environ["NM_URL"]
except KeyError:
   print "Please set the environment variable NM_URL"
   sys.exit(1)
   
try:
   os.environ["NM_PORT"]
except KeyError:
   print "Please set the environment variable NM_PORT"
   sys.exit(1)

try:
   os.environ["DOMAIN_HOME"]
except KeyError:
   print "Please set the environment variable DOMAIN_HOME"
   sys.exit(1)

try:
   os.environ["REPORTSSERVER_LIST"]
except KeyError:
   print "Please set the environment variable REPORTSSERVER_LIST"
   sys.exit(1)
  
vWlsUser=os.environ['WLS_USER']
vWlsUserPWd=os.environ["WLS_USER_PWD"]
vWlsUrl=os.environ["WLS_URL"]
vMachine=os.environ["NM_NAME"]
vNmUrl=os.environ["NM_URL"]
vNmPort=os.environ["NM_PORT"]
vDomain=os.environ["DOMAIN_NAME"]
vDomainHome=os.environ["DOMAIN_HOME"]

nmConnect(vWlsUser, vWlsUserPWd, vNmUrl ,vNmPort,vDomain,vDomainHome,'ssl')
for i in os.environ.get("REPORTSSERVER_LIST").split(","):
    try:
nmStart(serverName=i,serverType='ReportsServerComponent')
    except:
pass

startReportsServerInstance.cmd

call %DOMAIN_HOME%\bin\setDomainEnv.cmd
cd %DOMAIN_HOME%\bin\
/opt/ora/frm/oracle_common/common/bin/wlst.cmd %DOMAIN_HOME%\bin\startReportsServerInstance.py

stopReportsServerInstance.py

 #!/opt/ora/product/frm/oracle_common/common/bin/wlst.sh
import os, sys
try:  
   os.environ["WLS_USER"]
except KeyError: 
   print "Please set the environment variable WLS_USER"
   sys.exit(1)


try:
   os.environ["WLS_USER_PWD"]
except KeyError:
   print "Please set the environment variable WLS_USER_PWD"
   sys.exit(1)

try:
   os.environ["WLS_URL"]
except KeyError:
   print "Please set the environment variable WLS_URL"
   sys.exit(1)

try:
   os.environ["DOMAIN_NAME"]
except KeyError:
   print "Please set the environment variable DOMAIN_NAME"
   sys.exit(1)
   
try:
   os.environ["NM_NAME"]
except KeyError:
   print "Please set the environment variable NM_NAME"
   sys.exit(1)


try:
   os.environ["NM_URL"]
except KeyError:
   print "Please set the environment variable NM_URL"
   sys.exit(1)
   
try:
   os.environ["NM_PORT"]
except KeyError:
   print "Please set the environment variable NM_PORT"
   sys.exit(1)

try:
   os.environ["DOMAIN_HOME"]
except KeyError:
   print "Please set the environment variable DOMAIN_HOME"
   sys.exit(1)

try:
   os.environ["REPORTSSERVER_LIST"]
except KeyError:
   print "Please set the environment variable REPORTSSERVER_LIST"
   sys.exit(1)
  
vWlsUser=os.environ['WLS_USER']
vWlsUserPWd=os.environ["WLS_USER_PWD"]
vWlsUrl=os.environ["WLS_URL"]
vMachine=os.environ["NM_NAME"]
vNmUrl=os.environ["NM_URL"]
vNmPort=os.environ["NM_PORT"]
vDomain=os.environ["DOMAIN_NAME"]
vDomainHome=os.environ["DOMAIN_HOME"]

nmConnect(vWlsUser, vWlsUserPWd, vNmUrl ,vNmPort,vDomain,vDomainHome,'ssl')
for i in os.environ.get("REPORTSSERVER_LIST").split(","):
    try:
nmKill(serverName=i,serverType='ReportsServerComponent')
    except:
pass



 

showenvReportsServer.cmd

call %DOMAIN_HOME%
cd %DOMAIN_HOME%\bin\
set URL=
@echo off
for %%a in ("%REPORTSSERVER_LIST:,=" "%") do (
call "C:\Program Files\Internet Explorer\iexplore.exe" http://%RPT_HOST%:%RPT_PORT%/reports/rwservlet/showenv?server=%%~a
call "C:\Program Files\Internet Explorer\iexplore.exe" http://%RPT_HOST%:%RPT_PORT%/reports/rwservlet?server=%%~a+report=blank_template.jsp+desformat=html+DESTYPE=cache
)