Archive

Archive for September, 2010

Thousands of core dumps in $OMS_HOME

September 27, 2010 Leave a comment

Useful blog from martin that helped me when Oracle Grid control would not start and just core dumped filling the filesystem

http://martincarstenbach.wordpress.com/2010/05/24/thousands-of-core-dumps-in-oms_home/

Advertisements
Categories: Grid

Oracle RAC – Troubleshooting Connectivity Issues

September 26, 2010 Leave a comment

useful Video by Alex Gorbachev about ORA-12545 errors

Categories: Oracle Rac

backup and recovery of OCR Oracle 10g

September 26, 2010 Leave a comment

Another Useful post on youtube



Categories: Oracle Rac

Oracle 10g clusterware

September 26, 2010 Leave a comment

good video on youtube



Categories: Oracle Rac

OMS Startup

September 13, 2010 Leave a comment

$ORA_GRID_HOME/opmn/bin/opmnctl startall
$ORA_GRID_HOME/opmn/bin/opmnctl stopall

Categories: Grid

Finding out your RAC cluster name

September 12, 2010 Leave a comment

Note: To find out the value of your CLUSTER_NAME from CRS (OCR), do the following from the CRS_HOME:

cd $CRS_HOME/bin

./cemutlo -n
or
./ ocrdump
which will create a text file called OCRDUMPFILE
open that file and look for this entry
[SYSTEM.css.clustername]
ORATEXT : crs_cluster
In this case, “crs_cluster” is the cluster name.

Categories: Oracle Rac

viewing addm reports

September 12, 2010 Leave a comment
SQL> set long 1000000
SQL> set pagesize 50000
SQL> column get_clob format a80
SQL>select dbms_advisor.get_task_report(task_name) as ADDM_report
    from  dba_advisor_tasks
    where task_id = (
      select max(t.task_id)
      from dba_advisor_tasks t, dba_advisor_log l
      where t.task_id = l.task_id
        and t.advisor_name = 'ADDM'
        and l.status = 'COMPLETED');
Categories: tuning