some times i am not able to connect to my database via sqlplus.
after entering this command, we don't receive any response. please help.
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jan 23 11:11:36 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: /as sysdba
Set sufficient value of processes/sessions in init/spfile of database , might be session limit of DB is getting exceeded & restricting new connection.
Check alert log & below query o/p , CURRENT_UTILIZATION < MAX_UTILIZATION to get connection to DB
select * from v$resource_limit;
Also , try to connect as sqlplus prelim & do hang analyze , refer below link