Preparing the server
- we need to install ORACLE network protocol adopter for TCP/IP
- we need to configure a special background process called ‘listener’.
- In one server we can have one or more listeners depending on the load 9the no.of clients’ communications to the server)
- While defining the ‘listener’ we provide
- Listener name
- List of SID’s [databases]
- Protocol [TCP/IP]
- Port number [default 1521]
- One ‘listener’ can have service handlers for one or more instances.
- In case of having multiple listeners, they must go with different port numbers.
- One instance can be listed in one or more instances. Listener: instance ~ m:m [many to many]
- A listener can be started regardless of the status of the instance.
- $lsnrctl start [starts the all the listeners]
- $ lsnrctl starl ls1 [for 1 listener]
- All the listeners are mentioned in
$ORACLE_HOME/network/admin/listener.ora[an ASCLL file]
- Using lsnrctl command, we can
- Start
- Stop
- Services
- Debug
- Status
- $ lsnrctl
- LSNRCTL > help [for more information]
Inclined to build a profession as Oracle DBA Training? Then here is the blog post on, explore Oracle DBA Training
Preparing the client
- Install ORACLE network protocol adaptor for TCP/IP [client side components]
- We need to define an ALIAS in c: ORACLE_HOMEnetworkadminTNSNAMES.ora
- While defining an ALIAS, we provide
- Alias name
- Target server name [or IP address]
- Target SID [case sensitive]
- Protocol
- Port number [usually 1521]
- After defining the ALIAS, we check using c:tnsping <ALIANS_NAME>
[‘tnsping’ is the utility for ORACLE, whereas ‘ping’ is the utility of TCP/IP]
- The client application can be of 2 types
- ORACLE client tools [farms/reports]
[in this case, we can use ORACLE‘s native drivens]
- Non-ORACLE’s applications like v8 or cristal reports
[in this case, we need to use odbc drivers in conjunction with ORACLE’s ALIAS] Applications ratio 30:70 ORACLE products: non ORACLE products Configuring ODBC [open database connectivity drivers] Start Control panel Odbc 32 bit administration Create new DSN [data source name] Provide DSN name Select ORACLE’s odbc drivers Choose the ALIAS name what we defined earlier test the new DSN got created. Creating a DNS domain name server instead of creating a server at each client.
Ring | Ping |
Operator | Listener |
Clerk | Db down |
Clerk reject | Db_auth_failed |
Mgr is not available | No service handler for junk. |
Here Neptune works as client & Pluto acts as server to the Neptune
DEMO Server SIDE
Dba15 ~] cd $ ORACLE_ HOME/network/admin
Dba15 odmin]$ cp listener.ora $ HOME
Dba15 ~ ] $ vi .bash_profile
Export TNS_ADMIN = $ HOME
:wq
Dba15 ~]$ . . bash_profile
Dba15 ~]$ vi listener.ora
:wq
Dba15 ~]$ lsnrctl start listernr_dba15
Dba15 ~]$ p5 –x
~]$lsnrctl
lsnrctl> help
[for commands]
For an in-depth knowledge, click on below