on 01-14-2015 5:45 PM
Hi all
we have a new system installed on linux host , from dpmon we can check sap is up and running
but from my windows laptop when I try sapgui , for this new system the sapgui is not coming up
for other systems sapgui is responding fine
from where to start the troubleshooting
does 21212 and 21200 ports should be open on my windows laptop ? or on linux host ?
Regards
@Gaurav , @ramkrishna , @S BASIS , @Stanislav , @Christopher
Thanks you all for your responses
here is the solution worked
copied the sqlnet.ora from /network/admin to profile directroy oracle folder (if not similar)
updated ms_acl_info with new ip from global directory
from etc/hosts removed old ip
stopped sap, manually stopped db , stopped listener
started listener
started sap with startsap all
the above steps worked
scenario :new host got ip number changed ,recently
Thanks again
want to know apart from sdn , which other forum by sap you guys prefer positing queries on
SAP Basis or Netweaver , pl let me know.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
ORA-12170: TNS:Connect timeout occurred
Please follow SAP Note 1911531 - ORA-12170 or TNS-12535 during connecting to Oracle
Also make sure oracle listener should be under running state & send me the output results for command ps -ef |grep ora & lsnrctl status
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Add SAP server ip address in host file of your laptop...
Regards
s.Basis
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
but from my windows laptop when I try sapgui , for this new system the sapgui is not coming up
Try to disable any firewall or antivirus on your system if any and share the error message from your system as per you same connection is working fine from other systems.
for other systems sapgui is responding fine
Also share results for below commands at server end
> ps -ef |grep dw
>ps -ef |grep ora (If DB is oracle)
trans.log file after execution of R3trans -d
Last you need to check are you able to resolve server host name or server IP from your laptop ?
Regards,
Gaurav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Gaurav
you are right
R3trans -d is giving the below output
OCIServerAttach(OCI_DEFAULT) failed with -1=OCI_ERROR
OCIServerAttach(OCI_DEFAULT) failed with SQL error 12170:
ORA-12170: TNS:Connect timeout occurred
ERROR => CONNECT failed with SQL error '12170'
OCIServerAttach failed for 'PR1'
OCIErrorGet() -> SQL error code: 12170
ORA-12170: TNS:Connect timeout occurred
Following worked fine from me
from my laptop i checked telnet <ipadress> 3200 --- it connected
Regards
if R3trans is giving an error check for listener
can you check as prdadm : tnsping PRD
as oraprd : lsnrctl status
post output here
by the way PR1 ? what is that
21212 and 21200 are gui/dialog ports for SWPM/Sapinst
as for a connection you need to have connection to gateway : 3200 and message server 3600
dpmon process ins only database process
check if u have dw process in linux host like
dw.sap<SID>_DVEBMGS00 pf=/usr/sap/<SID>/SYS/profile/<SID>_DVEBMGS00_hostname
check: ps -fea|grep dw
Christopher Arias
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Christopher
Thank you for the Response
but , ps -ef | grep dw
gives very much output , dispatcher is running on the linux host , this is the new system installed.
dw.sapPRD_DVEBMGS00 pf=/usr/sap/PRD/SYS/profile/PRD_DVEBMGS00_x233PRDcidb
dw.sapPRD_DVEBMGS00 pf=/usr/sap/PRD/SYS/profile/PRD_DVEBMGS00_x233PRDcidb
dw.sapPRD_DVEBMGS00 pf=/usr/sap/PRD/SYS/profile/PRD_DVEBMGS00_x233PRDcidb
dw.sapPRD_DVEBMGS00 pf=/usr/sap/PRD/SYS/profile/PRD_DVEBMGS00_x233PRDcidb
dw.sapPRD_DVEBMGS00 pf=/usr/sap/PRD/SYS/profile/PRD_DVEBMGS00_x233PRDcidb
dw.sapPRD_DVEBMGS00 pf=/usr/sap/PRD/SYS/profile/PRD_DVEBMGS00_x233PRDcidb
dw.sapPRD_DVEBMGS00 pf=/usr/sap/PRD/SYS/profile/PRD_DVEBMGS00_x233PRDcidb
dw.sapPRD_DVEBMGS00 pf=/usr/sap/PRD/SYS/profile/PRD_DVEBMGS00_x233PRDcidb
dw.sapPRD_DVEBMGS00 pf=/usr/sap/PRD/SYS/profile/PRD_DVEBMGS00_x233PRDcidb
dw.sapPRD_DVEBMGS00 pf=/usr/sap/PRD/SYS/profile/PRD_DVEBMGS00_x233PRDcidb
where to check for the ports 21212 and 21200
on my lap top with netstat -a ? how to grep for 21212
or
on linux host netstat -a | grep 21212
User | Count |
---|---|
86 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.