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), Extract it to the Oracle installation directory under product (native named: instantclient_11_2): D:\Oracle\app\Dell\product\instantclient_11_2 Copy a folder under the root direct
When Oracle uses plsql developer to connect, the following error occurs: The Host object name cannot be found. The solution is mostly because the computer name is modified. Www.2cto.com solution: Step 1: sqlnet under the directory C:/oracle/product/10.1.0/db_1/NETWORK/ADMIN. ora tnsnames. ora listener. the original computer name in these three files is changed to your current computer name. Now the SQL Plus
Using Plsql, the first time you perform a select operation on a table, you are prompted to "dynamic execution table is inaccessible, automatic statistics for this session are forbidden", such as:The problem is that the current connection user does not have SELECT permission for the table v$session,v$sesstat,v$statname under the SYS user because the dynamic performance table-related permissions are not authorized to the current user.Processing method:
The Plsql Developer Menu bar has compare User objects and compare Table data functionality under the Tools option.One, Tools--Compare user objectsThis feature is used to compare objects owned by different users (including table, sequence, function, procedure, view, etc.) and generate SQL scripts that synchronize the differences, and the user can maintain synchronization of the object structure of two users
1. Download from www.oracle.comInstant Client package-Basic: All files required to run OCI, occi, and JDBC-OCI applications,instantclient-basic-nt-11.2.0.3.0.zip(51,149,941 bytes)
2. Install the downloaded client package to D: \ oracleclient, for example, and the client's main directory is D: \ oracleclient \ instantclient_11_2.
3. Create a network subdirectory under D: \ oracleclient \ instantclient_11_2, create an admin subdirectory under the ne
Label:Believe a lot of friends in Plsql Developer debugging Oracle , often encountered in Plsql developer execution of a certain SQL statement is not saved, then we in Plsql Developer how to find the SQL statements we executed, in
1. Automatically check my Objects after login (verified available)By default, after Plsql developer is logged in, Brower will select all Objects, and if you are logged on as a DBA, you will need to wait a few seconds for the tables directory to expand, and the response rate after selecting my Objects is measured in milliseconds.Setup method:The Tools menu--〉brower Filters opens the Order window for Brower F
Plsql developer because there is no corresponding 64-bit program, you can use this program to connect to Oracle only for x86 Oracle clients. This example is oracle11g, go to the official website to download instantclient_11_2 version x86. You can use this green program directly after 11g without installing the program.1. Configure environment variables: Oracle_ho
plsql Developer is an Oracle database development tool, very useful, plsql developer is very powerful, can be used as an integrated debugger, SQL window, Command window, Object Browser and performance optimization and other functions, Here's a quick introduction to how to use the P
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.
Solution:
1. Download the 32-bit Oracle client and install
2, set up Plsql Developer
Open PL SQL in Tools-preferences-connections, set the OCI library (that is, Oracle 32-bit instal
Label:1. Download instantclient-basic-win32-11.2.0.1.0(Oracle website:http://www.oracle.com/technetwork/ topics/winsoft-085727.html, 2:http://download.csdn.net/detail/czw2010/5732241) 2. Unzip the instantclient-basic-win32-11.2.0.1.0 and place it in the Oracle installation directory 3. Open Plsql Developer, select Tools , perference, Connection, configure
appropriate IP address to5. Place the modified Tnsnames.ora file under the D:\Oracle_Cleint\NETWORK\ADMIN folder.6. Environment variable settings (user variable, environment variable, "Properties", "My Computer," right), create a new user variable, variable name nls_lang, variable value simplified Chinese_china. Zhs16gbk7. Configure Plsql Developer, tools → preferences →oracle→ connection, complete Oracle
well as the IP address port number, But when you click OK, it pops up as shown in the first image, which means that you do not have an Oracle client installed or are not configured correctly in the Plsql tool preferences. Therefore, the direct point cancellation, Plsql will automatically open the software as follows the second figure. You will see the software's upper left tip without logging on
Tags: Oracle installation plsqlLast night computer poisoning, system redo, all things have to reload, now to install Plsql Developer, forget before is how to pretend, refer to the online information, re-install also simple to do a record;First, the installation of Oracle software 11.2.3database,c:\app\administrator\product\11.2.0\dbhome_1; This is to facilitate the configuration of monitoring files;Second,
Requirements: To connect to the Oracle database, do not want to install Oracle locally, too large, and account for memory, so use Plsql developer.Read a lot of blogs on the internet, Mom, is not clear, has been prompted to initialize the failure, is that oci,dll and then change a variety of configuration files, useless!Later, a colleague's Plsql Deveploper, his 9-point version, my 11-point, decisive change
Plsql developer "Dynamic execution table is inaccessible, automatic statistics for this session are forbidden" solution 2014-10-08 12:31:46Category: OraclePlsql developer "Dynamic execution table is inaccessible, automatic statistics of this session is forbidden" solutionPhenomenon:The first time with Plsql
Label:This article is original article, reproduced please indicate the source: http://blog.csdn.net/msdnchina/article/details/46416455 Troubleshoot issues that cannot be connected to Oracle DB using Plsql Developer in a Windows X64bit environment Background: Plsql developer does not have a 64bit version, so it can on
Tags: ar sp on data problem BS EF nbsp databaseWhat is written below is commonplace on the Internet: Plsql Developer connection to Oracle database garbled problem. It's written here purely for personal records.Problems that were encountered last week. Native Win7, with Oracle 11GR2 free installation client, through PLSQL Deve
, which is very hight thing. Unlike the overbearing word, basically all the keys have been pre-defined features, the change is very headache. Usually, after opening Plsql developer, the most often do is to open the SQL window and Command window, the two operations have defined shortcut keys, alt+s and ALT + C, so that the mouse point three things only need to press the key.Setup method: Menu Tools---Prefere
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.