Oracleclient + PLSQL Developer remote login to Oracle Database
Oracle databases have powerful functions and excellent performance. When these advantages are created, Oracle accounts for more memory than memory. To address this problem, how can we extract the essence of the problem to its dregs?
Solution: we can install a large Oracle database on the server in the LAN, install Oracleclient on the developer's
The Oracle database is powerful and performance-rich, and while creating these benefits, Oracle accounts for more memory. In response to this question, how do we take its essence to its dross? Solution: We can install a large Oracle database on a server within the LAN, install an Oracle client on the developer's PC, and telnet to the Oracle database via an Oracle client.Operation Steps:1. We can download Oracle client software from Oracle website, al
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 the server side, do not select the C:\Program Files (x86) path, Instead, the installation path will be modified (x86) removed). All the way installed, no problem, after the installation completed Plsql develop, prompting 32-bit
1. Download and install PLSQL developer. Tip: do not install it in the default c: \ Program Files (x86) directory. Otherwise, an unexpected error may occur. The local machine is installed in the C root directory. C: \ PLSQL developer 2.
How plsql developer connects to the database
1. When the PLSQL tool is opened, there are three text boxes, but you will find that the second image and the first image have an additional text box, showing the connection. several parameters are required to connect to the database. You should know that IP addresses, port numbers, user names, passwords, and database
One. Login to Oracle download page http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.htmlDownload Oracle for your computer version, Oracle 12c has only 64-bit version,Select the first, download file1 and file 2, download and extract to the same folder database, first decompression file1, that is, WINX64_12102_DATABASE_1OF2, select Extr
Xiang Sir using A - bit win8.1 System and Installation - bit of orcle , the version is 11g~because of the current Plsql Developer to be + in the first use, there will be no link Oracle database situation, this is because Plsql Developer does not support Oracle -bit Client connection, this article addresses the issue
to the full default, the global database name: ORCL system identifier: ORCL Server parameter file name is your installation address 13. Unlock the lock for the Scott user, then give the password tiger, then click OK, and you can exit the installer 14. Here in fact, Oracle has been installed, but to use plsql this powerful tool, the current Plsqldev official has not given about the 64-bit win version, so collected a lot of information on the web,
Tags: developer tcl sql IAR lis blank extract Auto des1. Download and install Plsql Developer12 Visit Plsql Developer official website https://www.allroundautomations.com/bodyplsqldevreg.html, download Win64 version 2. Visit the
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 64-bit system, but there is no corresponding 64-bit PL/SQL developer for our use, so we cannot connect
Label:1, default automatically check my Objects after loginBy 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 in milliseconds.The Tools menu, Object Brower Filters, opens the Order window for Brower folders and sets the "M
Label:
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 vari
db:11.2.0.3.0Os:oracle-linux 5.7Company Fortress machine in order to safely re-plan, each group can only access the Fortress machine disk space of the individual groups, so the disk space of the online Oracle group cannot be accessed, causing the Plsql developer to be unable to reconfigure the use, I have another client conflict.So simple, the installation of the client, the direct compression configuration
:
Next, configure the host and download Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (x64) and Instant Client for Microsoft Windows (32-bit) from the official website ).
For the installation process, see: Click to open the link.
After the installation is complete, configure the environment variables and add the following two variables respectively:
TNS_ADMINValue: D: \ Oracl11_64 \ product \ 11.2.0 \ client_1 \ network \ ad
Label:Due to development needs, install the XP system in the virtual machine and install Oracle, install Oracle client and PLSQL developer in the host to simulate remote operation of Oracle database. The first thing to do is to install the Oracle database in the virtual machine, the process reference: Click the Open link First, configure the network settings for the virtual machine and change the network co
Tags: enter none sid \ n Instance term Oracle names post The traditional way to connect to a remote database is to install an Oracle locally. Then use the Network configuration Assistant. Then connect with PL/SQL Dev. It is not very convenient because the database needs to be installed locally?The second method is described below1, first to the Oracle website to download three required compression packageDetailed address is: http://www.oracle.com/tech
When using PLSQL developer, the ORA-12154:TNS: Unable to parse the specified connection identifier "a solution to the problem plsqldeveloper version 7.1 today suddenly needs to change a project a long time ago, that project uses Oracle9iStart PLSQL developer, prompt to enter the user name and password and database, ent
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.