Re: AW: not able to connect to the database
- From: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
- To: drumilnarayan@xxxxxxxxx
- Date: Sat, 29 Nov 2008 10:10:54 +0100
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/>
>
Other related posts:
