其他:关于配置文件tnsnames.ora
SID的方式:
DB_82_204 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ip)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ora11g)
)
)
service_name:
DB_82_233 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ip )(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl.oracle11g.com )
)
)
这就要注意登录的时候数据库如何填写,是哪种方式:
ip:orcl sid
ip/orcl servicec_name
也就是这边,由于我配置的是SERVICE_NAME = ORCL,所以IP/service_name(也就是ip/ORCL)
本文暂时没有评论,来添加一个吧(●'◡'●)