cancel
Showing results for 
Search instead for 
Did you mean: 

ERROR, line: 778246, time: 201dump [UNKNOWN] in db check

Former Member
0 Kudos

Dear All,

I am getting below error in db check .please suggest how to solve it.

BR0280I BRCONNECT time stamp: 2010-04-06 07.01.58

BR0974I Checking database messages in J:\ORACLE\PRD\SAPTRACE\BACKGROUND\alert_prd.log ...

BR0976W Database message alert - level: ERROR, line: 778246, time: 201dump [UNKNOWN] [.jslvss_session_start??hot+5sion_start??ho

Regards,

Kumar

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

BR0974I Checking database messages in J:\ORACLE\PRD\SAPTRACE\BACKGROUND\alert_prd.log ...

So what is in your alert log for this ?

Mark

Former Member
0 Kudos

Hi,

Please find the log and this time the online backup is running

Incremental checkpoint up to RBA [0xa37.124a5.0], current log tail at RBA [0xa37.1257a.0]

Mon Apr 05 21:14:55 2010

Incremental checkpoint up to RBA [0xa37.130f2.0], current log tail at RBA [0xa37.132fc.0]

Mon Apr 05 21:44:56 2010

Incremental checkpoint up to RBA [0xa37.14f29.0], current log tail at RBA [0xa37.151d1.0]

Mon Apr 05 22:00:16 2010

Beginning log switch checkpoint up to RBA [0xa38.2.10], SCN: 671659262

Mon Apr 05 22:00:16 2010

Thread 1 advanced to log sequence 2616 (LGWR switch)

Current log# 4 seq# 2616 mem# 0: H:\ORACLE\PRD\ORIGLOGB\LOG_G14M1.DBF

Current log# 4 seq# 2616 mem# 1: K:\ORACLE\PRD\MIRRLOGB\LOG_G14M2.DBF

Mon Apr 05 22:00:21 2010

/* BRBACKUP */ ALTER DATABASE BACKUP CONTROLFILE TO 'I:\oracle\PRD\sapbackup\CNTRLPRD.DBF'

Mon Apr 05 22:00:21 2010

Completed: /* BRBACKUP */ ALTER DATABASE BACKUP CONTROLFILE TO 'I:\oracle\PRD\sapbackup\CNTRLPRD.DBF'

Mon Apr 05 22:00:27 2010

/* BRBACKUP */ ALTER TABLESPACE "PSAPEL701D" BEGIN BACKUP

Completed: /* BRBACKUP */ ALTER TABLESPACE "PSAPEL701D" BEGIN BACKUP

Mon Apr 05 22:00:40 2010

/* BRBACKUP */ ALTER TABLESPACE "PSAPEL701D" END BACKUP

Completed: /* BRBACKUP */ ALTER TABLESPACE "PSAPEL701D" END BACKUP

Mon Apr 05 22:00:40 2010

/* BRBACKUP */ ALTER TABLESPACE "PSAPEL701I" BEGIN BACKUP

Completed: /* BRBACKUP */ ALTER TABLESPACE "PSAPEL701I" BEGIN BACKUP

Mon Apr 05 22:01:28 2010

/* BRBACKUP */ ALTER TABLESPACE "PSAPEL701I" END BACKUP

Completed: /* BRBACKUP */ ALTER TABLESPACE "PSAPEL701I" END BACKUP

Mon Apr 05 22:01:28 2010

/* BRBACKUP */ ALTER TABLESPACE "PSAPPRD" BEGIN BACKUP

Completed: /* BRBACKUP */ ALTER TABLESPACE "PSAPPRD" BEGIN BACKUP

Mon Apr 05 22:03:16 2010

Beginning log switch checkpoint up to RBA [0xa39.2.10], SCN: 671730894

Mon Apr 05 22:03:16 2010

Thread 1 advanced to log sequence 2617 (LGWR switch)

Current log# 1 seq# 2617 mem# 0: H:\ORACLE\PRD\ORIGLOGA\LOG_G11M1.DBF

Current log# 1 seq# 2617 mem# 1: K:\ORACLE\PRD\MIRRLOGA\LOG_G11M2.DBF

Mon Apr 05 22:03:28 2010

Beginning log switch checkpoint up to RBA [0xa3a.2.10], SCN: 671734489

Mon Apr 05 22:03:28 2010

Thread 1 advanced to log sequence 2618 (LGWR switch)

Current log# 2 seq# 2618 mem# 0: H:\ORACLE\PRD\ORIGLOGB\LOG_G12M1.DBF

Current log# 2 seq# 2618 mem# 1: K:\ORACLE\PRD\MIRRLOGB\LOG_G12M2.DBF

Mon Apr 05 22:05:14 2010

Completed checkpoint up to RBA [0xa38.2.10], SCN: 671659262

Mon Apr 05 22:08:16 2010

Completed checkpoint up to RBA [0xa39.2.10], SCN: 671730894

Mon Apr 05 22:08:29 2010

Completed checkpoint up to RBA [0xa3a.2.10], SCN: 671734489

Mon Apr 05 22:14:58 2010

Incremental checkpoint up to RBA [0xa3a.cf34.0], current log tail at RBA [0xa3a.d670.0]

Mon Apr 05 22:44:58 2010

Incremental checkpoint up to RBA [0xa3a.10c06.0], current log tail at RBA [0xa3a.10cfe.0]

Mon Apr 05 23:11:26 2010

Beginning log switch checkpoint up to RBA [0xa3b.2.10], SCN: 672108964

Mon Apr 05 23:11:26 2010

Thread 1 advanced to log sequence 2619 (LGWR switch)

Current log# 3 seq# 2619 mem# 0: H:\ORACLE\PRD\ORIGLOGA\LOG_G13M1.DBF

Current log# 3 seq# 2619 mem# 1: K:\ORACLE\PRD\MIRRLOGA\LOG_G13M2.DBF

Mon Apr 05 23:14:59 2010

Incremental checkpoint up to RBA [0xa3a.120fd.0], current log tail at RBA [0xa3b.e966.0]

Mon Apr 05 23:16:29 2010

Completed checkpoint up to RBA [0xa3b.2.10], SCN: 672108964

Mon Apr 05 23:45:01 2010

Incremental checkpoint up to RBA [0xa3b.10d59.0], current log tail at RBA [0xa3b.10f66.0]

Tue Apr 06 00:00:27 2010

Beginning log switch checkpoint up to RBA [0xa3c.2.10], SCN: 672115259

Tue Apr 06 00:00:27 2010

Thread 1 advanced to log sequence 2620 (LGWR switch)

Current log# 4 seq# 2620 mem# 0: H:\ORACLE\PRD\ORIGLOGB\LOG_G14M1.DBF

Current log# 4 seq# 2620 mem# 1: K:\ORACLE\PRD\MIRRLOGB\LOG_G14M2.DBF

Tue Apr 06 00:05:31 2010

Completed checkpoint up to RBA [0xa3c.2.10], SCN: 672115259

Tue Apr 06 00:15:03 2010

Incremental checkpoint up to RBA [0xa3c.1161.0], current log tail at RBA [0xa3c.1238.0]

Tue Apr 06 00:45:04 2010

Incremental checkpoint up to RBA [0xa3c.4c81.0], current log tail at RBA [0xa3c.4ead.0]

Tue Apr 06 00:52:19 2010

/* BRBACKUP */ ALTER TABLESPACE "PSAPPRD" END BACKUP

Tue Apr 06 00:52:20 2010

Completed: /* BRBACKUP */ ALTER TABLESPACE "PSAPPRD" END BACKUP

Tue Apr 06 00:52:20 2010

/* BRBACKUP */ ALTER TABLESPACE "PSAPPRD640" BEGIN BACKUP

Completed: /* BRBACKUP */ ALTER TABLESPACE "PSAPPRD640" BEGIN BACKUP

Tue Apr 06 01:15:06 2010

Incremental checkpoint up to RBA [0xa3c.58c2.0], current log tail at RBA [0xa3c.59a9.0]

Tue Apr 06 01:32:56 2010

/* BRBACKUP */ ALTER TABLESPACE "PSAPPRD640" END BACKUP

Tue Apr 06 01:32:57 2010

Completed: /* BRBACKUP */ ALTER TABLESPACE "PSAPPRD640" END BACKUP

Tue Apr 06 01:32:57 2010

/* BRBACKUP */ ALTER TABLESPACE "PSAPPRD701" BEGIN BACKUP

Completed: /* BRBACKUP */ ALTER TABLESPACE "PSAPPRD701" BEGIN BACKUP

Tue Apr 06 01:45:09 2010

Incremental checkpoint up to RBA [0xa3c.69de.0], current log tail at RBA [0xa3c.6a73.0]

Tue Apr 06 02:15:17 2010

Incremental checkpoint up to RBA [0xa3c.72b3.0], current log tail at RBA [0xa3c.73c4.0]

Tue Apr 06 02:45:25 2010

Incremental checkpoint up to RBA [0xa3c.d1d9.0], current log tail at RBA [0xa3c.d294.0]

Tue Apr 06 03:00:21 2010

Errors in file i:\oracle\prd\saptrace\background\prd_000_6756.trc:

ORA-07445: exception encountered: core dump [UNKNOWN] [.jslvss_session_start??hot+5088] [PC:0x81D0560] [] [] []

Tue Apr 06 03:15:58 2010

/* BRBACKUP */ ALTER TABLESPACE "PSAPPRD701" END BACKUP

Tue Apr 06 03:15:58 2010

Completed: /* BRBACKUP */ ALTER TABLESPACE "PSAPPRD701" END BACKUP

Tue Apr 06 03:15:59 2010

/* BRBACKUP */ ALTER TABLESPACE "PSAPPRDUSR" BEGIN BACKUP

Completed: /* BRBACKUP */ ALTER TABLESPACE "PSAPPRDUSR" BEGIN BACKUP

Tue Apr 06 03:18:17 2010

/* BRBACKUP */ ALTER TABLESPACE "PSAPPRDUSR" END BACKUP

Completed: /* BRBACKUP */ ALTER TABLESPACE "PSAPPRDUSR" END BACKUP

Tue Apr 06 03:18:17 2010

/* BRBACKUP */ ALTER TABLESPACE "PSAPUNDO" BEGIN BACKUP

Completed: /* BRBACKUP */ ALTER TABLESPACE "PSAPUNDO" BEGIN BACKUP

Tue Apr 06 03:18:27 2010

Incremental checkpoint up to RBA [0xa3c.dc1c.0], current log tail at RBA [0xa3c.dd8c.0]

Tue Apr 06 03:32:11 2010

/* BRBACKUP */ ALTER TABLESPACE "PSAPUNDO" END BACKUP

Tue Apr 06 03:32:11 2010

Completed: /* BRBACKUP */ ALTER TABLESPACE "PSAPUNDO" END BACKUP

Tue Apr 06 03:32:11 2010

/* BRBACKUP */ ALTER TABLESPACE "PSAPUNDO2" BEGIN BACKUP

Completed: /* BRBACKUP */ ALTER TABLESPACE "PSAPUNDO2" BEGIN BACKUP

Tue Apr 06 03:41:26 2010

/* BRBACKUP */ ALTER TABLESPACE "PSAPUNDO2" END BACKUP

Tue Apr 06 03:41:26 2010

Completed: /* BRBACKUP */ ALTER TABLESPACE "PSAPUNDO2" END BACKUP

Tue Apr 06 03:41:26 2010

/* BRBACKUP */ ALTER TABLESPACE "SYSAUX" BEGIN BACKUP

Completed: /* BRBACKUP */ ALTER TABLESPACE "SYSAUX" BEGIN BACKUP

Tue Apr 06 03:43:25 2010

/* BRBACKUP */ ALTER TABLESPACE "SYSAUX" END BACKUP

Tue Apr 06 03:43:25 2010

Completed: /* BRBACKUP */ ALTER TABLESPACE "SYSAUX" END BACKUP

Tue Apr 06 03:43:25 2010

/* BRBACKUP */ ALTER TABLESPACE "SYSTEM" BEGIN BACKUP

Completed: /* BRBACKUP */ ALTER TABLESPACE "SYSTEM" BEGIN BACKUP

Tue Apr 06 03:45:25 2010

/* BRBACKUP */ ALTER TABLESPACE "SYSTEM" END BACKUP

Completed: /* BRBACKUP */ ALTER TABLESPACE "SYSTEM" END BACKUP

Tue Apr 06 03:46:55 2010

Beginning log switch checkpoint up to RBA [0xa3d.2.10], SCN: 672128074

Tue Apr 06 03:46:55 2010

Thread 1 advanced to log sequence 2621 (LGWR switch)

Current log# 1 seq# 2621 mem# 0: H:\ORACLE\PRD\ORIGLOGA\LOG_G11M1.DBF

Current log# 1 seq# 2621 mem# 1: K:\ORACLE\PRD\MIRRLOGA\LOG_G11M2.DBF

Tue Apr 06 03:48:29 2010

Incremental checkpoint up to RBA [0xa3c.f186.0], current log tail at RBA [0xa3d.25c.0]

Tue Apr 06 03:52:04 2010

Completed checkpoint up to RBA [0xa3d.2.10], SCN: 672128074

Tue Apr 06 04:18:31 2010

Incremental checkpoint up to RBA [0xa3d.78e4.0], current log tail at RBA [0xa3d.7a15.0]

Tue Apr 06 04:47:21 2010

Beginning log switch checkpoint up to RBA [0xa3e.2.10], SCN: 672157698

Tue Apr 06 04:47:21 2010

Thread 1 advanced to log sequence 2622 (LGWR switch)

Current log# 2 seq# 2622 mem# 0: H:\ORACLE\PRD\ORIGLOGB\LOG_G12M1.DBF

Current log# 2 seq# 2622 mem# 1: K:\ORACLE\PRD\MIRRLOGB\LOG_G12M2.DBF

Tue Apr 06 04:48:31 2010

Incremental checkpoint up to RBA [0xa3d.12291.0], current log tail at RBA [0xa3e.1fc0.0]

Tue Apr 06 04:52:25 2010

Completed checkpoint up to RBA [0xa3e.2.10], SCN: 672157698

Tue Apr 06 05:18:32 2010

Incremental checkpoint up to RBA [0xa3e.9648.0], current log tail at RBA [0xa3e.976e.0]

Tue Apr 06 05:48:32 2010

Incremental checkpoint up to RBA [0xa3e.1197f.0],

Regards,

Former Member
0 Kudos

Hi,

*Errors in file i:\oracle\prd\saptrace\background\prd_000_6756.trc:

What is in this.

Also, have you upgraded from a 640 kernel release to kernel 700 and then gone to an EHP level recently ?

Because you are are still backing up the old PSAP<640> tables......

Mark

Former Member
0 Kudos

hi,

Yes you are right we have just upgrade our su=system from ecc5 to ecc6 ehp4.

And sorry this trc file and in this there is oracle trc files also

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Windows Server 2003 Version V5.2 Service Pack 2

CPU : 4 - type 2200, 4 Physical Cores

Process Affinity : 0x0000000000000000

Memory (Avail/Total): Ph:3M/16362M, Ph+PgF:42925M/75999M

Instance name: prd

Redo thread mounted by this instance: 1

Oracle process number: 98

Windows thread id: 6756, image: ORACLE.EXE (J000)

      • SERVICE NAME:(SYS$USERS) 2010-04-06 03:00:20.398

      • SESSION ID:(1356.8276) 2010-04-06 03:00:20.398

      • 2010-04-06 03:00:20.398

ksedmp: internal or fatal error

ORA-07445: exception encountered: core dump [UNKNOWN] [.jslvss_session_start??hot+5088] [PC:0x81D0560] [] [] []

check trace file e:\oracle\prd\102\rdbms\trace\prd_ora_0.trc for preloading .sym file messages

-


Call Stack Trace -


calling call entry argument values in hex

location type point (? means dubious value)

-


-


-


-


.jslvss_session_sta 0000000000000000

rt??hot+5088

.jslve_execute0??ho UNK .jslvss_session_sta

t2416 rt??hot5088

.jslve_execute??hot UNK .jslve_execute0??ho

672 t2416

.rpiswu2??hot+2160 UNK .jslve_execute??hot

+672

.kkjex1e1104 UNK .rpiswu2??hot2160

.kkjsexe??hot944 UNK .kkjex1e1104

.kkjrdp??hot1856 UNK .kkjsexe??hot944

.opirip??hot2224 UNK .kkjrdp??hot1856

.opidrv??hot1856 UNK .opirip??hot2224

.sou2o96 UNK .opidrv??hot1856

.opimai_real??hot6 UNK .sou2o96

56

.opimai??hot224 UNK .opimai_real??hot6

56

.BackgroundThreadSt UNK .opimai??hot+224

art+4048

0000000075A47AE0 UNK .BackgroundThreadSt

art+4048

      • 2010-03-14 05:28:24.351

===== begin preloading .sym files

===== end preloading .sym files

Dump file e:\oracle\prd\102\rdbms\trace\prd_ora_0.trc

Mon Mar 22 03:50:44 2010

ORACLE V10.2.0.4.0 - 64bit Production vsnsta=0

vsnsql=14 vsnxtr=3

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

Windows Server 2003 Version V5.2 Service Pack 2

CPU : 4 - type 2200, 4 Physical Cores

Process Affinity : 0x0000000000000000

Memory (Avail/Total): Ph:15235M/16362M, Ph+PgF:48922M/75999M

Instance name: prd

Redo thread mounted by this instance: 0 <none>

Oracle process number: 0

Windows thread id: 3312, image: ORACLE.EXE

      • 2010-03-22 03:50:44.976

===== begin preloading .sym files

===== end preloading .sym files

Dump file e:\oracle\prd\102\rdbms\trace\prd_ora_0.trc

Mon Mar 22 03:50:59 2010

ORACLE V10.2.0.4.0 - 64bit Production vsnsta=0

vsnsql=14 vsnxtr=3

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

Windows Server 2003 Version V5.2 Service Pack 2

CPU : 4 - type 2200, 4 Physical Cores

Process Affinity : 0x0000000000000000

Memory (Avail/Total): Ph:15213M/16362M, Ph+PgF:48922M/75999M

Instance name: prd

Redo thread mounted by this instance: 0 <none>

Oracle process number: 0

Windows thread id: 3496, image: ORACLE.EXE

      • 2010-03-22 03:50:59.546

===== begin preloading .sym files

===== end preloading .sym files

Regards,

kumar

Former Member
0 Kudos

Hi,

ORA-07445

anything in the event logs for this.....

Is your kernel up to date as well ?

Struggling to pinpoint this.........

Mark

Former Member
0 Kudos

Hi Mark,

The kernel up it .please suggest

Regards,

Kumar

Former Member
0 Kudos

Hi,

Anything in the event logs on the O/S

Mark

Former Member
0 Kudos

Hi,

No there is error.

Regards,

Kumar

former_member204746
Active Contributor
0 Kudos

check trace file e:\oracle\prd\102\rdbms\trace\prd_ora_0.trc

Former Member
0 Kudos

Hi,

Dump file e:\oracle\prd\102\rdbms\trace\prd_ora_0.trc

Mon Mar 22 03:50:59 2010

ORACLE V10.2.0.4.0 - 64bit Production vsnsta=0

vsnsql=14 vsnxtr=3

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

Windows Server 2003 Version V5.2 Service Pack 2

CPU : 4 - type 2200, 4 Physical Cores

Process Affinity : 0x0000000000000000

Memory (Avail/Total): Ph:15213M/16362M, Ph+PgF:48922M/75999M

Instance name: prd

Redo thread mounted by this instance: 0 <none>

Oracle process number: 0

Windows thread id: 3496, image: ORACLE.EXE

      • 2010-03-22 03:50:59.546

===== begin preloading .sym files

===== end preloading .sym files

Regards,

Kumar

former_member204746
Active Contributor
0 Kudos

you have to choices:

1. ignore this error...

2. open a case with SAP. Google comes with no hit with this error message.

Former Member
0 Kudos

If you get an unknown Oracle error, it will always be a good idea to ask:

Did you apply all the required Oracle patches?

(By the way, if you open a case with SAP, this will be one of their first questions.)

For Oracle 10.2.0.4 have a look at SAP note 1137346.

regards