cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-03113 error

Former Member
0 Kudos

Hi,

I started off installing AS ABAP and AS JAVA of NW2004s with Oracle database on Windows 2003 as a Central System. The installation hung almost for 10 hours without any activity in "Create Database" Phase. When I checked out the log files I found this ORA-03113 : end-of-file communication error, which is followed by ORA-03114 : Not Connected to Oracle. Could anyone guide me on how to resolve this error?

Thanks in advance,

Visu

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Thanks Stefan,

I assumed that there was some problem with Oracle 10g installation, and re-installed it. This time, I didn't install the starter database and went ahead with the software only. That's because some 700MB of memory is allocated to the starter database, and I used the same for the installation. I thought that could be a problem. After I re-installed, it worked fine.

Now I am into another problem :

DBSL Trace: OCI-call 'OCIServerAttach' failed with rc=12541

DBSL Trace: Connect failed with sql error '12541'

(DB) Error: db_connect rc = 256

DBSL Trace: OCI-call 'OCIServerAttach' failed with rc=12541

DBSL Trace: Connect failed with sql error '12541'

(DB) Error: db_connect rc = 99

In one of the forums, there was a solution to increase the swap memory for this kind of problem. But it didn't work for me. Could you please guide me out? This is happening in the "Import ABAP" phase.

Thanks,

Visu

stefan_koehler
Active Contributor
0 Kudos

Hello Visu,

the ORA-12541 error leads to a SLQ*Net problem.

It seems like the listener is not running (it is needed to get a connection the the database via SQL*Net).

Information: http://ora-12541.ora-code.com/

Just check it with the command:

> shell> lsnrctl status

> shell> lsnrctl start

> This time, I didn't install the starter database and went ahead with the software only. That's because some 700MB of memory is allocated to the starter database, and I used the same for the installation.

Yeah you have only to install the oracle software. The database itself is created by SAPINST .. have you used the installer from SAP for the oracle installation? If you don't use the oracle installer from SAP, maybe your listener is not configured correct.

Regards

Stefan

Former Member
0 Kudos

Thanks Stefan,

The problem was I have restarted the desktop, and the listener was configured to be manual. When I started the listener, it worked. And the next issue that arose is:

Loading of 'SAPSSEXC' import package: ERROR

Import Monitor jobs: running 2, waiting 1, completed 14, failed 1, total 18.

Loading of 'SAPAPPL1' import package: ERROR

Import Monitor jobs: running 1, waiting 1, completed 14, failed 2, total 18.

Loading of 'SAPAPPL2' import package: ERROR

Import Monitor jobs: running 0, waiting 1, completed 14, failed 3, total 18.

ERROR: 2010-08-03 03:05:28 com.sap.inst.migmon.LoadTask run

Loading of 'SAPSSEXC' import package is interrupted with R3load error.

Process 'D:\usr\sap\NEK\SYS\exe\uc\NTI386\R3load.exe -i SAPSSEXC.cmd -dbcodepage 4103 -l SAPSSEXC.log -stop_on_error' exited with return code 2.

For mode details see 'SAPSSEXC.log' file.

Standard error output:

sapparam: sapargv( argc, argv) has not been called.

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

ERROR: 2010-08-03 03:05:29 com.sap.inst.migmon.LoadTask run

Loading of 'SAPAPPL1' import package is interrupted with R3load error.

Process 'D:\usr\sap\NEK\SYS\exe\uc\NTI386\R3load.exe -i SAPAPPL1.cmd -dbcodepage 4103 -l SAPAPPL1.log -stop_on_error' exited with return code 2.

For mode details see 'SAPAPPL1.log' file.

Standard error output:

sapparam: sapargv( argc, argv) has not been called.

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

ERROR: 2010-08-03 03:05:29 com.sap.inst.migmon.LoadTask run

Loading of 'SAPAPPL2' import package is interrupted with R3load error.

Process 'D:\usr\sap\NEK\SYS\exe\uc\NTI386\R3load.exe -i SAPAPPL2.cmd -dbcodepage 4103 -l SAPAPPL2.log -stop_on_error' exited with return code 2.

For mode details see 'SAPAPPL2.log' file.

Standard error output:

sapparam: sapargv( argc, argv) has not been called.

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

WARNING: 2010-08-03 03:05:56

Cannot start import of packages with views because not all import packages with tables are loaded successfully.

WARNING: 2010-08-03 03:05:56

3 error(s) during processing of packages.

Could you please figure out exactly what it is? The above mentioned errors are in import_monitor.java.log and import_monitor.log.

Regards,

Visu

Former Member
0 Kudos

Hello Visu. Are you read your post before posting? For eexample this lines:

For mode details see 'SAPSSEXC.log' file

For mode details see 'SAPAPPL1.log' file

For mode details see 'SAPAPPL2.log' file

P.S. do not post all files content if it so beeg. Post error and 10 lines before errors in this log files.

Regards.

Former Member
0 Kudos

Thanks Sergo,

I overlooked those files. From those files, I found the following error:

Dbsl Trace: ORA-1403 when accessing table SAPUSER

(RPF) Error: file SAPSSEXC.001 not found

(RPF) Error: file SAPAPPL1.001 not found

(RPF) Error: file SAPAPPL2.001 not found

What am I supposed to do now?

Regards,

Visu

markus_doehr2
Active Contributor
0 Kudos

It seems that the export is not complete.

Did you unpack/unzip the DVDs with full paths? Can you find those files on the installation source?

Markus

Former Member
0 Kudos

Are you see this files in your CD/DVD dump? Can you say the Paths where you copy CD/DVD on hard disk?

Are you downloaded files correct ?

P.S. to Markus, I did not repeat your question, I was during the answer and did not see you post...sorry.

Regards.

Former Member
0 Kudos

Thanks Sergo and Markus,

I found the corresponding files to be missing. I unzipped them again, and now it's going fine.

Regards,

Visu

Answers (1)

Answers (1)

stefan_koehler
Active Contributor
0 Kudos

Hello Visu,

unfortunately you don' tell us your oracel version, but i think you are using oracle 10g (because of the NW 2004s) installation.

Just check sapnote #1005758

If this sapnote does not fit, please post the alert.log file of the database, because you said that you have the problem in the "CREATE DATABASE" phase. Also please post the listener.log.

Regards

Stefan