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 <mailto: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.co m/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/addr ess>