Tags: folder copy files SQL Instant DMI 1.2 directory Oracle System installation1. Unzip the J:\ software \ (computer) Computer class software \oracle\plsqldeveloper\instantclient_11_2To product under the Oracle installation directoryC:\app\Administrator\product2, put the C:\app\Administrator\product\11.2.0\dbhome_1 directoryThe network folder is copied to the extracted directory C:\app\Administrator\product\instantclient_11_23, set the Oracle home di
When the PL SQL is installed, the database at the following figure is empty. You need to install a 32-bit client, stating that PL SQL does not support 64-bit client connections.
Soluti
IT Ninja Turtles PL/SQL Developer tips and shortcuts, Ninja Turtles developer
1. SQL plus Window: File-> New-> Command Window. This is similar to the SQL plus client tool of oracle, but it is much easier to use than it.
2. Set the
\instantclient_11_2\oci.dll
Set Plsql boot mode (two ways)1) in the Plsql Developer installation directory, create a script file that reads as follows:@echo offSet Path=c:\application\develop\database\oracle\product\instantclient_11_2Set Oracle_home=c:\application\develop\database\oracle\product\instantclient_11_2Set Tns_admin=c:\application\develop\database\oracle\product\instantclient_11_2Set Nls_lang=american_america. Zhs16gbkStart Plsqldev.exe
Issue: WIN8 64 uses bit system PLSQL developer Local connection Oracle inexplicably problems occur in the database. The error message box may even be empty.Reason: It indicates that the Internet, for reasons, is expected to be installed on a 64-bit system in a
total execution time of all units. When switching to the Unit module, the total execution time of the Unit module is
Unit -- unit name, that is, the stored procedure of execution, including the calling process and anonymous block.Line -- code line numberTotal time -- the execution time of the line of code (the color length represents the percentage of the execution time of the line of code and the maximum code execution time)Occurrences-number of executions of this rowText-the corresponding lin
Label:Installs the 32-bit Oracle Client (instantclient-basic-win32-11.2.0.1.0). WIN7 64-bit system is not plsqldeveloper, so the next 32-bit. Download Instantclient-basic-win32-11.2.0.1.0.zip (must be 32-bit, do not make the wrong version, the Oracle website has downloaded),
Issue: Win8 on a 64-bit system that uses PLSQL developer to connect to a local Oracle database can cause an inexplicable problem, and the error box may even be empty.Reason: According to the internet, the reason is estimated to install 64-bit Oracle database on
If you establish a connection server with a 32-bit database server on a 64-bit computer and use the connection server for Distributed queries on 64-bit computers, the following error message is returned:
Server: Message
7399
, Level
16
, Status
1
, Line
1
Ol
Problem? PL/SQL Developer client installation and configuration and handling of some problemsFirst, the problem analysiswhen using the PL/SQL Developer Client tool, be sure to look at the two-point knowledge that is different from
Export and Import of table structures and table data in PL/SQL Developer, and tables in developerExport table structure: Tools --> Export User Objects (Export User object) --> select the table to Export (including Sequence) -->. in the SQL file, all the exported table data is exported to the
MySQL, MariaDB, SQL Server, SQLite, Oracle, and PostgreSQL databases in a single program. The official website is: Http://www.navicat.com.cn/products/navicat-premium. Since this machine is a 64-bit operating system, download the latest 11.1.10 64-bit version. 3,
the logic, you can put it in this tool, format, the logic of the statement is clear10. Automatic connection of databaseBecause the database does not operate for a period of time, it will automatically disconnect, and then need to manually connect themselves, because of the network, always stuck there. The tool provides the ability to detect connections, which can be automatically connected.The specific settings are checked in front of the Tools-preferences-check Connection,check connection.11.
PL/SQL Developer connects to the Oracle (64Bit) diagram installed on Windows 7. Thanks to the continuous update of hardware technology, Windows 7 has gradually become the mainstream and the computer memory has gradually increased, to make full use of memory resources (because 32 is the system can only use about 3 GB of memory) and improve system performance, many
PLSQL developer cannot connect to 64-bit Oracle solution 1
Date: Source: smallsilver shared:
Oracle10.2.0.4 but pLsQl cannot be connected.Cause:Oci. the dll is 64-bit, and the 32-bit application PLSQL
PLSQL Developer connects to Oracle11g 64-bit database configuration details recently changed to a 64-bit computer, so oracle database also changed to 64-bit, but the problem also arises
Http://hi.baidu.com/yunfanleo/blog/item/fa65fcfd91916346d7887d25.html
PL/SQL developer
PL/SQL developer is an integrated development environment dedicated to the development of Oracle database storage progra
System variables--variable name: Tns_admin variable Value: D:\Oracle11g\admin\product\11.2.0\dbhome_1\NETWORK\ Adminoracle installation directory of network/admin Six, to solve the problem of Chinese garbled. If you can read a series of what the meaning of the representative, unless you wear a perspective mirror, this step can be skipped. 1. Open the registry: Start-run-regedithkey_local_machine/software/oracle/key_oradb11g_home1/oledb right mouse button--new--string value--name changed to: Nls
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.