Net8 is to establish network sessions and transfer data between machines..
Net8 is important to connect the database from remote. Server à server, server à client & application à server vice versa.
192.168.200.7 – client (Oracle software needed)
Entries of S/W: TNSnames.ora& & SQLnet.ora- optional
192.168.200.107 – Server (Oracle software & DB needed)
Entries of S/W: TNSname.ora, listener & SQLnet.ora- optional
Configuration file that defines databases addresses for establishing connections to them like (Host, DB name & port). It located on both client and server systems.
The sqlnet.ora file is the profile configuration file. It resides on the client machines and the database server. We can configure some client setting and restrictions. Like (tracing options, default domain, encryption, etc)
It’s a configuration file used to configure Oracle Database Listeners (required to accept remote connection requests).
Where all the files will be stored
Linux à $ORACLE_HOME/network/admin
Windows à %ORACLE_HOME%/network/admin
On client side:
$ vi tnsnames.ora
Test = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.200.107) (PORT=1521)) (CONNECTION_DATA = (SERVICE_NAME=TESTDB)))
Test – Is the net service name , can be anything.
TestDB – DB name
How to check the entries are valid
$ tnsping test
TNS could not resolve the service name àNet service name is wrong.
TNS request timed out àClient to server network break. Mostly in windows because of firewall ON, we need to disable.
TNS protocol adapter error à Oracle service down.
TNS packet writer failure à Network bandwidth low.
In some cases, If oracle uses more than ½ of the RAM, we will receive this error.
TNS no listener à Listener stopped.
$ lsnrctl status
$ lsnrctl start/stop/reload
Reload – Will help the downtime, in case of any modification on the listener can be reloaded instead of stop and start.
Oracle Net Listener is a separate process that runs on the database server computer. It receives incoming client connection requests and manages the traffic of these requests to the database server.
Create listener on server by NETMGR
$ netca à it will open a window à next and next we need to enter listener info.
Net manager – NETMGR
It’s a utility.
Oracle Net Manager is a utility used for configuring SQL*Net. It is similar to NetCA, but Net Manager allows you to perform more complex connectivity configurations.
On client side, $ netmgr it will open a window à we need to enter service, DB names & port.