Oraclre 12C: Pluggable Database (PDB) Automatic Startup

Below trigger will be created after SYS login to Container database

CREATE OR REPLACE TRIGGER auto_open_pdb

  AFTER STARTUP ON DATABASE 

BEGIN 

   EXECUTE IMMEDIATE 'ALTER PLUGGABLE DATABASE ALL OPEN'; 

END auto_open_pdb

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, '[]~!@#$%^&*()_+=\{}[:”;’<,>./?]+', '')