Oracle Restart Steps

1. Stop the application layer of the various programs.

$lsnrctl stop

3. Under exclusive system users, backup the control files:

Sql>alter database backup controlfile to trace;

sql>alter system switch logfile;
5. Under exclusive system users, run the following SQL statement, Generate a Kill_all_session.sql file that kills database user connections:

Set feedback off;
Set NewPage none;
Spool/oracle_backup/bin/kill_all_session.sql
Select ' Alter system kill session ' | | sid| | ',
' | | serial#| | '; ' from v$session where username are not null;
Spool off;

6. Under the exclusive system user, execute the kill_all_session.sql file that killed the database user connection:

7. Under exclusive system users, close the database in Immediate mode:

Or
Svrmgrl>shutdown immediate;

8. Start the ORALCE monitoring process:

9. Under exclusive system users, start the Oralce database:

Sql>connect/as SYSDBA
sql>startup;

Or:

Svrmgrl>connect internal;
svrmgrl>startup;

10. Start the application layer of the various programs.

Oracle Restart Steps