Installation of Oracle client Pl_sql

The operation of the Oracle database is mostly done on the client, so in many client software I chose Pl_sql, talk about the basic installation and operation of Pl_sql, as well as some problems encountered in the operation;

1. First download the Pl_sql client software, you can download the latest version on Oracle's official website.

Http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

After the decompression can be used directly, click on the "EXE" executable file can be used.

2. Main interface of the software:

3. Create a new understanding database:

The login user name "SYSTEM" Password is the password you set when you installed Oracle.

4. Click "Connect" after the screen display:

Add the JDBC jar package for MySQL.

Add a "MySQl" Connection when you create a new connection when you are finished adding:

Problems encountered in 1:

Restart after you close pl_sql. The following error occurred.

Solution:

Rename the "SQL Developer" folder under the path "C:\Users\ your hostname \appdata\roaming"to"SQL Developer-backup" or delete it directly. Then, after restarting, Oracle automatically re-creates a SQL Developer.

Referenced connections: http://bbs.csdn.net/topics/390721236 #4 Building

What you see in the Oracle Forum:

1. Go to C:\Users\%USERNAME%\AppData\Roaming and rename ' SQL Developer ' folder to something like ' SQL Developer-backup ' to Make sure your won ' t loose history etc.

2. Start SQL Developer and it'll recreate the folder from the scratch. You can later copy the history from the backup folder.

The above is the pl_sql from the installation to the basic use of the process.

Installation of Oracle client Pl_sql