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_at_sbcglobal.net> 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_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-l