Managing network file directories
The purpose of this topic is create some files as tnsnames.ora, listener.ora and sqlnet.ora through SQL and GUI.
– Oracle Net Manager (NETMGR) :Oracle Connection Manager is a proxy server that forwards connection requests to databases or other proxy servers. It operates on the session level. It usually resides on a computer separate from the database server and client computers. Oracle Connection Manager is available for installation with Oracle Database 12c Enterprise Edition.
– Oracle Restart Configuration (You must install GRID configuration first);
– Listener or Oracle Net Configuration Assistant (NETCA):
– To enable ADR : DIAG_ADR_ENABLED_listener_name parameter is set to on;
– To enable tracing : TRACE_LEVEL_listener_name;
– NETCA can be use to add service at tnsnames.ora on “Local Net Service Name configuration”;
– NETCA can be use to add service at sqlnet.ora on “Naming Methods Configuration”;
Parameters:
REMOTE_LISTENER= For remote listeners;
LOCAL_LISTENER= For local listeners;
Database Net Services Reference -> 5 Parameters for the sqlnet.ora File
Database Net Services Reference -> 6 Local Naming Parameters in the tnsnames.ora File
Database Net Services Reference -> 7 Oracle Net Listener Parameters in the listener.ora File (There are some listener examples in this page)
Database Net Services Administrator’s Guide -> 9 Configuring and Administering Oracle Net Listener
Database Net Services Administrator’s Guide -> 10 Configuring Oracle Connection Manager
With Oracle Enterprise Manager Cloud Control
Database Net Services Administrator’s Guide -> 9 Configuring and Administering Oracle Net Listener -> Configuring Listening Protocol Addresses Using Oracle Enterprise Manager Cloud Control
*The views expressed here are my own and do not represent those of my employer.*
Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by experiences in both South America and Europe, with a strong focus on collaboration and innovation across cultures. I am a Computer Scientist, PhD Candidate in Information and Communication Technologies, focusing on Data Science and Artificial Intelligence, and hold dual Master’s degrees in Data Science and Cybersecurity. With over fifteen years of international experience spanning Brazil, Hungary, and Sweden, I have collaborated with global organizations such as IBM, Playtech, and Oracle, as well as contributed remotely to projects across multiple regions. My professional interests include Databases, Cybersecurity, Cloud Computing, Data Science, Data Engineering, Big Data, Artificial Intelligence, Programming, and Software Engineering, all driven by a deep passion for transforming data into strategic business value.