ORA-12560: TNS protocol adapter error in oracle 8i
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: ORA-12560: TNS protocol adapter error in oracle 8i

  1. #1
    Join Date
    Sep 2005
    Posts
    12

    ORA-12560: TNS protocol adapter error in oracle 8i

    Hello

    I am a beginner in oracle ...i installed oracle 8i on win xp(128 mb RAM).I connected to Oracle for the first time using username:scott and password:tiger .but now when i try to connect to oracle using same password/username, it displays mme the following error:-

    ORA-12560: TNS protocol adapter error

    Please tell me as to what to do??? I will be really thankful to you...Please help me!!!

    Nitin

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    you need to start the service (or create a database if you havent done so already)

  3. #3
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    If you're a beginner and living in 2005, Try starting with atleast version 9i. There's already a version 10G Release 2 BTW.

    For connections as Davey said
    do
    --tnsping database name
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  4. #4
    Join Date
    Sep 2005
    Posts
    4
    hi if u are facing that problem then just create a database or start the oracle database service... the problem is related to your database.....

    and most probably u have not created the database...

    so create it...

  5. #5
    Join Date
    Sep 2005
    Posts
    12
    Hello

    Thanks everybody for ur reply!!! I connected to oracle 8i through the following steps:(from command prompt)-

    sqlplus>connect sys/change_on_install as sysdba

    it displayed:-

    idle instance started

    then i wrote:-

    startup

    and through this , instance got started and i was able to work in sql*plus editor...........but i want to ask whether i have to do this every time i want to connect to Oracle??? Is not there a way out by which instance gets automatically started...do i need to make any change in registry???
    actually when i tried to connect to Oracle(via 'scott/tiger' combination) after turning my PC on....it displayed me the following error:-

    ORA-01034:ORACLE not available

    that's when i tried to connect to Oracle thru command prompt via "sys/change_on_install" combination in sysdba mode(as described above in this post) and it was successful attempt.

    so please tell me how will this instance get started automatically???
    thanx once again

    Nitin

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    just set the service to start automatically from control panel -> services

  7. #7
    Join Date
    Sep 2005
    Posts
    4
    first go to services option from controlpanel-->administrative tools

    then right click on the database service what u r concern...

    then change the value of startup from manual to automatic ....

    and now enjoy .....

  8. #8
    Join Date
    Sep 2005
    Posts
    12
    I did wat u said...but when i restarted my PC and tried to cnnect to Oracle(via scott/tiger combination), it again displayed me:-

    ORA-01034:ORACLE not available

    and moreover in the services section in control panel...i changed from manual to automatic but then its status is always "starting" and not "started"....even when i have connected to oracle through:

    sqlplus>connect sys/password as sysdba
    startup

    so my problem is not solved....

    nitin

  9. #9
    Join Date
    Dec 2001
    Location
    Slovenia, Kranj
    Posts
    82
    What is the content of sqlnet.ora file?

  10. #10
    Join Date
    Mar 2002
    Location
    Manchester, England
    Posts
    202
    As Tarry said, 8i is soooo 1990's.
    you'll be better served learning 10g .

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