AskDBA.org Forum Forum for Oracle DBA's

About This Topic

• Posted 1 year ago
• By
• Latest reply from Amit Bansal
• This topic is not a support question
• RSS feed for this topic

Tags

• tns or sqlnet issue

1. 

   Anonymous
   

   
   
   Posts: 1

   offline

   Reputation:2

    

   
   Posted 1 year ago
   #

   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:
   (DESCRIPTION=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rss-db205-vip.mtnk)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=RSSDB)(INSTANCE_NAME=RSSDB1)(CID=(PROGRAM=oracle)(HOST=rss-db205.mtnk)(USER=oracle))))

   VERSION INFORMATION:
   TNS for Linux: Version 11.2.0.1.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
2. 

   suvv
   

   new member
   Joined: Aug '10
   Posts: 1

   offline

   Reputation:1

    

   
   Posted 1 year ago
   #

   Hello Mic,

   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/TIGER@SERVICENAME

   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.

   Thanks
   Suvv
3. 

   Amit Bansal
   

   Oracle DBA
   Joined: Jun '08
   Posts: 73

   offline

   Reputation:96

    

   
   Posted 1 year ago
   #

   Mic,

   Why are there two entries for Description in tns entry

   (DESCRIPTION=(DESCRIPTION=
   

   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>

   -Amit

   Cheers
   Amit
   http://askdba.org/weblog/