32-bit PLSQL: 64-bit Oracle and 64-bit System

Problem description: configuration: After 64-bit Oracle32-bit PLSQL is installed on Oracle, PLSQL is used to connect to the database, but the login window of PLSQL is always not displayed and cannot connect to the database normally, no database initialization content. Solution: 1. decompress the downloaded instantclient-basic-win32-10.2.0.5 file. Then copy to the data

Problem description: configuration: After 64-bit Oracle32-bit PLSQL is installed on Oracle, PLSQL is used to connect to the database, but the login window of PLSQL is always not displayed and cannot connect to the database normally, no database initialization content. Solution: 1. decompress the downloaded instantclient-basic-win32-10.2.0.5 file. Then copy to the data

Problem description:

Configuration: 64-bit system + 64-bit Oracle + 32-bit PLSQL

After Oracle is installed, PLSQL is used to connect to the database, but the login window of PLSQL is always not displayed. It cannot connect to the database normally and there is no initialization content for the database.

Solution:

1. Extract the downloaded instantclient-basic-win32-10.2.0.5 file. Copy it to The producti folder in the folder where the database is installed. Mine is: D: \ Oracle \ product.

2. Find the listener. ora and tnsnames. ora files in D: \ Oracle \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN. All copies are under D: \ Oracle \ product \ instantclient_10_2.

3. Find the installation directory of your PLSQL_Developer. My directory is D: \ PLSQL Developer. Create a notebook in it and write the following similar code:
@ Echo off
Setpath = D: \ Oracle \ product \ instantclient_10_2
Set ORACLE_HOME = D: \ Oracle \ product \ instantclient_10_2
Set TNS_ADMIN = D: \ Oracle \ product \ instantclient_10_2
Set NLS_LANG = AMERICAN_AMERICA.AL32UTF8
Start plsqldev.exe

PS: My instantclient_10_2 address is: D: \ Oracle \ product \ instantclient_10_2. Your path may be different from mine, so you need to change it to your instantclient_10_2 path!

After writing it, change your notepad name to start. bat and click Run.

4. Open PLSQL_Developer, cancel logon, and enter the main interface.
1. Click -- tool -- preferences -- connection:
2. Change the above cancellation to submit
3. Change the OCI Library to the path with instantclient_10_2.
4. Run the application -- OK -- disable PLSQL_Developer and run it again.

5. executable PLSQL (get)