Use Oracle instantclient to connect to the Oracle database
1. Download the correspondingProgramI got a 10204 instantclient-basic-win32-10.2.0.4.zip.(34,742,358 bytes)
Http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/htdocs/winsoft.html? _ Template =/ocom/print
Http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html
2. decompress the Oracle instatnt client to D: \ instantclient_10_2.3. Deco
Here are the methods given by the Battle Network
1, detect the "Secondary logon" service is open, specific: Right click on the computer, and then click "Management" will open the dialog box, and then click on the left side of the "service and management" in the right window to find "secondary Logon" if not started to start;
2, in the computer Search Battle.net folder and then delete;
3, to see if it is open 360 or the computer application/firewall if yes we closed;
4, Safe mode i
1, the establishment of Oracle installation directory, generally/opt/oracle;2, put the installation package instantclient-basic-linux.x64-11.2.0.3.0.zip into the directory, and extract: Unzip XXX, generate directory:/opt/oracle/instantclient_11 _2;;3. Create a new Tnsnames.ora file in the/opt/oracle/instantclient_11_2 directory to write the database connection information;4. Configure environment variables:/ect/profile fileExport Oracle_home=/opt/oracleexport Nls_lang=american_america. ZHS16GBKE
Label:Installing 32-bit and 64-bit Oracle clients first in many Oracle installation introductions, there are references to setting 2 points, one, E 1, and environment variables. nls_lang=simplified Chinese_china. ZHS16GBK 2.Tns_adminD:\app\product\11.2.0\client_1_64\network\admin second, through the PL/SQL login, set up preferences. The upper left corner of the red box can see the display is not logged in, that is, when logged in PL/SQL, do not fill in the account password, directly cancel, and
Tns_admin and the value is the path to the Tnsnames.ora file, for example: E:\oracleclient\instantclient_11_24.After installing Plsql, start, Cancel, and click Tools->preferences->connection:Oracle home=e:\oracleclient\instantclient_11_2OCI Library=e:\oracleclient\instantclient_11_2\oci.dllRestart Plsql, enter the user name, password, select the PL/SQL instance name to enter the database5.The initial login may have the problem of Chinese garbled, the solution is as follows:Add an environment va
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.