Oracle : ORA-00020: maximum number of processes (150) exceeded

 

ORA-00020: maximum number of processes (150) exceeded

To resolve this error , please follow below steps:

$ sqlplus -prelim "/as sysdba"

   SQL> Conn sys as sysdba

 SQL> shutdown abort

 ORACLE instance shut down.

 SQL> exit

 Disconnected from ORACLE

After this point the database could once again be restarted:

sqlplus / as sysdba

Then run below commands:

sql> alter system set processes=500 scope=spfile;

sql> alter system set sessions=555 scope=spfile;

sql> alter system set transactions=610 scope=spfile;

sql> shutdown abort

sql> startup

Create view in SQL server for Binary duplicate check : Sqlserver

 

create   view vw_duplicate_face as

Select Photo, COUNT(EmployeeCode) as aa,

  min (EmployeeCode) AS EmployeeCode_min ,

  max (EmployeeCode) AS EmployeeCode_max

  from 

(

select [EmployeeCode], 

                     cast(cast([HDCPInfo] as varbinary(max)) 

                      as varchar(max)) 

  as Photo

from   [HWATT].[dbo].[KQZ_Employee]

)a

Group By Photo

Having COUNT(EmployeeCode)>1

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