OraFAQ Forum: Client Tools » problems with TOAD

Home » SQL & PL/SQL » Client Tools » problems with TOAD (V 7.2.0.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

problems with TOAD [message #361309]

Tue, 25 November 2008 19:54

cesarnz
Messages: 10
Registered: November 2008

Junior Member

hi all,
was wondering if anyone has seen this error message when trying to connect to an oracle (10i) database :

Error while trying to retrieve text for error ORA-01019

i dont know why toad all of a sudden stopped working for me. have gone through the troubleshooting guide and checked :

ORACLE_HOME is set
PATH include ORACLE_HOME\bin dir
entry of the database exists in tnsnames.ora file
registry settings look ok i.e in HKEY_LOCAL_MACHINE\Software\ORACLE the oracle home is set

when i click on 'Advise' button in toad it says :

"you must add the loaction of your sql*net installation to your system PATH statemment"

but how did it work before is what i dont understand since i havent changed anything !!

any ideas as to what could be wrong ??

thanks in advance.

Report message to a moderator

Re: problems with TOAD [message #361337 is a reply to message #361309]

Wed, 26 November 2008 00:22

Littlefoot
Messages: 21654
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

There's no Oracle 10i database; 10g is its name.

Is, perhaps, TOAD version (7.2) too old to successfully connect to Oracle 10g database? Would it be possible to upgrade TOAD?

Did you check this TOAD Wiki page?

Report message to a moderator

Re: problems with TOAD [message #361528 is a reply to message #361337]

Wed, 26 November 2008 14:34

cesarnz
Messages: 10
Registered: November 2008

Junior Member

hi,
thanks for the reply. i will upgarde toad and see if that works. i dont understand how the current toad used to work before though ?? connectivity to that same database worked fine before !!

ta.

Report message to a moderator

Re: problems with TOAD [message #361529 is a reply to message #361528]

Wed, 26 November 2008 15:37

Littlefoot
Messages: 21654
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Did anything change? It sounds quite unbelievable that it worked "yesterday", nothing changed and all of the sudden it doesn't work "today".

Report message to a moderator

Re: problems with TOAD [message #361723 is a reply to message #361529]

Thu, 27 November 2008 16:11

cesarnz
Messages: 10
Registered: November 2008

Junior Member

hi,
am not sure whats changed. i didnt change anything but in order for it to stop working something must have changed somewhere !! i just dont know where though.

anyway, have upgraded to toad9.5 and it's giving me this error when i try and connect to that same database :

Can't initialise OCI. Error -1

this is a free download so am not sure if it has all the installs. have you used toad 9.5 before ??

ta.

Report message to a moderator

Re: problems with TOAD [message #361724 is a reply to message #361723]

Thu, 27 November 2008 16:29

Littlefoot
Messages: 21654
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Did you install Oracle Client? If not, perhaps you should have.

Report message to a moderator

Re: problems with TOAD [message #361790 is a reply to message #361724]

Fri, 28 November 2008 01:52

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

Quote:

Can't initialise OCI. Error -1

You are probably missing the file oci.dll, so as Littlefoot points out, you have probably NOT installed the Oracle Client.
IF installed, try to reinstall and verify that you can locate oci.dll and oraclient10.dll.

Report message to a moderator

Previous Topic:	sqlplus error
Next Topic:	Can I create an XLS file from SQL*Plus?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 08 03:37:56 CST 2021