Tagged: tns or sqlnet issue
- This topic is empty.
9 August, 2010 at 7:20 pm #1931Amit BansalKeymaster
In 11gR2 RAC, the alert log keeps showing the below errors, the ticket has opened to Oracle support for 1 week. No any progress.
Thanks in advance.
Fatal NI connect error 12533, connecting to:
TNS for Linux: Version 18.104.22.168.0 – Production
Time: 09-AUG-2010 18:55:19
Tracing not turned on.
Tns error struct:
ns main err code: 12533
TNS-12533: TNS:illegal ADDRESS parameters
ns secondary err code: 12560
nt main err code: 503
TNS-00503: Illegal ADDRESS parameters
nt secondary err code: 0
nt OS err code: 0
10 August, 2010 at 7:56 am #2115suvvParticipant
The TNS-12533 error usually occurs when the protocol specific parameters in
the ADDRESS section of the designated connect descriptor in the TNSNAMES.ORA
are incorrect.Verify if the entries are correct with a simple connect string
SQLPLUS SCOTT/[email protected]
If there is no issue for tns entries ,The next thing in a RAC configuration i will verify is the LOCAL_LISTENER and REMOTE_LISTENER settings.I have seen issues where this error is reported for incorrect LOCAL_LISTENER and REMOTE_LISTENER settings.
10 August, 2010 at 8:23 am #2116Amit BansalKeymaster
Why are there two entries for Description in tns entry
<br /> (DESCRIPTION=(DESCRIPTION=<br />
You have mentioned that this entries are mentioned in alert log. Have you checked the client from which it is coming. Also as Suvv sugested try checking local_listener and remote_listener value. Note that if you are using scan (11gr2), remote_listener should be scanname:<port>
- You must be logged in to reply to this topic.