orcle数据库连接测试ODBC配置.docx

1 、配置 oracle 数据库客户端# Configuration File: F:\oracle\product\\WORK\ADMIN\ # Generated by Oracle configuration tools. to_nn= //tns 名称,为方便管理可以随意命名。(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521 )) ) (CONNECT_DATA = (SERVICE_NAME = CL7100 ) // 数据库的名称,不是数据库用户名称。)) ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = gxms) )) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ))2、 CMD 测试连通数据库 Microsoft Windows [ 版本 ] (C) 版权所有 1985-2003 Microsoft Corp. C:\Documents and Settings\Administrator> tnsping //* 第一步,先测试 IP ,可加端口号。 tnsping :1521, tnsping /gxms gxms 为 SERVICE_NAME 。 gdms 为实例名 TNS Ping Utility for 32-bit Windows: Version - Production on 07-12 月- 2011 12:14:34 Copyright (c) 1997, 2006, Oracle. All rights reserved. 已使用的参数文件:D :\oracle\product\\work\admin\.ora 已使用 EZCONNECT 适配器来解析别名 Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(AD DRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521))) OK (10 毫秒) C:\Documents and Settings\Administrator> tnsping to_nn //* 第二步,测试 tns 名 TNS Ping Utility for 32-bit Windows: Version - Prod