Url for Test Report
http://localhost:9001/
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
)
