Static registration and Dynamic Registration of Oracle DBA listeners

= [Static registration] =
Static registration can be configured through graphical net manager.
The relationship between configuration options and related files in net manager:
Profile <=> sqlnet. ora
Service name <=> tnsnames. ora
Listener <=> listener. ora

For static registration on the server, you need to configure the [listener (listener. ora)], including:
Listening location (protocol, host, Port );
Database Service (Global Database Name: the global database name corresponds to the service name, Oracle main directory, SID of the Client [service name (tnsnames. ora );
Other services (I found that I couldn't leave it blank during the test, but the program name and SID here can be entered with some characters at Will );
To append a listener, you must configure it through netca. In win, netca creates a service.

1. Listener. ora (server side)
2. SID_LIST_SL01 =
3. (SID_LIST =
4. (SID_DESC =
5. (PROGRAM = xx)
6. (SID_NAME = xx)
7. )
8. (SID_DESC =
9. (GLOBAL_DBNAME = gdbn01)
10. (ORACLE_HOME = d: \ oracle \ product \ 10.2.0 \ db_1)
11. (SID_NAME = ORCL)
12. )
13. )
15. SL01 =
16. (DESCRIPTION =
17. (ADDRESS = (PROTOCOL = TCP) (HOST = duzz) (PORT = 8899 ))
18. )
20. Tnsnames. ora (client)
21. S01 =
22. (DESCRIPTION =
23. (ADDRESS_LIST =
24. (ADDRESS = (PROTOCOL = TCP) (HOST = duzz) (PORT = 8899 ))
25. )
26. (CONNECT_DATA =
27. (SERVICE_NAME = d01)
28. )
29. )
30. = [Dynamic Registration] =
31. To dynamically register a non-1521 port, you must first set the connection information (protocal, host, port-this connection information must be in the [listener (listener. ora)] Listening location) www.bkjia.com configured to the server tnsnames. ora, and then modify the local_listener parameter to point to tnsnames. configuration options in ora.
32. Listener. ora (server, SL01 is the listener created through netca)
33. SL01 =
34. (DESCRIPTION =
35. (ADDRESS = (PROTOCOL = TCP) (HOST = duzz) (PORT = 8899 ))
36. )
38. Tnsnames. ora (server side)
39. DL01 = (ADDRESS = (PROTOCOL = TCP) (HOST = duzz) (PORT = 8899 ))
41. AlterSystemSetLocal_listener ='Dl01';
42. AlterSystemSetService_names ='D01, d02, d03';
44. The client only needs to fill in the corresponding SERVICE_NAME in tnsnames. ora:
45. Tnsnames. ora (client)
46. S01 =
47. (DESCRIPTION =
48. (ADDRESS_LIST =
49. (ADDRESS = (PROTOCOL = TCP) (HOST = duzz) (PORT = 8899 ))
50. )
51. (CONNECT_DATA =
52. (SERVICE_NAME = d01)
53. )
54. )

To dynamically register a default port of 1521 on PMON, it is relatively simple. You do not need to set the local_listener parameter. www.bkjia.com naturally does not need to modify tnsnames on the server. ora file. The other steps are the same as those for Dynamic Registration of Non-1521 ports.

= [Verify Registration] =

1. Sqlplus/@ s01AsSysdba
2. Select DistinctSidFromV $ mystat;
3. SelectService_nameFromV $ sessionWhereSid =: sid;
4. View the service name of the current session,
5. If SYS $ USERS is returned, it indicates that the current session is connected by a service name registered statically,
6. Otherwise, the dynamic registration service name is returned.