Đang chuẩn bị liên kết để tải về tài liệu:
OCA: Oracle Database 11g Administrator Certified Associate- P17

Tham khảo tài liệu 'oca: oracle database 11g administrator certified associate- p17', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | Configuring Oracle Net for the Client 631 FIGURE 11.20 Choosing a network protocol 3. 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 hostname 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 . FIGURE 11.21 Choosing a hostname and a port 4. 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 Oracle8z or 632 Chapter 11 Understanding Network Architecture later databases or Oracle8z and previous databases. You can also select the connection type from one of these choices Database Default Û Shared Server Û 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 information 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 shown in Figure 11.23. FIGURE 11.22 Choosing the service name FIGURE 11.23 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 Configuration. This creates and saves the tnsnames.ora file. Contents and Structure of the tnsnames.ora File You created the tnsnames.ora file using the Oracle Net Manager so open the tnsnames.ora file to view its contents. The tnsnames.ora file is located at the location the