2.Oracle数据库SQL开发之 SQL DEVELOPER使用

2.Oracle数据库SQL开发之 SQL DEVELOPER使用

 欢迎转载，转载请标明出处：http://blog.csdn.net/notbaron/article/details/49082215

SQL DEVELOPER在安装ORACLE数据库的时候会自带安装。

不过使用的话需要系统中有JAVA虚拟机方可。

打开后如下图1

所示

 

1.  连接数据库

右键连接如下图2

先通过sqlplus / as sysdba创建一个toad用户

SQL> create user toad identified bytoad;

User created.

SQL> grant dba to toad;

Grant succeeded.

然后配置如下图3

点击测试，成功。

如果失败查看监听是否起来。

蛤蟆此处的监听如下：

[oracle@OEL ~]$ lsnrctl status

 

LSNRCTL for Linux: Version 12.1.0.2.0 -Production on 09-OCT-2015 17:24:11

 

Copyright (c) 1991, 2014, Oracle.  All rights reserved.

 

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version12.1.0.2.0 - Production

Start Date                09-OCT-2015 16:35:22

Uptime                    0 days 0 hr. 48 min. 49 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File  /u01/app/grid/product/12c/grid/network/admin/listener.ora

Listener Log File         /u01/app/grid/diag/tnslsnr/OEL/listener/alert/log.xml

Listening Endpoints Summary...

 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=OEL)(PORT=1521)))

 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=OEL)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/admin/orcl/xdb_wallet))(Presentation=HTTP)(Session=RAW))

Services Summary...

Service "+ASM" has 1 instance(s).

 Instance "+ASM", status READY, has 1 handler(s) for thisservice...

Service "orcl" has 1 instance(s).

 Instance "orcl", status READY, has 1 handler(s) for thisservice...

Service "orclXDB" has 1instance(s).

 Instance "orcl", status READY, has 1 handler(s) for thisservice...

Service "pdb1"has 1 instance(s).

 Instance "orcl", status READY, has 1 handler(s) for thisservice...

The command completed successfully

使用12C的新特性CDB/PDB，如果没使用也没有关系的。

连接上后如下图4

当然除了使用toad用户连接还可以使用sys用户连接。