Managing network file directories

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

Related posts

Leave a Comment