{"id":2833,"date":"2012-10-08T11:18:59","date_gmt":"2012-10-08T15:18:59","guid":{"rendered":"https:\/\/pitss.org\/us\/2012\/10\/08\/how-to-add-custom-report-server-using-opmn\/"},"modified":"2017-05-16T14:42:00","modified_gmt":"2017-05-16T18:42:00","slug":"how-to-add-custom-report-server-using-opmn","status":"publish","type":"post","link":"https:\/\/pitss.org\/us\/2012\/10\/08\/how-to-add-custom-report-server-using-opmn\/","title":{"rendered":"How to add custom report server using OPMN"},"content":{"rendered":"

For running reports, if you need to create a new standalone report server, you can do so by the following steps:<\/p>\n

    \n
  1. Go to %ORACLE_INSTANCE%\\bin ($ORACLE_INSTANCE\/bin in Unix)<\/li>\n
  2. Type in “opmnctl status” to see if opmn is running. If not, run “opmnctl startall”.<\/li>\n
  3. Type in the following to create a new standalone reports server: opmnctl createcomponent -adminUsername weblogic -adminHost full_computer_hostname -adminPort 7001 -oracleHome C:\\Oracle\\Middleware\\as_1 -oracleInstance C:\\Oracle\\Middleware\\asinst_1 -instanceName asinst_1 -componentName name_of_report_server -componentType ReportsServerComponent<\/em><\/li>\n
  4. Start the server “opmnctl startproc ias-component=name_of_report_server”
    \nExample: opmnctl createcomponent -adminUsername weblogic -adminHost PITSS_PC -adminPort 7001 -oracleHome C:\\Oracle\\Middleware\\as_1 -oracleInstance C:\\Oracle\\Middlewar\\easinst_1 -instanceName asinst_1 -componentName RptSvr_ReportServer -componentType ReportsServerComponent<\/li>\n<\/ol>\n

    NOTE: If you want your forms to communicate with the report server you just created, you will need to either update the APP_RS or RSERV parameters in the env files for your application or modify the hard-coded paths embedded in each form which calls a report. To get the new standalone reports server to work, you do not need to restart WLS_REPORTS.<\/p>\n

    NOTE: By default, the reports server engine settings are not sufficient to run reports in production. It is strongly recommended to fine-tune your reports server engines. More information can be found at https:\/\/pitss.org\/us\/2012\/10\/09\/recommended-reports-engine-settings\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

    For running reports, if you need to create a new standalone report server, you can do so by the following steps: Go to %ORACLE_INSTANCE%\\bin ($ORACLE_INSTANCE\/bin in Unix) Type in “opmnctl status” to see if opmn is running. If not, run “opmnctl startall”. Type in the following to create a new standalone reports server: opmnctl createcomponent […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[4,36],"tags":[11,16,23,13,37,40],"class_list":["post-2833","post","type-post","status-publish","format-standard","hentry","category-install-config","category-reports","tag-11g","tag-11gr2","tag-forms","tag-installation-setup","tag-reports","tag-weblogic"],"_links":{"self":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/2833","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/comments?post=2833"}],"version-history":[{"count":2,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/2833\/revisions"}],"predecessor-version":[{"id":8555,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/2833\/revisions\/8555"}],"wp:attachment":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/media?parent=2833"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/categories?post=2833"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/tags?post=2833"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}