本地没有安装oracle怎么连接数据库

Answer 1

配置字符串
E:\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN下的tnsnames.ora文件 仿照里面的配置即可
SERVER149 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.149)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)
修改HOST跟SERVICE_NAME
SERVER149 这个你随便起