Search This Blog

Saturday, November 23, 2019

IMPDP Command Error - ORA-39213: Metadata processing is not available: ORACLE


Connect as SYS Schema

SQL> conn sys@<DB> / as sysdba
Then execute below commands:


SQL> execute sys.dbms_metadata_util.load_stylesheets;

REP-51019: System user authentication is missing : ORACLE



 Make change file rwservlet.properties from

C:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\config\fmwconfig\servers\WLS_REPORTS\applications\reports_12.2.1\configuration\rwservlet.properties

   <singlesignon>no</singlesignon>

   TO

 <singlesignon>yes</singlesignon>


Add below line
<webcommandaccess>L2</webcommandaccess>


In rwserver.conf file, from

C:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\config\fmwconfig\servers\WLS_REPORTS\applications\reports_12.2.1\configuration\rwserver.conf

Change 

<job jobType="report" engineId="rwEng" securityId="rwJaznSec"/>
to
<job jobType="report" engineId="rwEng"/>

And

Comment the line below from
<security id="rwJaznSec" class="oracle.reports.server.RWJAZNSecurity"/> to <!--security id="rwJaznSec" class="oracle.reports.server.RWJAZNSecurity"/-->

Now, stop report server as Administrator and Start it again as Administrator

Thursday, November 7, 2019

Oracle :REP-52266: The in-process Reports Server rep_user failed to start.oracle.reports.RWException: IDL:oracle/reports/RWException:1.0



 Here is the solution I got :

  1. Search the file rwnetwork.conf
  2. Change the lines
From
<multicast channel="228.5.6.7" port="14021" timeout="1000" retry="5"/>
<!--namingService name="Cos" host="127.0.0.1" port="14021"/-->
To
<!--multicast channel="228.5.6.7" port="14021" timeout="1000" retry="5"/-->
<namingService name="Cos" host="127.0.0.1" port="14021"/>