Paweł Domański
114 lines
4.1 KiB
Markdown
114 lines
4.1 KiB
Markdown
https://oracle-base.com/dba/script?category=monitoring&file=jobs.sql = Jobs Scripts
|
||
http://oracledbazone.com/scripts/ = All Scripts
|
||
http://oracledbascriptsfromajith.blogspot.in/ = Scripts
|
||
https://communities.bmc.com/docs/DOC-9942 = listener checking scripts
|
||
|
||
http://www.idevelopment.info/cgi/ORACLE_dba_scripts.cgi = All Scripts
|
||
|
||
|
||
|
||
https://usdc1sp002.chep.com:7799/em
|
||
https://chep.service-now.com/navpage.do
|
||
http://www.idevelopment.info/data/Oracle/DBA_tips/Automatic_Storage_Management/ASM_50.shtml
|
||
http://gavinsoorma.com/category/scripts/
|
||
https://oe.us.dell.com/
|
||
http://select-star-from.blogspot.in/2012/12/delete-archivelogs-and-old-rman-backups.html
|
||
|
||
|
||
|
||
Dataguard
|
||
---------
|
||
|
||
http://emrebaransel.blogspot.in/2013/07/data-guard-queries.html
|
||
http://www.pafumi.net/Standby_Concepts_Configuration.html
|
||
http://www.orafaq.com/forum/t/176313/
|
||
http://oracledatabasegrid.blogspot.in/p/dataguard_4.html
|
||
http://askdba.org/weblog/resource-center/useful-sql-dba/
|
||
|
||
Undo parameter
|
||
--------------
|
||
http://www.akadia.com/services/ora_optimize_undo.html
|
||
http://oracledatabasegrid.blogspot.in/p/dgmgrl.html
|
||
|
||
Trace file:
|
||
-----------
|
||
http://csl-oracle.blogspot.in/2013/01/finding-location-of-oracle-alert-log.html
|
||
|
||
Syncplicity:
|
||
------------
|
||
https://my.syncplicity.com/Default.aspx
|
||
|
||
|
||
ASM
|
||
---
|
||
http://noriegaaoracleexpert.blogspot.in/2010/06/asm-load-balancing-anthony-d.html?m=1
|
||
http://appsdbaera.blogspot.in/2013/04/oracle-asm-load-balancing.html
|
||
http://www.sivakumardba.com/2013/02/adding-new-asm-disk-into-existing.html
|
||
|
||
|
||
RAC
|
||
---
|
||
http://www.databasejournal.com/features/oracle/article.php/3681531/Oracle-RAC-Checking-RAC-status-with-SQLOS-level-statements.htm
|
||
https://dbamohsin.wordpress.com/2011/02/09/rac-services-command-list/
|
||
http://oracledbabay.blogspot.in/2012/11/oracle-11gr2-rac-services.html
|
||
https://community.oracle.com/welcome
|
||
http://oracledatabasegrid.blogspot.in/2014/07/oracle-11gr2-rac-oc4j-and-gsd-resource.html
|
||
|
||
DBA_Jobs
|
||
--------
|
||
http://www.dba-oracle.com/t_how_to_tell_when_scheduled_job_is_running.htm
|
||
https://community.oracle.com/thread/557102?start=60&tstart=0
|
||
http://ora-apps-dba.blogspot.in/2009/07/repair-broken-jobs-in-dbajobs.html
|
||
http://oracledatabasegrid.blogspot.in/2014/07/oracle-11gr2-rac-oc4j-and-gsd-resource.html
|
||
https://dbhk.wordpress.com/2014/11/13/ctssd1883crs-2409the-clock-on-host-xxxxx-is-not-synchronous-with-the-mean-cluster-time-no-action-has-been-taken-as-the-cluster-time-synchronization-service-is-running-in-observer-mode/
|
||
http://oradbatips.blogspot.in/2012/12/tip-104-node-eviction-in-rac-11gr2-due.html
|
||
http://docs.oracle.com/cd/E19044-01/sol.containers/817-1592/rmtaskproj.task-6/index.html
|
||
|
||
|
||
Alert log:
|
||
---------
|
||
http://www.oradba.ch/2013/07/query-alert-log-from-sqlplus/
|
||
|
||
Agent
|
||
-----
|
||
https://mehmeteser.wordpress.com/tag/emctl-clearstate-agent/
|
||
http://www.pythian.com/blog/how-to-fix-a-target-with-a-pending-status-in-oem-12cr2/
|
||
https://jhdba.wordpress.com/tag/clearstate/
|
||
http://www.idevelopment.info/data/Oracle/DBA_tips/Enterprise_Manager/OEM_15.shtml
|
||
|
||
|
||
DBA_profiles:
|
||
--------------
|
||
http://kannan-oracle.blogspot.in/2012/06/how-to-show-user-profile-and-change-its.html
|
||
|
||
|
||
|
||
GRID INSTALLATION:
|
||
=================
|
||
|
||
https://balakumarnair.wordpress.com/2011/02/13/oracle-11gr1-enterprise-manager-grid-control-oem-installation-part-1/
|
||
|
||
https://balakumarnair.wordpress.com/2011/02/24/oracle-11gr1-enterprise-manager-grid-control-oem-installation-part-2/
|
||
|
||
https://balakumarnair.wordpress.com/2011/02/24/oracle-11gr1-enterprise-manager-grid-control-oem-installation-part-3/
|
||
|
||
|
||
|
||
Managing 11gR1 Grid Control – Commands, Log files & Directory Structure
|
||
=======================================================================
|
||
|
||
https://balakumarnair.wordpress.com/category/oracle-11gr2/
|
||
|
||
|
||
|
||
Live Scenarios: All Concepts
|
||
==============
|
||
|
||
http://dbaworkshop.blogspot.com.au/p/recovery-scenarios_5.html
|
||
|
||
|
||
http://dbaworkshop.blogspot.it/2013/03/How-to-duplicate-a-production-database-on-a-different-server-mantaining-the-same-SID-and-directory-structures-with-duplicate-RMAN-command.html
|
||
==========================================================
|
||
How to duplicate a production database on a different server mantaining
|
||
the same SID and directory structures with 'duplicate' RMAN command
|