Re: AW: not able to connect to the database

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_at_opitz-consulting.ch
http://www.opitz-consulting.ch

OCP 9i/10g SCSA SCNA

On Wed, Nov 26, 2008 at 2: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/>
>

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