ORA-12516 -> check lsnrctl status and services to make sure the instances are registered..
lsnrctl status;
lsnrctl services;
Make sure the service you want to connect (for exampla PROD1) is not a blocked state (state:blocked)
ORA-12520 -> Process limit reached.
Check the process values with the following sql;
select * from v$resource_limit where resource_name in ('processes','sessions');
For RAC.
Check lsnrctl services , and lsnrctl status and also check process limit..
If found any problems in service registration, check local listener of the rac nodes.(sqlplus > show parameter local_listener)
Local listener should be set to vip addresses..
For instance 1 Local_listener Should be like;
local_listener string (ADDRESS=(PROTOCOL=tcp)(HOST=erm1-vip)(PORT=1521))
lsnrctl status;
lsnrctl services;
Make sure the service you want to connect (for exampla PROD1) is not a blocked state (state:blocked)
ORA-12520 -> Process limit reached.
Check the process values with the following sql;
select * from v$resource_limit where resource_name in ('processes','sessions');
For RAC.
Check lsnrctl services , and lsnrctl status and also check process limit..
If found any problems in service registration, check local listener of the rac nodes.(sqlplus > show parameter local_listener)
Local listener should be set to vip addresses..
For instance 1 Local_listener Should be like;
local_listener string (ADDRESS=(PROTOCOL=tcp)(HOST=erm1-vip)(PORT=1521))
No comments :
Post a Comment
If you will ask a question, please don't comment here..
For your questions, please create an issue into my forum.
Forum Link: http://ermanarslan.blogspot.com.tr/p/forum.html
Register and create an issue in the related category.
I will support you from there.