Some of database datafiles are damaged or corrupted or moved to another position without modifying datafile name or datafiles are missing, … and now we need to startup the Oracle database ignoring missing datafiles.
In this case, assume that we miss
We’ll got … Read the rest “How to start Oracle database ignore missing datafile(s)”
In this post, I will show you all commands to start and stop Oracle databases. This is the basics but essentials while working with Oracle.
Login into database server, switch to oracle user and start sqlplus tool
su - oracle
sqlplus / as sysdba
… Read the rest “How to start & stop Oracle databases (startup & shutdown)”