- Log in to SIOS20-NODE1 as SIOS20-AD\lkadmin.
- Start PowerShell for administrator and execute the following command to stop the OracleOraDB19Home1TNSListenerORCL and change Startup type to Manual.
Set the service name to a variable
PS > $service_name = "OracleOraDB19Home1TNSListenerORCL"
Check service status
PS > Get-Service $service_name | Select-Object Name, Status, StartType
Stop the service
PS > Stop-Service -Name $service_name
Change the StartType to Manual.
PS > Set-Service -Name $service_name -StartType Manual
- 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.0.2.21 |
Port | 1521 |
- Open the list box at the top right, select Database Services.
- Click Add Database at the bottom.
- Enter the following values:
Net Manager Listeners / ORCL | |
---|---|
Global Database Name | (Empty) |
Oracle Home Directory | D:\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.0.2.21 |
Port Number | 1521 |
- From File > Save Network Configuration save the configuration.
- Now the configuration of the Oracle listener is complete. From the administrator command prompt execute
lsnrctl start orcl
.
Post your comment on this topic.