Skip to Main Content
Forums

Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-01081: cannot start already-running ORACLE - shut it down first

875798Jul 20 2011 — edited Jul 20 2011
Hi 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

Comments

CKPT
1) exit the current session
SQL> exit

2) startup the instance

SQL> startup

if not use force option. might the instance either in mount or nomount

SQL> startup force

post if any errors and also alert log file contents
vasanth
Hi,

I think your sqlplus path is not set properly.

Add ORACLE_HOME/bin in your environment PATH variable and try.

Thanks,
Vasanth
875798
I echoed $ORACLE_SID and it showed the correct sid set


so i used shutdown abort and it killed all process and shutdown

SQL> shutdown rbo

SQL> shutdown abort
ORACLE instance shut down.
SQL>

Thanks
875798
Thanks all

I shutdown abort and it worked.

Regards
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 17 2011
Added on Jul 20 2011
#general-database-discussions
4 comments
38,358 views