Leech SitesLeech link generator

[Solved]ORA-12528: TNS:listener: all appropriate instances are blocking new connections


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

Solution: Your website can't connect to Database

Fix:
Step 1: Run CMD as Administrator right

Step 2: Run sqlplus /nolog
C:\Windows\system32>sqlplus /nolog

Step 3: Connect as Sysdba
SQL> conn /as sysdba

Step 4: Startup mount
SQL> startup mount;

Step 5: Open Database
SQL> alter database open;

Step 6: Shutdown Database
SQL> shutdown immediate;

Step 7: Startup Database
SQL> startup

ora 12528

Related Post

widgets by blogtips


Share your views...

0 Respones to "[Solved]ORA-12528: TNS:listener: all appropriate instances are blocking new connections"

Post a Comment

Vote, Comment, Email to [email protected]

 

© 2013 LEECH LINKs vs LEECH SITEs

This blog run on iThesis Theme