listener.ora and tnsnames.ora configuration using netca & netmgr
HTML-код
- Опубликовано: 25 окт 2024
- 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: mallik034.blog...
LinkedIn: / mallikarjun-ramadurg-3...
twitter: / mallik034
instagram: / mallik034
Regards,
Mallikarjun Ramadurg
Mobile: +966 543796525
WhatsApp: +91 9880616848
Blog: mallik034.blog...
LinkedIn: / mallikarjun-ramadurg-3...
twitter: / mallik034
instagram: / mallik034