1, separate download instantclient_10_2, in the cloud disk has
2. Preference configuration path in Plsql
3, E:\oracle\product\10.2.0\db_1\NETWORK\ADMIN in the Listener.ora
# Listener.ora Network Configuration File:e:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
Sid_list_listener =
(Sid_list =
(Sid_desc =
(Sid_name = Plsextproc)
(Oracle_home = E:\oracle\product\10.2.0\db_1)
(program = Extproc)
)
(Sid_desc =
(Global_dbname = ORCL)
(Oracle_home = E:\oracle\product\10.2.0\db_1)
(Sid_name = ORCL)
)
)
LISTENER =
(Description_list =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP) (HOST = lyc-pc) (PORT = 1521))
)
)
Red for manual add
3. Configure the Tns_admin value in the environment variable E:\oracle\product\10.2.0\db_1\NETWORK\ADMIN
Win7 64 installing Oracle 32-bit 10g note important