cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Solution manager installation

Former Member
0 Kudos

Hi Everyone,

Installing SAP Solution Manager 7.1 SR1 on Windows 2012 R2 standard edition with Oracle 12C as database.

Installation is getting stuck at Run Jload step, with listener error.

Jload -sec SMD,jdbc/pool/SMD,\\<hostname>/sapmnt/SMD/SYS/global/security/data/SecStore.properties,\\<hostname>/sapmnt/SMD/SYS/global/security/data/SecStore.key -dataDir F:\SoftwarePackages\51042609\DATA_UNITS\SOLMAN_JAVA_EXPORT_JDMP -job C:\Program Files\sapinst_instdir\SOLMAN71\SYSTEM\ORA\CENTRAL\AS\IMPORT.XML -log jload.log

Connecting to database

Couldn't connect to DB

com.sap.inst.common.exception.DBConnectionException: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

  at com.sap.inst.common.db.DBConnection.connect(DBConnection.java:157)

  at com.sap.inst.jload.Jload.main(Jload.java:222)

  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:331)

  at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)

Caused by: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

  at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)

  at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147)

  at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:257)

  at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:398)

  at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:463)

Please advise.

Regards,

Ashraf

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi All,

I have managed to resolve this issue with help from SAP by raising OSS incident.

Issue : While running Jload , in alertSID.log it was giving 12545 TNSLSNR error and if checked in listener log it is showing jdbc trying to connect with some junk IP.

Resolution steps: At first suspect was listener configuration for which this post was created.

After creating thread dump to analyse this issue we found that instead of actual IP ,installer is trying to connect database using junk IP. Few SAP notes 1568249  and 1841151 implemented but these were only applicable for resolving ping -4 <hostname>.

Solution provided by SAP is to disable NDIS server and lower down metric for public network card from network properties.

Regards,

Ashraf.

patelyogesh
Active Contributor
0 Kudos

Thanks for sharing solution.

Yogesh

Answers (5)

Answers (5)

Former Member
0 Kudos

Hi Yogesh,

changed to IP address instead of hostname in tnsnames.ora but no effect.

Major issue as of now is

Listener is running and  not identifying "SMD" as known instance but "smd" it is identifying as known instance.

Not able to login via sqlplus so couldn't register listener in database.

Regards,

Ashraf

Former Member
0 Kudos

Sorry for such big update without clear description. SCN was not allowing to copy/paste data hence I have to use HTML.

Former Member
0 Kudos

Hi Yogi, At present sapinst is stuck with Run Jload step. 1. Listener is running in system but it is not able to identify SMD instance. LSNRCTL> status Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=SMD.WORLD)) STATUS of the LISTENER ------------------------ Alias                    LISTENER Version                  TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 - Production Start Date                29-FEB-2016 11:07:25 Uptime                    0 days 0 hr. 33 min. 36 sec Trace Level              off Security                  ON: Local OS Authentication SNMP                      OFF Listener Parameter File  C:\oracle\oraclehome01\SMD\12102\network\admin\listener.ora Listener Log File        C:\oracle\SMD\saptrace\diag\tnslsnr\\listener\alert\log.xml Listening Endpoints Summary...   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\SMD.WORLDipc)))   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\SMDipc)))   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)))   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))) Services Summary... Service "SMD" has 2 instance(s).   Instance "SMD", status UNKNOWN, has 1 handler(s) for this service...   Instance "smd", status READY, has 1 handler(s) for this service... The command completed successfully LSNRCTL> exit PS C:\oracle\oraclehome01\SMD\12102\BIN> set ORACLE_SID=SMD PS C:\oracle\oraclehome01\SMD\12102\BIN> set ORACLE_HOME=C:\oracle\oraclehome01\SMD\12102\BIN PS C:\oracle\oraclehome01\SMD\12102\BIN> sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Mon Feb 29 11:44:30 2016 Copyright (c) 1982, 2013, Oracle.  All rights reserved. ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: SYS Enter password: ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: I have looked into static and dynamic registration of listener. As I am unable to login to database via SQLPLUS. 2. tnsping result PS C:\oracle\oraclehome01\SMD\12102\BIN> .\tnsping SMD TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 29-FEB-2016 10:22:44 Copyright (c) 1997, 2014, Oracle. All rights reserved. Used parameter files: \\\sapmnt\SMD\SYS\profile\oracle\sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = mpawin1 35) (PORT = 1521))) (CONNECT_DATA = (SID = SMD) (GLOBAL_NAME = SMD.WORLD))) OK (20 msec) PS C:\oracle\oraclehome01\SMD\12102\BIN> 3. Excerpt from listener.log Started with pid=1752 Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc) (PIPENAME=\\.\pipe\SMD.WORLDipc))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc) (PIPENAME=\\.\pipe\SMDipc))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=) (PORT=1521))) Listener completed notification to CRS on start TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODEWARNING: Subscription for node down event still pending 29-FEB-2016 10:04:22 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=) (USER=smdadm))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER) (VERSION=202375680)) * status * 0 Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=) (PORT=1521))) 29-FEB-2016 10:04:31 * service_register * smd * 0 29-FEB-2016 10:07:13 * (CONNECT_DATA=(SID=SMD)(CID=(PROGRAM=) (HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=169.254.182.77% 16)(PORT=64831)) * establish * SMD * 0 29-FEB-2016 10:14:32 * service_update * smd * 0 4. Excerpt from alertSMD.log Fatal NI connect error 12545, connecting to: (LOCAL=NO) VERSION INFORMATION: TNS for 64-bit Windows: Version 12.1.0.2.0 - Production Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 12.1.0.2.0 - Production Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 12.1.0.2.0 - Production Time: 29-FEB-2016 10:07:13 Tracing not turned on. Tns error struct: ns main err code: 12545 TNS-12545: Connect failed because target host or object does not exist ns secondary err code: 12560 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 Mon Feb 29 10:07:13 2016 opiodr aborting process unknown ospid (4648) as a result of ORA-609 Regards, Ashraf

patelyogesh
Active Contributor
0 Kudos

Hello,

Did you try changing in TNSNAMES.ORA file the host name to a  IP address?

-Yogi

patelyogesh
Active Contributor
0 Kudos

Question???

Is this distributed installation or central?

If distributed you need native client installed.

-Yogi

former_member182657
Active Contributor
0 Kudos

Hi Ashraf,


Connecting to database

Couldn't connect to DB

Would you please test the database connection or check your DB should be in running state ? If possible try to restart the system once & start the listener & then database to proceed further.

Hope this will help you.

Regards,