Search code examples
databaseoracle-databaserestart

How can I restart an Oracle database?

I have to restart my Oracle database because of view changes in the SPFile. I tried to shutdown and startup, but I don't know how to startup in the right way again.

Solution

  • Start SQL*Plus without connecting to a database

    SQLPLUS /NOLOG
Connect as SYSDBA
CONNECT username AS SYSDBA

    Issue the startup command

    STARTUP

    If that doesn't work for you I would recommend consulting the Oracle Docs on starting up a DB. Lots of startup options are listed there.