| 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.
|
|
|
|
|
|
| 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.
|
|
|
|
|
|
| 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.
|
|
|
|
|
|
| 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
