Pular para o conteúdo principal

Postagens

Mostrando postagens de agosto, 2011

Configure PCP - Parallel Concurrent Processing R12

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

List ASM disks with devices

#!/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