Re: Urgent help - SOS !!!

How exactly did that message look that told you dbms_application_info was
"inaccessible" ?

Did you mean you ran utlrp.sql or actually pupbld.sql ?

Utlrp will recompile invalid objects, while pupbld will build the sql*plus
product user profile tables - should be run in SYSTEM schema.

Stefan

On 10/6/06, Shreeni <shreeni@xxxxxxxxxxxxx> wrote: 

 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 DBMS
LOCK.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
==============================================================================


Other related posts: