Link to install Oracle S/W on Windows

http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/r1/Windows_DB_Install_OBE/Installing_Oracle_Db12c_Windows.html

Initialization parameters (Basic)

 

  1. DB_NAME
  2. DB_DOMAIN
  3. CONTROL_FILES
  4. DB_CACHE_SIZE
  5. LOG_BUFFER
  6. LARGE_POOL_SIZE
  7. SHARED_POOL_SIZE
  8. OPTIMIZER_MODE
  9. CURSOR_SHARING
  10. OPEN_CURSORS
  11. PGA_AGGREGATE_TARGET
  12. GLOBAL_NAMES
  13. COMPATIBLE
  14. RECYCLEBIN
  15. FILESYSTEMIO_OPTIONS

For AMM(11g and above)

  1. MEMORY_TARGET
  2. MEMORY_MAX_TARGET

For ASMM (10g and above)

  1. SGA_TARGET
  2. SGA_MAX_SIZE
  3. PGA_AGGREGATE_TARGET

 

Oracle Scripts

https://oracle-base.com/dba/scripts

http://www.akadia.com/html/ora_scripts.html

 

Useful RMAN commands

http://www.thegeekstuff.com/2013/08/oracle-rman-backup/

 

RMAN Crosscheck

http://docs.oracle.com/cd/B19306_01/backup.102/b14192/maint002.htm

 

RMAN Section 

https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmbckad.htm#CHDJCAAG

 

SPM (11g but good)

Click to access twp-sql-plan-management-11gr2-133099.pdf

 

Upgrade to 12c 

https://docs.oracle.com/database/121/UPGRD/toc.htm

%d bloggers like this: