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

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.