on 12-30-2010 5:38 PM
Hi Experts,
When i tried to start the Listner, it gives an error.
C:\Documents and Settings\hmtadm>lsnrctl
LSNRCTL for 32-bit Windows: Version 9.2.0.4.0 - Production on 30-DEC-2010 23:03:
27
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=10.22.10.183)(HOST=sapserver)(PORT
=1521)))
TNS-12538: TNS:no such protocol adapter
TNS-12560: TNS:protocol adapter error
TNS-00508: No such protocol adapter
LSNRCTL>
Please revert if any know solution for this issue...
Thanks in advanced
Regards
Hemant
First you have to start the listener and ten see the status..
In the above reply see how to start the listener and then see the status.
To start listener simple use start command after you have entered the listener prompt.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thanks issue resolved
Hemant G
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
- try to issue command : lsnrctl start <your oracle SID> example : lsnrctl start PRD
- if you have are facing the same problem, would you delete old listener and re-create listener with Net Configuration Assistant ?
- if still error, can you paste your tnsnames.ora and listener.ora here ?
hope it help you.
rgds,
Alfonsus Guritno
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Refer SAP Note 654717. It might help you to resolve the issue.
Regards,
Sachin Rane.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
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.