Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004

    Unanswered: ORA-12547: TNS:lost contact


    I am a newbie to Oracle who is attempting to upload data to a remote database. Recently SQL loader started giving the following error:
    SQL*Loader: Release - Production on Sat Jan 3 09:22:15 2004

    (c) Copyright 1999 Oracle Corporation. All rights reserved.

    SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
    ORA-12547: TNS:lost contact

    TNSping gives a similar error.

    The weird thing, however, is that SQLPlus continue to work without error given the same username/password/service name combination - so its unlikely to be a network/port issue. Testing the net service name via Net8 Configuration Assistant also works.

    I like to know if anyone has had this problem and what the possible causes are. Would definitely appreciate help

    Thanks in advance

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    NO operating system named & no version.
    NO version of Oracle specified.
    MetaLink shows a decent number of "bugs"
    with the ORA-12547 status, but they are almost always OS and/or Oracle version specific.
    So I suspect you're tripping over a BUG.
    You're On Your Own (YOYO)!

Posting Permissions

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