TNS Error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: TNS Error

Hybrid View

  1. #1
    Join Date
    Sep 2000
    Posts
    17

    Exclamation

    Hi,

    When I am trying to create a service name, I am getting TNS-12571 TNSacket writer failure error.. What could be the reason?

    Pls help me..

    nag

  2. #2
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    The ora-12571 is usually an indication of the following:
    Check for possible network or network related equipment problems, such a bad router card.
    Check for any duplicate ip address in your configuration files, TNSNAMES.ORA and
    LISTENER.ORA

    EDIT the SQLNET.ORA file on the client and server. Remove the following entry from the
    SQLNET.ORA file on both the client and
    server:
    SQLNET.EXPIRE_TIME=0


    In case of any help please be free to ask me at rohitsn@altavista.com

    Regards,
    Rohit Nirkhe,Oracle DBA,OCP 8i
    rohitsn@altavista.com

  3. #3
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    Investigate ?

    Hi, 17th May 2001 18:29 hrs

    1)Switch on the tracing .It should tell where the data is being lost.

    2)try to ping from client as well as from server to the client ?

    3)Check with invalid NLS_LANG settings in the registry.
    Go to HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE and check the NLS settings for continuity with the settings of the db on the server. One could delete these settings in the registry
    of the pc and the NLS would default to that of the server.

    4)Check with the system admin any existing network problem

    Cheers

    Padmam




    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width