CodePudding user response:
1, tnsnames. Ora is a client configuration file, if you saw this file on the server, means that the current server may as the client to connect to other server, it simply describes the server IP, server listening port number, server provided by Oracle RDB service as well as other slightly secondary connection information, this file is the client is not necessary; Listener. Ora is a server-side configuration file, describing the current listening in listening to the server which IP on the server and which port, and to provide what service, but it on the server is not a must, no listener. Ora or the file does not provide the exact service configuration, dynamic monitoring, the registration of the DB instance pmon process, take the initiative to monitor the service; Sqlnet. Ora is a slightly more complex configuration file, it contains a client and server network related configuration, a lot of specific parameters, you can refer to the oracle online documentation: ".net service reference"
2, since the original poster asks this question, compared to what what did the three stages should be very understand? They go into here, I think this problem is difficult, to have to think bosses to explain
CodePudding user response:
Oracle tnsnames. Ora, listener. Ora, sqlnet. Ora three files,Tnsnames. Ora file for TNS parsing connection string (client and server can use)
Listener. Ora listeners corresponding configuration file (server)
Sqlnet. This is about the network configuration, ora connection string parsing IP restrictions such as the configuration file (server)