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
Hi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc in Data Science and another MSc in Software Engineering. I have over ten years of experience working with companies such as IBM, Epico Tech, and Playtech across three different countries (Brazil, Hungary, and Sweden), and I have joined projects remotely in many others. I am super excited to share my interests in Databases, Cybersecurity, Cloud, Data Science, Data Engineering, Big Data, AI, Programming, Software Engineering, and data in general.
(Continue reading)