OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Cannot start oracle

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Cannot start oracle [message #61403]

Wed, 21 April 2004 21:33

Onomitra Ghosh
Messages: 4
Registered: April 2004

Junior Member

Hi,

I am working with an Oracle 8i database. I longed to the Oracle EIM as sysdba and shut down the database in the normal mode. But it is taking a lot of time and the OEM session also got hung. Now I cannot log on to the database, it says that it is shutting down (ORA-01081). I tried to start it again but I get the same message.

I am not sure what users are still logged on to the database. There is an application which runs on the database and it may have open hung sessions in it.

Please let me know what is the solution.

Thanks,

Onomitra

Report message to a moderator

Re: Cannot start oracle [message #61404 is a reply to message #61403]

Wed, 21 April 2004 21:40

Anatol Ciolac
Messages: 113
Registered: December 2003

Senior Member

SQL>connect internal
SQL>shutdown abort
SQL>startup

When you want to stop database use
SQL>shutdown immediate
For better explainiing of command shutdown see documentation.

Report message to a moderator

Re: Cannot start oracle [message #61405 is a reply to message #61404]

Wed, 21 April 2004 21:45

Onomitra Ghosh
Messages: 4
Registered: April 2004

Junior Member

Hi Anatol,

Thanks for your reply, but I am not able to log on to sqlplus by sys or sysdba.

Thanks,

Onomitra

Report message to a moderator

Re: Cannot start oracle [message #61406 is a reply to message #61405]

Wed, 21 April 2004 22:01

Anatol Ciolac
Messages: 113
Registered: December 2003

Senior Member

To shut down database correctly you must to connect to them as sysdba. What program packet is Oracle EIM? If you have a Oracle client software, then you have sqlplus on your PC.

Report message to a moderator

Re: Cannot start oracle [message #61407 is a reply to message #61406]

Wed, 21 April 2004 22:07

Onomitra Ghosh
Messages: 4
Registered: April 2004

Junior Member

Hi Anatol,

Mentioning "Oracle EIM" is a mistake on my part. I meant OEM i.e. Oracle Enterprise Manager. During shutdown, I logged on as "sys" and as "sysdba".

Thanks,

Onomitra

Report message to a moderator

Re: Cannot start oracle [message #61408 is a reply to message #61407]

Wed, 21 April 2004 22:19

Anatol Ciolac
Messages: 113
Registered: December 2003

Senior Member

Excellent. Run sqlplus and restart your database.

Report message to a moderator

Re: Cannot start oracle [message #61409 is a reply to message #61408]

Wed, 21 April 2004 22:31

Onomitra Ghosh
Messages: 4
Registered: April 2004

Junior Member

Hi Anatol,

Thanks, the problem is solved by following the steps you said.

Onomitra

Report message to a moderator

Re: Cannot start oracle [message #61622 is a reply to message #61403]

Tue, 11 May 2004 14:27

Trifon Anguelov
Messages: 514
Registered: June 2002

Senior Member

If you shutdown the db with a NORMAL , then all the corrent sessions should commit their job before the db is goign to be shutdown.

Yoo should try with SHUTDWON IMMEDIATE next time for faster results. If the db hangs - the OracleService shutdown/startup will take care of this.

HTH,

clio_usa - OCP 8/8i/9i

DBAclick.com | Oracle DBA Forums | [url=http://news.dbaclick.com] Oracle Usenet groups<a/>

Report message to a moderator

Previous Topic:	last row inserted displayed not as the last row.
Next Topic:	help!i am using exp and get error"EXP-00008: ORACLE error 6552 encountered"

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 14:28:53 CDT 2024