安装DBvisualizer并且配置oracle

1.安装

有绿色免安装版，DBvisualizer介质地址：链接: http://pan.baidu.com/s/1i5BJ5E9 密码: 48e8：下载后解压即可

2.配置

1）点击dbvis-multi.exe启动DBvisualizer客户端

2）点击下图，新建数据库连接，使用向导配置数据库连接

3）配置oracle连接设置

如果报错：listener连接错误，可以到oracle的安装目录/u01/app/oracle/product/11.2.0/db_1/network/admin下找到 listener.ora

编辑查看：

# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
#SID_LIST_LISTENER =
 # (SID_LIST =
  #    (SID_DESC =
   #     (GLOBAL_DBNAME =orcl)
#       (ORACLE_HOME =/u01/app/oracle/product/11.2.0/db_1)
 #       (SID_NAME =orcl)
  #          )
 # )


LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle