it locally. However, it is still difficult for the client to use the tool during this time. On the one hand, Oracle Database beginners do not know whether the client has sqlplus and where to download it; on the other hand, they do not know how to configure it to connect to remote ORACLE. The following is a brief explanation.
The following is a: http://www.oracle.com/technetwork/topics/winsoft-085727.html
First, the problem descriptionThe oracle-client side is not installed locally, and because of limited machine resources, you want to connect to the remote database via PL/SQL developer. Simple installation PL/SQL developer cannot connect to the database remotely.Second, the settlementFirst Unified version: Windows64 bit, pl/sql64 bit, download instantclient-basic
Today, the second configuration of PL/SQL developer, said that the egg hurts, yesterday because moved a thing and then inexplicably can not connect the database, always show a variety ofError, I moved the thing is because the Chinese will show garbled, (because I am using 32-bit PL/SQL developer to connect 64-bit Orcale, so refer to the online tutorial in the TimAdd an environment variable name is Nls_lang,
Log on to PL/SQL Developer, log on to the local database, and check that the Oracle listening service is not started. Right-click to start the listening program and report an error. How can this problem be solved ?,
I. Error description
When you log on to PL/SQL Developer to log on to the local database, no listening program is reported. Check that the
Users who do not have Oracle installed locally must download a instantclient (even the client), and the path points to it for normal useDownload Instantclient-basic-nt-11.2.0.3.0.zipUnzip to D:\Oracle\instantclient_11_2First open the Plsql interface pop-up login box This time you very impulsive entered the correct user name password, as well as the IP address por
/ ahr0cdovl2jsb2cuy3nkbi5uzxqvbhf4mdqwnq==/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70/gravity/ Center "/>TNSNames configured properlyAfter multiple lookups, the reason is:specific reason: The 64-bit Win7 will install the 32-bit application into the program Files directory by default, and the two parentheses may be frustrating for Oracle. Change the installation path for a more "popular"
Tags: blog http java strong file art ar problemORACLE SQL Developer does not support Java versionsToday I open ORACLE SQL developer ready to start practiced hand. Did not expect to give a false hint . I have a Java JDK installed and a version 1.6. I might have chosen the Java.exe file below the bin directory, which was supposed to be the result of no problem or a
After PLSQL developer is installed, there are always some problems during connection configuration. The following describes the direct channel:
1. The client needs to install the compressed client package downloaded from the Oracle official website, for example, decompress it to D:/sqlplus.
2. The host information and SERVICE_NAME information in the tnsnames. ora file in the D:/sqlplus directory of th
Tags: software lis completed ORACL without ref EVEL management 127.0.0.11. Install Plsql DeveloperOracle database and PL/SQL Developer installation steps, here do not narrate, Baidu installation method when you say in the installation of PL/SQL developer software, do not install in program Files (x86) directory, otherwise cannot start pl/ SQL Developer, this I ha
From: http://blog.csdn.net/kk185800961/article/details/86023061. Start with only Oracle and access connections2. Open Oracle SQL Developer:Tools--> Preferences--> Database--third-party JDBC driver--Add driver entries3. Automatically loaded into the directory, Jtds.jar downloaded to put here.(My path: C:\Documents and settings\administrator\application data\sql
there may be unexpected problems Set the following environment variables Oracle_home=d:\oracle\instantclient_11_2 Tns_admin=%oracle_home%\network\admin Nls_lang=simplified Chinese_china. Zhs16gbk The path variable is prefixed with%oracle_home%; III. installation of PL/SQL Developer and Configuration : http://allroundautomations.com/ Special note that install
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 it is already installed, skip this step. (linux mint 12 is installed by default.) command:Sudo apt-get install sun-java6-jdk
3. l SQL Develoepr setting is an rpm package by default. To install Mint in Linux, You need to convert the RPM to DEB package. Now, you
PL/SQL Developer does not install a client to connect to a remote oracle database (for example, developeroracle)Labels ):Http://www.oracle.com/technetwork/cn/database/features/instant-client/index-092699-zhs.html2. Download and install PLSQL (around 16 Mb ):Http://www.onlinedown.net/soft/4902.htm3. Unzip the instantclient-basic-win32-11.2.0.1.0.zip to a new folder, such as D:/oracleclient/instantclient_11_2
1. Configure the Oracle database connection
In the previous article, we have learned how to use Oracle's net configuration assistant to configure database connections. In addition, you can modify the configuration file to connect to the database. Find the tnsnames. ora file under the Oracle Installation File. The general path is ORACLE_HOME % \ Network \ ADMIN:
O
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 install Mint in Linux, You need to convert the RPM to DEB package. Now, you need to download th
Oracle Database installation process is cumbersome, and uninstall more cumbersome, if the uninstallation is not clean, the next time you install Oracle will not succeed. Here's a way to remotely connect an Oracle database using the PLSQL Developer tool without having to install an
Tags: des style blog http color io os using ARThis article goes from the CSDN blog, http://blog.csdn.net/helifengwell/archive/2010/08/18/5820434.aspx1, first download instant Client to Oracle site:Http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/index.htmlChoose a different instant client version number depending on your operating systemDownload back is a compressed file, extracted after the folder called: D:/instantclient_11
This article goes from the CSDN blog, http://blog.csdn.net/helifengwell/archive/2010/08/18/5820434.aspx1, first download instant Client to Oracle website:Http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/index.htmlChoose a different instant client version based on your operating systemDownload back is a compressed file, extracted after the folder called: D:/instantclient_11_2. Put it in the directory you like. For example: d:/
Tags: style blog C java tar http1. 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
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.