Oracle.DataAccess.Client.OracleException ORA-12528 : TNS: listener: all appropriate instances are blocking new connections
Cause: All instances supporting the service requested by the client reported that they were blocking the new connections. This condition may be temporary, such as at instance startup.
Action: Attempt the connection again. If error persists, then contact the administrator to check the status of the instances.
1개의 답변이 있습니다.
아래 내용 참고해 보세용
Oracle.DataAccess.Client.OracleException
ORA-12528 : TNS: listener: all appropriate instances are blocking new connections
Cause: All instances supporting the service requested by the client reported that they were blocking the new connections. This condition may be temporary, such as at instance startup.
Action: Attempt the connection again. If error persists, then contact the administrator to check the status of the instances.
리스너 상태를 확인해 보세요..
**# lsnrctl status**
리스너가 내려져 있거나, 정상적으로 동작 하고 있음에도 연결이 되지 않는다면,
**# lsnrctl stop
**# lsnrctl start****
이후 sqlplus 접속 합니다. (sysdba 권한)
접속 시 instance 가 내려져 있다면
sql> startup
정상적으로 동작하고 있다면 다시 한번 재시작 해 봅니다.
sql> shutdown immediate
sql> startup