Label:
Oracle SQL Developer is a very powerful open source SQL development tool, but recently I began to study it, just installed Oracle SQL Developer is not supported to connect MySQL, need to download the JDBC driver formysql from the My
1. EnvironmentWin7 x64,oracle 11g r2,jdk6 x642. QuestionsThe first time you start Oracle SQL Developer will let us fill in the path of Java.exe, I found in the JDK installation directory of the bin Java.exe, but fill in the following error:3. CausesThe Oracle SQL Developer installed in Oracle 11g is 32-bit, and the jav
Because of the reasons for the project need to use the Oracle database, due to time constraints can not learn from the foundation, and the Oracle operation of the command interface is too unfriendly, so I found Pl/sql developer this very useful software to indirectly use the database.
Here's a brief description of how to use this software to connect to Oracle databases.
The first step is to install Oracle
PL/SQL Developer is an integrated development environment that specializes in developing applications for Oracle databases. PL/SQL is also a programming language called the procedural SQL language (procedural language/sql). PL/SQL
Oracle SQL Developer Connection error (ORA-12505)I had a problem with my Oracle database, and I finally got it done. Today I have created another DBA administrator connection method, and I will share my solution with you, I hope it will be useful to you. Connection error code: Listener refused the connection with following error: ORA-12505, TNS: listener ...... confirm that this is the SID error connecting
When logging on to Oracle SQL developer, the problem is solved. When logging on to oracle's built-in SQL developer, the connection method was not selected at the beginning. The default connection type "Basic" was used. I filled in the connection name, user name, password, and connection prompt me error. Listener refuse
When you use PL/SQL developer 7 to connect to a newly installed Oracle database server, ORA-01460 errors always occur frequently: type conversion errors.
Only PL/SQL developer has this problem.
The suspect is a character set problem. I checked a lot of information and found the cause of the problem:Query select * F
When logging in to Oracle with PL/SQL Developer: Using a filter for all users can leads to poor performance!Analysis: Regardless of the configuration of Oracle, you will see very many tables, views, sequences, etc. that are not relevant to the current work when using the tree directory on the left side of Plsql, resulting in very slow opening timesSpecific solution: Tools-->object browser filter--> Select "
installation of weapons is a top priority. There are four modules in the system: Fleet information Management, warship information management, military officer information management, weapon information management. At the same time in the four systems to be inserted, query, change and other changes. Based on these analysis, the data flow chart is drawn out, the dictionary is written out, and the corresponding CDM,LDMandPDM are drawn using Power Designer . Create a table space, create a user, as
Tags: plsql installing Oracle Client InstallationDownload the 3 required packages (in order to connect the 11g database)1:oracle Client (Oracle clients)Http://www.oracle.com/technetwork/cn/database/enterprise-edition/downloads/112010-win64soft-086667-zhs.htmlDownload Win64_11gr2_client.zip Specific installation method can refer to Baidu2:pl/sql Developer 11.0Http://files.allroundautomations.com/plsqldev1106
Please refer to:Http://www.cnblogs.com/ymj126/p/3712727.htmlOrhttp://blog.csdn.net/cselmu9/article/details/8070728Oracle 11g Client can be downloaded from the official Oracle website or at the following URL.Http://pan.baidu.com/s/1X9xDkWhat about PL/SQL developer? Heroes can also be google/baidu to the latest version.Http://pan.baidu.com/s/1X9xDkWood elder brother's articles are based on their own practice,
After installing ORACLE11GR2 for the first time, it was curious to point out that when you click on SQL Developer under Application development, a window pops up, To choose a java.exe path, I will say the JDK1.7 under the Java.exe fill in, and then shut down the interface, the next time, found the warning, the highest version must not be higher than 1.6, and no prompt changes, directly into the interface, b
are four modules: Fleet information Management, warship information management, military officer information management, weapon information management, and in the four systems to be inserted, query, modify and other changes. Based on these analyses, the data flow chart is drawn out, the dictionary is written out, and the corresponding CDM,LDM,and PDM are drawn using Power Designer . Create a table space, create a user, assign permissions, create a user profile, and then build tables, views,
1. Log in to PL/SQL DeveloperThis omits the installation steps for the Oracle database and PL/SQL Developer, and note that when you install the PL/SQL Developer software, do not install it under the program Files (x86) directory or you cannot start PL/
1. the downloaded Oracle SQL Developer, rpm file,: http://www.oracle.com/technology/software/products/ SQL /index.html 2. install sun's jdk1.6, if installed, skip (linux mint 12 is installed by default) command: sudo apt-get install sun-java6-jdk www.2cto.com 3. oracl SQL Develoepr is a rpm package by default. To insta
)) (Connect_data = (SERVER = dedicated) (service_name = orawin) ))Of course, copy can also be obtained from the corresponding directory of the Oracle server already installed.4. After configuring these, open PL/SQL, click Cancel to not login, directly into the interface 5. Select Tools-preferences on the menu Configure the path to the Oracle Instant Client in the lower right corner of the Options page . Oracle Home input D:\software\oracle-instantc
settingsTools-Preferences:Oracle Home directory Name: D:\app\admin\product\11.2.0\dbhome_1OCI Library: D:\app\admin\product\11.2.0\Instantclient_11_2\oci.dll2, Error 2:ORA-12541:TNS: no listening programOpen 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\db
Comparison:Plsqldev: Third-party, fast startup software, slow execution of SQL queriesSqldeveloper:oracle company, slow startup software, fast execution of SQL queriesObjective:To connect a local Oracle Server service-side instance using SqldeveloperUsing Sqldeveloper to connect to a remote Oracle client instanceEnvironment:Oracle 11gOracleClient 11g ODACOracle SQL
Unable to start. After "unable to create an instance..." is downloaded, run the following message:
---------------------------Unable to create an instance of the Java Virtual MachineLocated at path:---------------------------
The reason is that the JVM parameter settings are incorrect. There are two solutions:
Solution 1:
Modify the file and set the "addvmoption-xmx" parameter as follows:Addvmoption-xmx256mThen it starts up normally.
Solution 2:The setting is different, and the principle is the
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.