up. I have the database backup. I am afraid
> however,
> that the problem is still floating around.
>
> Briefly, here is what occured:
>
> I restarted Oracle because our application was unable to
connect.
> I
> could connect through svrmgrl, but a 'select sysdate from
Or check whether u have a large pool too..reduce the large_pool_size
parameter.
Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email : [EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone : +44 (0) 115 - 95 76217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 60
at the problem is still floating around.
>
> Briefly, here is what occured:
>
> I restarted Oracle because our application was unable to connect.
> I
> could connect through svrmgrl, but a 'select sysdate from dual'
> just
> hung. So I brought the database down, and re
maybe a mild uptick in resource contention after adding a third
app server passed over some internal threshold?
-Original Message-
Sent: Monday, December 10, 2001 4:50 PM
To: Multiple recipients of list ORACLE-L
I discovered the trace file after restarting Oracle - so that
process ID i
I have the database backup. I am afraid
however,
that the problem is still floating around.
Briefly, here is what occured:
I restarted Oracle because our application was unable to connect.
I
could connect through svrmgrl, but a 'select sysdate from dual'
just
hung. So I brought the dat
ecause our application was unable to connect. I
could connect through svrmgrl, but a 'select sysdate from dual' just
hung. So I brought the database down, and recieved the memory
segment error.
So we were having problems while the database was up. Here is a
trace file dump that may be l
hung. So I brought the database down, and recieved the memory
segment error.
So we were having problems while the database was up. Here is a
trace file dump that may be linked to the problem:
PMON unable to acquire latch 80002060 modify parameter values
possible holder pid = 58 o
ipcs -a
ipcrm -
-Original Message-
Sent: Monday, December 10, 2001 3:27 PM
To: Multiple recipients of list ORACLE-L
Hi Jeff,
1. the previous killed instance that still holds a shared memory segment ?
2. unappropriatedly large parameters of shared_pool and/or db_block_buffers
?
Rega
Hi Jeff,
1. the previous killed instance that still holds a shared memory segment ?
2. unappropriatedly large parameters of shared_pool and/or db_block_buffers ?
Regards,
Ed
> ORA-27123: unable to attach to shared memory segment
> SVR4 Error: 12: Not enough space
>
> Any ideas?
--
Please se
There is not enough memory on the server to allocate the shared memory that
the init.ora requires. Make you shared_pool smaller and try again.
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, December 10, 2001 2:25 PM
> ORA-27123: un
I ran into this problem before.
oracle had crashed and we could not restart. So , If oracle is truely shut
down on that box do an
ipcs -m to show all active memory segments.
Find the ones owned by oracle and do an
ipcrm -M key
and remove the shared memory .
I did then , then the da
ORA-27123: unable to attach to shared memory segment
SVR4 Error: 12: Not enough space
Any ideas?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jeff Wiegard
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, Cali
Interesting stuff about 'fuzzy' SCN's and files.
A couple of notes on MetaLink with pertinent information:
22956.1
1015544.102
The second one has the added benefit of making clear why
your database should be shut down cleanly before taking a
cold backup.
Jared
On Friday 25 May 2001 07:46, J
Laura,
I fight this nearly every damn day. We constantly refresh several SAP
systems from production copies via EMC BCV's and TimeFinder. About half of
the time, I get the same error, where recovery was successful, but open
resetlogs would fail. It turns out, in my case, that no amount of r
Title: Another Database Down
Just
to put you a little more in the picture I have recovered a couple of DBs now
without archived redo log files etc where all hope had been lost and resumes
were being updated and got them back by fudging a couple of issues. (Oracle
would probably throw
Title: Another Database Down
From Metalink,
In Oracle releases before 7.3.3 on Unix it was possible for
two instances to mount the same database using different values for
ORACLE_SID when not running in Parallel Server mode. This could cause
database corruption as two independent
Title: Another Database Down
No, I
did not know about this. Could you explain or tell me where I can find
info on this?
Laura
-Original Message-From: Robertson Lee - lerobe
[mailto:[EMAIL PROTECTED]]Sent: Thursday, May 24, 2001 3:51
AMTo: Multiple recipients of list
ind
that rabbit in the hat.
Thank you in advance,
Laura
Another Database Down
Well, I think the time for jubilation has been
short-lived for me. The production database was recovered successfully due
to archiving and luck. I also have a small, inhouse, remedy (help desk)
database that I haven
Title: Another Database Down
Have
you tried removing/moving the lk file in the $ORACLE_HOME/dbs
directory ??
Lee
-Original
Message-From: Burton, Laura L.
[mailto:[EMAIL PROTECTED]]Sent: 24 May 2001 00:27To:
Multiple recipients of list ORACLE-LSubject: Another
Title: RE: Database Down
Woo
Hoo, well done and have a virtual (drink of your choice) on
me.
I know
it is really scary when you get thrown in at the deep end like this but if you
are anything like me, after this happened to me for the first time and I had, by
all means at my disposal
controlfile because Oracle won't be able to tell when it should
> assume recovery is complete.
>
> Rachel
>
>
> From: Jared Still <[EMAIL PROTECTED]>
>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>
Title: Another Database Down
No
need to panic yet! Check out Metalink note 1034037.6 which has about 4 possible
reasons for this -- all pretty simple.
-Original Message-From: Burton, Laura L.
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 23, 2001 7:27
PMTo: Multiple
Title: RE: Database Down
Whoopsby all means...LOL
-Original Message-From: Jacques Kilchoer
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 23, 2001
6:31 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Database Down
-Original Message
Title: RE: Database Down
-Original Message-From: Burton, Laura L.
[mailto:[EMAIL PROTECTED]]
Amen
Sister!! I am afraid you all will have to be my virtual party people,
since I am the only one around here that got excited when the recovery was
done...so have a great
Title: Another Database Down
Well, I think the time for jubilation has been short-lived for me. The production database was recovered successfully due to archiving and luck. I also have a small, inhouse, remedy (help desk) database that I haven't done anything with and now recove
Title: RE: Database Down
Here some help from Paul Drake on NT
diagnostics tools you can put in place to send yourself event
logs.
Sample code to email event logs
C:\>blat -install mail.mydomain.com
[EMAIL PROTECTED]
Failed to open registry key for Blat profile , using
default.
SMTP ser
racle won't be able to tell when it should assume
recovery is complete.
Rachel
>From: Jared Still <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Database Down
>Date: Wed, 23 May 2001 08:31
Title: RE: Database Down
Amen
Sister!! I am afraid you all will have to be my virtual party people,
since I am the only one around here that got excited when the recovery was
done...so have a great time!!
Laura
:)
-Original Message-From: Jacques Kilchoer
[mailto:[EMAIL
On Wed, 23 May 2001,Jared Still scribbled on the wall in glitter crayon:
->Backup is easy, recovery is not always so.
->
->Jared
->
Now there's a quote that should go into "Zen and the Art of ORACLE Database
Administration"... now who's writing that again?;-)
--
Bill Thater Certifiab
Title: RE: Database Down
>-Original Message-
>From: Burton, Laura L. [mailto:[EMAIL PROTECTED]]
>
>My database is up and with no data loss!!!
Congratulations! I've done the exercises in Rama Velpuri's book, but when it comes to a live situation, it's a lit
ou came in.
Yell. Scream. And DOCUMENT what went wrong... to everyone you can think of.
Rachel
>From: Paul Drake <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Database Down
>Date: Wed, 23 May 200
On Wed, 23 May 2001,Rachel Carmichael scribbled on the wall in glitter crayon:
->Yell. Scream. And DOCUMENT what went wrong... to everyone you can think of.
->
->Rachel
Including sending copies to yourself at an account off site, then save it there. BCC
is your friend.;-)
--
Bill Thater
p and why it waited
until you came in.
Yell. Scream. And DOCUMENT what went wrong... to everyone you can think of.
Rachel
>From: Paul Drake <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Database
Title: RE: Database Down
My database is up and with no data loss!!! I was able to do a complete recovery, not incomplete.
After the coca-cola (for caffeine) to calm my nerves I had the sysadmin restore the datafiles and archive logs from the hot backup from Friday. The control files 1 and
>> I thought I would have to restore all datafiles and archive logs from
>> the physical backup so that they would be in sync, and then 'recover'
>> the database using the hot backup. This would only incur minimum data
>> loss since Saturday is a non-work day for most employees. After reading
>>
On Wednesday 23 May 2001 01:00, Paul Drake wrote:
>
> 0. caffeine.
Agreed.
> 2. You *will* be performing incomplete recovery. Recover until cancel,
> preferably with a backup controlfile.
>Did you create a backup controlfile as part of the hot backup on May
> 11th? Restore with that controlf
> "Burton, Laura L." wrote:
>
> I have an Oracle 8.0.5 database residing on a Windows NT operating
> system which uses Raid5. The 'almost never' has happened; two disks
> have gone bad at the same time. As fate would have it the 'complete'
> physical backup performed the day before the disks cr
Title: Database Down
I have an Oracle 8.0.5 database residing on a Windows NT operating system which uses Raid5. The 'almost never' has happened; two disks have gone bad at the same time. As fate would have it the 'complete' physical backup performed the day before the d
ok at. A lot of work building, cutting over, and rebuilding,
but
> may result in minimum downtime.
>
> dgm
>
> - Original Message -
> > > > Attention all installation gurus/hacks...
> > > >
> > > > I'm looking for suggestions, experiences, a
Patrick <[EMAIL PROTECTED]>
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent: Thursday, February 08, 2001 4:15 PM
> Subject: RE: Applying patches - minimizing database down time
>
>
> > Do you have a test instance to apply the patches to? Check
recipients of list ORACLE-L
> > Subject: RE: Applying patches - minimizing database down time
> >
> > Yeah, I like the theory but putting the theory into practice is another
> > story. Maybe I'll try it another day. I thought Oracle supported 24X7
> > Internet ec
, 2001 2:45 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Applying patches - minimizing database down time
>
> Yeah, I like the theory but putting the theory into practice is another
> story. Maybe I'll try it another day. I thought Oracle supported 24X7
> Inter
educe
database down time from 1 hour to 5 minutes.
"Patches? We don't need no stinkin' patches!" L.E.
Returning to Dog Patch,
Lil' Abner
-Original Message-
Patrick
Sent: Thursday, February 08, 2001 12:21 PM
To: Multiple recipients of list ORACLE-L
You might consi
logminer.
> -Original Message-
> From: Molina, Gerardo [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, February 08, 2001 12:56 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Applying patches - minimizing database down time
>
> (Not a sales pitch)
>
gurus/hacks...
I'm looking for suggestions, experiences, and best practices on safely
applying Oracle patches and minimizing database down time. By way of example
let's say we're going from server version 8.1.6.0.0 to 8.1.6.3.0. Let's also
say we're going to apply the 8.1.
Attention all installation gurus/hacks...
I'm looking for suggestions, experiences, and best practices on safely
applying Oracle patches and minimizing database down time. By way of example
let's say we're going from server version 8.1.6.0.0 to 8.1.6.3.0. Let's also
say we
46 matches
Mail list logo