First of all, the installation of Orcale should be very simple, installation is not good only familiar with some of the problems encountered in the record, if later forget can also look.
The first biggest problem is installing the client when installing 32-bit, regardless of whether your operating system is 32-bit or 64-bit.
After installation, you need to configure some configuration information E:\app\John\product\11.2.0\client_1\NETWORK\ADMIN find the Tnsnames.ora file in this directory
Tnsnames.ora Network Configuration file:d:\app\wang\product\11.1.0\client_1\network\admin\tnsnames.ora# Generated By Oracle configuration tools. ora_6.175 = (DESCRIPTION = (Address_list = (ADDRESS = (PROTOCOL = TCP) (HOST = 10.59.6.175) (PORT = 1521)) (Connect_data = (SID = ORCL))) orcl_192.168.200.146 = (DESCRIPTION = (Address_list = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.200.146) (PORT = 1521))) (Connect_data = (SID = ORCL))) ora_6.226 = (DESCRIPTION = (Address_list = (addre SS = (PROTOCOL = TCP) (HOST = 10.59.6.226) (PORT = 1521))) (Connect_data = (SID = ORCL))) ora_175 = (DESCR Iption = (Address_list = (ADDRESS = (PROTOCOL = TCP) (HOST = 10.59.6.175) (PORT = 1521))) (Connect_data = (SID = Orclcs)) ) orcl_110 = (DESCRIPTION = (Address_list = (ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521)) (C Onnect_data = (SID = orcl110))) Zbdbrac = (DESCRiption = (Address_list = (address = (PROTOCOL = TCP) (HOST = 10.59.6.227) (PORT = 1521)) (address = (PROTOCOL = TCP) (HOST = 10.59.6.228) (PORT = 1521)) (load_balance = yes)) (Connect_data = (service_name = Zbdbrac) ) )
Configure this to change the host to the server address you need to connect to.
Installation of Oracle Client