- Log in to sios20lknode01 as sios20\\lkadmin.
- Using the Windows OS service manager, stop the OracleOraDB19Home1TNSListener and change Startup type to Manual. Once it is changed the following should appear.

- Select Start > Oracle-OraDB19Home1 to launch Net Manager.
Select Listeners > LISTENER in the left pane and select Address1 in the right pane.

- Click Remove Address at the bottom.

- Select Listeners in the left pane, click + in the upper right corner, then type ORCL in the box. Click OK.

- With Listeners > ORCL selected in the left pane, select Listening Locations in the box in the upper right, then click Add Address.

- Enter the following values:
| Net Manager Listeners / ORCL | ||
|---|---|---|
| Protocol | TCP/IP | |
| Host | 10.20.1.200 | |
| Port | 1521 |
* Change this value after creating the Oracle resource.

- Open the list box at the top right, select Database Services and click Add Database.

- 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 |

- Select Service Naming > orcl in the left pane and enter the following values:
| 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.

- The Oracle Listener configuration is now complete. Execute the following command from the command prompt:
lsnrctl start orcl




Post your comment on this topic.