In this article, I will provide a detailed guide on How to create Listener in Silent Mode in my virtualbox. We’ll walk you through each step of the process.
Table of Contents
1. Login to the server as oracle user and set the environment variable:
[root@srv1]# sudo su - oracle
Last login: Sun Jun 16 15:42:24 +04 2024 on pts/0
[oracle@srv1 ~]$ . oraenv
ORACLE_SID = [oradb] ? oradb
The Oracle base remains unchanged with value /u01/app/oracle
2. Now create listener using NETCA utility:
[oracle@srv1 ~]$ netca -silent -responsefile /u01/app/oracle/product/19.3.0/dbhome_1/assistants/netca/netca.rsp
Parsing command line arguments:
Parameter "silent" = true
Parameter "responsefile" = /u01/app/oracle/product/19.3.0/dbhome_1/assistants/netca/netca.rsp
Done parsing command line arguments.
Oracle Net Services Configuration:
Profile configuration complete.
Oracle Net Listener Startup:
Running Listener Control:
/u01/app/oracle/product/19.3.0/dbhome_1/bin/lsnrctl start LISTENER
Listener Control complete.
Listener started successfully.
Listener configuration complete.
Oracle Net Services configuration successful. The exit code is 0
3. Check the listener status :
[oracle@srv1 ~]$ ps -ef | grep tns
oracle 3576 1 0 15:47 ? 00:00:00 /u01/app/oracle/product/19.3.0/dbhome_1/bin/tnslsnr LISTENER -inherit
oracle 3646 3409 0 15:48 pts/0 00:00:00 grep --color=auto tns
[oracle@srv1 ~]$ lsnrctl status
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 16-JUN-2024 15:48:28
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=srv1)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 16-JUN-2024 15:47:35
Uptime 0 days 0 hr. 0 min. 53 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/19.3.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/srv1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srv1)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully
I hope you found this article helpful. Feel free to reach out if you have any questions. If you want to create an Oracle database using this easy silent method, you can follow my other article Create & Drop database using DBCA silent mode.