Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Settimg up TOAD?

  • 24-04-2007 1:40pm
    #1
    empirix
    Closed Accounts Posts: 1,723 ✭✭✭


    Hey not sure if this is the correct forum, feel free to move.

    Anyway, i have to use TOAD in work and tbh i am used to it being installed and set up, basically the boss has given me toad for me to install and she hasnt told me anything else. I don't even have an oracle client on my pc - do i need this? how do i find the database etc? Anybody know what i'm trying to get at here? all info welcome

    cheers


Comments

  • #2
    nuada
    Closed Accounts Posts: 68 ✭✭nuada


    For a start anyway here's a decent free oracle client
    http://www.toadsoft.com/lic_agree.html


  • #3
    empirix
    Closed Accounts Posts: 1,723 ✭✭✭empirix


    man thats toad, you know how to conncet to the database


  • #4
    Sniipe
    Registered Users, Registered Users 2 Posts: 2,933 ✭✭✭Sniipe


    hmm... do u need a client... I'm not sure, I suspect u do.
    once u have toad setup u will definately need to change settings in ur client.

    for me I change stuff in:
    C:\oracle\ora81\network\ADMIN\tnsnames.ora

    typically mine look like this

    blah.blah =

    (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 123.123.123.123)(PORT = 1234))

    (CONNECT_DATA =
    (SID = NPNA)(SERVICE_NAME = productname.company))

    )

    Once u get to here u can open a new connection.

    this prob won't help u at all, I only know how to get mine working


  • #5
    matt-dublin
    Registered Users, Registered Users 2 Posts: 4,468 ✭✭✭matt-dublin


    did she just give you a zip file or the installation package?

    if its the zip file just extract it to some directory somewhere and just open toad.exe

    then just put in you username password and database instance when you open a new db and you should be fine


  • #6
    nuada
    Closed Accounts Posts: 68 ✭✭nuada


    Sorry, wrong link.

    Do you have a file called TNSNames.ora in C:\oracle\ora92\network\ADMIN ?


  • Advertisement
  • #7
    empirix
    Closed Accounts Posts: 1,723 ✭✭✭empirix


    nuada wrote:
    Sorry, wrong link.

    Do you have a file called TNSNames.ora in C:\oracle\ora92\network\ADMIN ?


    Just done a sea4rch and i do have a tnsnames.ora but its not in an oracle dir - any ideas


  • #8
    nuada
    Closed Accounts Posts: 68 ✭✭nuada


    Well like sniipe said all you need to do is stick that file in the correct directory and provide a connection name, host, port.

    Lots of info here: http://www.google.com/search?source=ig&hl=en&q=tnsnames.ora


  • #9
    Tom Dunne
    Registered Users, Registered Users 2 Posts: 23,212 ✭✭✭✭Tom Dunne


    empirix wrote:
    Hey not sure if this is the correct forum, feel free to move.

    Anyway, i have to use TOAD in work and tbh i am used to it being installed and set up, basically the boss has given me toad for me to install and she hasnt told me anything else. I don't even have an oracle client on my pc - do i need this? how do i find the database etc? Anybody know what i'm trying to get at here? all info welcome

    cheers

    Right, first things first - you do need Oracle client.

    Where is your tnsnames.ora?

    Do you have an orant directory? Or even an Oracle directory? (both on your C: drive).

    Fire up a command prompt and type sqlplus - does anything appear?


Advertisement