ALM_PROD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.211.95.53)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = stdb)
)
)
cgtest =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.211.93.250)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = cgtestdb2)
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.211.95.53)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = stdb)
)
)
cgtest =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.211.93.250)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = cgtestdb2)
)
)
如上,cgtest指数据库服务名称,随便起,
host指主机名称,
port指oracle端口号,
server有2种,dedicated,shared,一般情况下用dedicated,
service_name指数据库实例名称
如果某配置文件中出现:
bme.interact.url = jdbc:oracle:thin:@10.211.93.250:1521:cgtestdb2
bme.interact.username = sns
bme.interact.password = 123456
则表示host为10.211.93.250(host一般在自己电脑上写localhost就行),port为1521,service_name为cgtestdb2,
pl/sql developer登陆的时候,可以通过sns和123456进行登陆,数据库选择为cgtest(即数据库服务名称),连接为normal。