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

OCA /OCP Oracle Database 11g A ll-in-One Exam Guide- P21: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 156 8. Create a new service name highlight Service Naming in the navigation tree and click the icon. 9. Enter NEW as the net service name and click Next. 10. Select TCP IP as the protocol and click Next. 11. Enter as the host name and 2521 as the port and click Next. 12. Enter SERV1 as the service name and click Next. 13. Click Finish. If you try the test it will fail at this time. The illustration that follows shows the result. 14. Save the configuration by clicking File and Save Network Configuration. This will create the and files in the TNS_ADMIN directory. 15. Use an editor to check the two files. They will look like this NEWLIST DESCRIPTION ADDRESS PROTOCOL TCP HOST PORT 2521 NEW DESCRIPTION ADDRESS_LIST ADDRESS PROTOCOL TCP HOST PORT 2521 CONNECT_DATA SERVICE_NAME SERV1 Chapter 4 Oracle Networking 157 16. From an operating system prompt start the listener with lsnrctl start newlist. 17. From an operating system prompt test the connect string with tnsping new. 18. Connect to your database using operating system authentication bypassing any listener with sqlplus as sysdba. 19. Set the service_names and local_listener parameters for the running instance memory only not the parameter file and register the new service name with the new listener alter system set service_names serv1 scope memory alter system set local_listener new scope memory alter system register 20. From an operating system prompt confirm that the new service has registered with the new listener with lsnrctl services newlist. 21. Confirm that the new network environment is functional by logging on sqlplus system oracle@new Use the Oracle Shared Server Architecture The standard dedicated server architecture requires that the database listener should spawn a dedicated server process for each concurrent connection to the instance. These server processes will persist .