var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How create new listener from command prompt
I have problem with Oracle Net and Net8 tools and thus I am not able to create new listener, does anybody know how create new listener using command prompt?
Thank you for any advice!
What is your OS?
In unix it is very simple, windows should be similar but I am not sure how you would register the new listener service. Add another entry in listener.ora file and start the listener. If you are using same version ensure you identify second listener to be started on different port (ie. not 1521/1541 default).
From example below
Set proper environment variable than
to start lsn_817
lsnrctl start lsn_817
to start lsn_920
lsnrctl start lsn_920
(ADDRESS= (PROTOCOL= TCP)(Host= pf1d7.tcpl.ca)(Port= 1521))
STARTUP_WAIT_TIME_LSN_817 = 0
CONNECT_TIMEOUT_LSN_817 = 10
LOG_DIRECTORY_LSN_817 = /oracle/network/log
LOG_FILE_LSN_817 = lsn_817.log
TRACE_LEVEL_LSN_817 = OFF
TRACE_DIRECTORY_LSN_817 = /oracle/network/trace
TRACE_FILE_LSN_817 = lsn_817.trc
(SID_DESC = (SID_NAME = davt)(ORACLE_HOME = /oracle/product/8.1.7))
(ADDRESS= (PROTOCOL= TCP)(Host= pf1d7.tcpl.ca)(Port= 1541))
STARTUP_WAIT_TIME_LSN_920 = 0
CONNECT_TIMEOUT_LSN_920 = 10
LOG_DIRECTORY_LSN_920 = /oracle/network/log
LOG_FILE_LSN_920 = lsn_920.log
TRACE_LEVEL_LSN_920 = OFF
TRACE_DIRECTORY_LSN_920 = /oracle/network/trace
TRACE_FILE_LSN_920 = lsn_920.trc
(SID_DESC = (SID_NAME = dbfs)(ORACLE_HOME = /oracle/product/9.2.0))
We use windows 2000 server and Oracle 18.104.22.168
It should be basically the same for Windows (although, being honest, I haven't actually tried it myself). Try these two links:
I have come across this article, which may be worth paying attention to:
Failed to start service, TNS-12560, TNS-00530 when create new listener
To recreate Oracle TNS listener service on Windows NT, you delete the
service entry in registry. When using lsnrctl to start the listener,
you get the following errors:
Starting tnslsnr: please wait...
Failed to start service, error 3.
TNS-00530: Protocol adapter error
The Listener service is not recreated and the Listener would not start.
You are using a valid listener.ora file and protocol adapters.
After you delete the Listener service from registry, you have to reboot NT
for it to take effect. Then you can use lsnrctl to start the Listener,
which would re-create the listener service.
90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.
I tried it in win2000 oracle instance and the method used in unix works.
However this is a manual process. I am not familiar enough with Windows to add this to the service. You need to consult someone else regarding this.
Add new listener entry to listener.ora
than use command line to manually start it.
lsnrctl start new_listenername
OK. Thank you very much for your help.