ORACLE: BAT FILE

Trick to speed up things.

Create a file in the location where your cmd defaults to as

My databases name is HARRY, so I will put the following lines in a notepad:

SET ORACLE_HOME=C:\oracle\product\10.2.0\db_2

SET ORACLE_BASE=C:\oracle\product\10.2.0

set ORACLE_SID=HARRY

NET START OracleServiceHARRY

sqlplus "/ as sysdba"
save the file as databasename.bat
Next time to you can simply specify the @HARRY
BAT file name and it will take you into the sql prompt.
You have probably saved a few seconds of your productive time....
getting to the things your want to faster!

Additionally, you can go to
C:\oracle\product\10.2.0\db_2\sqlplus\admin\glogin.sql
and add the following lines at the bottom so that they are executed after the login into sqlplus
is successful. This way you get a quick look into your system.
SELECT STATUS FROM V$INSTANCE;
SELECT NAME,OPEN_MODE,LOG_MODE FROM V$DATABASE;
SHOW USER;
Enjoy!