Thứ Sáu, 27 tháng 11, 2020

ORA-12528 TNS listener all appropriate instances are blocking new connections in Oracle Database


C:\Windows\system32>sqlplus /nolog
SQL*Plus: Release – Production on Wed Oct 1 19:40:51 2008
Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.
SQL> connect sys@dbname as sysdba
Enter password:
ERROR: ORA-12528:
TNS:listener: all appropriate instances are blocking new connection

Check listener:
lsnrctl status

Alias                     LISTENER
Version                   TNSLSNR for windows: Version - Production
Start Date                20-DEC-2014 02:39:22
Uptime                    14 days 2 hr. 26 min. 18 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File D:\oracle\12.1.0\dbhome_1\network\admin\listener.ora
Listener Log File D:\oracle\diag\tnslsnr\test\listener\alert\log.xml
Listening Endpoints Summary...
Services Summary...
Service "ORCL" has 1 instance(s).
  Instance "ORCL", status BLOCKED, has 1 handler(s) for this service...

lsnrctl services
Giải pháp: Restart lại instance có cảnh báo trên

SQLPLUS / as sysdba
shutdown immediate

+ Check lại: lsnrctl status

KẾT NỐI VỚI CHUYÊN GIA TRẦN VĂN BÌNH: 📧 Mail: ☎️ Mobile: 0902912888 ⚡️ Skype: tranbinh48ca 👨 Facebook: 👨 Inbox Messenger: (profile) 👨 Fanpage: 👨 Inbox Fanpage: 👨👩 Group FB: 👨 Website: 👨 Blogger: 🎬 Youtube: 👨 Tiktok: 👨 Linkin: 👨 Twitter: 👨 Địa chỉ: Tòa nhà Sun Square - 21 Lê Đức Thọ - Phường Mỹ Đình 1 - Quận Nam Từ Liêm - TP.Hà Nội #OracleTutorial #OracleDBA #OracleDatabaseAdministration #học oracle database #oca #ocp #oce #ocm


Trần Văn Bình - Oracle Database Master