li_chuansong
发贴: 55
积分: 21
|
于 2003-07-28 12:27
1.配置LISTENER.ORA
LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = qdgs-jk)(PORT = 1521)) )
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = f:\Oracle\Ora81) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = oracle.qdgs) (ORACLE_HOME = f:\Oracle\Ora81) (SID_NAME = oracle) ) #============================sidn_ame同inittg4msql.ora一致 (SID_DESC = (SID_NAME = tg4msql) (ORACLE_HOME = f:\Oracle\Ora81) (PROGRAM = tg4msql) ) ) #===================== 2.配置TNSNAMES.ORA(增加) TG4MSQL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = qdgs-jk)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = tg4msql) ) ) 3.inittg4msql.ora #文件名=init+sidn_ame # HS init parameters # HS_FDS_CONNECT_INFO=qdgs_oa.oa_db HS_FDS_TRACE_LEVEL=OFF
九佰 edited on 2003-07-30 10:22
|