on 07-26-2011 7:50 AM
Dear All
We have completed the SAP Installation on Redhat Linux 5 and Oracle10g,We are able to start the listener and SAP, the dispatcher is also running however when we click on SAP GUI frontend we are getting resource temporarily unavailable error.tnsping to SID is also working fine.Below is the sqlnet.log output
ED1SRV:ed1adm 1> more sqlnet.log
***********************************************************************
Fatal NI connect error 12541, connecting to:
(DESCRIPTION=(ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=ED1SRV)(PORT=152
7))(CONNECT_DATA=(SID=ED1)(GLOBAL_NAME=ED1.WORLD)(CID=(PROGRAM=R3trans@ED1SRV)(H
OST=ED1SRV)(USER=ed1adm))))
VERSION INFORMATION:
TNS for Linux: Version 10.2.0.2.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 10.2.0.2.0 - Production
Time: 23-JUL-2011 12:40:46
Tracing not turned on.
Tns error struct:
ns main err code: 12541
TNS-12541: TNS:no listener
ns secondary err code: 12560
nt main err code: 511
TNS-00511: No listener
nt secondary err code: 111
nt OS err code: 0
***********************************************************************
Fatal NI connect error 12541, connecting to:
(DESCRIPTION=(ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=ED1SRV)(PORT=152
7))(CONNECT_DATA=(SID=ED1)(GLOBAL_NAME=ED1.WORLD)(CID=(PROGRAM=R3trans)(HOST=ED1
SRV)(USER=ed1adm))))
VERSION INFORMATION:
TNS for Linux: Version 10.2.0.2.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 10.2.0.2.0 - Production
Time: 23-JUL-2011 12:40:46
Tracing not turned on.
Tns error struct:
ns main err code: 12541
TNS-12541: TNS:no listener
ns secondary err code: 12560
nt main err code: 511
TNS-00511: No listener
nt secondary err code: 111
nt OS err code: 0
Kindly suggest the necessary action.
Mahesh
Hi,
Please check the Note 609332 Composite note: ORA-12541/ORA-12224.
If this does not help, please analyse the listener.log for further analysis.
$ORACLE_HOME/network/log/listener.log.
Regards,
Aidan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Aidan
Thank you very much for your reply.
I went through all the related notes provided by you.However, the entries in tnsnames.ora and listener.ora are identical and listener.log is also not having any error even R3trans -x is also returning with 0 error code.Kindly let me know where else can i find the cause of the error.
Thanks in Advance
Mahesh
Hi,
Please check note 562403 and execute the four tests in item 15.
With these results, you can troubleshoot your issue using the
information of this note.
I would like to suggest you take a full check on the enviroment
variables of your <sid>adm user and make sure that it use the right
directory when starting the listener.
Has the environment variable SAPSYSTEMNAME set correctly in the
environment of SIDADM?
Please also check if the database parameters were set correctly as per
Note 830576.
Regards,
Aidan
Dear Aidan
Thank you very much for your reply and providing for some vital information about the FAQs on oracle.
As per your suggestion i went through the SAP note 562403 4 steps of 15th FAQ 3 steps are working fine except one wherein i am getting error when i am trying to login as below:
oraed1> sqlplus "sysdba/Sahiba@123"
SQL*Plus: Release 10.2.0.4.0 - Production on Fri Jul 29 11:34:52 2011
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Kindly suggest the further action.
Thanks in Advance
Mahesh
Hi,
For assistance with the ora-12154 error please refer to the
folowing note:
443867 - ORA-12154 Collective SAP note
https://service.sap.com/sap/support/notes/443867
Regards,
Aidan
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
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.