ORACLE: UDE-00010: multiple job modes requested, schema and tables.

 Here , When you use below import command,

impdp userid=schema/pass@db statistics=none full=N schemas=(schema_name)  tables=TEST_TABLEdirectory=TEST_DIR dumpfile=SCHEMA_BACKUP.DMP logfile=SCHEMA_BACKUP.log

You will be shown error as 

UDE-00010: multiple job modes requested, schema and tables.

Solution with Example: Use only one parameter like SCHEMAS or TABLES.

When Parameter file are like ..

SCHEMAS=schema_name
DIRECTORY=TEST_DIR
DUMPFILE=SCHEMA_BACKUP.dmp
LOGFILE=SCHEMA_BACKUP.log
TABLES=TEST_TABLE1,TEST_TABLE2


So, full command will be like 

impdp userid=schema/pass@db statistics=none full=N   tables=TEST_TABLEdirectory=TEST_DIR dumpfile=SCHEMA_BACKUP.DMP logfile=SCHEMA_BACKUP.log

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

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"/>

SQLSERVER : Passed to log scan in database 'model' is not valid

ERROR :  The log scan number (85:368:1) passed to log scan in database 'model' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during start up.

I have done just to solve this:

Step-1: Go to this path C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Binn\Templates

Step-2: Copy and paste the database/file named model.mdf and modellog.ldf to this path C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA

Now, service will be started !!! 

Remove Special Character using REGEXP_REPLACE : ORACLE

Example  :

REGEXP_REPLACE(style_ref_no, '[]~!@#$%^&*()_+=\{}[:”;’<,>./?]+', '')

MSSQL: RESTORE DB USING master User

Alter Database <YOUR DB>
  SET SINGLE_USER With ROLLBACK IMMEDIATE
 
 
RESTORE DATABASE <YOUR DB>
  FROM DISK = 'D:\BACKUP_DB\FR_17.04.2019 morning'

Oracle : ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr]

      SQL> startup mount
      SQL> alter database recover; //recover database;
      SQL> alter database open;

Comma separated value to ROWS in ORACLE SQL

SELECT t.id,
       v.COLUMN_VALUE AS value,
       ROW_NUMBER() OVER ( PARTITION BY id ORDER BY ROWNUM ) AS lvl
    FROM   prod_resource_mst t,
       TABLE(
         CAST(
           MULTISET(
             SELECT TRIM( REGEXP_SUBSTR( t.line_number, '[^,]+', 1, LEVEL ) )
             FROM   DUAL
             CONNECT BY LEVEL <= REGEXP_COUNT( t.line_number, '[^,]+' )
           )
           AS SYS.ODCIVARCHAR2LIST
         )
       ) v  where id=51