Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2004
    Posts
    6

    Question Unanswered: ORA 03106: Fatal two communication protocol error

    hi all,

    I am trying to connect to oracle 9.2.0.1.0. my database is on remote machine. but when i try to run my application then i get no listener but the listener is running.

    and when i try to check the test service from the client machine then it shows the ORS 03106 : fatal two communication protocol error.

    Anybody can suggest me the solution.

    Anuj Kumar Jain

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Can you tnsping from the OS level ??? What OS are you running ??

    Can you PING the server (tcpip communications ???) How is the LISTENER
    setup ???
    lsnrctl > status

    how is your tnsnames setup ???

  3. #3
    Join Date
    Dec 2004
    Posts
    6
    hi Experts,

    Thanks.

    how is your tnsnames setup ???

    tnsping is working properly.

    lsnrctl >ststus command also shows that the listener is running.

    Os is Windows Xp with service pack 4

    but even when i am trying to run from the client machine then it says that no listener.

    Please suggest me what i do to recover this problem

    Thnaking You

    Anuj Kumar Jain

  4. #4
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    From the client machine ...
    Ensure TNSNAMES... from command prompt
    c:\> tnsping yourservicename
    ok...

    Check the sqlnet.ora to ensure authentication is ok...

    SQLNET.AUTHENTICATION_SERVICES= (NONE) <- not NTS

    Unless you are using windows authentication...

    HTH
    Gregg

  5. #5
    Join Date
    Dec 2004
    Posts
    6
    hi,

    Thanks for reply.

    My SQLNET.ora file is as follows :

    """""""""""""""""""""""""""""""""""""""""""""""""" """"""
    TRACE_LEVEL_CLIENT=16

    TRACE_DIRECTORY_CLIENT= "C:\oracle\ora92\network\trace"
    LOG_DIRECTORY_CLIENT = "C:\oracle\ora92\bin\network\log"

    NAMES.DEFAULT_DOMAIN="rbi.org.in"

    SQLNET.AUTHENTICATION_SERVICES= (NTS)

    NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME, ONAMES)
    """""""""""""""""""""""""""""""""""""""""""""""""" """""""""""""

    Thanks and Regards

    Anuj Kumar Jain

Posting Permissions

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