Dicas ORACLE DBA

To find Symbolic Links find . -type l Show all links, it does nto use the cool flashing RED that BASH can do to show a  broken links. find . -type l | (while read FN ; do test -e "$FN" || ls -ld "$FN"; done)

1) edit context file (vi $CONTEXT_FILE): find and change the variables: s_appldcp to ON s_applcsf to shared file system s_appltmp to valid UTL_FILE_DIR  configured in database 2) Run autoconfig for all nodes 3) Check tnsnames.ora and listener.ora in $TNS_ADMIN, if exist FNDSM and FNDFS entries 4) In System Administrator Responsibility > Concurrent > Manager  > Define , set primary and secundary node for all manager. 5) Set profile option 'Concurrent: PCP Instance Check' to OFF if database instance-sensitive failover is  not  required. By setting it to 'ON', a concurrent manager will fail over to a secondary Application tier node if the database instance to which it is connected becomes unavailable for some reason. *** There are programs (MRP and Transaction Managers for example) that are not natively support RAC Database. Some programs use DBMS_PIPE, was therefore required specific configuration for these programs

#!/bin/bash for i in `/etc/init.d/oracleasm listdisks` do v_asmdisk=`/etc/init.d/oracleasm querydisk -d $i | awk  '{print $2}'` v_minor=`/etc/init.d/oracleasm querydisk -d $i | awk -F[ '{print $2}'| awk -F] '{print $1}' | awk '{print $1}'` v_major=`/etc/init.d/oracleasm querydisk -d $i | awk -F[ '{print $2}'| awk -F] '{print $1}' | awk '{print $2}'` v_device=`ls -la /dev | grep $v_minor | grep $v_major | awk '{print $10}'` echo "ASM disk $v_asmdisk based on /dev/$v_device  [$v_minor $v_major]" done

$cat get_free_memory.sh #!/bin/bash MEMFREE=$(cat /proc/meminfo|grep MemFree|awk '{print $2}') LOW=10000 echo em_result=$MEMFREE if [ $MEMFREE -lt $LOW ]; then echo "em_message=Free Memory low" fi $./get_free_memory.sh em_result=983 em_message=Free Memory low

As root: $cd $GRID_HOME/crs/install $perl rootcrs.pl -deconfig -force (Repeat for all nodes) On last node execute: $perl rootcrs.pl -deconfig -force -lastnode The -lastnode remove node cluster with the OCR and voting disks.

set verify off set pagesize 1000 column RN format A40 heading "Responsibility Name" prompt prompt &1 can be run by: SELECT responsibility_name RN FROM fnd_request_groups frg, fnd_request_group_units frgu, fnd_concurrent_programs_vl fcpv, fnd_responsibility_vl frv WHERE frgu.request_unit_type = 'P' AND (UPPER(fcpv.concurrent_program_name) = UPPER('&1') OR UPPER(fcpv.user_concurrent_program_name) = UPPER('&1')) AND frgu.request_group_id = frg.request_group_id AND frgu.request_unit_id = fcpv.concurrent_program_id AND frv.request_group_id = frg.request_group_id ORDER BY responsibility_name / Metalink note: 134036.1

declare l_result boolean; SELECT count(1) a, (CASE WHEN a < 1000 THEN l_result := fnd_concurrent.set_completion_status('NORMAL',Complete normal.'); WHEN a >= 1000 THEN l_result := fnd_concurrent.set_completion_status('WARNING','Complete with warnings.'); ELSE l_result := fnd_concurrent.set_completion_status('ERROR','Complete with error.'); END ) Raise FROM teste; commit; end; / exit;