problem in logging sql oracle 8i

Discussion in 'Software Q&A' started by shivi4, Oct 15, 2006.

Thread Status:
Not open for further replies.
  1. shivi4

    shivi4 New Member

    Joined:
    Oct 4, 2004
    Messages:
    162
    Likes Received:
    0
    Trophy Points:
    0
    hi i am using oracle 8i version
    i have problem to login sql plus with scott/tiger

    as user name and password

    i have also tried system/manager please help

    ERROR:
    ORA-12560: TNS:protocol adapter error

    ERROR:
    ORA-12154: TNS:could not resolve service name
     
  2. DukeNukem

    DukeNukem Come get Some

    Joined:
    Aug 28, 2005
    Messages:
    417
    Likes Received:
    2
    Trophy Points:
    0
    Location:
    Home Sweet Home
    Have you Cross checked whether the service is running or not.
    if in case its stoped start it then give it a shot.
    though tns service is not required in local enable it too.


    if you r using multiple homes try to put the SID after login and password

    eg scott/tiger@live or system/manager@live
     
  3. OP
    OP
    shivi4

    shivi4 New Member

    Joined:
    Oct 4, 2004
    Messages:
    162
    Likes Received:
    0
    Trophy Points:
    0
    how to chewck service is running or not
    i am running oracle in hone computer only
     
  4. DukeNukem

    DukeNukem Come get Some

    Joined:
    Aug 28, 2005
    Messages:
    417
    Likes Received:
    2
    Trophy Points:
    0
    Location:
    Home Sweet Home
    what os are you runnin Bro.

    if its windows 2000/XP
    run services.msc from "run" option
    here you'll see the current installed services and their status. check whether Oracle service is running or not.
     
  5. OP
    OP
    shivi4

    shivi4 New Member

    Joined:
    Oct 4, 2004
    Messages:
    162
    Likes Received:
    0
    Trophy Points:
    0
    i am runnning win xp
    __________
    OracleOraHome81Agent
    OracleOraHome81ClientCache
    OracleOraHome81DataGatherer
    OracleWebAssistant0
    i have turn them on but still it is giving same error

    how to tun tns
     
    Last edited: Oct 18, 2006
  6. abhijit_reddevil

    abhijit_reddevil Manchester United

    Joined:
    Jul 26, 2005
    Messages:
    1,447
    Likes Received:
    4
    Trophy Points:
    38
    Location:
    Kolkata, India
    You should put the required details like username, password, oracle home IP/computer name in the domain in the tnsnames.ora file. This file can be found in \ora81\network\admin and an example in \ora81\network\admin\sample. This is assuming your TNS listener service is automatically started and running.
     
  7. DukeNukem

    DukeNukem Come get Some

    Joined:
    Aug 28, 2005
    Messages:
    417
    Likes Received:
    2
    Trophy Points:
    0
    Location:
    Home Sweet Home
    The Main Services needed is not mentioned here which goes like this
    OracleServiceORCL 'Here ORCL is the SID NAME

    and a tnslistner service which look like this
    OracleOraHome81TNSListener

    if these are the only service related to oracle u are havin. then you have not installed oracle properly.

    reinstall it again (just in case)
     
  8. OP
    OP
    shivi4

    shivi4 New Member

    Joined:
    Oct 4, 2004
    Messages:
    162
    Likes Received:
    0
    Trophy Points:
    0
    OracleOraHome81TNSListener
    i am not getting the above even after re installation
     
  9. DukeNukem

    DukeNukem Come get Some

    Joined:
    Aug 28, 2005
    Messages:
    417
    Likes Received:
    2
    Trophy Points:
    0
    Location:
    Home Sweet Home
    do one thing

    First stop all the services running related to oracle.

    Delete the folder where ORACLE is installed (if gettin error while deleting the folder (unable to delete) use the software unlocker to unlock the folder from here http://www.softpedia.com/get/System/System-Miscellaneous/Unlocker.shtml Then delete it (oracle folder ofcourse)
    ), Using Regedit/regcleaner/similar softies remove all registeries entries related to oracle.

    Now install the Oracle form the very begining.

    DO NOT DO THE CUSTOM INSTALLATION BY YOUR OWN IF U DONT KNOW WHAT YOU ARE DOING.

    MAKE THE INSTALLATION AS "ENTERPRISE" WITH ALL DEFAULTS
     
Thread Status:
Not open for further replies.

Share This Page