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