Oracle+9i培训胶片中文版-3-6.客户端配置-caith

1、Network 客户端配置1.01目标通过这部分课程的学习，您应该了解：主机命名方法本地服务名方法使用Oracle Net 配置助理:主机命名方法网络服务名处理简单的连接问题2主机名方法需要客户端软件客户端和服务端支持TCP/IP协议需要DNS或者本地的/etc/hosts 文件不支持连接管理和安全选项3sqlnet.oralistener.oraServerTRACE_LEVEL_CLIENT = OFFsqlnet.authentication_services = (NTS)names.directory_path = (HOSTNAME)TCP/IPClient主机命名客户端配置4Cl

2、ientsqlnet.oralistener.oraServerSID_LIST_LISTENER =(SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ) (ORACLE_HOME = /u03/ora9i/rel12) (SID_NAME = TEST) 1521TCP/IP主机命名服务端配置5选择主机命名方法6主机命名方法7配置本地网络服务名8服务名添加9指定oracle版本10输入数据库服务名11网络协议12主机名和 Listener 端口13测试和连接14连接测试结果15自己命名网络服务名16保存17# TNSNAMES.ORA Network Conf

3、iguration # Generated by Oracle configuration tools.MY_SERVICE.US.ORACLE.COM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521) ) (CONNECT_DATA = (SERVICE_NAME = TEST.) ) )tnsnames.ora18# SQLNET.ORA Network Configuration File: /u03/ora9i/rel12/network/admin/sqlnet.ora

4、# Generated by Oracle configuration tools.NAMES.DEFAULT_DOMAIN = NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME)SQLNET.EXPIRE_TIME=0sqlplus system/managerMY_SERVICESQL*Plus: Release .0 - Beta on Tue Feb 27 10:11:00 2001(c) Copyright 2000 Oracle Corporation. All rights reserved.Connected to:Oracle9i Enterprise Edition Release .0 - BetaJServer Release .0 - BetaSQLsqlnet.ora19ORA-12154 “TNS:could not resolve service name” ORA-12198 “TNS:could not find path to destination” ORA-12203 “TNS:unable to connect to destination”ORA-12533 “TNS:illegal ADDRESS paramet