on 02-26-2016 8:37 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry for such big update without clear description. SCN was not allowing to copy/paste data hence I have to use HTML.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Question???
Is this distributed installation or central?
If distributed you need native client installed.
-Yogi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.