Unable to create connection string????
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Unable to create connection string????

  1. #1
    Join Date
    Nov 2000
    Location
    New Delhi, India
    Posts
    81

    Unhappy

    Hi!!

    I've installed Oracle 8.1.5 on Linux. Now my client application also running on the same m/c requires connection string to make a connection to the database. I tried using the "netec" and "netasst" to make the tnsnames.ora but both of these applications stops abruptly. How should I proceed. Also I want to install Intelligent Agents on this machine.

    What should be done, as I need to start a project soon and the work is getting affected....Pls Help!!

  2. #2
    Join Date
    Dec 2000
    Posts
    10

    About connect string....

    Hi shruti,

    See did u change tnsnames.ora manually? Don't use any gui (i think u're not using gui, since u're in linux). U have to manually change it. Sending you my Unix server's tnsnames.ora which connects to Sun Solaris.

    extproc_connection_data =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = ORCL))
    (CONNECT_DATA = (SID = extproc))
    )

    ORCL =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL= TCP)(Host= gayatri)(Port= 1521))
    (CONNECT_DATA = (SID = ORCL))
    )
    extproc_connection_data =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = td))
    (CONNECT_DATA = (SID = td))

    tdnew =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(Host = 10.31.8.121)(Port = 1521))
    (CONNECT_DATA = (SID = td))
    )

    I hope u can u it fast if not then mail me on darshil_dba@rediffmail.com

    Best wishes
    Darshil

  3. #3
    Join Date
    Nov 2000
    Location
    New Delhi, India
    Posts
    81
    Thanks for your support.

    Since I'm using Linux I can use GUI tools. I was preferring these tools so as not to make any error while creating the tnsnames.ora manually. I was able to create the listener.ora through the "netasst" gui tool.

    Anyway I installed oracle 8.1.5 on Win 2000 and when I generated the files throught these tools they used "service" keyword instead of "sid" (mind it its 8i).
    So what you've sent is it surely gonna run or not. Please let me know.

    My listener.ora is as follows

    LISTENER =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = eye)(PORT = 1521))
    (PROTOCOL_STACK =
    (PRESENTATION = TTC)
    (SESSION = NS)
    )
    )


    Thanks again for your support.

    Shruti

  4. #4
    Join Date
    Jan 2001
    Posts
    9
    If you look into $oracle_home/net8/admin you will see the example of tnsname.ora for that operating system all you should do is to cut and past one section which is using tcp/ip assuming your network is using tcp/ip and change the sid and all other info accordingly

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