NETCA (Network Configuration Assistant) is an Oracle utility used to configure network components for Oracle databases. It simplifies the setup and management of network configurations, including creating and managing listener.ora, tnsnames.ora, and other related files. This guide will walk you through the listener configuration process using NETCA utility.
Prerequisites:
1. Oracle Database Software should be installed.
2. Oracle Database Environments should be set.
Run NETCA from OS prompt:
|
[oracle@target ~]$ netca |
Select Listener Configuration and Click Next
|
[oracle@target ~]$ lsnrctl start LISTENER LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 22-JAN-2025 12:09:54 Copyright (c) 1991, 2024, Oracle. All rights reserved. Starting /u01/app/oracle/product/19.0.0/dbhome_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 19.0.0.0.0 - Production System parameter file is /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora Log messages written to /u01/app/oracle/diag/tnslsnr/target/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=target.localdomain)(PORT=1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=target.localdomain)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 22-JAN-2025 12:09:54 Uptime 0 days 0 hr. 0 min. 2 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/target/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=target.localdomain)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) The listener supports no services The command completed successfully |
Thanks for visiting!!
0 comments:
Post a Comment