SAP NW7.0 SR3 Java AddIn Installation failed at "Import Java dump"

[Former Member]

Dear all,

I get an error at Java AddIn Installation SAP Netweaver 7.0 SR3

(Software Life-Cycle Option -> Java Add-In for ABAP -> Oracle ->

Central System ->)

The first installation step "Central Services Instance (SCS) Java Add-

In" I have installed it without errors.

The Installation failed at 2nd step "Database Instance Java Add-In" at phase 11

of 14 "Import java dump":

26.05.09 15:16:46 com.sap.inst.jload.Jload main
INFO: Jload -sec
Q2B,jdbc/pool/Q2B,/usr/sap/Q2B/SYS/global/security/data/SecStore.properties,/usr/sap/Q2B/SYS/global/security/
data/SecStore.key -
dataDir /usr/sap/swdc/51033513/DATA_UNITS/JAVA_EXPORT_JDMP -
job /tmp/sapinst_instdir/NW04S/LM/AS-JAVA/ADDIN
/ORA/CENTRAL/DB/IMPORT.XML -log jload.log

26.05.09 15:16:47 com.sap.inst.jload.Jload main
SEVERE: couldn't connect to DB


26.05.09 15:16:47 com.sap.inst.jload.Jload logStackTrace
SEVERE: java.sql.SQLException: Io exception: The Network Adapter could
not establish the connection
at oracle.jdbc.driver.DatabaseError.throwSqlException
(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException
(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException
(DatabaseError.java:255)
at oracle.jdbc.driver.T4CConnection.logon
(T4CConnection.java:387)
at oracle.jdbc.driver.PhysicalConnection.<init>
(PhysicalConnection.java:420)
at oracle.jdbc.driver.T4CConnection.<init>
(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection
(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect
(OracleDriver.java:801)
at
com.sap.sql.jdbc.NativeConnectionFactory.createNativeConnection
(NativeConnectionFactory.java:215)
at com.sap.sql.connect.OpenSQLDataSourceImpl.createConnection
(OpenSQLDataSourceImpl.java:522)
at com.sap.sql.connect.OpenSQLDataSourceImpl.getConnection
(OpenSQLDataSourceImpl.java:276)
at com.sap.inst.jload.db.DBConnection.connectViaSecureStore
(DBConnection.java:105)
at com.sap.inst.jload.db.DBConnection.connect
(DBConnection.java:149)
at com.sap.inst.jload.Jload.main(Jload.java:580)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke
(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.sap.engine.offline.OfflineToolStart.main
(OfflineToolStart.java:81)

the database is up and running, the Oracle Listener is also working well.

Any idea??

Thanks so much in advance!

Best Regards,

Gerd

[Former Member]

Hi Sunny, hi Markus!

many thanks for your hints!

I've just solved the problem. The problem was, our Listener was not configured correctly.

I've adjusted the listener.ora, tnsnames.ora to the correct hostname - cause, we had a hostname-switch last month and I had forgotten to adapt the Listener...

now the Listener is running as well:

mcho35au:oraq2b 120% lsnrctl status LISTENER_Q2B

LSNRCTL for Solaris: Version 10.2.0.4.0 - Production on 30-MAY-2009
09:52:48

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=Q2B.WORLD))
STATUS of the LISTENER
------------------------
Alias LISTENER_Q2B
Version TNSLSNR for Solaris: Version 10.2.0.4.0 -
Production
Start Date 30-MAY-2009 09:52:15
Uptime 0 days 0 hr. 0 min. 32 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/Q2B/102_64/network/admin/listener.ora
Listener Log
File /oracle/Q2B/102_64/network/log/listener_q2b.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=Q2B.WORLD)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=Q2B)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=mcho35au)(PORT=1527)))
Services Summary...
Service "Q2B" has 1 instance(s).
Instance "Q2B", status UNKNOWN, has 1 handler(s) for this service...
Service "Q2B.WORLD" has 1 instance(s).
Instance "Q2B", status READY, has 1 handler(s) for this service...
Service "Q2B_XPT.WORLD" has 1 instance(s).
Instance "Q2B", status READY, has 1 handler(s) for this service...
The command completed successfully

meanwhile the step "Import java dump" has finished successfully!

Thanks to all!

Best Regards,

Gerd

Edited by: Gerd Schuster on May 30, 2009 10:29 AM

[markus_doehr2]

> 26.05.09 15:16:47 com.sap.inst.jload.Jload logStackTrace

> SEVERE: java.sql.SQLException: Io exception: The Network Adapter could

> not establish the connection

> the database is up and running, the Oracle Listener is also working well.

What database patchlevel and JDBC driver are you using?

Markus

[sunny_pahuja2]

Hi

As Java is not able to connect to database. Could you please check user id and password that is trying to connect to database ?

Thanks

Sunny