PL/SQL Developer是一个集成开发环境,专门面向Oracle数据库的开发和管理,是一款很实用的Oracle客户端程序。如何配置PL/SQL实现和Oracle的连接呢?
1.配置Oracle数据库连接
2. 下载并安装PL.SQL.Developer配置应用
1.配置Oracle数据库连接
前面一篇我们已经知道如何使用Oracle的Net Configuration Assistant配置数据库连接。除此方法外,我们还可以通过修改配置文件的方式实现数据库的连接。在Oracle的安装文件下查找tnsnames.ora文件,一般路径如: ORACLE_HOME%\network\admin下:
添加如下内容:
- oracledata =
- (DESCRIPTION =
- (ADDRESS_LIST =
- (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.112)(PORT = 1521))
- )
- (CONNECT_DATA =
- (SERVICE_NAME = orcl)
- )
- )
2. 下载并安装PL.SQL.Developer配置应用
配置tools->preferences->connection
3.再次打开plsql则会在database中有oracledata 选项输入用户名密码就可以登陆。
oracle\product\10.2.0\client_1\tnsnames.ora
10.1.11.151 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.11.151)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.11.151)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)