Background: The Oracle database is installed on this computer and is connected using Plsql.
After the Oracle 11g database is installed today. Connect to the database with Plsql the dead and alive are not connected. Also, the Database drop-down box for the Plsql client login form is empty. See:
Oracle services and monitoring are turned on, and there is no problem checking the relevant configuration.
Later went online search, found someone said Plsql cannot directly connect 64-bit Oracle 11g database.
Since the Plsql is 32 bits. To connect a 64-bit database, you need to install a 32-bit Oracle client.
Remember to use the ORACLE10G database when there is no such thing ah, with Plsql can be directly connected to the database.
How to resolve:
1. Download the Oracle client: instantclient-basic-win32-11.2.0.1.0.zip (click Download Oracle32-bit client) and extract it to the Oracle installation folder under Product:
D:\app\NiuNiu\product\instantclient_11_2.
2. Copy files: Copy the Tnsnames.ora file under the Database installation folder D:\app\NiuNiu\product\11.2.0\dbhome_1\NETWORK\ADMIN to the client folder.
3, Configuration Plsql Developer:
In tools-"perference-" connection inside set up Oracle_home and OCI Library. For example, this machine is set to:
Oracle home:d:\app\niuniu\product\instantclient_11_2
OCI Library:d:\app\niuniu\product\instantclient_11_2\oci.dll
4. Environment variable setting:
Change variable: Add in Path: D:\app\NiuNiu\product\instantclient_11_2;
New variable: named "Tns_admin" with a value of "D:\app\NiuNiu\product\instantclient_11_2;"
New variable: named "Nls_lang" with a value of "simplified Chinese_china. ZHS16GBK ",
Follow the above steps to test after the completion of the configuration.
(It's better to start the computer again)
Landing Success!
Faq
Why configure the "Nls_lang" variable?
Do not add this variable when using the database to add data. The Chinese in the table will become garbled, because our database is 64 bits. and the operating software Plsql_developer is 32-bit. That is, you write in Plsql_developer in Chinese is a 32-bit character set, and the database can only be stored correctly is the 64-bit Chinese character set. This resulted in writing and reading is not a character set, and finally caused Chinese to become question marks or garbled characters.
"Oracle Error Collection": Plsql cannot connect directly to a 64-bit oracle11g database