All about Oracle

http://www.thegeekstuff.com/2009/05/oracle-lsnrctl-listener-shutdown-and-startup-procedures/

http://download.oracle.com/docs/cd/B19306_01/server.102/b14196/network004.htm

http://download.oracle.com/docs/cd/B12037_01/server.101/b10739/undo.htm

Data Guard command-line interface (CLI) to create, manage, and monitor a broker configuration.

http://docs.oracle.com/cd/B12037_01/server.101/b10822/cli.htm

Oracle ready reference

http://www.datadisk.co.uk/html_docs/oracle/

http://docs.oracle.com/cd/B19306_01/server.102/b14231/manproc.htm

http://www.oracle.com/pls/db102/homepage

PL/SQL: http://docs.oracle.com/cd/B19306_01/appdev.102/b14261/overview.htm#BABFAAAJ

http://ss64.com/ora/syntax-analytic.html

http://www.oracle-developer.net/

Oracle analytic functions:
http://www.orafaq.com/node/55


Oracle documentation: http://tahiti.oracle.com/
Oracle features articles: http://www.oracle-base.com/articles/articles.php

Automatic Workload Repository (AWR): http://www.oracle-base.com/articles/11g/awr-baseline-enhancements-11gr1.php

==========================================================
Some times it's headache to start (how-to-start) oracle DB:
Here is the tip:


[root@test-974 bin]# ps -ef | grep pmon
root      4433  4220  0 23:16 pts/1    00:00:00 grep pmon
[root@test-974 bin]# su - oracle
[oracle@test-974 ~]$ sqlplus

SQL*Plus: Release 11.1.0.6.0 - Production on Tue May 21 23:17:33 2013

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Enter user-name: sys as sysdba
Enter password:
Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1657225216 bytes
Fixed Size                  1300296 bytes
Variable Size            1174407352 bytes
Database Buffers          469762048 bytes
Redo Buffers               11755520 bytes
Database mounted.
Database opened.
SQL>exit

Then;
login as user
Make sure to export ORACLE_HOME="XXX"
use (su - oracle) 

start oracle listener from bin directory


For more help: 
http://www.oracledistilled.com/tag/tnsping/
http://www.thegeekstuff.com/2009/05/oracle-lsnrctl-listener-shutdown-and-startup-procedures/


You should be good by now..... :)  Thank you...

==========================================================
::Oracle AQ start-stop::
http://www.oracle-developer.net/display.php?id=411

==========================================================

Get details of Oracle Metadata

For example: you can get entire schema (all tables) detail using 

SELECT DBMS_METADATA.GET_DDL('TABLE',u.table_name) FROM USER_TABLES u;

Very good article: http://www.dba-oracle.com/oracle_tips_dbms_metadata.htm
==========================================================