DBAII_R1_1_Les04_E

Views:
 
Category: Entertainment
     
 

Presentation Description

No description available.

Comments

Presentation Transcript

Naming Method Configuration : 

Naming Method Configuration

Objectives : 

Objectives After completing this lesson, you should be able to do the following: Describe the difference between host naming and local service name resolution Use Oracle Net Configuration Assistant to configure: Host Naming method Local naming method Net service names Perform simple connection troubleshooting

Overview of Naming Methods : 

Overview of Naming Methods Naming methods are used by a client application to resolve a connect identifier to a connect descriptor when attempting to connect to a database service. Oracle Net provides five naming methods: Host naming Local naming Directory naming Oracle Names External naming

Host Naming : 

Host Naming Clients can connect to a server using a host name under the following conditions: Connecting to an Oracle database service using Oracle Net Services Client software Client and server are connecting using TCP/IP protocol Host names are resolved through an IP address translation mechanism such as DNS or a local /etc/hosts file No advanced features such as Connection Manager or security options are used

Host Naming: Client Side : 

Host Naming: Client Side sqlnet.ora … names.directory_path = (HOSTNAME) Server listener.ora Client TCP/IP

Host Naming: Server Side : 

Host Naming: Server Side Client sqlnet.ora listener.ora Server SID_LIST_LISTENER =(SID_LIST = (SID_DESC = (GLOBAL_DBNAME = stc-sun02.us.oracle.com) (ORACLE_HOME = /u03/ora9i/rel12) (SID_NAME = TEST) 1521 TCP/IP

Host Naming Example : 

Host Naming Example listener.ora file Connecting from the client SID_LIST_LISTENER =(SID_LIST = (SID_DESC = (GLOBAL_DBNAME = stc-sun02.us.oracle.com) (ORACLE_HOME = /u03/ora9i/rel12) (SID_NAME = TEST) sqlplus system/manger@stc-sun02.us.oracle.com

Naming Methods Configuration : 

Naming Methods Configuration

Selecting the Host Naming Method : 

Selecting the Host Naming Method

Local Naming : 

Local Naming listener.ora Server Client tnsnames.ora sqlnet.ora

Selecting the Local Naming Method : 

Selecting the Local Naming Method

Configuring Local Net Service Names : 

Configuring Local Net Service Names

Working with Net Service Names : 

Working with Net Service Names

Specify the Oracle Database Version : 

Specify the Oracle Database Version

Database Service Name : 

Database Service Name

Network Protocol : 

Network Protocol

Host Name and Listener Port : 

Host Name and Listener Port

Testing the Connection : 

Testing the Connection

Connection Test Result : 

Connection Test Result

Net Service Name : 

Net Service Name

Save the Net Service Name : 

Save the Net Service Name

Generated Files:tnsnames.ora : 

Generated Files:tnsnames.ora # TNSNAMES.ORA Network Configuration # File:/u03/ora9i/rel12/network/admin/tnsnames.ora # Generated by Oracle configuration tools. MY_SERVICE.US.ORACLE.COM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = stc-sun02.us.oracle.com)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = TEST.us.oracle.com) ) )

Generated Files:sqlnet.ora : 

Generated Files:sqlnet.ora # SQLNET.ORA Network Configuration File: /u03/ora9i/rel12/network/admin/sqlnet.ora # Generated by Oracle configuration tools. NAMES.DEFAULT_DOMAIN = us.oracle.com NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME) SQLNET.EXPIRE_TIME=0 sqlplus system/manager@MY_SERVICE SQL*Plus:Release 9.0.1.0.0-Production on Thu Nov 15 13:46:24 2001 (c) Copyright 2001 Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production JServer Release 9.0.1.0.0 - Production SQL>

Troubleshooting the Client Side : 

Troubleshooting the Client Side The following error codes are related to problems on the client side: ORA-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 parameters” ORA-12541 “TNS:no listener”

Summary : 

Summary In this lesson, you should have learned how to: Describe the difference between host naming and local service name resolution Use Oracle Net Configuration Assistant to configure: Host naming method Local naming method Net service names Perform simple connection troubleshooting

Practice 4 Overview : 

Practice 4 Overview This practice covers the following topics: Local Naming configuration Configuration of net service names Testing the configuration

authorStream Live Help