ora 12514Ora 12514 tns监听程序

Ora 12514 tns监听程序

SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = G:oracleproduct10.2.0db_1) (PROGRAM = extproc) ) --- 以上 为系统自动建立的不用管它 ---- 一下内容是需要我们手动添加的 (SID_DESC = (SID_NAME = efss) -- 生产库的ORACLE_SID (ORACLE_HOME = ) --生产库的ORACLE_HOME (GLOBAL_NAME = ntrs) --生产库对外提供的全局服务名可以与ORACLE_SID不一样 ) ) TNS： ntrs = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.7.61.241)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ntrs) ) ) 注意：每次修改LISTENER文件之后， 需要重启监听服务！！