Some Oracle commands

1.set the oracle xmltoollite instance (windows cmd)
e.g. set ORACLE_SID
>set ORACLE_SID=xmltoollite

2.login to sqplus as dba in xmltoollite instance
>sqlplus sys/mypassword as sysdba

3.stop db : force shutdown
e.g. shutdown
SQL>shutdown immediate

4. start db
SQL>startup

5.logout from sqlplus
SQL>quit

check connectivity (windows cmd)
--------------------------------
e.g. tnsping
>tnsping XMLTOOL_

listener (windows cmd)
---------------------
e.g. lsnrctl

1. see services attached to this listener
>lsnrctl services LISTENER

2. see status of services attached to this listener
>lsnrctl status LISTENER

3. start the listener
>lsnrctl start LISTENER

4.stop the listener
>lsnrctl stop LISTENER

how to setup multiple listeners
-------------------------------
http://blogs.sun.com/rtsai/entry/how_to_configure_multiple_oracle