Results 1 to 8 of 8

Thread: ora:12560 error

  1. #1
    Join Date
    Jul 2003
    Posts
    6

    Unanswered: ora:12560 error

    hi all

    I am getting ora:12560 Tns protocol error. can any one help me to solve this.

    Thank u
    usha

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

    Arrow TNS Error

    Hi
    Could you please mention along, what exactly are you trying to do, when you are getting this error.
    Also along with the same error code, is there any message description.

    By the way, are you trying to to a TNS ping, or connecting client to server.

    Thanx and Regards
    Aruneesh

  3. #3
    Join Date
    Jul 2003
    Posts
    6

    Re: TNS Error

    hi

    I am trying to connect to oracle8i on windows Xp.i entered the username and password,when i clicked ok i am getting this error
    ora:12560 TNS protocol error.

    I am able to connect to oracle8i for the first time.But when i restart the system i am unable to connect to oracle and giving this error.

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

    Arrow Solved

    Hi
    It is because of lsnrctl on the system.
    Check the services in XP for lsnrctl. It should be running. Also check your listener.ora file.
    Thanx and Regards
    Aruneesh

  5. #5
    Join Date
    Jul 2003
    Posts
    6

    Re: Solved

    Hi

    Sorry for my lack of knowledge.Can you give me the details of ..Why this error occurs and the steps to solve this error.



    Thanks a lot
    usha

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

    Arrow lsnrctl

    Hi
    Sorry for my lack of experience on Oracle on XP. But XP comes with service like in Win 2000. (Start->Programs->Administrative Services).

    Open that and go to Services section. For a sucessful Oracle installation, you would see a service called lnsrctl (listener control). Make that "automatic start".

    Next thing is search for a file called tnsnames.ora and also listener.ora. Could u post or attach both the files.
    Thanx and Regards
    Aruneesh

  7. #7
    Join Date
    Jul 2003
    Posts
    6

    Re: lsnrctl

    hi

    i couldn't find lsnrctl in my services. (i am using xp home edition is there any thing because of this??).

    # TNSNAMES.ORA Network Configuration File: C:\oracle\ora81\network\admin\tnsnames.ora
    # Generated by Oracle configuration tools.

    ORCL =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST =OurSystem)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = orcl)
    )
    )

    INST1_HTTP =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = OurSystem)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = SHARED)
    (SERVICE_NAME = orcl)
    (PRESENTATION = http://admin)
    )
    )

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

    --------------------------------


    # LISTENER.ORA Network Configuration File: C:\oracle\ora81\network\admin\listener.ora
    # Generated by Oracle configuration tools.

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = OurSystem)(PORT = 1521))
    )
    )
    (DESCRIPTION =
    (PROTOCOL_STACK =
    (PRESENTATION = GIOP)
    (SESSION = RAW)
    )
    (ADDRESS = (PROTOCOL = TCP)(HOST = OurSystem)(PORT = 2481))
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = C:\oracle\ora81)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = orcl)
    (ORACLE_HOME = C:\oracle\ora81)
    (SID_NAME = orcl)
    )
    )

    Thank you
    usha

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

    Arrow XP Home Edition

    Hi
    I read few days back, probably last week, on the same lines on this forum itself, about the OS Oracle runs fine on.
    And unfortunately it does run on XP Home Edition, but does work fine on XP Professional.

    You might wanna search about solutions to get this working, because it is not too hard to get the required drivers and install them on XP Home edition too.
    Thanx and Regards
    Aruneesh

Posting Permissions

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