oracle找不到mts,oracle MTS 配置

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = paidb)

(ORACLE_HOME = /oracle/app/oracle/product/11.2.0/dbhome_1)

(SID_NAME = paidb)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.20.28)(PORT = 1523))

)

)

)

修改oracle的tnsnames.ora配置文件，如下

PAIDB =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.20.28)(PORT = 1523))

(CONNECT_DATA =

(SERVER = SHARED)

(SERVICE_NAME = paidb)

)

)

LISTENER_PAIDB =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.20.28)(PORT = 1523))

注：一定要将 tnsnames.ora中的SERVER设置为SHARED，才是共享方式访问