1 Reply Latest reply: Apr 17, 2012 8:04 AM by Csoto-Oracle RSS

    REP-0178: Reports Server RptSvr_SINS00018174_asinst_1 cannot establish conn

    fred alvaera
      REP-0178: Reports Server RptSvr_SINS00018174_asinst_1 cannot establish connection.

      I installed Oracle Enterprise Manager 11g Version 11.1.1.5.0 with Reports Server. I am able to generate the report using the URL but when I issue a rwclient command, I get this error.

      Please help.
        • 1. Re: REP-0178: Reports Server RptSvr_SINS00018174_asinst_1 cannot establish conn
          Csoto-Oracle
          Hi Fred,

          This problem may occur when a wrong rwclient is picked. Perhaps the environment is not set appropriately before rwclient is called or the rwclient.bat/rwclient.sh in <oracle_home>/bin is found and used, but it is only a template that upon install allowed to create the valid rwclient.bat/rwclient.sh in the <oracle_instance>/config/reports/bin (in fact when the instance was actually configured).

          Try using the appropriate rwclient.bat/rwclient.sh as it calls rwclient.exe/rwclient after setting the environment. Either set in the PATH the directory <oracle_instance>/config/reports/bin before <oracle_home>/bin or specify the full path to rwclient.bat/rwclient.sh.


          Another possibility can be that the services were started as root and therefore some log files have been created with the user root. Hence there is no more write access to theses log files for the basic Oracle user (which is the owner of the installation) :
          $INSTANCE_HOME/diagnostics/logs/OHS/ohs1/access_log
          $INSTANCE_HOME/diagnostics/logs/ReportsToolsComponent/ReportsTools/runtime_diagnostic.log
          $INSTANCE_HOME/diagnostics/logs/ReportsToolsComponent/ReportsTools/zrclient_diagnostic.log

          If that's the case, then try to change the owner of the following log files to ORACLE user (which is the owner of the installation):
          $INSTANCE_HOME/diagnostics/logs/OHS/ohs1/access_log
          $INSTANCE_HOME/diagnostics/logs/ReportsToolsComponent/ReportsTools/runtime_diagnostic.log
          $INSTANCE_HOME/diagnostics/logs/ReportsToolsComponent/ReportsTools/zrclient_diagnostic.log
          And then restart the report server and run again the rwclient.sh command to generate the reports.


          Hope this helps.

          Thanks,
          Cris