Re: AW: not able to connect to the database

tail the listener.log (if on unix) or read it on windows to determine if there are any sqlnet messages being logged.

On Wed, Nov 26, 2008 at 1:12 PM, drumil narayan <drumilnarayan_at_yahoo.com>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_at_dataport.de" <Jan-Hendrik.Boll_at_dataport.de>
> *To:* oracle-l_at_freelists.org
> *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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> *Im Auftrag von *drumil narayan
> *Gesendet:* Mittwoch, 26. November 2008 13:46
> *An:* david.barbour1_at_gmail.com
> *Cc:* Bort, Guillermo; oracle-l_at_freelists.org
> *Betreff:* Re: not able to connect to the database
>
> yes, space is available, tnsping is resolving proprely..
>
> ------------------------------
> *From:* David Barbour <david.barbour1_at_gmail.com>
> *To:* drumilnarayan_at_yahoo.com
> *Cc:* "Bort, Guillermo" <guillermo.bort_at_eds.com>; oracle-l_at_freelists.org
> *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_at_yahoo.com>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_at_eds.com>
>> *To:* drumilnarayan_at_yahoo.com; oracle-l_at_freelists.org
>> *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_at_eds.com <name.name_at_eds.com>
>>
>>
>>
>> We deliver on our commitments
>>
>> so you can deliver on yours.
>>
>>
>>
>> *From:* oracle-l-bounce_at_freelists.org [mailto:
>> oracle-l-bounce_at_freelists.org] *On Behalf Of *drumil narayan
>> *Sent:* Wednesday, November 26, 2008 10:13 AM
>> *To:* oracle-l_at_freelists.org
>> *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/>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l