End of file communication error......
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: End of file communication error......

  1. #1
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Guys,
    OS NT
    ver 816.

    When i try to access the database on my mchine at home i get the end of file comm error.....
    While if at work when on the NT domain it causes no problems.
    Why do i get this error??
    Note: the tnslsnr is running.
    The service/db is running.
    what cud be wrong here??
    my listener.ora is....
    i ran the trace (this is the bottom end of the long trc file..)

    -> PARAMETER TABLE LOAD RESULTS FOLLOW <-
    Successful parameter table load
    -> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
    LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = LAPTOP_TARRY)(PORT = 1521))) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = laptop_tarry)))))
    SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = D:\orant) (PROGRAM = extproc)) (SID_DESC = (GLOBAL_DBNAME = nick) (ORACLE_HOME = D:\orant) (SID_NAME = nick)))
    --- PARAMETER SOURCE INFORMATION ENDS ---

    --- LOG CONFIGURATION INFORMATION FOLLOWS ---
    Existing log stream is identical to desired "D:\orant\network\log\listener.log"; ignoring alter
    --- LOG CONFIGURATION INFORMATION ENDS ---


    my listener.ora
    is>>>>>>>>>>>

    # LISTENER.ORA Network Configuration File: D:\orant\network\admin\listener.ora
    # Generated by Oracle configuration tools.

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = LAPTOP_TARRY)(PORT = 1521))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = laptop_tarry))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = D:\orant)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = nick)
    (ORACLE_HOME = D:\orant)
    (SID_NAME = nick)
    )
    )

    i guess it's got something to with the hostnaming, but what exactly must i do to help it resolve the host name WHEN THE LAPTOP is NOT connected to the network???

    Note: In the 8 version i cud change the mode to bequeath and then i could run it without being on network?

    Help here?
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  2. #2
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587

    Unhappy

    pando,sam,jeff,tim,julin,jurij..........?????????????
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    guess it's got something to with the hostnaming, but what exactly must i do to help it resolve the host name WHEN THE LAPTOP is NOT connected to the network???
    So the laptop is not connected to the network where the DB is in???

    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  4. #4
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    The server/client is on the laptop.
    So the db is on this mchine.
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  5. #5
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Let's see the TNSNAMES.ORA file.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  6. #6
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    julian,
    here's the tnsnames.ora.........

    # TNSNAMES.ORA Network Configuration File: D:\orant\network\admin\tnsnames.ora
    # Generated by Oracle configuration tools.

    NICK.WAGENBORG.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = laptop_tarry)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = nick)
    )
    )

    EXTPROC_CONNECTION_DATA.WAGENBORG.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )

    WBSH.WAGENBORG.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = nlwgnts7)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SID = wbsh)
    )
    )

    DMV.WAGENBORG.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = nlwgnts7)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SID = dmv)
    )
    )

    WBDZ.WAGENBORG.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = nlwgnts7)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SID = wbdz)
    )
    )


    AS u can see only nick is on my machine.



    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  7. #7
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Can you check into the sqlnet.ora file and see whether the any SQLNET.AUTHENTICATION_SERVICES = (NT) then remove it. also make sure that the names.domain had been set to WAGENBORG.COM and NAMES.DIRECTORY_PATH=(TNSNAMES)

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  8. #8
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    tnsnames looks fine. Follow Sam's suggestions and post us with what happened.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  9. #9
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330
    Hi Really funny,
    The same thing happened to couple of administrator in 9i Oracle Trg class.
    They got ora 03113 end of cumm....error.Everything set correctly.
    when they logged out and again logged in to sqlplus it worked...
    I also noticed that error in our office while control C ing the shutdown process..
    Thanks.
    Thanigai.

  10. #10
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587

    Thumbs up Thanx sam,julian

    sam ,
    you were right(i shud have done a little bit of rethinking when i spoke of bequeathing the operation/local process).
    I changed the SQLNET.AUTHENTICATION_SERVICES = (NTS) to BEQ and it was fine!(when i undocked my notebook)

    sam,julian,

    Thanx guys.
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

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