Oracle has three shutdown modes:
· Normal (default) - waits for in-flight work to complete. This could take houes.
· Immediate - terminates all sessions and does a rollback on all
· Abort - aborts all sessions, leaving current DML in need of rollback, de-allocates the SGA and terminates the background processes. Note that a shutdown abort is NOT evil or dangerous. The "abort" simply means that Oracle will terminate all active work, which is what most people want during a shutdown!
The "normal" and "immediate" modes can take a long time in you have in-flight transactions, and many Oracle DBA's ensure a swift clean shutdown this way, aborting the sessions, re-starting to allow warmstart rollback of the aborted transactions, and a shutdown immediate to close cleanly:
Depending on your default shell, run the
coraenvscript to set the environment variables for the instance that you want to shut down:
Bourne, Bash, or Korn shell:
$ . /usr/local/bin/oraenv
% source /usr/local/bin/coraenv
When prompted, specify the SID for the instance.
Run the following commands to shut down the instance:
$ sqlplus /nolog SQL> CONNECT SYS/sys_password as SYSDBA SQL> SHUTDOWN NORMAL
After the instance shuts down, you can quit SQL*Plus.
Restarting an Oracle Database or Automatic Storage ManagementInstance
If the database instance uses Automatic Storage Management for storage management, then you must start the Automatic Storage Management instance before you start the database instance.
To restart an Oracle Database or Automatic Storage Management instance:
If required, repeat Steps 1 and 2 of the preceding procedure to set the
ORACLE_HOMEenvironment variables to identify the SID and Oracle home directory for the instance that you want to start.
Run the following commands to start the instance:
$ sqlplus /nolog SQL> CONNECT SYS/sys_password as SYSDBA SQL> STARTUP
After the instance starts, you can exit from SQL*Plus.
Login into the machine as oracle login user id( where oracle is installed)..
ORACLE_HOME = <Oracle installation Directory>in Environment variable
Open a command prompt
Change the directory to
type the command
connect /as sysdba
alter user SYS identified by "newpassword";
One more check, while oracle installation and database confiuration assistant setup, if you configure any database then you might have given password and checked the same password for all other accounts.. If so, then you try with the password which you have given in your database configuration assistant setup.
Hope this will work for you..