jjrr007
asked on
Oracle In OraHome92 Driver
When I try to connect to my Oracle data sources, I receive the following error, "Oracle In Orahome92 could not be found."
I had installed a program that uninstalled this driver, but how do I get the driver back? It had worked earlier. I am a non-Oracle query tool to query the Oracle databases (using Teradata SQL Assistant). My computer runs on 32 bit windows 7.
I had installed a program that uninstalled this driver, but how do I get the driver back? It had worked earlier. I am a non-Oracle query tool to query the Oracle databases (using Teradata SQL Assistant). My computer runs on 32 bit windows 7.
ASKER
That is part of the issue. Could you provide a weblink for me to install it?
There is no link to install it. You download media and run the setup.
Depending on what you downloaded, there will be options to just install ODBC.
If you no longer have the 9i media, and if all you need is the ODBC driver, I suggest the Instant Client:
http://www.oracle.com/technetwork/topics/winsoft-085727.html
You will need two downloads:
Instant Client Package - Basic
Instant Client Package - ODBC
Unzip both to the same folder. Create a network\admin folder under that and copy a good tnsnames.ora and sqlnet.ora files into that folder.
Then run the installer to install to install ODBC (I believe it is a .BAT file).
There are readme files for both that explain what to do.
Depending on what you downloaded, there will be options to just install ODBC.
If you no longer have the 9i media, and if all you need is the ODBC driver, I suggest the Instant Client:
http://www.oracle.com/technetwork/topics/winsoft-085727.html
You will need two downloads:
Instant Client Package - Basic
Instant Client Package - ODBC
Unzip both to the same folder. Create a network\admin folder under that and copy a good tnsnames.ora and sqlnet.ora files into that folder.
Then run the installer to install to install ODBC (I believe it is a .BAT file).
There are readme files for both that explain what to do.
ASKER
Thanks. From the web URL, which link should I install? There are many versions here.
I beleive only the latest 11gR2 (11.2.0.3) is certified on Windows 7. Don't quote me on that one.
Others may 'work'.
As a general rule: Unless you specifically need a lower version always go with the latest and greatest.
Others may 'work'.
As a general rule: Unless you specifically need a lower version always go with the latest and greatest.
ASKER
Issues remain. I did the following:
1. Unzipped the "instantclient-odbc-nt-11.
to C:/Oracle/Ora92/Network/Ad
2. Placed my tnsnames.ora and listener.ora in the C:/Oracle/Ora92/Network/Ad
directory.
3. Ran ODBCinstall.exe - just double clicked- no errors seen (doesn't mean set-up right) and restarted.
4. Tried to create a new data source in odbc data administrator. I don't see Oracle data drivers at all.
What do you suggest? I am still getting the same errors. it looks like I will need detailed instructions after downloading these files...
1. Unzipped the "instantclient-odbc-nt-11.
to C:/Oracle/Ora92/Network/Ad
2. Placed my tnsnames.ora and listener.ora in the C:/Oracle/Ora92/Network/Ad
directory.
3. Ran ODBCinstall.exe - just double clicked- no errors seen (doesn't mean set-up right) and restarted.
4. Tried to create a new data source in odbc data administrator. I don't see Oracle data drivers at all.
What do you suggest? I am still getting the same errors. it looks like I will need detailed instructions after downloading these files...
>>Unzipped ... to C:/Oracle/Ora92/Network/Ad
You mis-understood. Unzip them to a common folder THEN create the network/admin folder. This folder is where Oracle looks for the tnsnames.ora file by default. Note that the downloads do not come with the tnsnames.ora and sqlnet.ora files. Those you must already have. If not, your DBA should be able to asssit you.
Also, you should not unzip them to a folder named Ora92. That is the default ORACLE_HOME for version 9iR2.
Pick a brand new folder. I suggest keeping it under C:\Oracle.
Create something like: c:\Oracle\11_2_0_3_Instant
>> it looks like I will need detailed instructions after downloading these files...
There are readme files with the details on how to install/configure the Instant Client.
>>just double clicked- no errors seen (doesn't mean set-up right)
Exactly. Follow the instructions that came with the download.
You mis-understood. Unzip them to a common folder THEN create the network/admin folder. This folder is where Oracle looks for the tnsnames.ora file by default. Note that the downloads do not come with the tnsnames.ora and sqlnet.ora files. Those you must already have. If not, your DBA should be able to asssit you.
Also, you should not unzip them to a folder named Ora92. That is the default ORACLE_HOME for version 9iR2.
Pick a brand new folder. I suggest keeping it under C:\Oracle.
Create something like: c:\Oracle\11_2_0_3_Instant
>> it looks like I will need detailed instructions after downloading these files...
There are readme files with the details on how to install/configure the Instant Client.
>>just double clicked- no errors seen (doesn't mean set-up right)
Exactly. Follow the instructions that came with the download.
ASKER
This worked much better. I put the extracted files (not outer shell folder) into "c:\oracle\instantclient_1
Now I see the "oracle in Instantclient_11_2" as a driver and when I create the data source. The readme file was useless- that's why I ask these questins here. We are making progress. Where do I place the tnsnames.ora and listener.ora files? I will try to re-create the databases from that point.
Now I see the "oracle in Instantclient_11_2" as a driver and when I create the data source. The readme file was useless- that's why I ask these questins here. We are making progress. Where do I place the tnsnames.ora and listener.ora files? I will try to re-create the databases from that point.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I meant create the database connections- sorry I mistyped. I have been writing queries and connecting to data now for over 8 years. I just haven't had as much experience with this issue. I am trying what you mentioned with the network/admin and will reply briefly. Thanks!
ASKER
This worked well. Thank you!!
BTW, I may ask a question about setting-up SQL Plus tomorrow or later on today.
BTW, I may ask a question about setting-up SQL Plus tomorrow or later on today.
ASKER
Thanks for your time and expertise!!!
ASKER
You are very good at this. In case you are interested, the question about SQL Plus is listed here:
https://www.experts-exchange.com/questions/28098042/Installing-Using-SQL-Plus.html
https://www.experts-exchange.com/questions/28098042/Installing-Using-SQL-Plus.html
If you do not have the media, yoou will need to download/install a currently supported ODBC driver from oracle.com.