On Dec 14, 1:55 pm, "mtn_bik..._at_msn.com" <mtn_bik..._at_msn.com> wrote:
> Hi,
>
> My database 8i works very well but after few moments users are not
> able to login to the database.
>
> If I use SQLPLUSW to test a connection, it works well for user SYS as
> SYSDBA but the rest of user cannot connect to the same database.
> SQLPLUSW.EXE are going to "not responding".
>
> If I try to shutdown the database, the database was unable to shut
> down correctly. It stay in shutdown pending. (I use the shutdown
> immediate option.)
>
> No error message (ORA-???), no alert in SIDALRT.LOG...
>
> Someone have ideas?
>
> Thanks.
check the listener.log
check the parameter "processes".
select count(1) from v$session;
select count(1) from v$process where addr>'00';
Received on Fri Dec 14 2007 - 13:57:13 CST
