SLES 9 Oracle 10g Instance Crash opteron 2005-07-11 - By Seah Hong Yee
sorry accidently click send from the las t mail
Pleaes note that the date changes was due to a faulty system clock setting
during installation.
This is from $ORACLE_HOME/rdbms/log
/u01/app/oracle/product/10.1.0/db_1/rdbms/log/compiere_ora_18025.trc
Oracle Database 10g Release 10.1.0.3.0 - 64bit Production
ORACLE_HOME = /u01/app/oracle/product/10.1.0/db_1
System name: Linux
Node name: miller
Release: 2.6.5-7.97-smp
Version: #1 SMP Fri Jul 2 14:21:59 UTC 2004
Machine: x86_64
Instance name: compiere
Redo thread mounted by this instance: 0 <none>
Oracle process number: 0
18025
kstwlb: SGA is no longer mapped
AUM timeouts: MQL_TUNE(300s) TUR_TUNE(60s) SESS_EXPRN(1800s) QRY_EXPRN(1800s)
SL
OT_PERIOD(600s) MQL_CUSHION(300s) KSUCKI_FG_PERIOD(150s) MMNL_EXPRN(1200s)
KTTSI
NFO(300s)
oracle@(protected):~/product/10.1.0/db_1/rdbms/log> more alert_compiere.log
Sun Feb 8 23:10:27 2004
Running with 1 strand for Non-Enterprise Edition
Sun Feb 8 23:10:27 2004
Running without dynamic strand for Non-Enterprise Edition
Sun Feb 8 23:11:17 2004
Running with 1 strand for Non-Enterprise Edition
Sun Feb 8 23:11:17 2004
Running without dynamic strand for Non-Enterprise Edition
Sun Feb 8 23:11:52 2004
Running with 1 strand for Non-Enterprise Edition
Sun Feb 8 23:11:52 2004
Running without dynamic strand for Non-Enterprise Edition
Mon Feb 9 02:00:25 2004
Running with 1 strand for Non-Enterprise Edition
Mon Feb 9 02:00:25 2004
Running without dynamic strand for Non-Enterprise Edition
Mon Jul 4 10:39:46 2005
Running with 1 strand for Non-Enterprise Edition
Mon Jul 4 10:39:46 2005
Running without dynamic strand for Non-Enterprise Edition
On Monday 11 July 2005 16:32, Magni Fabrizio wrote:
> The traces are explained by bug 4061041.
>
> But what about the crashes?
>
> What can you see in the alertlog?
> The reason of the crash should be logged there.
>
> Fabrizio
>
> > -- --Original Message-- --
> > From: Trieb, Christian [mailto:christian.trieb@(protected)]
> > Sent: Monday, July 11, 2005 10:01 AM
> > To: Seah Hong Yee; suse-oracle@(protected)
> > Subject: AW: [suse-oracle] SLES 9 Oracle 10g Instance Crash opteron
> >
> >
> > Hallo.
> >
> > this is BUG 4061041
> >
> > Regards
> > __ ____ ____ ____ ____ ____ ____ ____ ____ ____ ___
> >
> > SIEMENS
> > Siemens Business Services
> > Management GmbH Acc Südwest
> > SBS D ORS BM Reg. Mitte / Südwest
> >
> > Hausadresse:
> > Nachtweideweg 1 -7
> > 67227 Frankenthal / Pfalz
> > Deutschland
> >
> > Tel. +49 6233 / 86 3662
> > Fax +49 6233 / 86 3911
> > Mobil. +49 172 / 63 62 603
> > E-Mail:
> > mailto:Christian.Trieb@(protected)
> >
> > Dipl. - Inf.(FH)
> > Christian Trieb
> > Teamleiter DBA
> > Vorstand der Deutschen ORACLE Anwendergruppe
> > Leiter SIG - Database
> > __ ____ ____ ____ ____ ____ ____ ____ ____ ______
> > -- --Ursprüngliche Nachricht-- --
> > Von: Seah Hong Yee [mailto:hongyee@(protected)]
> > Gesendet am: Montag, 11. Juli 2005 10:11
> > An: suse-oracle@(protected)
> > Betreff: Re: [suse-oracle] SLES 9 Oracle 10g Instance Crash opteron
> >
> >
> > The bdump files are full of these type of entry
> >
> >
> > Before in kgllkdl(), hd}097638.
> > Before in kgllkdl(), hd}096740.
> > Before in kgllkdl(), hd}097638.
> > Before in kgllkdl(), hd}096740.
> > Before in kgllkdl(), hd}097638.
> > Before in kgllkdl(), hd}096740.
> >
> > I only have this system running for 7 days and already the
> > bdump directories
> > has more files than my other test system.
> >
> > On Monday 11 July 2005 15:30, Magni Fabrizio wrote:
> > > Hi,
> > > you should find some error (and probably traces) in you
> >
> > alert log and
> >
> > > bdump.
> > >
> > > Try to cut and paste those errors.
> > > Maybe somebody has already seen your problem and can be of help.
> > >
> > > If the error is a ORA-600 (See ORA-600.ora-code.com) or ORA-7445 (See ORA-7445.ora-code.com) you should search on
> >
> > metalink or
> >
> > > better you sould open a service tar.
> > >
> > > Regards
> > > Fabrizio
> > >
> > > > -- --Original Message-- --
> > > > From: Seah Hong Yee [mailto:hongyee@(protected)]
> > > > Sent: Monday, July 11, 2005 9:31 AM
> > > > To: suse-oracle@(protected)
> > > > Subject: [suse-oracle] SLES 9 Oracle 10g Instance Crash opteron
> > > >
> > > >
> > > > Hi,
> > > >
> > > > I am currently testing Oracle 10g on two machine, the 32 bit
> > > > machine runs on
> > > >
> > > > SLES9
> > > > 1 gig RAM
> > > > 2 X Pentium III 866Mhz
> > > > ext3 on scsi
> > > >
> > > > The above machine runs without problems for one month.
> > > >
> > > > Last weekend I set up another machine with the same
> > > > application but this time
> > > > is the 64bit version of Oracle 10g.
> > > >
> > > >
> > > > The specification is like this
> > > >
> > > > SLES9
> > > > 2 gig RAM
> > > > 2 X Opteron 244
> > > > ADAPTEC ZCR 2015 (I2O) RAID, I configure as raid 10.
> > > > ext 3
> > > >
> > > > I am also using ORARUN on both machine, both of them is the
> > > > script as of June
> > > > 9 2005 downloaded from suse's site.
> > > >
> > > > The installation method was the documentation provided by
> > > > SUse on oracle 10g
> > > > and SLES 9 installation. The only modification I did to the
> > > > orarun script was
> > > > to comment out dbsnmp portion which does not apply to 10g.
> > > >
> > > > The problem is my oracle instance tend to crash ( become
> > > > unavailable) at least
> > > > once a day. And I have notice once it was during starting up
> > > > of emctl start
> > > > dbconsole. The machine itself was quite stable with no
> > > > crashes on Jboss.
> > > > When access http://192.168.1.102:5500/em/ I get a message database
> > > > unavailable. Individual client was not able to connect to
> > > > the database, I
> > > > have to either do "rcoracle restart" or manually run
> > > > "dbstart " to restart
> > > > the database. However, I was not able to do "emctl stop
> > > > dbconsole."
> > > >
> > > > Thanks.
> > > >
> > > > Regards,
> > > >
> > > > Hong Yee
> > > >
> > > > --
> > > > To unsubscribe, email: suse-oracle-unsubscribe@(protected)
> > > > For additional commands, email: suse-oracle-help@(protected)
> > > > Please see http://www.suse.com/oracle/ before posting
> >
> > --
> > To unsubscribe, email: suse-oracle-unsubscribe@(protected)
> > For additional commands, email: suse-oracle-help@(protected)
> > Please see http://www.suse.com/oracle/ before posting
> >
> >
> > --
> > To unsubscribe, email: suse-oracle-unsubscribe@(protected)
> > For additional commands, email: suse-oracle-help@(protected)
> > Please see http://www.suse.com/oracle/ before posting
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
|
|
