Page 1 of 2 12 LastLast
Results 1 to 15 of 23
  1. #1
    Join Date
    Aug 2003
    Posts
    9

    Unanswered: ORA-12571 help needed

    Hi.

    I am the unfortunate backup for our Oracle DBA who is enjoying a vacation right now, so I would much appreciate any help that is available.

    I have a customer who has an application that uses the Oracle 8.1.6 client. That client is giving the following error when the user goes to connect to the database (start the application):

    ORA-12571
    TNS: packet writer failure

    They have uninstalled and re-installed the client on the user's machine only to have the error pop up again and again.

    The user can log on from another machine, but is unable to make the connection from his own. Other users who can successfully log into through their own desktop cannot do so through this machine.

    Help?

    TIA,
    Adria Carbo
    Computing & Information Services
    Texas A&M University
    a-carbo@tamu.edu

  2. #2
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    I think you need to check the TNSNAMES.ORA file, it sounds like it doesn't have the right entries.

    The simple solution is to copy it from a machine that can connect. The complex solution is to understand the entries in TNSNAMES.ORA (it's a text file) and consider an automated delivery mechanism.

    HTH
    Bill

  3. #3
    Join Date
    Aug 2003
    Posts
    9
    Thank you so much for your suggestion!

    I've just checked the tnsnames.ora file. It is the same as on other machines, but just to be sure a "clean copy" was pulled down from another server and we're still getting the same error.

    I'd appreciate any other suggestions.

    Best,
    Adria

  4. #4
    Join Date
    Jul 2003
    Posts
    2,296
    Could this be a firewall issue?

    ie: this machine is not on the same side of the firewall as the others that can connect?
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  5. #5
    Join Date
    Aug 2003
    Posts
    9
    The machine is on the same side of the firewalll as the Oracle server.

    Again, thank you for your input! I truly appreciate it.

    Best,
    Adria

  6. #6
    Join Date
    Jul 2003
    Posts
    2,296
    only other thing I can think of is your sqlnet.ora file.

    is the default domain set the same as the other clients?
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  7. #7
    Join Date
    Aug 2003
    Posts
    9
    the sqlnet.ora file is the same on the problem machine as all others. It looks like this:

    # SQLNET.ORA Network Configuration File: X:\Oracle\Ora81\network\admin\sqlnet.ora
    # Generated by Oracle configuration tools.

    SQLNET.AUTHENTICATION_SERVICES= (NTS)

    NAMES.DIRECTORY_PATH= (TNSNAMES)


    the tnsnames.ora file looks something like this:

    # TNSNAMES.ORA Network Configuration File: X:\Oracle\Ora81\network\admin\tnsnames.ora
    # Generated by Oracle configuration tools.
    # The "(SERVER=DEDICATED)" line in "CONNECT_DATA" was added by System Programmer on 06-19-03 per
    # DBA in an attempt to fix the long-standing "pause" problem in application.

    MYORACLEDB =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = hostname.tamu.edu)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = myoracledb.tamu.edu)
    (SERVER=DEDICATED)
    )
    )

  8. #8
    Join Date
    Jul 2003
    Posts
    2,296
    change your sqlnet.ora file to reflect this:

    Code:
    NAMES.DEFAULT_DOMAIN = tamu.edu
    
    SQLNET.AUTHENTICATION_SERVICES= (NTS)
    
    NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  9. #9
    Join Date
    Aug 2003
    Posts
    9
    Thank you so much for your suggestions. I made the changes you suggested and got another error (though at least a different one).

    Now, when the application attempts to connect to the database, they get the following:

    Unable to connect to the database.

    DB Error Code: 12541
    DB Error Message: ORA-12541 TNS: no listener

    Any thoughts?

    Best,
    Adria

  10. #10
    Join Date
    Jul 2003
    Posts
    2,296
    I would say post your listener.ora file that is on the host.
    Make sure the listener is up (which I am sure it is): lsnrctl stat
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  11. #11
    Join Date
    Jul 2003
    Location
    US
    Posts
    314

    Arrow Firewall Issue (Most certianly)

    Hi
    I was watching this issue for sometime, and I thought it would have been resolved by now.
    The point here about no TNS listener, came my way few days back, when I was trying to connect TOAD to the Oracle running on our production servers.

    I figured out after fighting and looking for help around, that it for due the reason there was a firewall between me and the server. So I can to configure SSH tunneling betwen the 2 machines using port forwarding.

    Tell me are you using SSH to connect to the server. If yes, I am sure we would be able to resolve this issue in just 1-2 more postings.

    If no, make sure the TNS listener is running on your machine. Start lsnrctl which automatically starts the TNS listener.

    TaR (Thanx and Regards)
    Aruneesh

  12. #12
    Join Date
    Aug 2003
    Posts
    9
    here is the listener.ora file:

    # LISTENER.ORA Configuration File:/ora1/app/oracle/product/8.1.6/network/admin/listener.ora
    # Generated by Oracle configuration tools.

    LISTENER =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oblio.tamu.edu)(PORT = 1521))
    (ADDRESS = (PROTOCOL = IPC)(KEY = CIS))
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME = CIS.TAMU.EDU)
    (ORACLE_HOME = /ora1/app/oracle/product/8.1.6)
    (SID_NAME = CIS)
    )
    )

    As for this being a firewall issue ... I'm unclear on how that would affect only 1 user's machine and not the rest of them. The guy can literall walk to the next machine in the cubicle and get on just fine. I do admit a great deficit in my understanding of network issues though. ;+)

    As always, thank you so very much for your input! I am learning so much!

    Best,
    Adria

  13. #13
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Smile

    You can enable the tracing on both server and client sides. The logs could give you some clues.

    Just my 2 cents here ...

    clio_usa
    OCP - DBA
    Visit our Web Site

  14. #14
    Join Date
    Aug 2003
    Location
    Lelystad - Netherlands
    Posts
    7
    can you 'ping' the server from the computer that does not connect to the database?

    if yes, i would create the same oracle-environtment as on an other computer that can connect to the database (identical tnsnames.ora and sqlnet.ora)

  15. #15
    Join Date
    Aug 2003
    Posts
    9
    I can ping the server from the down computer, but I cannot tnsping (I get a TNS-03505: Failed to resolve name error).

    The down computer is using a copy of the same tnsnames.ora and sqlnet.ora files as all of the other machines.

    As always, thank you for your assistance.

    Best,
    Adria

Posting Permissions

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