Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

TOAD connection not working

Posted on 2004-09-08
13
Medium Priority
?
7,557 Views
Last Modified: 2012-06-21
I have installed Oracle 9.i and TOAD 7.6 Expert - yestrday it worked fine for me  on a colleagues PC - but today when I have logged in as myself (and stupidly installed TOAD again) - now when I go to login to my database I geta message that is Blank and just has an "OK" button - when I click this button nothing happens.

Can anyone suggest what is happenning.

I have already tried uninstalling TOAD, deleting the Quest directory in the Program Files directory as well.

Short of uninstalling Oracle 9.i on my computer and re-installing - can anyone suggest why this has happenned. I cannot fin anythin n the TOAD release notes to help.

Thanks
0
Comment
Question by:sfjohnston71
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 5
13 Comments
 

Author Comment

by:sfjohnston71
ID: 12012266
Forgot to mention that I am working on the same PC as yesterday
0
 
LVL 23

Expert Comment

by:seazodiac
ID: 12012270
try to do TNSPING in your DOS command window for the database you tried to connect.
0
 

Author Comment

by:sfjohnston71
ID: 12012475
I should also mention that I can connect to SQL Plus using the id and pasword i have.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:sfjohnston71
ID: 12012492
seazodiac - at my cmd prompt I am typing c:\>tnsping <databasename>

it's telling me that the name is not recognised as an internal or external command, operable program or batch file
0
 
LVL 23

Expert Comment

by:seazodiac
ID: 12012533
but you are sure you can use SQLPLUS to connect to oracle...

if you are absolutely sure about that, then let's configure TOAD,

when you open up the TOAD, in the first popup window (not the main window) showing the connection screen.

On the right side of the window, it has a few checkbox say: use SQLNET to connect , Use net8 compatible to that effect.

check those two boxes. and try again
0
 

Author Comment

by:sfjohnston71
ID: 12012546
I checked the box Force SQL*Net (ignore Net 8) it gave me an error message

Initialization error
Could not locate OCI dll

When I click connect
0
 

Author Comment

by:sfjohnston71
ID: 12012555
When I try and check SQL*Net Compatible Net8 I get the message

Can't initialize OCI. Error -1
0
 

Author Comment

by:sfjohnston71
ID: 12012588
I can connect to SQL plus - just ran a simple query against a table and got back the desired result
0
 
LVL 23

Expert Comment

by:seazodiac
ID: 12012627
ok, here is another thing to look at :

in the very same window you do the configuration above.

at the very bottom of the right side, there is SQLNET Help (it's blue link) you can click that, it will open up another window with a bunch of ORACLE_HOMES

make sure you have the right ORACLE_HOME there, the same ORACLE_HOME where your SQLPLUS executables are in..
0
 
LVL 23

Expert Comment

by:seazodiac
ID: 12012637
It's A button "SQL*NET HELP" on the bottom .
0
 

Author Comment

by:sfjohnston71
ID: 12012677
I have a line saying that D:\oracle\ora92\BIN is not in the system path when I click on the connect using

my home directory is d:\oracle\ora92 - which is where my Oracle is installed and the SQL Plus folder is

I don't have a SQL NetHelp - I have a SQL Net Editor which does not mention Oracle Home

0
 
LVL 23

Accepted Solution

by:
seazodiac earned 1000 total points
ID: 12012730
Ok, let's re-examine the things:

in the TOAD popup window (login window) there should be 3 buttons there, Can you read what they are?

I have "SQL*NET HELP" , "OK", "CANCEL" button...

If I click SQLNET Help button:

you will another pop up window to allow you set up ORACLE_HOME.

0
 

Author Comment

by:sfjohnston71
ID: 12012913
OK - seazodiac - you can have the points. I uninstalled Oracle 9.i and TOAD out of shear frustration and now I can connect!!

But now I have issues with my access rights - aargghhhhhhhhhh
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

715 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question