ORA-01081: cannot start already-running ORACLE - shut it down first
875798Jul 20 2011 — edited Jul 20 2011Hi Team,
I shutdown mu database yesterday for maintenance, wanted to startup this morning and am getting this error:
/oracle : sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.2.0 - Production on Wed Jul 20 09:46:41 2011
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected.
SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown immediate
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-01089: immediate shutdown in progress - no operations are permitted
SQL>
when i check for any oracle process running on the background i saw :
oracle 164052 159750 0 09:35:09 pts/1 0:00 -ksh
oracle 249868 446686 1 09:32:33 pts/0 0:00 -ksh
oracle 405702 249868 0 09:38:41 pts/0 0:00 ps -ef
oracle 397800 86834 0 0:00 <defunct>
oracle 430572 249868 0 09:38:41 pts/0 0:00 grep oracle
oracle 287286 1 0 09:34:14 pts/0 0:00 /oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER -inherit
oracle 86834 1 0 Jun 28 - 5:23 ora_cjq0_CONCILIA
oracle 303966 164052 0 09:35:55 pts/1 0:00 tail -f alert_CONCILIA.log
Then i killed 'ora_cjq0_CONCILIA' process.
/ora_bck/logs : kill -9 86834
and tried to startup again still getting the same error as above.
I need help on how to resolve this as this is a production database.
Thanks