Using the Windows OS service manager, stop the OracleOraDB19Home1TNSListenerORCL and change Startup type to Manual. After you change it, the following screen should appear.
Select Start > Oracle-OraDB19Home1 to launch Net Manager.
Select Listeners > ORCL in the left pane and select Address1 in the right pane.
Set the following values:
Net Manager Listeners / ORCL
Protocol
TCP/IP
Host
10.20.1.200
Port
1521
Open the list box at the top right, select Database Services and click Add Database at the bottom.
Enter the following values:
Net Manager Listeners / ORCL
Global Database Name
Null
Oracle Home Directory
F:\app\oracle\product\WINDOWS.X64_193000_db_home
SID
ORCL
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
Address1
Protocol
TCP/IP
Host Name
10.20.1.200
Port Number
1521
From File > Save Network Configuration save the configuration.
Now the configuration of the Oracle listener is complete. From the command prompt execute lsnrctl start orcl.
Post your comment on this topic.