- Log in to SIOS20LKNODE01 as sios20\lkadmin.
- 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.