Because Plsql does not support 64-bit Oracle clients, PLSQL must use Oracle's 32-bit instanclient package. Unzip and place a directory, for example: D:\Oracle\instantclient_10_2
PS: 10g 32-bit instantclient package can also be connected to the 11g Oracle 64-bit Library
1. After entering Plsql, set the address of Oracle home under Preferences: D:\Oracle\instantclient_10_2, set the OCI location at the same time: D:\Oracle\instantclient_10_2\oci.dll
2, need to set the tns_admin in the environment variable of the system, the value is D:\Oracle\instantclient_10_2, this let plsql start to know where to find Tnsnames.ora file
3, the environment variable also needs to set Nls_lang, the value is simplified Chinese_china. ZHS16GBK, of course, it's based on your own database.
In general, after this, plsql can use the
If the login discovery prompt cannot resolve the specified connection identifier, or a similar statement, it is mostly because the listener is not set up. The default listener's listener list does not specify the specific Oracle instance is which, in this case, the specific listener instance description Plus (red that paragraph), specific reasons do not know ... When you're done configuring, remember to restart Oracle's listener service.
Sid_list_listener =
(Sid_list =
(Sid_desc =
(Sid_name = Clrextproc)
(Oracle_home = d:\oracle\product\11.2.0\dbhome_1)
(program = Extproc)
(Envs = "Extproc_dlls=only:d:\oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
(Sid_desc =
(Global_dbname = ORCL)
(Oracle_home = d:\oracle\product\11.2.0\dbhome_1)
(Sid_name = ORCL)
)
)
LISTENER =
(Description_list =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = Tyson-mac) (PORT = 1521))
(ADDRESS = (PROTOCOL = NMP) (SERVER = Tyson-mac) (PIPE = orapipe))
)
)
Note: This Listener.ora file is located in the Oracle 11g installation directory, for example: D:\Oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN
Instead of Instantclient, because Oracle's services are directed to the other side.
About Oracle 11g 64-bit and plsql coexistence issues