| 
DATE :-- 1st Sep 2014 | 
ORA-12528: TNS:listener: all appropriate instances are blocking new connections
Error :-- 
SQL> conn sys@DBSTP11G as sysdba
Enter password:
ERROR:
ORA-12528: TNS:listener: all appropriate instances are blocking
new connections
Warning: You are no longer connected to ORACLE.
SQL> exit
Resolution :-- 
DBSTP11G =
  (DESCRIPTION =
 
 (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.163)(PORT=1521))
   (CONNECT_DATA =
    (SERVER=DEDICATED)
    (SID_NAME=DBSTP11G)
    (SERVICE_NAME=DBSTP11G)
    (UR=A)
   )
  )
UR=A 
It will resolve the issue 
 network issue resolved
 
No comments:
Post a Comment