Hi Friends,

Welcome you back on exiting topic, Today’s session is on

1. check listneter is running or not using lsnrctl utility
[oracle@rac1 ~]$ lsnrctl status

2. Check listener os process is running or not
[oracle@rac1 ~]$ ps -ef|grep tns

3. Check listener.or and tnsnames.ora files are available on TNS_ADMIN locastion or not
[oracle@rac1 ~]$ cd $TNS_ADMIN

4. Verify at the database level whether listner is registared or not (remote_listener & local_listener parameter)

[oracle@rac1 admin]$ sqlplus / as sysdba
SQL] show parameter remote
SQL] show parameter local

5. run the netca GUI tool to configure the listner
[oracle@rac1 admin]$ cd $ORACLE_HOME/bin
[oracle@rac1 bin]$ ./netca

6. Verify the listner up and running after configuration
[oracle@rac1 bin]$ ps -ef|grep tns

7. Veirfy the listner status using lsnrctl utility
[oracle@rac1 bin]$ lsnrctl status

[oracle@rac1 bin]$ cd $TNS_ADMIN
[oracle@rac1 admin]$ cat listener.ora

9. user netmgr tool to create tnsnames.ora file, You can use this netmger tool to create listner as well.
[oracle@rac1 admin]$ cd $ORACLE_HOME/bin/
[oracle@rac1 bin]$ ./netmgr

10. Verify the tnsnames.ora file create under the TNS_ADMIN location or not
[oracle@rac1 bin]$ cd $TNS_ADMIN
[oracle@rac1 admin]$ cat tnsnames.ora

11. Verify the listner and registred status at the database;
[oracle@rac1 admin]$ sqlplus / as sysdba
SQL] show parameter local
[oracle@rac1 admin]$ lsnrctl status


Please do follow me and support me on,

Blog: https://mallik034.blogspot.com/
LinkedIn: https://www.linkedin.com/in/mallikarjun-ramadurg-397a751a
twitter: https://twitter.com/mallik034
instagram: https://www.instagram.com/mallik034/

Regards,
Mallikarjun Ramadurg
Mobile: +966 543796525
WhatsApp: +91 9880616848
Blog: https://mallik034.blogspot.com/
LinkedIn: https://www.linkedin.com/in/mallikarjun-ramadurg-397a751a
twitter: https://twitter.com/mallik034
instagram: https://www.instagram.com/mallik034/