tailieunhanh - OCA /OCP Oracle Database 11g A ll-in-One Exam Guide- P20

OCA /OCP Oracle Database 11g A ll-in-One Exam Guide- P20:There is an ever increasing demand for staff with IT industry certification. The benefits to employers are significant—they can be certain that staff have a certain level of competence—and the benefits to the individuals, in terms of demand for their services, are equally great. Many employers are now requiring technical staff to have certifications, and many IT purchasers will not buy from firms that do not have certified staff. | OCA OCP Oracle Database 11g All-in-One Exam Guide 146 user interface. For all the commands you must specify the name of the listener if it is not the default name of LISTENER. Figures 4-6 and 4-7 show how to check the status of a listener and to stop and start it issuing the commands either from the operating system prompt or from within the user interface. Note that the status command always tells you the address on which the listener accepts connection requests the name and location of the file that defines the listener and the name and location of the log file for the listener. Also in the examples shown in the figures the listener LIST2 supports no services. This is because there are no services statically registered in the file for that listener and no instances have dynamically registered either. Figure 4-8 uses the services command to show the state of the listener after an instance has registered dynamically. Figure 4-6 Using Isnrctl commands from the operating system prompt to check the status and then start the listener LIST2 Chapter 4 Oracle Networking 147 PART I Figure 4-8 The services command shows the services for which the listener will accept connections. Figure 4-7 Using the Isnrctl user interface to check the status and then stop the listener LIST2 OCA OCP Oracle Database 11g All-in-One Exam Guide 148 In Figure 4-8 the output of the status command tells you that the listener called LISTENER supports three services all available on the instance orclllg Service is the regular database service. The listener can launch dedicated server sessions against it it hasn t launched any yet . Service is the XML database protocol server. This lets users connect to the database with protocols other than Oracle NET such FTP and HTTP. Service has to do with Dataguard. By default an llg database instance will register the XDP and XPT services but they .