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