Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    2

    Unhappy Unanswered: NEWBIE - TNS-12560 TNS:Protocol Adapter Error

    I'm new to Oracle...working on it for a client. So I appoligize in advance if this question is silly..but rest assured, I've GOOGLED the heck out of it with no results

    I'm just trying to create an ODBC DSN for this oracle database I created.

    I created a database (named EM) thru SVRMGR23.
    I can log into and view the tables by saying:
    CONNECT INTERNAL;
    STARTUP PFILE=C:\DATABASE\INITEASYMANAGER.ORA;
    CONNECT EM/changeit (the username/password I set up)

    From here I can do SELECT statements and whatnot to view my data, so it seems my database is set up correctly, at least this far.



    Now, I want to set up an ODBC connection to it.
    Looks like I've got these choices:
    Microsoft ODBC for Oracle 2.573.7326
    Oracle ODBC Driver 8.01.61.00
    Oracle73 2.05.03.01
    Oracle73 Ver 2.5 2.05.03.01


    I've tried them all, and the crux of my problem seems to be in the SQL*NET Connect_String. From what I've read (from Googling) this Connect String should be the Database name, as it's defined in the TNSNAMES.ORA file?!?

    Here is a listing of that file:
    EM.world =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS =
    (COMMUNITY = tcp.world)
    (PROTOCOL = TCP)
    (Host = AMTULW2K110777.bp1.ad.bp.com) #<--that is my local machine name
    (Port = 1521)
    )
    )
    (CONNECT_DATA = (SID = EM)
    )
    )



    and here is my LISTENER.ORA file:

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

    LISTENER =
    ( ADDRESS_LIST =
    (ADDRESS =
    (PROTOCOL=tcp)
    (HOST=AMTULW2K110777.bp1.ad.bp.com)
    (PORT=1521)
    )
    )

    # List of services served by this listener
    SID_LIST_LISTENER=
    (SID_LIST=
    (SID_DESC=
    (SID_NAME=EM)
    )
    )

    # Start of configuration parameters.
    TRACE_LEVEL_LISTENER=OFF
    TRACE_FILE_LISTENER = "listener"
    LOG_FILE_LISTENER = "listener"
    CONNECT_TIMEOUT_LISTENER = 10
    STOP_LISTENER = YES
    DBA_GROUP = dba




    Does anyone see any obvious errors in the above 2 files. I know this must be a rediculous NEWB question..but again...I have researched the heck out of it.. I just want an ODBC connection so I can run a program that has already been written to transfer data between this database and another via ODBC.

    Any help would be MUCH appreciated!!!

  2. #2
    Join Date
    Aug 2002
    Location
    SHANGHAI,CHINA
    Posts
    20
    First,confirm your oracle database instance has been created and running
    Second,you should better to use the same sql*net client's version the server.(I see u use oracle7.x,and I can not confirm which your oracle database version.)
    Then,before create odbc dsn,you must use oracle client utitily(Easy Net configuration) to create a local network service(it will write tnames.ora autmaticly),same as edit your tnames.ora file by yourself.After did it,u can use tnsping test it.
    Last,configure the odbc setting correctly.

  3. #3
    Join Date
    Sep 2003
    Posts
    2
    wengyan ,

    Thanks for the advice.. I'll try all these steps today...

    thanks again

Posting Permissions

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