一般默认情况下sid与你的数据库的名称是一样的! 查看service_name 创建tnsnames.ora 使用sid或service_name都可以连接数据库 1、service_name: ORASTAT = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 168.168.10.10)(PORT = 1521)) ) (CONNECT_DATA = (service_name = orastat) ...
id, x.name, x.type, y.account from ( SELECT n.account_id as account_id, m.id as id, m.name as name, m.type as type, m.creator, m.info FROM easymetahub.Music_MetaHubDataSource m LEFT JOIN easymetahub.Music_MetaHubAccountDataSource n ON m.id = n.data_source_id ) x left ...
查看service_name 创建tnsnames.ora 使⽤sid或service_name都可以连接数据库 、service_name:ORASTAT = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 168.168.10.10)(PORT = 1521)))(CONNECT_DATA = (service_name = orastat)))2 sid ORASTAT = (DESCRIPTION = (ADDRESS_LIST...
一般默认情况下sid与你的数据库的名称是一样的! 查看service_name 创建tnsnames.ora 使用sid或service_name都可以连接数据库 1、service_name: ORASTAT = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 168.168.10.10)(PORT = 1521)) ) (CONNECT_DATA = (service_name = orastat) ...