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

  1. Select Start > Oracle-OraDB19Home1 to launch Net Manager.

Select Listeners > LISTENER in the left pane and select Address1 in the right pane.

  1. Click Remove Address at the bottom.

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

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

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

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

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

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

  1. From File > Save Network Configuration, save the configuration.

  1. The Oracle Listener configuration is now complete. Execute the following command from the command prompt:

lsnrctl start orcl

Feedback

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