How to install and configure Win8.1OS64-bit oracle11 and connect PL/SQL Developer to 64-bit oracle and win8.1os64oracle11

How to install and configure Win8.1OS64-bit oracle11 and connect PL/SQL Developer to 64-bit oracle and win8.1os64oracle11
Oracle

 

Why oracle?

 

1. oracle can run on mainstream platforms, while SQL server only supports windows, while windows is running in wr, so you know. In terms of security, oracle and linux are a good choice in many places;

2. In the supported connection mode, oracle can support standard connections such as oledb, jdbc, and oci.

3. oracle began release of oracle6. The huge user base, coupled with years of experience in coder development, can be said to have been honed.

 

Comparison with other databases

 

Oracle11 Installation

 

Latest

Http://www.oracle.com/technetwork/cn/database/enterprise-edition/downloads/index.html, after version 11, oracle installation is much simpler, more when the next step to solve. Some problems may occur depending on the platform. For example, there is no built-in framework3.5 on win 8. You need to enable this window function. Generally, installation will not cause problems.

 

Note:

1. Since the oracle service starts more than 100 MB, it is recommended that the memory be more than one point. How can we get at least 4 GB, and 2 GB is very stuck.

2. There is no problem with hard disk space, and it is reserved for about 2 GB.

3. After the installation is complete, there will be such an Interface

 

In password management, we can unlock the account or change the user name. Be careful, you can find that the above sentence: database control URL bit https: // localhost: 1158/em. This is equivalent to the Enterprise Manager in SQL server. Unlike it, the manager is managed in a browser. Oracle 10 was previously managed using oracleenterprise manager (OEM.

Is such an Interface

 

Visualized operations make oracle operations less difficult than before. I think oracle has moved closer to easy-to-operate visualized operations, just like SQL server.

 

 

Easy to use-Change Password

 

For example, changing a user's password

1. Select the server. Users under security

 

 

2. In the object name column, enter the object name sys you want to operate on and click Edit.

 

 

 

 

PL/SQLDeveloper connect to oracle

 

PL/SQL Developer only has 32 bits, while oracle does. Some configurations are required. Here I will share my experience in the configuration process.

 

Environment:

A. oracle database 11 genterprise edition release 11.2.0.1.0

B. Pl/SQL 9.0.6

 

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

 

A. decompress the package and copy it to C: \ app \ Administrator \ product in the installation directory.

 

B. Open PL/SQL. Click Cancel to go to the interface tool-preferences, as shown in the configuration.

 

 

C. Environment Variable Configuration

 

Possible problems

The specified connection string cannot be parsed, probably because you have not completely uninstalled the previous oracle. At this time, follow

Configure the specified tnsname environment variable.

Summary

 

At the very beginning of oracle's learning, we had such a detour. We also encountered a lot of depressing questions about computers, which was not so hot, but that kind of bad mood is indeed quite irritating. Then again, no one is confused or depressed about the technology. Think about it. In many cases, you must be careful, rigorous, and impatient. As we all know, there will always be such a problem at the time of doing so. It can only be forged in various kinds of depressing!

Speed is not up to speed, step by step, and everything should follow the rules. In addition, confidence in yourself is also very important. Don't be discouraged and strike if one problem cannot be solved.

How to configure Oracle 11g 64-bit connection P/l SQL Developer?

You need to create the ORACLE_HOME main directory and environment variables for the Windows operating system:
OraHOME. reg
Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE \ SOFTWARE \ ORACLE \ Users] "NLS_LANG" = "SIMPLIFIED permission" "ORACLE_BUNDLE_NAME" = "Enterprise" "ORACLE_GROUP_NAME" = "Oracle-stronglient10g_home1" "ORACLE_HOME "=" D: \ instantclient_10_2 "" ORACLE_HOME_KEY "=" SOFTWARE \ ORACLE \ key_1_lient10g_home1 "" ORACLE_HOME_NAME "=" OraClient10g_home1"
OraEnv. reg
Windows Registry Editor Version 5.00 [HKEY_CURRENT_USER \ Environment] "LD_LIBRARY_PATH" = "D: \ SmartAct \ OracleWork \ instantclient_10_2 "" NLS_LANG "=" SIMPLIFIED authorization "" ORACLE_HOME "=" D: \ instantclient_10_2 "" PATH "=" % PATH %; D: \ instantclient_10_2 "" SQL _PATH "=" D: \ instantclient_10_2 "" TNS_ADMIN "=" D: \ instantclient_10_2 \ network \ admin "are respectively saved as a registry file for import and then start.


Pl/SQL developer failed to log on to Oracle 11g (Windows 7 (64-bit), oracle 11g 64 (BIT ))

Use PL/SQL Developer to connect to OracleX64:
• 1. Download the 32-bit Oracle InstantClient and expand it to a directory, such as C: \ instantclient-basic-nt-11.2.0.2.0;
• 2. Copy the system tnsnames. ora to this directory;
• 3. Set Oracle_Home and OCI Library in PLSQL Developer:
Tools configure Preferences configure Oracle connector Connection:
Oracle_Home: C :\ instantclient-basic-nt-11.2.0.2.0
OCI Library: C :\instantclient-basic-nt-11.2.0.2.0 \ oci. dll
• 4. Edit the following bat file in the PLSQL Developer directory, replace the shortcut, and start PLSQL Developer:
@ Echo off
Set path = C: \ instantclient-basic-nt-11.2.0.2.0
Set ORACLE_HOME = C: \ instantclient-basic-nt-11.2.0.2.0
Set TNS_ADMIN = C: \ instantclient-basic-nt-11.2.0.2.0
Set NLS_LANG = AMERICAN_AMERICA.ZHS16GBK
Start plsqldev.exe