June 30, 2010 at 2:53 pm
Where Can i Download the Oracle Client Package or , I gone through the Oracle Website there were lot of Packages ..
please guide me to install oracle Client ..
Thanks
Praveen
July 1, 2010 at 11:41 am
Without knowing your hardware, or which release of Oracle you are trying to connect to, below is a link with many options. Choose the release and OS, then click on See All to get the client links. The main links listed are for the DB software. Note that the client can be of equal or higher release level than the DB. When you install, avoid instant client as there are few configuration options. Install either runtime or administrator. The install program is not bad, usually you just go with the defaults.
Here is the link:
http://www.oracle.com/technology/software/products/database/index.html
July 2, 2010 at 7:03 am
To test client please...
1- Ping target host - if you can ping it you can access the box.
2- Edit tnsnames.ora file located in ORACLE_HOME/network/admin adding an entry for target database.
3- Set ORACLE_HOME and ORACLE_SID
4- tnsping oracle_sid (the same on tnsnames.ora) - if you can tnsping you have tns connectivity.
5- Attempt connection via sqlplus - if you can connect on top of having tns connectivity user_id and password are correct.
Good luck 🙂
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 10, 2010 at 4:20 pm
The link that Michael provided is certainly a good place to start. The Oracle Database Release 11g R2 is currently the latest release, and will probably work for you. To see the client installations (instead of the database installation) click on the "See All" link next to your operating system. On the following page, you will want to download the zip that contains the client (i.e. Oracle Database 11g Release 2 Client (11.2.0.1.0)).
Once you are ready to install, (as mentioned before) you will not want to do install the Instant client. I went with the Administrator install, as this gives me all of the features that I needed. After the installation, you will want to create a TNSNAMES.ORA connection configuration file and modify the SQLNET.ORA file in the NETWORK\ADMIN subdirectory in your Oracle install folder. If you need help with syntax try these links:
http://www.orafaq.com/wiki/Tnsnames.ora
http://www.orafaq.com/wiki/Sqlnet.ora
________________________________________
Get some SQLey goodness at Dirt McStain's SQL Blog
July 11, 2010 at 7:53 pm
Thanks all .. For the help ...
July 15, 2010 at 3:35 pm
Sometimes a reboot is required in order to fully install the oracle client
July 16, 2010 at 6:20 am
Spam! reported, please no replays.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply