Labels

Friday, October 12, 2012

Instance is blocked



Instance is blocked by the listner.

When you restart the listener you found one instance is blocked.
Service "dupli" has 1 instance(s).
  Instance "dupli", status BLOCKED, has 1 handler(s) for this service...
Service "dupli_XPT" has 1 instance(s).
  Instance "dupli", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully

Solutions:-
1) Check the listener and tnsname.ora file entry
2)Check if the database is in nomount state. If it is nomount stage then it will show the instance is blocked

No comments:

Post a Comment