Today I siwtch on the computer and TOAD seems to upgrade itself when I tried to load it. Once the loading process was complete I had lost all my connections and passwords.
So I tried to manually type in the connection details. Each time I get:
Can’t initialize OCI. Error -1
Yes I have looked at other threads but have not found anything relevant.
I’ve unistalled TOAD and loaded back in without any success. The confusing issue is I can use SQL Developer without any issues. So, to my limited knowledge, the clients are OK.
Im not convinced its a PATH issue either since I can run Crystal Reports 2008 (32 bit) without issue and dont want to mess up the configuration.
When I changed the ORACLE _HOME other applications stopped working. So I changed the ORACLE_HOME back to its original value.
I fully expected TOAD to fail i.e. fail to connect to the databases, but it did not. I have been able to connect to all the databases and my other applications are working.
I have no idea what went wrong and why changing ORACLE_HOME makes TOAD work.
I also dont have any idea why changing the ORACLE_HOME back to its original value still allows TOAD to work.