AIX+Oracle 11gR2安装及配置Gateway透明网关.docx
文本预览下载声明
环境信息:Oracle操作系统: AIX 6.1版本oracle版本:11.2.0.3oracle IP:172.16.7.80ORACLE_SID = orclORACLE_HOME = /orcl/app/product/11.2.0/orcl?SQLServer操作系统: Windows Server 2008SQLServer版本: SQL Server 2008SQLServer IP: 192.168.8.90数据库名:oadata?Gateway操作系统:AIX 6.1版本:? 11.2.0.3安装目录: /home/gateway/gwhomeIP: 172.16.7.80??Oracle与Gateway均安装在AIX小机172.16.7.80上,连接Windows Server上的SQLServer 2008.?操作步骤:1. 从oracle官网上下载透明网关的安装包。2. 创建gateway用户, 用户组与oracle用户相同:#useradd?-u?224?-g?oinstall?-G?oinstall,dba?-m?-d?/home/gateway?-s?/usr/bin/ksh?gateway#passwd gateway3. 以gateway用户登陆,在/home/gateway目录下mkdir gwhome.4. 修改gateway用户的.profile文件,增加如下内容:export?ORACLE_HOME=/home/gateway/gwhomeexport?LD_LIBRARY_PATH=$ORACLE_HOME/libexport?TNS_ADMIN=$ORACLE_HOME/network/adminexport?PATH=$ORACLE_HOME/bin:$PATH?5. 安装gateway软件。选择相应的sqlserver组件。在配置SQLServer的时候,需注意,SQL Server Database Name应该填写需要连接的数据库名称,这里应填写oadata;SQLServer Instance Name为空。最后配置监听的时候选择典型配置。6. 修改gateway的参数文件/home/gateway/gwhome/dg4msql/admin/initdg4msql.ora.?initdg4msql.ora文件是默认生成的.?为方便统一管理, 将该文件改名为init+SID.ora。在本例中,应将该文件改名为initoadata.ora。修改文件内容如下:HS_FDS_CONNECT_INFO=[192.168.8.90]:1433//oadata#?alternate?connect?format?is?hostname/serverinstance/databasenameHS_FDS_TRACE_LEVEL=OFFHS_FDS_RECOVERY_ACCOUNT=saHS_FDS_RECOVERY_PWD=yilingpass7. 修改gateway的监听文件/home/gateway/gwhome/network/admin/listener.ora。文件内容如下:SID_LIST_LISTENER?=??(SID_LIST?=????(SID_DESC?=??????(SID_NAME?=?oadata)???????????(ORACLE_HOME?=?/home/gateway/gwhome)??????(PROGRAM?=dg4msql)?????)??)LISTENER?=??(DESCRIPTION_LIST?=????(DESCRIPTION?=??????(ADDRESS?=?(PROTOCOL?=?IPC)(KEY?=?EXTPROC1522))??????(ADDRESS?=?(PROTOCOL?=?TCP)(HOST?=?172.16.7.80)(PORT?=?1522))????)??)ADR_BASE_LISTENER?=?/home/gateway/gwhome?8. 修改gateway的tnsnames.ora文件(/home/gateway/gwhome/network/admin/tnsnames.ora),内容如下:ORCL?=??(DESCRIPTION?=????(ADDRESS_LIST?=??????(ADDRESS?=?(PROTOCOL?=?TCP)(HOST?=?172.16.7.80)(PORT?=?1521))????)????(CONNECT_DATA?=??????(SERVICE_NAME?=?orcl)????)??)dg4msql?=??(DESCRIPTION?=????(ADDRESS_LIST?=??
显示全部