本地安装好Oracle数据库,如何使用plsql工具连接数据库
其实很简单,在Oracle客户端的tnsnames.ora的配置文件中添加以下内容就可以了:
orcl =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
其实很简单,在Oracle客户端的tnsnames.ora的配置文件中添加以下内容就可以了:
orcl =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)