1. Log in to SIOS20-NODE1 as SIOS20-AD\lkadmin.
  1. Start PowerShell for administrator and execute the following command to stop the OracleOraDB19Home1TNSListenerORCL and change Startup type to Manual.

Set the service name to a variable

PS > $service_name = "OracleOraDB19Home1TNSListenerORCL"

Check service status
PS > Get-Service $service_name | Select-Object Name, Status, StartType

Stop the service
PS > Stop-Service -Name $service_name

Change the StartType to Manual.
PS > Set-Service -Name $service_name -StartType Manual
  1. Select Start > Oracle-OraDB19Home1 to launch Net Manager.
  1. Select Listeners > ORCL in the left pane and select Address1 in the right pane.
  1. Set the following values:
Net Manager Listeners / ORCL
Protocol TCP/IP
Port 1521
  1. Open the list box at the top right, select Database Services.
  1. Click Add Database at the bottom.
  1. Enter the following values:
Net Manager Listeners / ORCL
Global Database Name (Empty)
Oracle Home Directory D:\app\oracle\product\WINDOWS.X64_193000_db_home

  1. On the left page, select Service Naming > orcl and enter the values as shown below:
Net Manager Service Naming / orcl
Service Identification
Service Name orcl
Connection Type Dedicated Server
Protocol TCP/IP
Host Name
Port Number 1521

  1. From File > Save Network Configuration save the configuration.
  1. Now the configuration of the Oracle listener is complete. From the administrator command prompt execute lsnrctl start orcl.


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment