Issue :-
Agent unable to identify state of the ASMDG resource. . The asm_diskstring parameter is not set correctly in the ASM initialization parameter file. (3)
Not able to connect to ASM
Agent unable to identify state of the ASMDG resource. . The asm_diskstring parameter is not set correctly in the ASM initialization parameter file. (3)
Not able to connect to ASM
oracle@server1$sqlplus "/ as sysdba"
SQL*Plus: Release 11.2.0.2.0 Production on Wed Sep 6 15:38:30
2017
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR:
ORA-00020: maximum number of processes (100) exceeded
Enter user-name:
Solution 1:
Step 1 :- If you try to connect to ASM then below error will pop up
oracle@server1$sqlplus "/ as sysdba"
SQL*Plus: Release 11.2.0.2.0 Production on Wed Sep 6 15:38:30 2017
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR:
ORA-00020: maximum number of processes (100) exceeded
Enter user-name:
Step 2 :- check ASM session
ps -ef | grep -i LOCAL=YES | grep -i asm
oracle 27154 9375 0 Jul 18 ? 0:00 oracle+ASM
(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 28021 9375 0 Jul 07 ? 0:00 oracle+ASM (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 5515 9375 0 Jul 08 ? 0:00 oracle+ASM (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 22722 9375 0 Jul 15 ? 0:00 oracle+ASM (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 927 9375 0 Sep 01 ? 0:00 oracle+ASM (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 7843 9375 0 Jul 19 ? 0:00 oracle+ASM (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 6962 9375 0 Jul 01 ? 0:00 oracle+ASM (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 17643 9375 0 Jul 18 ? 0:00 oracle+ASM (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 6163 9375 0 15:40:13 ? 0:00 oracle+ASM (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 27152 9375 0 Jul 18 ? 0:00 oracle+ASM (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 84 9375 0 Aug 13 ? 0:00 oracle+ASM (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 28021 9375 0 Jul 07 ? 0:00 oracle+ASM (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 5515 9375 0 Jul 08 ? 0:00 oracle+ASM (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 22722 9375 0 Jul 15 ? 0:00 oracle+ASM (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 927 9375 0 Sep 01 ? 0:00 oracle+ASM (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 7843 9375 0 Jul 19 ? 0:00 oracle+ASM (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 6962 9375 0 Jul 01 ? 0:00 oracle+ASM (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 17643 9375 0 Jul 18 ? 0:00 oracle+ASM (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 6163 9375 0 15:40:13 ? 0:00 oracle+ASM (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 27152 9375 0 Jul 18 ? 0:00 oracle+ASM (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 84 9375 0 Aug 13 ? 0:00 oracle+ASM (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
Step 3 :- you can try to reduce some session by removing Above old processes without impacting ASM
oracle@server1$ kill -9 27154 28021 5515
*********************************************************************************************************************
Solution 2:-
Perform below as planned activity with proper downtime
Increase
the Maximum Number of Processes in the Database with the SQL below :
1. Connect
database as sysdba user
SQL>
conn / as sysdba
2.
Increase maximum number of database process
SQL>
alter system set processes=250 scope=spfile; // set processes as per capacity of server/DB
3. Restart
DB to take effect.
4. Retest
the issue.
No comments:
Post a Comment