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

Welcome back to HamidHelal blog.

Sorry for the long delay.

Today i encountered an error from client

ORA-12520: TNS:listener could not find available handler for requested type of server


when i tried to connect to database as admin, i got another error is


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


but there is a trick to connect

try,

C:\Users\Administrator>CD C:\app\Administrator\product\11.2.0\dbhome_1\BIN

C:\app\Administrator\product\11.2.0\dbhome_1\BIN>SQLPLUS /NOLOG

SQL*Plus: Release 11.2.0.4.0 Production on Tue Aug 20 00:38:14 2019

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

SQL> CONN /AS SYSDBA
ERROR:
ORA-00020: maximum number of processes (150) exceeded




C:\app\Administrator\product\11.2.0\dbhome_1\BIN>sqlplus -prelim "/ as sysdba"

SQL*Plus: Release 11.2.0.4.0 Production on Tue Aug 20 00:41:43 2019

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

SQL> SHUTDOWN ABORT
ORACLE instance shut down.
SQL> EXIT
Disconnected from ORACLE



C:\app\Administrator\product\11.2.0\dbhome_1\BIN>SQLPLUS / AS SYSDBA

SQL*Plus: Release 11.2.0.4.0 Production on Tue Aug 20 00:43:31 2019

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> STARTUP
ORACLE instance started.

Total System Global Area 1.0255E+10 bytes
Fixed Size                  2290120 bytes
Variable Size            1644170808 bytes
Database Buffers         8589934592 bytes
Redo Buffers               18817024 bytes
Database mounted.
Database opened.
SQL>

Part 1 || ORA-06512: at "SYS.UTL_HTTP", line 1130 ORA-24247: network access denied by access control list (ACL)

As salamualikum (islamic greetings), brothers and sisters. :)

  Hope you are well with the grace of Almighty Allah (swt)

If you confirm about creating Oracle Database ACL (Access Control List ) for 11g and higher,

and getting following error for calling a web service or web address, then this solution if for you.

Error

Error starting at line : 1 in command -
begin
PROC_URL_CALL;
end ;
Error report -
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1130
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "HR.PROC_URL_CALL", line 8
ORA-06512: at line 2
29273. 00000 -  "HTTP request failed"
*Cause:    The UTL_HTTP package failed to execute the HTTP request.
*Action:   Use get_detailed_sqlerrm to check the detailed error message.
           Fix the error and retry the HTTP request.

Where PROC_URL_CALL have the following code,

create or replace PROCEDURE PROC_URL_CALL AS

  l_url            VARCHAR2(500) := 'http://allieditbd.com';
  l_http_request   UTL_HTTP.req;
  l_http_response  UTL_HTTP.resp;
BEGIN
  -- Make a HTTP request and get the response.
  l_http_request  := UTL_HTTP.begin_request(l_url);
  l_http_response := UTL_HTTP.get_response(l_http_request);
  UTL_HTTP.end_response(l_http_response);
END;

and calling the procedure ,

begin
PROC_URL_CALL;
end ;

There is no error in the ACL creation, issue in the procedure where we set default value for url.

remove the http:// and add www.

Now the code will be

create or replace PROCEDURE PROC_URL_CALL AS

  l_url            VARCHAR2(500) := 'www.allieditbd.com';
  l_http_request   UTL_HTTP.req;
  l_http_response  UTL_HTTP.resp;
BEGIN
  -- Make a HTTP request and get the response.
  l_http_request  := UTL_HTTP.begin_request(l_url);
  l_http_response := UTL_HTTP.get_response(l_http_request);
  UTL_HTTP.end_response(l_http_response);
END;

Now run call the procedure

begin
PROC_URL_CALL;
end ;

and you will get

PL/SQL procedure successfully completed.

Thanks for reading the post and congratulation on your success.

How to fix all shortcuts (.lnk) back to open with default.

navigate to this key:

 HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.lnk >> just delete the keys highlighted in yellow as shown in the photo below. and log off and back on again.. there... should be all fixed ..Hope This Helps..

java.lang.Exception: Exception in sending Request :: null (When try to start Oracle Database Console), What to do ?

As salamualikum (islamic greetings), brothers and sisters. :)

 Huhh, Post again after a long time. I'm passing very busy time. Lot's of change around me.

Come to the topic.

When you start the "Oracle Enterprise Manager, Database Control" knows as "DB Console"
you may see the topic error like as

 then how you solve this problem / get rid of this problem ?

Don't worry, it's simple. Assuming your are using oracle Database 10gR2 in windows enviornment.

Follow the following steps and get everything working.. 

1. Open the Command prompt
2. write cd C:\oracle\product\10.2.0\db_1\bin
3. write set oracle_sid=<SID_NAME> for example ORCL
4. write emctl stop dbconsole

You will get,

Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2006 Oracle Corporation.  All rights reserved.
http://SERVER:1158/em/console/aboutApplication
The OracleDBConsoleTT service is stopping.....
The OracleDBConsoleTT service was stopped successfully.

 Now double click the My Computer and go to

1. C:\oracle\product\10.2.0\db_1\sysman\admin

look for file name: "supportedtzs.lst"

2. Open it and look for your timezone. For example Asia/Dacca

3. Now go to " C:\oracle\product\10.2.0\db_1\PC_NAME_<SID_NAME>\sysman\config "

look for file name: "emd.properties"

4. At the end of this file add:-

agentTZRegion=Asia/Dacca

 and comment out if any like

 #agentTZRegion=-05:00




5. write emctl start dbconsole


Now, you are done... 

Open browser and logged in Enterprise Manager using sys/password as sysdba.

Click on Pending Status and logged in again, Now you will successfully use Enterprise Manager. 


Comments to share your thoughts..


End for the day....

Praise to Almighty Allah(swt).  :)

Fi amanillah