installation of PL/SQL developer problems encountered

Prerequisite: The Oracle database has been successfully installed.

Installation environment: Win7 64-bit

Oracle installation version 11g 64-bit

Question 1) Oracle comes with Sqldeveloper

Let me enter the full path of the Java.exe and then report a warning

Warning:could not find jvm.cfg! In ' C:\Program files\java\jdk1.8.0_151\jre\lib\jvm.cfg '

The other person's experience is that the installed Sqldeveloper is 32-bit and the JDK is 64-bit, so no.

Solution) under 64-bit sqldeveloper or 32-bit JDK

But the oracle11g I'm pretending to be is 64-bit.

I didn't try to solve it.

configuration of PL/SQL developer

Suppose the ORACLE11G server class is installed in the app folder on the F drive

PL/SQL Developer Plsqldeveloper---plsql----instantclient_11_2 (client) in E-drive Plsqldeveloper

|__plsql Developer

　　　　　　　　　　　　　　　　　　　　　　　　　　

(1) Environment variables

　　Nls_lang = Simplified Chinese_china. Zhs16gbk

　　Tns_admin = E:\PLSQLDEVELOPER\PLSQL\instantclient_11_2 (#---> Installation path) "is a problem."

　　Actually, after looking at http://blog.csdn.net/mr_li13/article/details/52226006, I found

Direct settings tns_admin = F:\app\zml\product\11.2.0\dbhome_1\NETWORK\ADMIN (Directory for Oracle Server class installation)

You can save the process of configuring Tnsnames.ora later

"Note" If you want to trouble a little afraid of error, can be like a red letter configuration, and then copy and paste F:\app\zml\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.org

　　To #\plsql\instantclient_11_2\network\admin (if not created by yourself)

Running PL/SQL developer will find

Unable to connect to Oracle server There are two options SYSDBA, Sysoper

With SYSDBA login, the maximum, for SYS user (super user sudo), can do anything

After logging in with Sysoper permissions slightly more than SYS, for public users, can not create a delete database, only the full recovery of the database, can not be fully restored

Reference http://blog.csdn.net/mr_pang/article/details/50032515

Then cancel and go to the PL/SQL Developer page

(2)PL/SQL Developer Environment Setting (emphasis)

Tools----> Preferences-----> Connections

Set Oracle Home directory name: F:\app\zml\product\11.2.0\dbhome_1 (Oracle server Classpath)

Setting up the OCI Library: E:\plsqldeveloper\plsql\instantclient_11_2\oci.dll (OCI Library in Oracle client)

You can go in when you're done.

Configuration error may cause ORA-12170 TNS ' connection timeout '

ORA-00911 Invalid character

ORA-12154 TNS: Unable to resolve the specified connection identifier (and possibly a space before the SID name)

　　

installation of PL/SQL developer problems encountered