If you are able to connect as sys, and query v$session, but not v$lock this may be some library cache issue. Try this: sqlplus / as sysdba alter session set tracefile_identifier='FOO'; alter session set events '10046 trace name context forever, level 12'; select * from v$lock; Then, let that session sit there and wait for a couple moments - a minute or two, and look in user_dump_dest for a file with FOO in its name. What's the WAIT lines that you see in there ? Stefan ========================= Stefan P Knecht Senior Consultant Systems Engineering OPITZ CONSULTING Schweiz GmbH Seestrasse 97 CH-8800 Thalwil Mobile +41-79-571 36 27 stefan.knecht@xxxxxxxxxxxxxxxxxxx http://www.opitz-consulting.ch OCP 9i/10g SCSA SCNA ========================= On Wed, Nov 26, 2008 at 2:12 PM, drumil narayan <drumilnarayan@xxxxxxxxx>wrote: > yes able to connect to database locally as sys user on server. > confusing is with sys user am not able to query from v$lock and can query > from v#session > not able to connect from sql client. > > ------------------------------ > *From:* "Jan-Hendrik.Boll@xxxxxxxxxxx" <Jan-Hendrik.Boll@xxxxxxxxxxx> > *To:* oracle-l@xxxxxxxxxxxxx > *Sent:* Wednesday, 26 November, 2008 6:19:38 PM > *Subject:* AW: not able to connect to the database > > do you use login-triggers? > can you log into the database locally? (via sqlplus "/As sysdba") > ------------------------------ > *Von:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] > *Im Auftrag von *drumil narayan > *Gesendet:* Mittwoch, 26. November 2008 13:46 > *An:* david.barbour1@xxxxxxxxx > *Cc:* Bort, Guillermo; oracle-l@xxxxxxxxxxxxx > *Betreff:* Re: not able to connect to the database > > yes, space is available, tnsping is resolving proprely.. > > ------------------------------ > *From:* David Barbour <david.barbour1@xxxxxxxxx> > *To:* drumilnarayan@xxxxxxxxx > *Cc:* "Bort, Guillermo" <guillermo.bort@xxxxxxx>; oracle-l@xxxxxxxxxxxxx > *Sent:* Wednesday, 26 November, 2008 5:59:31 PM > *Subject:* Re: not able to connect to the database > > Oh yeah - just because sufficient space is available on the disks > (depending on your Operating System - it'd help to have that info) that > doesn't mean a filesystem hasn't filled up. > > On Wed, Nov 26, 2008 at 7:17 AM, drumil narayan > <drumilnarayan@xxxxxxxxx>wrote: > >> suffcient space is available on all the disks. it is not giving any >> errors, just stops where it is.. >> >> ------------------------------ >> *From:* "Bort, Guillermo" <guillermo.bort@xxxxxxx> >> *To:* drumilnarayan@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx >> *Sent:* Wednesday, 26 November, 2008 5:46:32 PM >> *Subject:* RE: not able to connect to the database >> >> What error do you get when trying to connect? Have you checked archive >> space? >> >> >> >> *Guillermo Alan Bort* >> >> DBA / DBA Main Team >> >> >> >> *EDS*, an HP company >> >> ITO >> >> Arias 1851 >> >> Ciudad Autonoma de Buenos Aires (C1429DXC) >> >> Argentina >> >> >> >> Tel: +54 11 4704-3132 >> >> E-mail: guillermo.bort@xxxxxxx <name.name@xxxxxxx> >> >> >> >> We deliver on our commitments >> >> so you can deliver on yours. >> >> >> >> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto: >> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *drumil narayan >> *Sent:* Wednesday, November 26, 2008 10:13 AM >> *To:* oracle-l@xxxxxxxxxxxxx >> *Subject:* not able to connect to the database >> >> >> >> am not able to connect to our production server, two nod rac. >> >> in oem it is showing metric collection error. in alert logs there are no >> errors. dumps or core have no been generated at other dump destinations. >> >> other sys none of the user is getting connected >> >> >> >> what could be the issue...this is critical production system >> >> >> >> thanks >> >> >> >> >> >> ------------------------------ >> >> Be the first one to try the new Messenger 9 Beta! Click >> here.<http://in.rd.yahoo.com/tagline_messenger_7/*http:/in.messenger.yahoo.com/win/> >> >> ------------------------------ >> Add more friends to your messenger and enjoy! Invite them >> now.<http://in.rd.yahoo.com/tagline_messenger_6/*http://messenger.yahoo.com/invite/> >> > > > ------------------------------ > Get perfect Email ID for your Resume. Get before others > grab.<http://in.rd.yahoo.com/tagline_dbid_13/*http://in.promos.yahoo.com/address> > > ------------------------------ > Add more friends to your messenger and enjoy! Invite them > now.<http://in.rd.yahoo.com/tagline_messenger_6/*http://messenger.yahoo.com/invite/> >