tailieunhanh - Practice Solutions

Create a listener listenernn(n) (nn(n) will be a two or three digit number provided by your instructor) using Oracle Net Manager. The listener must be configured for the server as specified by the instructor. The listener must be configured for the TCP/IP protocol only and must listen for incoming connections on the port provided by the instructor. | Practice Solutions A Practice Solutions Practice 3 Practice 3 Solutions 1. Create a listener listenernn(n) (nn(n) will be a two or three digit number provided by your instructor) using Oracle Net Manager. The listener must be configured for the server as specified by the instructor. The listener must be configured for the TCP/IP protocol only and must listen for incoming connections on the port provided by the instructor. Note: If Oracle9i Oracle Net software is available on the student PC, the listener configuration file will be created on the client PC using Oracle Net Manager and, in later steps, transferred via FTP or a similar file transfer application to the server. If Oracle9i client software is not available on your PC, a file must be created on the server. Sample networking files can be found in your $HOME/STUDENT/LABS directory. The sample files have .sam extensions. Copy $HOME/STUDENT/LABS/ to $TNS_ADMIN/ and edit the file using vi. $ cd | Practice Solutions A Practice Solutions Practice 3 Practice 3 Solutions 1. Create a listener listenernn(n) (nn(n) will be a two or three digit number provided by your instructor) using Oracle Net Manager. The listener must be configured for the server as specified by the instructor. The listener must be configured for the TCP/IP protocol only and must listen for incoming connections on the port provided by the instructor. Note: If Oracle9i Oracle Net software is available on the student PC, the listener configuration file will be created on the client PC using Oracle Net Manager and, in later steps, transferred via FTP or a similar file transfer application to the server. If Oracle9i client software is not available on your PC, a file must be created on the server. Sample networking files can be found in your $HOME/STUDENT/LABS directory. The sample files have .sam extensions. Copy $HOME/STUDENT/LABS/ to $TNS_ADMIN/ and edit the file using vi. $ cd $TNS_ADMIN $ cp $HOME/STUDENT/LABS/ Using Oracle Net Manager a. From the Start menu, select Programs > Oracle - Oracle Home > Configuration and Migration Tools > Net Manager. b. Expand the Local folder in the Oracle Net Configuration tree and then click the Listeners folder. Select Create from the Edit menu or click the “+” icon. c. Enter a name for your listener (listenernn(n)) in the Choose Listener Name dialog box that appears and click OK. The name of the new listener appears below the Listeners folder in the left-hand pane. d. Select Listening Locations from the pull-down menu on the right side of the screen, if not already selected. e. Click Add Address. A tab for the address details of the listener will appear. f. Select TCP/IP as the protocol, if not already selected. g. Enter the name of the server in the Host field, and the port number assigned for your listener in the Port field (the port number is provided by your instructor). h. Select Database .