cancel
Showing results for 
Search instead for 
Did you mean: 

error during database load in ECC 5.0

Former Member
0 Kudos

Hello All,

i am trying to install ECC.5 with oracle 10g during database load phase he is giving me a error when i saw in log file i found this.

C:\usr\sap\EPT\SYS\exe\run/R3load.exe: START OF LOG: 20090611085559

C:\usr\sap\EPT\SYS\exe\run/R3load.exe: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#6 $ SAP

C:\usr\sap\EPT\SYS\exe\run/R3load.exe: version R6.40/V1.4

C:\usr\sap\EPT\SYS\exe\run/R3load.exe -ctf I E:/sap5/51031332_1/EXP1/DATA/SAP0000.STR C:\Program Files\sapinst_instdir\ECC50\SYSTEM\ABAP\ORA\NUC\DB/DDLORA.TPL C:\Program Files\sapinst_instdir\ECC50\SYSTEM\ABAP\ORA\NUC\DB/SAP0000.TSK ORA -l C:\Program Files\sapinst_instdir\ECC50\SYSTEM\ABAP\ORA\NUC\DB/SAP0000.log -o D

C:\usr\sap\EPT\SYS\exe\run/R3load.exe: job completed

C:\usr\sap\EPT\SYS\exe\run/R3load.exe: END OF LOG: 20090611085559

C:\usr\sap\EPT\SYS\exe\run/R3load.exe: START OF LOG: 20090611103425

C:\usr\sap\EPT\SYS\exe\run/R3load.exe: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#6 $ SAP

C:\usr\sap\EPT\SYS\exe\run/R3load.exe: version R6.40/V1.4

C:\usr\sap\EPT\SYS\exe\run/R3load.exe -dbcodepage 1100 -i C:\Program Files\sapinst_instdir\ECC50\SYSTEM\ABAP\ORA\NUC\DB/SAP0000.cmd -l C:\Program Files\sapinst_instdir\ECC50\SYSTEM\ABAP\ORA\NUC\DB/SAP0000.log -stop_on_error

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: db_connect rc = 256

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: DbSlErrorMsg rc = 99

C:\usr\sap\EPT\SYS\exe\run/R3load.exe: job finished with 1 error(s)

C:\usr\sap\EPT\SYS\exe\run/R3load.exe: END OF LOG: 20090611103428

can anybody help me to sort this out.

Any help highly appreciated.

Thanks & Regards

Subhash

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi subhash,

It seems to me MEDIA RECOVERY PROBLEM.try this commands:-

startup mount (after oracle instance started)

Recover database until cancel

if it does not work :

Recover using backup control file:

then:

alter database open resetlogs;

or check this link : - Http://www.dbspeacilists.com/presentations

hope it will work for u

Regards,

Rohit

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

also post SAP0000.log

regards

Umesh K

andreas_herzog
Active Contributor
0 Kudos

ora-1034 means "oracle not available"

-> are you able to login to your oracle instance using sqlplus?

-> is the listener process running?

-> are the oracle services running?

GreetZ, AH

Former Member
0 Kudos

Yeah i m able to login with Sqlplus

listner is running

Oracle services are also running

when i tried to found the problem i found that my database control file has some problem so i solved it out but now my problem is

C:\oracle\EPT\sapdata1\ept_21\EPT.DATA21 needs media recovery

when i execute this

Recover Datafile 'C:\oracle\EPT\sapdata1\ept_21\EPT.DATA21';

ORA-00279: change 262364 generated at 06/11/2009 09:43:56 needed for thread 1

ORA-00289: suggestion : C:\ORACLE\EPT\ORAARCH\EPTARCHARC00052_0689209324.001

ORA-00280: change 262364 for thread 1 is in sequence #52

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

now as i m not a oracle expert i am unable to understand how to recover this datafile

Thanks & Regards

Subhash

andreas_herzog
Active Contributor
0 Kudos

-> provide (archived) redolog file -> EPTARCHARC00052_0689209324.001

-> have a look <a href="http://http://www.lc.leidenuniv.nl/awcourse/oracle/server.920/a96572/performingreco.htm">HERE</a>

GreetZ, AH

Former Member
0 Kudos

First of all thanks for helping me

i have tried this

Connected to an idle instance.

SQL> STARTUP MOUNT

ORACLE instance started.

Total System Global Area 205520896 bytes

Fixed Size 1248116 bytes

Variable Size 117441676 bytes

Database Buffers 83886080 bytes

Redo Buffers 2945024 bytes

Database mounted.

SQL> SET AUTORECOVERY ON

SQL> RECOVER DATABASE

ORA-00279: change 262364 generated at 06/11/2009 09:43:56 needed for thread 1

ORA-00289: suggestion : C:\ORACLE\EPT\ORAARCH\EPTARCHARC00052_0689209324.001

ORA-00280: change 262364 for thread 1 is in sequence #52

ORA-00308: cannot open archived log

'C:\ORACLE\EPT\ORAARCH\EPTARCHARC00052_0689209324.001'

ORA-27041: unable to open file

OSD-04002: unable to open file

O/S-Error: (OS 2) The system cannot find the file specified.

But i m not able to see any archive file on oraarch folder

Regards

Subhash

former_member204746
Active Contributor
0 Kudos

try this:

sqlplus / as ssydba

startup mount

recover;

alter database open;