Label: Because of the use of PL/SQL, we have just installed Oracle 11g 64-bit today, and after the results are turned on, PL/SQL is not automatically configured. Then find the following blog post on the Internet, follow the steps
As Plsql developer did not provide 64-bit, so according to the information on the Internet to do a bit of finishing, sent up1. Download and install the Oracle 11g R2 64-bit, ignoring the hardware detection failure information when
Label:Cause of the problem:Plsql developer cannot connect to 64-bit Oracle server because Plsql is 32-bit, there is no 64-bit version, and Oracle is 64-
directory (mine is)D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN folder under Tnsnames.ora,Copy all contents2, Find Plsql decompression directory (my is)D:\PLSQL\PLSQL\instantclient_11_2 folder under Tnsnames.ora,Paste overwrites the original content,4, open the Plsql decompression folder, (my decompression location is)D:\PLSQL\PLSQL\PLSQL Developer Double-click Plsqldev,Enter user name, password, database select Orcl in the dropdown box
\instantclient_12_2. finally download PL/SQL and install, open to Tools preferences Configuration connection file, Oracle home:d:\dev\oracle\instantclient_12_2,oci library:d:\dev\oracle \instantclient_12_2\oci.dll. The key is to configure the environment variables, tns_admin:d:\dev\oracle\instantclient_12_2, and then add in path: D:\Dev\oracle\instantclient_12_2. After the installation of Oracle in the D:\D
the Start.bat file in the Plsql Developer directory. The following are the contents of Start.bat: @echo offSet Path=f:\app\administrator\product\instantclient_11_2Set Oracle_home=f:\app\administrator\product\instantclient_11_2Set Tns_admin=f:\app\administrator\product\instantclient_11_2Set Nls_lang=american_america. Zhs16gbkStart Plsqldev.exe where set Nls_lang=american_america. ZHS16GBK's ZHS16GBK is your database encoding. Then start your plsql
Label:Troubleshooting X64 operating system PL/SQL connection error Make sure the the-Bits Oracle client installedDescription Plsql developer does not support Oracle 64-bit client connections.Workaround:1. Download 32-bit Oracle Cl
Tags: listen file GBK reader operation 32-bit service login OtnThank the original author, the original link: https://wenku.baidu.com/view/433d0b544a7302768f993926.html With the actual installation, Oracle can be successfully installed on a 64-bit Windows7 by the following steps. The following is a detailed download, installation, configuration process. Strictly f
1, Pl/sql Cannot connect Oracle (ORA 12154:tns: Unable to resolve the specified connection identifier)
Workaround: Pl/sql cannot be installed under the Program Files folder, to be installed under the Program Files folders x86
2. Pl/sql
Label:1) Install Oracle 12c 64-bit 2) Installing the 32-bit Oracle Client (INSTANTCLIENT-BASIC-NT-12.1.0.1.0.ZIP) Download Instantclient-basic-win32-11.2.0.1.0.zip, must be Win32 version, Oracle official website has downloaded,: http://www.oracle.com/technetwork/topics/ Hpsoft-090268.html, unzip it to product under the Oracle installation directory: D:\oracle\pro
PID 2303, vid 067b
If the official driver is not easy to use, use the following driver. Normally, do not use it.
AppearsYellow exclamation markThe reason is that pl2303 chips are not officially produced and are counterfeited from China.
For 64-bit (x64) systems, use a 64-bit driver.
If it is displayed, the devic
PLSQLPL/SQL developer is an Oracle Database DeveloperProgramIntegrated Unit Development Environment (IDE). With PL/SQL developer, you can easily create the server part of your client/server application. So far, you can do the following in the worst case:• Use a text editor t
1) Install Oracle 11g 64-bit2) Installing the 32-bit Oracle Client (instantclient-basic-win32-11.2.0.1.0): Http://www.oracle.com/technetwor ... oft-095945-zhs.htmlDownload Instantclient-basic-win32-11.2.0.1.0.zip (must be 32-bit, do not make the wrong version, the Oracle website has downloaded), Unzip it to product under the Oracle installation directory (this ma
1. First talk about the difference between pl/SQL and SQL * plus. For example, it is easy to understand:
Pl/SQL-> C ++ LanguageSQL * plus-> Microsoft Visual C ++ 6.0 Compiler
Pl/SQL is
Win8 64-bit connection to oracle Database Using plsql developer, win8plsql
Problem: When plsql developer is used on a 64-bit win8 system to connect to a local oracle database, an inexplicable problem may occur. The error prompt bo
Tags: col program configuration SQL query field positioning Rod AC MVCThese days encountered two problems, are very wonderful, distressed for three days, the final positioning out.Problem one, inserting data through PL/SQL developer to a remote Oracle database server, querying data through
Install the Oracle database under a 64-bit operating system and download a new 64-bit database (if the 32-bit database is installed on a 64-bit operating system, either the client or th
Encounter this problem, online search a lot, most of the inaccurate interpretation, after exploring according to their own understanding to write how to solve.Phenomenon: The problem is more clear on the Internet, the use of Plsql Developer connection to the database will report a problem with the inability to locate the Oci.dll file, there may be different reports, but the problem is to say this file problem.Cause: The Plsql
The key to performance optimization is to find the right direction, for example, for a PL/SQL code, we think it is slow to execute, but in the end it needs a measurable tool to analyze, and we sometimes like to leave debug code in it, like using dbms_utility.get_ Time is spent on the execution of the statement, which can be cumbersome if the code is large.PL/SQL
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.