PL/SQL Developer log on to Oracle 12c

PL/SQL Developer log on to Oracle 12c

After Oracle 12c is installed, PL/SQL Developer cannot connect to Oracle 12c. Search online and follow the instructions in fcflying, so take a note:

1) install Oracle 12c 64-bit

: Http://www.oracle.com/technetwork/cn/database/enterprise-edition/downloads/index.html? SsSourceSiteId = ocomcn

2) install a 32-bit Oracle client (instantclient-basic-nt-12.1.0.1.0)

: Http://www.oracle.com/technetwork/topics/winsoft-085727.html

3) install PLSQL Developer

: Http://pan.baidu.com/s/1gdelc5d

4) decompress the downloaded "instantclient-basic-nt-12.1.0.1.0" file to get the "instantclient_12_1" file, copy "instantclient_12_1" to "D: \ app \ Administrator \ product \ 12.1.0 ". (Note that I have installed Oracle on the D Drive)

5) Copy "D: \ app \ Administrator \ product \ 12.1.0 \ dbhome_1 \ NETWORK \ ADMIN \ tnsnames. ora "file to the" D: \ app \ Administrator \ product \ 12.1.0 \ instantclient_12_1 \ NETWORK \ ADMIN "directory. The "NETWORK \ ADMIN" directory structure does not exist in the "instantclient_12_1" directory. Therefore, you must manually create the Directory and copy the "tnsnames. ora" file.

-------------------------------------- Split line --------------------------------------

Rlwrap

SQLPLUS spool to dynamic Log File Name

Oracle SQLPLUS prompt settings

Accelerate SQL return by setting SQLPLUS ARRAYSIZE (row prefetch)

PL/SQL Developer Practical Skills

-------------------------------------- Split line --------------------------------------