DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: TNS protocol adapter error

  1. #1
    Join Date
    Dec 2001
    Posts
    337
    Hello,

    I am trying to create a database with Oracle 816. 9I and 817 also exist on the same box. I need to login to sqlplus to run the create database script, however i get the Oracle Tns protocol adapter error when i login. I am using a windows 2000 server box. I have the listener started and have edited the tnsnames.ora file accordingly. Any help would be appreciated..Thanks

    Chucks

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    SET ORACLE_SID=the desired SID

    And then run sqlplus.

  3. #3
    Join Date
    Jun 2000
    Location
    dumfries,va,usa
    Posts
    227
    I have a similar problem but with one db (8.1.6) and designer9i. Both on direct oracle home. how do I connect via Deisnger Sqlplus to the db without an service name. I can do this with the db sqlplus (on another oracle home)
    leonard905
    leonard905@yahoo.com

  4. #4
    Join Date
    Dec 2001
    Posts
    337
    Hi ,

    I set ORACLE_SID, however i still get the ORA-12560 TNS: protocol adapter error. Any other suggestions? Thanks.

  5. #5
    Join Date
    May 2002
    Posts
    2,645
    Which sqlplus are you running? The one with the RDBMS, or the version that comes with Developer/Forms 6i/9i? If you are using the one with forms, what is your TNS_ADMIN variable set to? If not set, then your forms is looking in its ORACLE_HOME/network/admin (or Windows version of that path) location for the Net8/Oracle Net config files (tnsnames.ora, sqlnet.ora). And, if you haven't configured or edited those forms files, that is why you get the TNS error - there's no SID for the forms sqlplus to find.

  6. #6
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by Chucks_k
    I set ORACLE_SID, however i still get the ORA-12560 TNS: protocol adapter error. Any other suggestions? Thanks.
    You typicaly get this error when the NT service for your SID is not started. Run the service first, then try to connect.

    If the service does not exist yet, use oradim.exe to create it.

    [Edited by jmodic on 09-18-2002 at 01:14 PM]
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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