Oracle Listener and TNSNames configuration | listener.ora & tnsnames.ora |
A listener is configured with one or more listening protocol addresses, information about supported services, and parameters that control its runtime behavior. The listener configuration is stored in a configuration file named listener.ora.
This tnsnames.ora file is a configuration file that contains net service names mapped to connect descriptors for the local naming method, or net service names mapped to listener protocol addresses.
A net service name is an alias mapped to a database network address contained in a connect descriptor. A connect descriptor contains the location of the listener through a protocol address and the service name of the database to which to connect. Clients and database servers (that are clients of other database servers) use the net service name when making a connection with an application.
By default, the tnsnames.ora file is located in the ORACLE_HOME/network/admin directory.
For more information visit:
https://asrblogger.com/
Join Telegram : https://t.me/asrBlogger
Scripts from Github : https://github.com/anishs10/db-scripts
#oracledatabase #databaseadministration #TNSNAMES #OracleListener #networkconfiguration #oracletutorial #techhowto #pdf #databaseconnectivity #asrblogger #oracledatabasetutorial #asrblogger #asrbloggerdba
