Win8.1os64 bit ORACLE11 installation configuration and PL/SQL developer how to connect 64-bit Oracle

Source: Internet
Author: User

Oracle

Why Choose Oracle

1.oracle is capable of running on a mainstream platform, and Windows is only supported on SQL Server, and it's in WR, so you know. In many places, Oracle and Linux are a good choice in terms of security.

2. Supported connection modes, Oracle can support the OLEDB,JDBC,OCI and other standards to connect.

3. From the 80 onwards, Oracle began the release of Oracle6. The vast user base combined with years of coder development experience, can be said to have been honed.

comparison with other databases


installation of Oracle11

Latest

http://www.oracle.com/technetwork/cn/database/enterprise-edition/downloads/index.html, after version 11, Oracle has a much simpler installation, More time to go directly to the next solution. may be different depending on the platform, there are some problems, such as: Win 8 does not bring framework3.5, you need to enable the window function. General installation is not a problem.

Precautions:

1. Since the Oracle service started on more than 100 m, it is recommended that the memory or multipoint, how to at least 4g,2 a G is very card.

2. While hard disk space is generally no problem, set aside about 2G.

3. The installation is complete, there will be an interface



We can either unlock the required account or change the user name in password management. Careful to find that there is such a sentence: The database control URL bit https://localhost:1158/em. This is equivalent to Enterprise Manager in SQL Server. Unlike it, the manager is managed with a browser. Previously, Oracle 10 was also managed by Oracleenterprise Manager (OEM).

Is such an interface



Visual operations make Oracle's operations less difficult than it was before. I think that with this piece of work, Oracle has moved closer to easy-to-operate visualizations, just like SQL Server.

simple use of ore-change password

Example: Changing a user's password


1. Select the server, the user under security



2. In the Object Name column, enter the name of the object you want to manipulate. sys, click Edit



Pl/sqldeveloper Connecting Oracle


Because PL/SQL developer has only 32 bits, Oracle is 64-bit. Need some configuration, here to share my experience in the configuration process.

Environment:

A.oracle Database 11genterprise Edition release 11.2.0.1.0

B.pl/sql 9.0.6

http://www.oracle.com/technetwork/topics/winsoft-085727.html, download the specified version number of the client, and must be 32-bit.

A. After decompression, copy to the installation directory C:\app\Administrator\product.




B. Open PL/SQL, click Cancel, go to interface tool-preferences;



C. Environment variable Configuration




Problems that may occur




The specified connection string could not be resolved because you did not cleanly uninstall the previous Oracle. This time according to

Configure the specified TNSNAME environment variable to


Summary

In the early learning of Oracle at this time, go this and that kind of detour, also met a lot of depressed computer to hit the problem, it is not an abyss of misery, but the kind of mood does not come out really also let people get angry. Then again, learn which technology who is not wandering and depressed. Think carefully, many times, still want to cautious, rigorous, not impatient and quick success. Truth all know, to do when there will always be such a problem, can only be forged in a variety of depressed!


To make haste, to follow the rules of Everything. In addition to their own confidence is also very important, do not because a problem can not solve, discouraged and strike.

Related Article

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.