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. Former Oracle ACE, Computer Scientist, MSc in Data Science, over ten years of experience in companies such as IBM, Epico Tech, and Playtech based in three different countries (Brazil, Hungary, and Sweden) and joined projects remotely in many others. I am super excited to show you my interest in Databases, Cloud, Data Science, Data Engineering, Bigdata, AI, Programming, Software Engineering, and data in general.
(Continue reading)