Troubleshoot issues with PL/SQL Developer connecting Oracle 11g 64-bit

1, error 1: initialization error could not initialize

The computer was originally equipped with Oracle 11g 64-bit, but PL/SQL is not connected, reported " initialization Error "The mistake of collecting data to find the cause of the original PL/SQL is a 32-bit of, and Oracle Client is 64 bits (originally installed from the server side) , they are incompatible and of course cannot be connected.

Workaround:

(1) Download 32-bit client

Download the free installation version of the 32-bit Oracle client, Address: http://www.oracle.com/technetwork/topics/winsoft-085727.html ( According to the installed Oracle Server version download corresponding client), I downloaded is: instantclient-basic-win32-11.2.0.1.0.zip;

(2) Decompression

Decompression Instantclient-basic-win32-11.2.0.1.0.zip, for example: D:\app\admin\product\11.2.0\instantclient_11_2;

(3) Adding environment variables

Environment variables-System variables-NEW: Tns_admin = D:\app\admin\product\11.2.0\dbhome_1\network\admin( used to set which TNS profile to use ) , Nls_lang = American_america. UTF8 (character encoding);

(4) PL/SQL settings

Tools-Preferences:

Oracle Home directory Name: D:\app\admin\product\11.2.0\dbhome_1

OCI Library: D:\app\admin\product\11.2.0\Instantclient_11_2\oci.dll

2, Error 2:ORA-12541:TNS: no listening program

Open Command Console, enter command: LSNRCTL status to view listener status;

No boot listener, enter command: Lsnrctl start, if not successfully started, check that the listener's profile Listener.ora is configured correctly:

# Listener.ora Network Configuration File:d:\app\admin\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
Direct_handoff_ttc_listener = OFF
Sid_list_listener =
(Sid_list =
(Sid_desc =
(Sid_name = Clrextproc)
(Oracle_home = D:\app\admin\product\11.2.0\dbhome_1)
(program = Extproc)
)
(Sid_desc =
(Sid_name = Plsextproc)
(Oracle_home = D:\app\admin\product\11.2.0\dbhome_1)
(program = Extproc)
)
(Sid_desc =
(Global_dbname = ORCL)
(Oracle_home = D:\app\admin\product\11.2.0\dbhome_1)
(Sid_name = ORCL)
)
)


LISTENER =
(Description_list =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1522))
(ADDRESS = (PROTOCOL = TCP) (HOST = admin-pc) (PORT = 1522))
)
)

Adr_base_listener = D:\app\admin
Default_service_listener = (XE)
ConfigurationAfter modification, you restart the listener.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Troubleshoot issues with PL/SQL Developer connecting Oracle 11g 64-bit