/oracle/rdbms/product/10.2.0/db_1/admin/dwdata/bdump/dwdata_pmon_25725.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /oracle/rdbms/product/10.2.0/db_1
System name: Linux
Node name: NQMPMS
Release: 2.6.9-42.EL
Version: #1 SMP Wed Jul 12 23:25:09 EDT 2006
Machine: ia64
Instance name: dwdata
Redo thread mounted by this instance: 1
Oracle process number: 2
Unix process pid: 25725, image: [EMAIL PROTECTED] (PMON)
*** 2007-06-27 17:07:05.687
*** SERVICE NAME:(SYS$BACKGROUND) 2007-06-27 17:07:05.687
*** SESSION ID:(665.1) 2007-06-27 17:07:05.687
Background process SMON found dead
Oracle pid = 11
OS pid (from detached process) = 25743
OS pid (from process state) = 25743
dtp = 0x40000018260, proc = 0x405fe589d98
Dump of memory from 0x0000040000018260 to 0x00000400000182A8
...
...
...
Repeat 1 times
405FE58A070 00000000 00000000 0000648F 00000000 [.........d......]
405FE58A080 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
405FE58A0B0 00000000 00000000 FE589D98 00000405 [..........X.....]
405FE58A0C0 00000000 00000000 00000000 00000000 [................]
...
...
...
Repeat 4 times
405FE58A570 00000000 00000018 00000003 00000000 [................]
error 474 detected in background process
ORA-00474: SMON process terminated with error
On 6/27/07, Yoel Susanto <[EMAIL PROTECTED]> wrote:
>
> coba diliat di file
>
> /oracle/rdbms/product/10.2.0/db_1/admin/dwdata/bdump/dwdata_pmon_25725.trc:
> ada info apa lagi
>
>
> On 6/27/07, indra syafruddin <[EMAIL PROTECTED] <indra.e00%40gmail.com>>
> wrote:
> >
> > Saya mendapatkan masalah di database Oracle, saat saya startup, 1 menit
> > kemudian db nya mati. Kejadiannya terus berulang
> > kemudian saya coba cek log di bdump, saya menemukan error :
> >
> > ORA-00607: Internal error occurred while making a change to a data block
> > ORA-00602: internal programming exception
> > ORA-07445: exception encountered: core dump [sskgds_getreg()+544]
> > [SIGSEGV]
> > [unknown code] [0x60000FFF820000D0] [] []
> > ORA-07445: exception encountered: core dump [sskgds_getreg()+
> >
> > Saya juga menemukan beberapa error :
> > Errors in file
> >
> >
> /oracle/rdbms/product/10.2.0/db_1/admin/dwdata/bdump/dwdata_p010_23654.trc:
> > ORA-07445: exception encountered: core dump [kdr9ir2rst0()+0] [SIGSEGV]
> > [unknown code] [0x60000FFF82000000] [] []
> > Wed Jun 27 16:33:49 2007
> > Errors in file
> >
> >
> /oracle/rdbms/product/10.2.0/db_1/admin/dwdata/bdump/dwdata_p010_23654.trc:
> > ORA-07445: exception encountered: core dump [sskgds_getreg()+544]
> > [SIGSEGV]
> > [unknown code] [0x60000FFF82000098] [] []
> > ORA-07445: exception encountered: core dump [kdr9ir2rst0()+0] [SIGSEGV]
> > [unknown code] [0x60000FFF82000000] [] []
> >
> > dan jika di tail -f, log terakhir adalah :
> >
> > Errors in file
> >
> >
> /oracle/rdbms/product/10.2.0/db_1/admin/dwdata/bdump/dwdata_pmon_25725.trc:
> > ORA-00474: SMON process terminated with error
> > Wed Jun 27 17:07:05 2007
> > PMON: terminating instance due to error 474
> > Instance terminated by PMON, pid = 25725
> >
> > Pertanyaan saya, mengapa error tersebut terjadi, dan bagiamana caranya
> > untuk
> > menjalankan database.
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
>
>
[Non-text portions of this message have been removed]
