OCA: Oracle Database 11g Administrator Certified Associate Study Guide- P15

OCA: Oracle Database 11g Administrator Certified Associate Study Guide- P15: There is high demand for professionals in the information technology (IT) industry, andOracle certifications are the hottest credential in the database world. You have made theright decision to pursue certification, because being Oracle Database 11g certified will giveyou a distinct advantage in this highly competitive market.
Nội dung trích xuất từ tài liệu:
OCA: Oracle Database 11g Administrator Certified Associate Study Guide- P15 Configuring Oracle Net for the Client 631F i g U r e 11 . 2 0 Choosing a network protocol3. The next step is to choose the hostname and port. This step depends on the protocol you chose in the previous step. If you chose TCP/IP, you are prompted for the host- name and the port number. The hostname is the name of the machine on which the listener process is running. The port number is the listening location for the listener. The default port is 1521 (see Figure 11.21).F i g U r e 11 . 2 1 Choosing a hostname and a port4. The next step is to define the service name. For Oracle 11g, the service name does not have to be the same as the ORACLE_SID because a database can have multiple service names. In Oracle 11g, the service name is normally the same as the global database name. This is the service name that is supplied to the listener, so the listener has to be listening for this service. You can also choose whether this service is for Oracle8i or632 Chapter 11 N Understanding Network Architecture later databases or Oracle8i and previous databases. You can also select the connection type from one of these choices: NÛ Database Default NÛ Shared Server NÛ Dedicated Server Figure 11.22 shows an example of the Oracle Net Manager service name screen.5. The last step is to test the net service name and verify that all the connection informa- tion entered is correct. Click the Test button to test the network connection. Click Finish button to create the tnsnames.ora entry. You can edit the entry, as shownin Figure 11.23.F i g U r e 11 . 2 2 Choosing the service nameF i g U r e 11 . 2 3 The Oracle Net Manager tnsnames.ora wizard Configuring Oracle Net for the Client 633 After you complete all this, save your changes by choosing File  Save Network Con-figuration. This creates and saves the tnsnames.ora file.Contents and Structure of the tnsnames.ora FileYou created the tnsnames.ora file using the Oracle Net Manager, so open the tnsnames.orafile to view its contents. The tnsnames.ora file is located at the location the TNS_ADMINvariable is set to, which defaults to the $ORACLE_HOME/network/admin directory. Here is anexample of the tnsnames.ora file:OCP11G = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = bt-dell1)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = OCPTEST) ) ) Table 11.6 summarizes the parameters in the tnsnames.ora file.tA b l e 11 . 6 The tnsnames.ora ParametersParameter DescriptionDESCRIPTION Starts the connect descriptor section of the file.ADDRESS_LIST Starts a list of all connect descriptor address information.ADDRESS Specifies the connect descriptor for the net service name.PROTOCOL Specifies the protocol used, such as TCP/IP.HOST Specifies the name of the machine on which the listener is running. An IP address can also be specified in TCP/IP.PORT Specifies the listening location of the listener specific to TCP/IP.CONNECT_DATA Starts the services section for this net service name.SERVICE_NAME Replaces the SID parameter from older releases of Oracle. Defines which service to connect to, which can be the same as the ORACLE_SID or the global database name. Databases can now be referred to by more than a single service name.634 Chapter 11 N Understanding Network ArchitectureConfiguring Local Naming Using Enterprise ManagerYou can also use Oracle Enterprise Manager to configure local naming. You do so from theNet Services Administration screen as described in the “Adding a Listener Using EnterpriseManager Database Control” section earlier in this chapter. You will see the screen shownin Figure 11.15. Choose Local Naming from the Administer drop-down list, and click Goto open the Local Naming screen, as shown in Figure 11.24.F i g U r e 11 . 2 4 Using Enterprise Manager to configure local naming1. Click the Create button to open the Create Net Service Name page. Here you can enter the unique service name that you want users to use to connect to this Oracle service. This can also be the Oracle SID.2. Select the type of connection to use for this service: a dedicated server, shared server, or the database default.3. Specify the address information. This includes the protocol, port, and host used by the service being connected to.4. Click the Add button under Addresses to open the Add Address screen to fill in the approp ...