OraFAQ Forum: Client Tools » Oracle instance Shutdown

Home » SQL & PL/SQL » Client Tools » Oracle instance Shutdown (Oracle 11G windows server 2016)

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

Oracle instance Shutdown [message #684484]

Mon, 14 June 2021 01:13

Qas313
Messages: 9
Registered: May 2021

Junior Member

Hi All,
I have a database and user on same name unfortunately with power fluctuation Server shut downs abnormally now server starts normal but DB is not working. Oracle is connecting with sysdba user but not with ordinaty user and its schema it gives a message database is shutting down.. kindly guide me to resolve the issue..

Regards,

Report message to a moderator

Re: Oracle instance Shutdown [message #684486 is a reply to message #684484]

Mon, 14 June 2021 01:27

Michel Cadot
Messages: 68348
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

1/ Check the Oracle service is on
2a/ If not then start it
2b/ If started, connect, with SQL*Plus, as sysdba and execute "startup", post the result of the command

Don't forget to format your post as explained in "How to use [code] tags and make your code easier to read".

Report message to a moderator