when i am trying to connect my database by local user like scott or hr, its giving me this below error.
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0
I also tried my database to shutdown and startup again, but i don't know whether it shutdown and start properly or not.
Please help me out.
Connect as SYSDBA and try following commands
select status, database_status from v$instance;
select open_mode from v$database;
Ideally, you should have INSTANCE STATUS as STARTED, database status as active and open_mode (2nd query as READ WRITE).