Re: Unable to Shutdown the Database

rbs wrote:
> We have a Oracle Database version 9.2. When we tried to shutdown
> immediate the database we got the message
>
>
> SQL> ORA-01013: user requested cancel of current operation
> SQL> ORA-01081: cannot start already-running ORACLE - shut it down
> first
>
>
> This is the message which we got in the alert file of the database.
>
>
>
> SHUTDOWN: waiting for active calls to complete.
> Sun May 15 10:02:18 2005
> SHUTDOWN: Active sessions prevent database close operation
> Starting ORACLE instance (normal)
> Sun May 15 10:02:19 2005
>
> Can anybody tell why we are not able to shut down the database

No you don't.
You killed off you attempt to shut the database. That's where the 1013 came from. And right after, you tried to start again. Which you cannot. Hence the 1081.

You probably have some script doing a shutdown, followed by a startup.
Next time, tell the story as it is, and you'll receive more valuable answers.

As to your why: read up on shutdown immediate, and the difference between that and shutdown (normal), or shutdown abort.

-- 
Frank van Bortel