1) Install Oracle 11g 64-bit2) Installing the 32-bit Oracle Client (instantclient-basic-win32-11.2.0.1.0)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), Unzip it to product under the Oracle installation directory (this machine is name
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 64-bit Oracle database. However, there is no corresponding 64-bit PL/SQL
, and then in the Instantclient_11_2 directory, create a new Layer two folder \NETWORK\ADMIN, Then build a tnsnames.ora file under the Admin folder and add the following to the file: [Plain]View PlainCopyprint?
ORACLE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))
(Connect_data =
(SERVER = dedicated)
(service_name = ORACLE)
)
)
Listener_orac
\instantclient_12_2. finally download PL/SQL and install, open to Tools preferences Configuration connection file, Oracle home:d:\dev\oracle\instantclient_12_2,oci library:d:\dev\oracle \instantclient_12_2\oci.dll. The key is to configure the environment variables, tns_admin:d:\dev\oracle\instantclient_12_2, and then a
Installing the 32-bit Oracle client Instantclient-basic-nt-12.1.0.1.0.zip: http://www.oracle.com/technetwork/topics/winsoft-085727.html Download unzip to get "instantclient_12_1" file, copy "Instantclient_12_1" to "C:\app\oracle\product\12.1.0" (can also be any path). Installing Plsql Developer: http://pan.baidu.com/s/
Tags: style blog http color ar file SP art
Download instantclient-basic-nt-11.2.0.2.0 -bit client, post-pressurized storage, such as F:\instantclient_11_2
Copy the Oracle 11.2G Msvcr80.dll and Tnsnames.ora to the extracted instantclient_32-bit client root directory, where they are:D:\home\product\11.2.0\dbhome_1\BIN and D:\home\product\11.2.0\dbhome_1\NETWORK\ADMIN
Set up the Oracle_home and OCI Library in Plsql
Oracle Database Restore, how to restore a DMP file to the Oralce library Recently used to restore data from Oracle's DMP file because there is no such information, collected on the Internet, I believe that the following information, we can successfully restore the DMP file with the command line back to the Here I am using the oracle10g version, my machine is 512 RAM, there are some difficulties in running Oracle
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
Installing JAVA-JDKThis part of the tutorial is a lot, you can follow the online tutorial to installInstalling SqldeveloperDownload Sqldeveloper Linux RPM http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.htmlSince Oracle does not provide the. deb installation package, you need to download and install Alien, convert and install rpmsu
First, download the Oracle client: http://www.oracle.com/technetwork/topics/winsoft-085727.htmlCurrent Latest VersionVersion 12.1.0.2.0Select the first instant Client for Microsoft Windows (32-bit) to download it,Please do not download 64bit, I have tried, can not achieve the connection.Unzip the downloaded Instantclient-basic-nt-12.1.0.2.0.zip compressed package and put it in the D:\instantclient_12_1 directory.In the environment variables, in the sy
----ORACLE as a large database management system, its powerful and perfect data management function attracts more and more people's attention. In Oracle system development, I have the following experience in developer/2000 programming, hoping to provide some references for beginners.
----A, use Settings menu item properties and form data item properties to restri
After the Oracle database is installed, start the database as SQL Developer: The result is a small box prompting you to enter the full PathName for Java.exeFor this workaround:Locate the Java.exe file under the Oracle path that you installed, and locate the following two paths of Java.exe:First one: D:\app\Administrato
1. 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 developer\)my jtds
Comparison of two-live solutions: ASM vs V-plexWang WenjieOracle Company Principle System AnalystOracle Advanced ServicesThe evolution of Oracle Database Center disaster Recovery has evolved over the years from initial cold backup, to hot backup, to storage replication, to Dg,adg,rac one node, RAC, and eventually to the hottest dual-live dual-center architecture, This is the remote RAC (Extended RAC) we often call.General pre-Sales engineers to realiz
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.