SQL Developer连接时报错：ORA-12528

SQL Developer连接时报错：

状态: 失败 -测试失败: Listener refused the connection with the following error:

ORA-12528, TNS:listener: all appropriate instances are blocking new connections

解决办法：

1. 修改添加listener.ora中所有的路径为本地安装路径
   Example:
   TRACE_DIRECTORY_LISTENER=/private/app/oracle/product/8.0.3/network/trace
   修改为：
   TRACE_DIRECTORY_LISTENER=F:/app/Administrator/virtual/product/12.2.0/network/trace

2. 在文件中添加标绿的部分
   SID_LIST_LISTENER=
   (SID_LIST=
   (SID_DESC=
   BEQUEATH CONFIG
   (GLOBAL_DBNAME=salesdb.mycompany)
   (SID_NAME=sid1)
   (ORACLE_HOME=F:/app/Administrator/virtual/product/12.2.0)
   PRESPAWN CONFIG
   (PRESPAWN_MAX=20)
   (PRESPAWN_LIST=
   (PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=2)(TIMEOUT=1))
   )
   (SID_DESC =
   (GLOBAL_DBNAME = ORCL)
   (ORACLE_HOME = F:/app/Administrator/virtual/product/12.2.0/dbhome_1)
   (sid_name = ORCL)
   )
   )
   )