Banner 468 x 60px

Wednesday, June 26, 2013

Can not download reports through SAPGUI

0 comments
Error:

 

While downloading SAP reports to desktop or local disk , user gets message not able to copy and GUI Security popup appears.

 

 

​​
Resolution :

 

This error persists due to security configuration in SAP GUI. To resolve this goto SAPGUI Options > Security > Security Settings and "Disable" Security mode.

 

 


Read more...

Oracle Listener Can not Start - TNS-12541: TNS:no listener

0 comments
Error :

Oracle listener cannot start and gives error return code1.


Environment:

OS : Windows Server 2008, DB : Oracle 11g, SAP ECC 6 .0 EHP6

Investigations :

Look into logs

C:\Program Files\sapinst_instdir\ERPEhP6\AS-ABAP\ORA\CENTRAL\lsnrctl.log

LSNRCTL for 64-bit Windows: Version 11.2.0.3.0 - Production on 24-JUN-2013 18:33:56

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   64-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SIDHOST.local)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   64-bit Windows Error: 61: Unknown error
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=GDI.WORLD)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   64-bit Windows Error: 2: No such file or directory


Resolution:

Look into the usage of port . i.e Other application may using the same port. To know port usage at windows command prompt execute

netstat -ano | findstr 1521 > This command gives if the port is free or its been using by any other application.  If output is ESTABLISHED it means this port is used by some application and command gives process id using this port.

C:\Users\Administrator>netstat -ano | findstr 1521

  TCP    192.168.8.115:1521     192.168.8.115:56157    ESTABLISHED     9682
  TCP    192.168.8.115:1521     192.168.8.115:56158    ESTABLISHED     9682

tasklist /SVC /FI "PID eq 9682" > This command will give you application name holding this process id. Alternatively you can see in windows task manager.

C:\Users\Administrator>tasklist /SVC /FI "PID eq 9682"

Image Name                     PID Services
========================= ======== ====================
java.exe                      9892 N/A

Now we have two options left. Either change port for listener or change other applications port which is using this port 1521.

In my scenario I have gone for changing port for oracle listener in file listener.ora at path C:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora.  Changed default port 1521 to free port 1527.


Start oracle listener from services.msc or command prompt. This solved my issue and installation moved further.


​​Keywords:


TNS-12541: TNS:no listener,  TNS-12560: TNS:protocol adapter error ,   TNS-00511: No listener


Read more...

Wrong Kernel DVD Popup Message

0 comments
Issue :

 

You are using SAP software provision manager for installing an SAP system. At define parameters phase you need to input kernel DVD. Even after giving correct media label tool gives wrong media error.

 

 

 

 

Resolution :

 

1.       Download Unicode, non Unicode and SL Controller 720/700

2.       Extract related kernel DVD

3.       Extract other kernel DVD and SL Controller

4.       Put all extracted folder to DATA_UNITS folder of original kernel DVD.

                                                                                                                                                                                                                                                        

Reference:

 

SAP Note : 1654937 - How to correctly build the SAP Netweaver Kernel Media

Read more...