Oracle Client set oracle home

In the Windows, I have issues in Oracle client driver, so Toad and Sql developer can't login. how to create an oracle home ? which bin path I should point to ? how to set up toad home and should point to which oracle bin ?

here is my oracle structure.

--oracle
    ---- client
        --- 11.2.0.1
    ---- product
        ---- 10.2.0
        ---- 11.1.0.6

Thanks

Copyright Notice：Content Author:「user595234」，Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article：https://stackoverflow.com/questions/10605425/oracle-client-set-oracle-home

Products recommended by Amazon

More >>>

SanDisk 128GB microSDXC-Card, Licensed for Nintendo-Switch - SDSQXAO-128G-GNCZN

HUANUO Dual Monitor Stand - Adjustable Spring Monitor Desk Mount Swivel Vesa Bracket with C Clamp, Grommet Mounting Base for 13 to 27 Inch Computer Screens - Each Arm Holds 4.4 to 14.3lbs

AMD Ryzen 5 5600X 6-core, 12-Thread Unlocked Desktop Processor with Wraith Stealth Cooler

Timberland Men's 6-Inch Premium Waterproof Boot

More about “Oracle Client set oracle home” related questions

Oracle Client set oracle home

Show Detail

oracle instant client and ORACLE_HOME environment variable

I have Oracle Server and Oracle Instant Client on the same machine. (Windows 7) Notes on Instant Client state that get rid of ORACLE_HOME environment variable. I am using SQL Developer - If I w...

Show Detail

set oracle_home in unix from python script

hi I'm trying to run sqlldr from python script, before that I'm trying to set ORACLE_HOME from python as below subprocess.call(["export","ORACLE_HOME=/home/user1/oracle/client"], shell=True) ...

Show Detail

Client 19C client and Oracle Home Name

We are packaging Oracle 19C client 64 bits. Eventually 32 bits too. With 11GR2, I was using Oracle_Home_Name parameter to set a dictinct name for the 32 and 64 bits. In the start menu and registry ...

Show Detail

Connect from excel to oracle using oracle instant client

What are the steps to be taken to use oracle instant client to connect from excel to oracle database. I have the unzipped basic instant client folder. The OS used is Windows XP. Here is my connec...

Show Detail

oracle instant client for python and oracle client for vba

I had been happily using the driver that comes with the oracle client to query oracle databases with the following connection: Set cn = New ADODB.Connection cn.Open ("Provider=MSDAORA;" & _ ...

Show Detail

What should be set in the oracle home of PL/SQL Developer

Oracle client is installed in the path D:\oracle\product\10.2.0\client_1. What should be set in the oracle home of PL/SQL DEVELOPER?

Show Detail

ORACLE_HOME is not visible in phpInfo page

In my CentOS machine I have set my ORACLE_HOME environment variable in the ~/.bash_profile file. My .bash_profile file # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then ...

Show Detail

How to install oracle client on mac?

Tried installing oracle client and set path like this but when i tried to install cx_Oracle it says it couldn't find oracle. export ORACLE_HOME=/Users/bharatathota/oracle/instantclient_12_1 export

Show Detail

Puppet Oracle home setting

here is my code for installing cx_Oracle. exec { 'build_cxoracle': command => 'python2.7 setup.py build', path => '/bin:/usr/bin', environment => 'ORACLE

Show Detail