Dicas ORACLE DBA

First Configure public Yum Repository: http://public-yum.oracle.com/ Run oracle-validated: [root@localhost yum.repos.d]# yum install oracle-validated Loading "security" plugin Setting up Install Process Parsing package install arguments Resolving Dependencies --> Running transaction check ---> Package oracle-validated.x86_64 0:1.1.0-14.el5 set to be updated filelists.xml.gz          100% |=========================| 3.1 kB    00:00 filelists.xml.gz          100% |=========================| 2.9 MB    00:10 filelists.xml.gz          100% |=========================| 2.7 MB    00:15 filelists.xml.gz          100% |=========================| 3.2 MB    00:18 filelists.xml.gz          100% |=========================| 2.6 MB    00:14 filelists.xml.gz          100% |===========...

DATAFILE_BLOCKS The number of data blocks in the datafile BLOCKS The number of data blocks written to the backup BLOCK_SIZE The size of the data blocks in bytes So BLOCKS * BLOCK_SIZE will give the number of bytes written for this particular datafile and hence the size of the backup piece may be calculated. SQL> select bs_key, sum(blocks*block_size) from rc_backup_datafile group by bs_key; If you do not use catalog (controlfile): SQL>select bs_key, sum(blocks*block_size) from v$backup_datafile group by bs_key;

BEGIN  DBMS_AUTO_TASK_ADMIN.DISABLE(  client_name => 'auto optimizer stats collection',  operation => NULL,  window_name => NULL);  END;  / to verify: SQL> select client_name,status from Dba_Autotask_Client;  CLIENT_NAME                        STATUS ---------------------------------- -------- auto optimizer stats collection    DISABLED auto space advisor                 ENABLED sql tuning advisor                 ENABLED

1. Using the adctrl utility, shutdown the workers. a. adctrl b. Select option 3 "Tell worker to shutdown/quit" 2. Backup the FND_INSTALL_PROCESSES table which is owned by the APPLSYS schema a. sqlplus applsys/ b. create table fnd_Install_processes_back as select * from fnd_Install_processes; c. The 2 tables should have the same number of records. select count(*) from fnd_Install_processes_back; select count(*) from fnd_Install_processes; 3. Backup the AD_DEFERRED_JOBS table. a. sqlplus applsys/ b. create table AD_DEFERRED_JOBS_backas select * from AD_DEFERRED_JOBS; c. The 2 tables should have the same number of records. select count(*) from AD_DEFERRED_JOBS_back; select count(*) from AD_DEFERRED_JOBS; 4. Backup the .rf9 files located in $APPL_TOP/admin//restart directory. At this point, the adpatch session should have ended and the cursor should be back at the Unix prompt. a. cd $APPL_TOP/admin/ b. mv restart restart_back c. mkdir rest...

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