Not able to access oracle from TOAD
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Not able to access oracle from TOAD

  1. #1
    Join Date
    Jul 2002
    Posts
    42
    Hi,
    I am not able to connect oracle thru TOAD,but able login thru SQL*PLUS. this is after installing 9ias in my machine. (windows 2000). If i try to connect oracle thru toad then it gives the error TNS- ora-12541 listner error.
    what i have to do, inorder to connect oracle thru TOAD.
    thanks
    Oracle

  2. #2
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    When you installed 9ias you probably created second oracle_home?
    Toad is maybe using another oracle_home.
    Sometimes installer give you some Oracle Home Selector tool, try to find it in Start menu/Programs somewhere.

    Otherwise you can look in regedit under LOCAL_MACHINE/SOFTWARE/ORACLE you have a key ORACLE_HOME which is probably set to new home of 9ias.
    Try editing this key.

    Hope my assumptions and guideliness are right.

    Tomaz

  3. #3
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    Check which ORACLE_HOME is your TOAD using.. There must be multiple tnsnames.ora files on your machine.

    Which Version of TOAD you are using?.. Check whether you have "clicked" option "Use Last Oracle Home" in your login dialog box of TOAD. Try selecting that...

    Sameer


  4. #4
    Join Date
    Jul 2002
    Posts
    42
    It says, Initialization error - Could not locate OCI.dll.....
    Oracle

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