DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 19

Thread: Protocol Adapter Error?

  1. #1
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    688

    Angry

    Hi, guys!
    I am trying to install Oracle 8.1.7 on WinNT 4 as Administrator, during database creation using DB assist., I am getting error 12560:TNS : protocol adapter error.
    Does anyone have edias how to fix it?
    The same error message I get when connect to svrmgrl
    Thank you very much.

    [Edited by kgb on 11-05-2001 at 01:25 PM]
    Best wishes!
    Dmitri

  2. #2
    Join Date
    Jun 2001
    Location
    NJ
    Posts
    118
    Issue the command
    SET oracle_sid=yourservice_name
    in ur dos prompt.
    TNS Protocl adapter error is mostly due to the service name.
    IT should work once you sset the Oracle_sid

    Thanks.
    GD_1976.

  3. #3
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    688
    I created ORACLE service using command line
    oradim -new -sid trax51 -intpwd oracle -startmode AUTO -pfile=E:\orant\admin\inittrax51.ora

    I used:
    SET ORACLE_SID=trax51
    in command line, but when I am trying to start svrmgrl, I am getting error:
    ORA-12560:TNS: protocol adapter error

    Any ideas would be very appreciated.
    Thank you.
    Best wishes!
    Dmitri

  4. #4
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Hi,

    In 8.1.7 svrmgrl is not available. You must use sqlplus:

    sqlplus sys/password@sid as sysdba

    If doesn't work try with another this:

    sqlplus "sys/password@sid as sysdba"

    The last i use with some remote applications because it doesn't work i don't know why (was Oracle directly who recommended to use).

    Hope this helps

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by aarroyob
    In 8.1.7 svrmgrl is not available. You must use sqlplus:
    As it was stated a couple of times recently in this forum: SVRMGRL *is* available and fully supported in 8.1.7. You can use SQL*Plus for managing the database, but you still can use svrmgrl also.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  6. #6
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Thanks for the correction Jurij, I didn't know. I'm new in this forum and I didn't read.

    Best regards

    Angel Arroyo

  7. #7
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    688
    I was trying to use sqlplus
    sqlplus /nologing
    > connect internal as sysdba
    ERROR:
    ORA-24314:service handle not initialized
    -------

    sqlplus /nologing
    > connect sys/change_on_install as sysdba
    ERROR:
    ORA-12560:service handle not initialized
    -------
    sqlplus /nologing
    > connect internal/oracle as sysdba
    ERROR:
    ORA-01017:invalid username/password
    -------


    Thank you.
    Best wishes!
    Dmitri

  8. #8
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    if you have set the ORACLE_SID ok, and your tnsnames is ok, then maybe there was a previous installation of ORACLE in your server and that you may need to edit some registry entry like oracle home, or oracle SID i'm not so sure.

  9. #9
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Did you try sqlplus "sys/change_on_install@sid as sysdba" ?

    Try it with " ".

  10. #10
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by kgb
    I was trying to use sqlplus
    sqlplus /nologing
    > connect internal as sysdba
    ERROR:
    ORA-24314:service handle not initialized
    -------

    sqlplus /nologing
    > connect sys/change_on_install as sysdba
    ERROR:
    ORA-12560:service handle not initialized
    -------
    sqlplus /nologing
    > connect internal/oracle as sysdba
    ERROR:
    ORA-01017:invalid username/password
    -------


    Thank you.
    Sounds like your DB server is not properly configured.


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