Oracle11g installation problem summary

Oracle11g installation problem summary

Test environment: win7 64-bit flagship edition + jdk7 (64-bit)

Installed Software: oracle 11g R2 64-bit

After the database is installed according to the general online tutorial, a bunch of problems are found. Close up this note.

1. log in with SQL developer and report the following error:

Because the system prompts sqldevelZ development? Http://www.bkjia.com/kf/ware/vc/ "target =" _ blank "class =" keylink "> keys + o6zO0r + keys/keys + y93be9yr3WuM/keys/qOsyLu6887Swem7 + tK7tq + keys/ qGjPC9wPgo8cD4yoaK4/LjEusPWuM/ywre + ttLUuvO3os/W09axqLTtwcuhozwvcD4KPHA + pgltzybzcm9 "http://www.2cto.com/uploadfile/Collfiles/20150514/2015051410110620.png" alt = "\">

Question about Java Virtual Machine? A friend told me:

The Oracle SQL developer is NOT supported on 64 bits JDK. to solve it, install a 32 bits/x86 JDK and update your SQL developer config file, so that it points to the 32 bits JDK.

That is to say, oracle does not support 64-bit jdk. Because my computer is a 64-bit system, so I installed jdk is 64-bit, so this error is reported. I think a 32-bit system friend should not have such a problem.

Now you only need to download a 32-bit SQL developer, and decompress it to replace the location of sqldeveloper in the installation folder.

Now, the problem that sqldeveloper cannot log on is solved.

Then I started to install plsql. Okay, the problem is coming again.

After plsql is installed, you cannot log on. An error is reported !!!

The above prompt is very clear. Let me confirm whether my client is a 32-bit client. If you know the problem, go to the oracle official website and find a 32-bit client of the corresponding version.

1. decompress the package to the oracle installation folder. Where I am: D: \ oracle \ product \ instantclient_11_2;

2. Copy tnsnames. ora (in % Oracle_Home % \ NETWORK \ ADMIN) in the Oracle installation directory to this directory.

3. Go to PL/SQL (do not log on to enter), select Tools> Preferences., and set Oracle_Home and OCI Library to the 32-bit Client Directory installed in step 1, as shown in:

Next, configure the environment variables:

NSL_LANG = AMERICAN_AMERICA.ZHS16GBK)

TNS_ADMIN = D: \ oracle \ product \ instantclient_11_2 (this is the path after my client unzipping)

Then restart plsql. Log on again. The problem is solved in this way.