ORA-12528: TNS:listener: all appropriate instances are blocking new connect
HesipesiMay 16 2008 — edited May 20 2008Hi
I have a oracle 10gR2 installed on Redhat linux AS 4.
I have configured my database to work on ASM.All the configuration have set properly
and every thing is fine except the Automatic starting the database in time
the mechine is restarted.
when i restart the mechine with nothing in dbora(used to automatically start the database)
and start everything after logging into oracle user(listener ,database,Enterprise manager)
no problem(i can see my ASM instance database instance throught Enterprise managaer).
but when i use dbora to do that i get this error appear in enterprise manager
ORA-12528: TNS:listener: all appropriate instances are blocking new connections (DBD ERROR: OCIServerAttach)
this is the content of dbora:
____________________________________________
s script is intended to allow the automated
# startup and shutdown of an oracle database server.
#
# Author: Sean O'Donnell <sean@seanodonnell.com>
#
# the user that oracle runs as (default: oracle)
ORACLE=oracle
# database instance id
ORACLE_SID=orcl
# ORACLE_HOME (file system) path
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
PATH=${PATH}:$ORACLE_HOME/bin
export ORACLE_SID ORACLE_HOME PATH
case $1 in
'start')
su - $ORACLE -c "$ORACLE_HOME/bin/lsnrctl start"
su - $ORACLE -c "$ORACLE_HOME/bin/dbstart"
su - $ORACLE -c "$ORACLE_HOME/bin/emctl start dbconsole"
;;
'stop')
su - $ORACLE -c "$ORACLE_HOME/bin/emctl stop dbconsole"
su - $ORACLE -c "$ORACLE_HOME/bin/dbshut"
su - $ORACLE -c "$ORACLE_HOME/bin/lsnrctl stop"
;;
*)
echo "usage: $0 {start|stop}"
;;
esac
exit
_____________________________________________________
What do u think could be the reason?!!!!
thank you in advance