There's no error at all...the prompt just sits there. However if I kill the process then I get a message saying DBMS_APPLICATION_INFO is inaccessible. I ran the pupbld.sql to recreate but the same continues. I queried the DBA_DDL_LOCKS table and cleared all the locks using the DBMSLOCK.sql script and bounced the instance. I also checked the login triggers if any and there arent any. Nothing has helped so far. Thanks and have a good day. Shreeni (630) 401-2887 (Mobile) (630) 837-1730 (Home) _____ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Baumgartel, Paul Sent: Thursday, October 05, 2006 5:41 PM To: 'shreeni@xxxxxxxxxxxxx'; oracle-l@xxxxxxxxxxxxx Subject: RE: Urgent help - SOS !!! One possibility: Is there a database login trigger that's failing? If so, no one can log in except those who have ADMINISTER DATABASE TRIGGER system privilege. Paul Baumgartel CREDIT SUISSE Information Technology DBA & Admin - NY, KIGA 1 11 Madison Avenue New York, NY 10010 USA Phone 212.538.1143 paul.baumgartel@xxxxxxxxxxxxxxxxx www.credit-suisse.com -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Shreeni Sent: Thursday, October 05, 2006 6:37 PM To: oracle-l@xxxxxxxxxxxxx Subject: Urgent help - SOS !!! On a development database instance 10gR2 on Solaris 10, all of a sudden no one can login except SYS or SYSTEM. However if I grant SYSDBA to SCOTT he can login. If I revoke the grant and make SCOTT a normal user then the connect as Scott/Tiger just hangs. There is nothing in Alert log or Udump trace files. I checked if somehow the instance had gone into restricted mode but it is not. I shut the database down and restarted but no help. It is not in archivelog mode. I checked the space on the server and it is ok. There are 4 other instances on the same box and they are fine. Do you guys have seen anything like this and can u give me any directions as where to start looking ? The Database is 10.2.0.1 on Solaris SunFire V240 Thanks and have a good day. Shreeni (630) 401-2887 (Mobile) (630) 837-1730 (Home) ============================================================================ == Please access the attached hyperlink for an important electronic communications disclaimer: http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html ============================================================================ ==