| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> startup/shutdown problem - long
This is a multi-part message in MIME format.
------=_NextPart_000_000B_01BFF8B3.A5CD68C0 Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi all,
Oracle 8.0.5.2.1, Solaris 2.6, 1GB Ram, 2 instances/2 databases...
I had problem shutting down both our db today, nothing strange in the = alert file, no trace file, the alert is like this:
Thu Jul 27 14:29:59 2000
Shutting down instance (normal)
License high water mark =3D 2
Thu Jul 27 14:29:59 2000
ALTER DATABASE CLOSE NORMAL
Thu Jul 27 14:30:00 2000
SMON: disabling tx recovery
SMON: disabling cache recovery
Thu Jul 27 14:30:00 2000
Thread 1 closed at log sequence 1
Thu Jul 27 14:30:01 2000
Completed: ALTER DATABASE CLOSE NORMAL
Thu Jul 27 14:30:01 2000
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
And it just hangs there, there aren't any CPU / disk activity.. I waited = almost 1 hour before deciding to shutdown abort.. And after shutdown = abort, now I can't start (mount) the database, the alert showed:
PMON started with pid=3D2 DBW0 started with pid=3D3 LGWR started with pid=3D4 CKPT started with pid=3D5 SMON started with pid=3D6 RECO started with pid=3D7
and it hang here...
After that I tried to shutdown the other instance/database, and I had = exactly same problem for 2nd instance...
I search metalink and found suggestions to reboot the machine, something = wrong about the shared memory... Anyway this is our development machine = so I have time to do some experiment with it, its uptime is already 267 = days, so I'm trying to preserve it :)
I then did truss for svrmgrl, as suggested from metalink:
truss -fae -vall -o /tmp/mytruss svrmgrl
SVRMGR> connect internal;
Connected.
SVRMGR> startup nomount;
ORACLE instance started.
Total System Global Area 121265680 bytes Fixed Size 48656 bytes Variable Size 18735104 bytes Database Buffers 102400000 bytes Redo Buffers 81920 bytesSVRMGR>=20 And I got the following repeated again and again non-stop:
26674: semop(1638400, 0xEFFFE9D0, 1) (sleeping...) 26678: semop(1638400, 0xEFFFE920, 1) (sleeping...) 26682: semop(1638400, 0xEFFFE920, 1) (sleeping...) 26686: semop(1638400, 0xEFFFE920, 1) (sleeping...) 26700: semop(1638400, 0xEFFFE920, 1) (sleeping...) 26674: Received signal #14, SIGALRM, in semop() [caught] 26674: semop(1638400, 0xEFFFE9D0, 1) Err#91 ERESTART 26674: semnum=3D2 semop=3D-1 semflg=3D0 26674: sigprocmask(SIG_BLOCK, 0xEFFFE5E8, 0x00000000) =3D 0 26674: set =3D 0 0 0 0 26674: times(0xEFFFE578) =3D -1987064759 26674: utim=3D1 stim=3D5 cutim=3D0 cstim=3D0 =(HZ=3D100)
26674: sigprocmask(SIG_UNBLOCK, 0xEFFFE5E8, 0x00000000) =3D 0 26674: set =3D 0 0 0 0 26674: setcontext(0xEFFFE6B8) 26678: Received signal #14, SIGALRM, in semop() [caught] 26678: semop(1638400, 0xEFFFE920, 1) Err#91 ERESTART 26678: semnum=3D3 semop=3D-1 semflg=3D0 26678: sigprocmask(SIG_BLOCK, 0xEFFFE538, 0x00000000) =3D 0 26678: set =3D 0 0 0 0 26678: times(0xEFFFE4C8) =3D -1987064746 26678: utim=3D2 stim=3D1 cutim=3D0 cstim=3D0 =(HZ=3D100)
26678: sigprocmask(SIG_UNBLOCK, 0xEFFFE538, 0x00000000) =3D 0 26678: set =3D 0 0 0 0 26678: setcontext(0xEFFFE608) 26682: Received signal #14, SIGALRM, in semop() [caught] 26682: semop(1638400, 0xEFFFE920, 1) Err#91 ERESTART 26682: semnum=3D4 semop=3D-1 semflg=3D0 26682: sigprocmask(SIG_BLOCK, 0xEFFFE538, 0x00000000) =3D 0 26682: set =3D 0 0 0 0 26682: times(0xEFFFE4C8) =3D -1987064733 26682: utim=3D1 stim=3D3 cutim=3D0 cstim=3D0 =(HZ=3D100)
26682: sigprocmask(SIG_UNBLOCK, 0xEFFFE538, 0x00000000) =3D 0 26682: set =3D 0 0 0 0 26682: setcontext(0xEFFFE608) 26686: Received signal #14, SIGALRM, in semop() [caught] 26686: semop(1638400, 0xEFFFE920, 1) Err#91 ERESTART 26686: semnum=3D5 semop=3D-1 semflg=3D0 26686: sigprocmask(SIG_BLOCK, 0xEFFFE538, 0x00000000) =3D 0 26686: set =3D 0 0 0 0 26686: times(0xEFFFE4C8) =3D -1987064712 26686: utim=3D0 stim=3D6 cutim=3D0 cstim=3D0 =(HZ=3D100)
26686: sigprocmask(SIG_UNBLOCK, 0xEFFFE538, 0x00000000) =3D 0 26686: set =3D 0 0 0 0 26686: setcontext(0xEFFFE608) 26700: Received signal #14, SIGALRM, in semop() [caught] 26700: semop(1638400, 0xEFFFE920, 1) Err#91 ERESTART 26700: semnum=3D7 semop=3D-1 semflg=3D0 26700: sigprocmask(SIG_BLOCK, 0xEFFFE538, 0x00000000) =3D 0 26700: set =3D 0 0 0 0 26700: times(0xEFFFE4C8) =3D -1987064676 26700: utim=3D2 stim=3D3 cutim=3D0 cstim=3D0 =(HZ=3D100)
26700: sigprocmask(SIG_UNBLOCK, 0xEFFFE538, 0x00000000) =3D 0 26700: set =3D 0 0 0 0 26700: setcontext(0xEFFFE608) $ps -fe|grep ora_ oracle 26682 1 0 16:27:08 ? 0:00 ora_lgwr_TEST oracle 26700 1 0 16:27:08 ? 0:00 ora_reco_TEST oracle 26696 1 0 16:27:08 ? 0:00 ora_smon_TEST oracle 26678 1 0 16:27:07 ? 0:00 ora_dbw0_TEST oracle 26686 1 0 16:27:08 ? 0:00 ora_ckpt_TEST oracle 26674 1 0 16:27:07 ? 0:00 ora_pmon_TEST$ipcs
And when i type "alter database mount", it just hang and truss output is = giving error on semop Err #91 ERESTART like above...
Anybody has any idea how to solve this (preferrably by not rebooting the =
sun machine)??
I have tried removing (ipcrm) all shared memory/semaphore before running =
svrmgrl, still no luck... Btw, isn't it strange that the key for the =
above semaphore is 00000000 (?)
/etc/system:
set shmsys:shminfo_shmmni=3D200 set shmsys:shminfo_shmmax=3D4294967295 set shmsys:shminfo_shmseg=3D200 set semsys:seminfo_semmap=3D1000 set semsys:seminfo_semmsl=3D1000 set semsys:seminfo_semmnu=3D1000 set semsys:seminfo_semume=3D1000 set semsys:seminfo_semmns=3D1750 set semsys:seminfo_semmni=3D1000
rgds,
Sindu
------=_NextPart_000_000B_01BFF8B3.A5CD68C0 Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>Hi all,</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Oracle 8.0.5.2.1, Solaris 2.6, 1GB Ram, 2 =
instances/2=20
databases...</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>I had problem shutting down both our db =
today,=20
nothing strange in the alert file, no trace file, the alert is like=20
this:</FONT></DIV>
mount</FONT></DIV><DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>and it hang here...</FONT></DIV>
Size &nb= sp; &nbs= p;  =; =20
Buffers = &= nbsp; &n=bsp; =20
(sleeping...)<BR>26678: semop(1638400, 0xEFFFE920, 1) =20 (sleeping...)<BR>26682: semop(1638400, 0xEFFFE920, 1) =20 (sleeping...)<BR>26686: semop(1638400, 0xEFFFE920, 1) =20 (sleeping...)<BR>26700: semop(1638400, 0xEFFFE920, 1) =20 (sleeping...)<BR>26674: Received signal =#14,=20
semnum=3D2 semop=3D-1 =20
semflg=3D0<BR>26674: sigprocmask(SIG_BLOCK, 0xEFFFE5E8, =
0x00000000) =3D=20
0<BR>26674: =
set =3D 0=20
0 0 0<BR>26674: =20
times(0xEFFFE578) &n=
bsp; &nb=
sp; =20
=3D =
-1987064759<BR>26674: &nbs=
p;=20
utim=3D1 =
stim=3D5 =20
cutim=3D0 =
cstim=3D0 =20
(HZ=3D100)<BR>26674: setitimer(ITIMER_REAL, 0xEFFFE578, =
0x00000000) =3D=20
0<BR>26674: =20
value: interval: 0.000000 sec =20
value: 3.000000 sec<BR>26674: =
sigprocmask(SIG_UNBLOCK,=20
0xEFFFE5E8, 0x00000000) =3D=20
0<BR>26674: =
set =3D 0=20
0 0 0<BR>26674: =20
setcontext(0xEFFFE6B8)<BR>26678: Received =
signal=20
#14, SIGALRM, in semop() [caught]<BR>26678: semop(1638400, =
0xEFFFE920,=20
1)  =
; =20
Err#91 =
ERESTART<BR>26678: =
semnum=3D3 semop=3D-1 =20
semflg=3D0<BR>26678: sigprocmask(SIG_BLOCK, 0xEFFFE538, =
0x00000000) =3D=20
0<BR>26678: =
set =3D 0=20
0 0 0<BR>26678: =20
times(0xEFFFE4C8) &n=
bsp; &nb=
sp; =20
=3D =
-1987064746<BR>26678: &nbs=
p;=20
utim=3D2 =
stim=3D1 =20
cutim=3D0 =
cstim=3D0 =20
(HZ=3D100)<BR>26678: setitimer(ITIMER_REAL, 0xEFFFE4C8, =
0x00000000) =3D=20
0<BR>26678: =20
value: interval: 0.000000 sec =20
value: 3.000000 sec<BR>26678: =
sigprocmask(SIG_UNBLOCK,=20
0xEFFFE538, 0x00000000) =3D=20
0<BR>26678: =
set =3D 0=20
0 0 0<BR>26678: =20
setcontext(0xEFFFE608)<BR>26682: Received =
signal=20
#14, SIGALRM, in semop() [caught]<BR>26682: semop(1638400, =
0xEFFFE920,=20
1)  =
; =20
Err#91 =
ERESTART<BR>26682: =
semnum=3D4 semop=3D-1 =20
semflg=3D0<BR>26682: sigprocmask(SIG_BLOCK, 0xEFFFE538, =
0x00000000) =3D=20
0<BR>26682: =
set =3D 0=20
0 0 0<BR>26682: =20
times(0xEFFFE4C8) &n=
bsp; &nb=
sp; =20
=3D =
-1987064733<BR>26682: &nbs=
p;=20
utim=3D1 =
stim=3D3 =20
cutim=3D0 =
cstim=3D0 =20
(HZ=3D100)<BR>26682: setitimer(ITIMER_REAL, 0xEFFFE4C8, =
0x00000000) =3D=20
0<BR>26682: =20
value: interval: 0.000000 sec =20
value: 3.000000 sec<BR>26682: =
sigprocmask(SIG_UNBLOCK,=20
0xEFFFE538, 0x00000000) =3D=20
0<BR>26682: =
set =3D 0=20
0 0 0<BR>26682: =20
setcontext(0xEFFFE608)<BR>26686: Received =
signal=20
#14, SIGALRM, in semop() [caught]<BR>26686: semop(1638400, =
0xEFFFE920,=20
1)  =
; =20
Err#91 =
ERESTART<BR>26686: =
semnum=3D5 semop=3D-1 =20
semflg=3D0<BR>26686: sigprocmask(SIG_BLOCK, 0xEFFFE538, =
0x00000000) =3D=20
0<BR>26686: =
set =3D 0=20
0 0 0<BR>26686: =20
times(0xEFFFE4C8) &n=
bsp; &nb=
sp; =20
=3D =
-1987064712<BR>26686: &nbs=
p;=20
utim=3D0 =
stim=3D6 =20
cutim=3D0 =
cstim=3D0 =20
(HZ=3D100)<BR>26686: setitimer(ITIMER_REAL, 0xEFFFE4C8, =
0x00000000) =3D=20
0<BR>26686: =20
value: interval: 0.000000 sec =20
value: 3.000000 sec<BR>26686: =
sigprocmask(SIG_UNBLOCK,=20
0xEFFFE538, 0x00000000) =3D=20
0<BR>26686: =
set =3D 0=20
0 0 0<BR>26686: =20
setcontext(0xEFFFE608)<BR>26700: Received =
signal=20
#14, SIGALRM, in semop() [caught]<BR>26700: semop(1638400, =
0xEFFFE920,=20
1)  =
; =20
Err#91 =
ERESTART<BR>26700: =
semnum=3D7 semop=3D-1 =20
semflg=3D0<BR>26700: sigprocmask(SIG_BLOCK, 0xEFFFE538, =
0x00000000) =3D=20
0<BR>26700: =
set =3D 0=20
0 0 0<BR>26700: =20
times(0xEFFFE4C8) &n=
bsp; &nb=
sp; =20
=3D =
-1987064676<BR>26700: &nbs=
p;=20
utim=3D2 =
stim=3D3 =20
cutim=3D0 =
cstim=3D0 =20
(HZ=3D100)<BR>26700: setitimer(ITIMER_REAL, 0xEFFFE4C8, =
0x00000000) =3D=20
0<BR>26700: =20
value: interval: 0.000000 sec =20
value: 3.000000 sec<BR>26700: =
sigprocmask(SIG_UNBLOCK,=20
0xEFFFE538, 0x00000000) =3D=20
0<BR>26700: =
set =3D 0=20
0 0 0<BR>26700: setcontext(0xEFFFE608)</FONT></DIV>
 |
 |