DbSl Trace: CONNECT failed with sql error '12518' at IMPORT ABAP

[Former Member]

Hi

We are trying to install ECC 6.0 on windows 2008 SP2 and oracle 10.2.0.4. We get an error at IMPORT ABAP phase.

content of import_monitor.java :

java version "1.4.2_26"

Java(TM) Platform, Standard Edition for Business (build 1.4.2_26-b03)

Java HotSpot(TM) 64-Bit Server VM (build 1.4.2_26-b03, mixed mode)

Import Monitor jobs: running 1, waiting 1, completed 26, failed 0, total 28.

Loading of 'SAPSLOAD' import package: ERROR

Import Monitor jobs: running 0, waiting 1, completed 26, failed 1, total 28.

content of SAPSLOAD.log:

...

E:\usr\sap\UED\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20100705173108

E:\usr\sap\UED\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/701_REL/src/R3ld/R3load/R3ldmain.c#5 $ SAP

E:\usr\sap\UED\SYS\exe\uc\NTAMD64\R3load.exe: version R7.01/V1.4 [UNICODE]

Compiled Feb 24 2009 23:41:07

E:\usr\sap\UED\SYS\exe\uc\NTAMD64\R3load.exe -i SAPSLOAD.cmd -dbcodepage 4103 -l SAPSLOAD.log -stop_on_error

DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12518

DbSl Trace: CONNECT failed with sql error '12518'

DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12518

DbSl Trace: CONNECT failed with sql error '12518'

(DB) ERROR: db_connect rc = 256

DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12518

DbSl Trace: CONNECT failed with sql error '12518'

DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12518

DbSl Trace: CONNECT failed with sql error '12518'

(DB) ERROR: DbSlErrorMsg rc = 99

E:\usr\sap\UED\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

E:\usr\sap\UED\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20100705173108

content of sqlnet.log file:

Fatal NI connect error 12560, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleUED)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=UED)(CID=(PROGRAM=E:\oracle\UED\102\bin\sqlplus.exe)(HOST=U34SSAPUED)(USER=uedadm))))

VERSION INFORMATION:

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 10.2.0.4.0 - Production

Time: 05-JUL-2010 16:19:39

Tracing not turned on.

Tns error struct:

ns main err code: 12560

TNS-12560: TNS:protocol adapter error

ns secondary err code: 0

nt main err code: 530

TNS-00530: Protocol adapter error

nt secondary err code: 2

nt OS err code: 0

Fatal NI connect error 12518, connecting to:

(DESCRIPTION=(ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=u34ssapued)(PORT=1527))(CONNECT_DATA=(SID=UED)(GLOBAL_NAME=UED.WORLD)(CID=(PROGRAM=E:\usr\sap\UED\SYS\exe\uc\NTAMD64\R3load.exe)(HOST=U34SSAPUED)(USER=uedadm))))

VERSION INFORMATION:

TNS for 64-bit Windows: Version 10.2.0.2.0 - Production

Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 10.2.0.2.0 - Production

Time: 05-JUL-2010 17:28:38

Tracing not turned on.

Tns error struct:

ns main err code: 12564

TNS-12564: TNS:connection refused

ns secondary err code: 0

nt main err code: 0

nt secondary err code: 0

nt OS err code: 0

Best Regards...,

[former_member204746]

a few possibilities:

1. your Oracle database is down

2. your Oracle listener is down

3. your Oracle listener is badly configured

[Former Member]

Hi again.

I've solved problem. Oracle was stopped or started succesfully, I also restarted server and change some oracle parameters. But these did not solved problem.

I've uninstalled SAP and Oracle, reduced to java version to 1.4.2_17 and set paralel process number to 2. Now IMPORT ABAP phase has been passed.

Bes Regards...

[Former Member]

Hi,

TNS-12560: TNS:protocol adapter error

Probably your listener or database is down...

If both are running, just stop the installation and reboot the server.

Then again start listener and database and continue SAP installation with "Continue old installation" option..

Also make sure that below environment variables are set properly...

ORACLE_HOME

ORACLE_SID

DBSID

Regards.

Rajesh Narkhede

[Former Member]

Hi,

Check [this link|;

Regards,

Varadhu

Edited by: Varadhu on Jul 6, 2010 2:03 PM