Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

HesipesiMay 16 2008 — edited May 20 2008
Hi
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 17 2008
Added on May 16 2008
1 comment
5,711 views