Listener registered statically)

(1) listener. ora

In this experiment, static listening is configured to listener L1, and the project SID_LIST_L1 is the static listening configuration of L1:

1. L1 =
2. (DESCRIPTION_LIST =
3. (DESCRIPTION =
4. (ADDRESS = (PROTOCOL = TCP) (HOST = PC1255-20110528) (PORT = 1522 ))
5. )
6. )
8. SID_LIST_L1 =
9. (SID_LIST =
10. (SID_DESC =
11. (SID_NAME = PLSExtProc)
12. (Oracle_HOME = D: \ oracle \ product \ 10.2.0 \ db_1)
13. (PROGRAM = extproc)
14. )
16. (SID_DESC =
17. (GLOBAL_DBNAME = t01)
18. (ORACLE_HOME = D: \ oracle \ product \ 10.2.0 \ db_1)
19. (SID_NAME = t01)
20. )
22. )

(2) After the listener. ora file is edited, use reload to re-read the configuration file (reload will also re-register the dynamic listener ):

(

RELOAD Purpose Use RELOADCommand to reread listener.oraFile. This command enables you to add or change statically configured services without actually stopping the listener.

In addition, the database services, instances, service handlers, and listening endpoints that were dynamically registered with the listener will be unregistered and subsequently registered again.

Http://download.oracle.com/docs/cd/A97630_01/network.920/a96581/lsnrctl.htm

)

1. LSNRCTL> status
2. Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = PC1255-20110528) (PORT = 1522 )))
3. LISTENER STATUS
4. ------------------------
5. Alias L1
6. Version TNSLSNRFor32-BitWindows: Version 10.2.0.1.0-Production
7. Start Date: 24-7-2011 22:14:19
8. Normal operation time: 0 days, 1 hour, 26 minutes, 2 seconds
9. Tracking levelOff
10. SecurityON:LocalOS Authentication
11. SNMPOFF
12. Listener parameter file D: \ oracle \ product \ 10.2.0 \ db_1 \ network \ admin \ listener. ora
13. Listener log file D: \ oracle \ product \ 10.2.0 \ db_1 \ network \ log \ l1.log
14. Listener endpoint overview...
15. (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = PC1255-20110528) (PORT = 1522 )))
16. Service summary ..
17. Service"T02"Contains one routine.
18. Routine"T02", Status READY, contains 1 handler of this service...
19. Service"T02XDB"Contains one routine.
20. Routine"T02", Status READY, contains 1 handler of this service...
21. Service"T02_XPT"Contains one routine.
22. Routine"T02", Status READY, contains 1 handler of this service...
23. Command executed successfully
24. LSNRCTL> reload
25. Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = PC1255-20110528) (PORT = 1522 )))
26. Command executed successfully
27. LSNRCTL> status
28. Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = PC1255-20110528) (PORT = 1522 )))
29. LISTENER STATUS
30. ------------------------
31. Alias L1
32. Version TNSLSNRFor32-BitWindows: Version 10.2.0.1.0-Production
33. Start Date: 24-7-2011 22:14:19
34. Normal operation time: 0 days, 1 hour, 26 minutes, 8 seconds
35. Tracking levelOff
36. SecurityON:LocalOS Authentication
37. SNMPOFF
38. Listener parameter file D: \ oracle \ product \ 10.2.0 \ db_1 \ network \ admin \ listener. ora
39. Listener log file D: \ oracle \ product \ 10.2.0 \ db_1 \ network \ log \ l1.log
40. Listener endpoint overview...
41. (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = PC1255-20110528) (PORT = 1522 )))
42. Service summary ..
43. Service"PLSExtProc"Contains one routine.
44. Routine"PLSExtProc", Status UNKNOWN, contains 1 handler of this service...
45. Service"T01"Contains one routine.
46. Routine"T01", Status UNKNOWN, contains 1 handler of this service...
47. Command executed successfully

1 2 Next Page