| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Urgent help - SOS !!!
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Baumgartel, Paul
Sent: Thursday, October 05, 2006 5:41 PM
To: 'shreeni_at_sbcglobal.net'; oracle-l_at_freelists.org
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_at_credit-suisse.com
www.credit-suisse.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On
Behalf Of Shreeni
Sent: Thursday, October 05, 2006 6:37 PM
To: oracle-l_at_freelists.org
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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 05 2006 - 17:53:51 CDT
 |
 |