$ORACLE_HOME/network/admin/listener.ora[an ASCLL file]
Inclined to build a profession as Oracle DBA Training? Then here is the blog post on, explore Oracle DBA Training
[‘tnsping’ is the utility for ORACLE, whereas ‘ping’ is the utility of TCP/IP]
[in this case, we can use ORACLE‘s native drivens]
[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]
You liked the article?
Like : 0
Vote for difficulty
Current difficulty (Avg): Medium
1/12
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.
Stay Updated
Get stories of change makers and innovators from the startup ecosystem in your inbox