srvctl stop listener

How to Resolve PRCC-1017 : LISTENER was already stopped on Node

by Ed Chen
January 18, 2023December 29, 2022

PRCC-1017 Saw error PRCC-1017 when we tried to stop a listener service at specific node. [grid@primary01 ~]$ srvctl stop listener -n primary01 PRCC-1017 : LISTENER… Read More »

How to Make a WhiteList for DB Connection

by Ed Chen
November 3, 2022November 18, 2022
2 Comments

Database Whitelist If there's only a few clients that use the database, we can make a whitelist to explicitly accept those clients. We take 2… Read More »

How to Make a BlackList for DB Connection

by Ed Chen
November 2, 2022November 18, 2022

Database Blacklist Unexpected connections may be seen in your listener log, we can make a blacklist to explicitly block those clients. We take 2 steps… Read More »

How Oracle Restart SCAN

by Ed Chen
March 7, 2020November 21, 2022

You cannot stop SCAN (Single Client Access Name) before stopping SCAN_LISTENER, so if you want to restart SCAN, you have to consider how to handle… Read More »