Arvind Toorpu

I found this interesting article online & would like to share: The role of the DBA is an anomaly in the IT environment. DBAs are often extremely critical yet hidden from view; highly paid yet individual contributors; and very knowledgeable yet rarely consulted. So why does an extremely critical, highly paid, and very knowledgeable resource…

 ORA-24247: network access denied by access control list (ACL)Yesterday I was trying to send mail from my Oracle Database and I got below mentioned error :- ERROR at line 1:ORA-24247: network access denied by access control list (ACL)ORA-06512: at “CINP01314”, line 255ORA-06512: at line 21  In 11g Database , we need to create and configure…

Recently i was working on moving some data file on the primary server and i have set the standby_file_management=’MANUAL’. and  then I saw the following error on my standby server. ALTER DATABASE RECOVER managed standby database disconnect from sessionAttempt to start background Managed Standby Recovery process (ORCL)Thu Mar 20 16:07:33 2014MRP0 started with pid=35, OS…

Frist Create file vi rman_script.sh then add the following lines in rman_script.sh file #!/bin/bash####################################################################  this script will delete the archive and obsolete file on standby server  ############################################################################# ORACLE_HOME=/u01/app/oracle/product/11.2/db_1;export ORACLE_HOME;ORACLE_SID=ORCL;export ORACLE_SID; rman msglog ” now.log ” <<EOFconnect target /;CONFIGURE CONTROLFILE AUTOBACKUP ON;CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE…

Count All the Rows in all tables in a schema  you can do it various options Option 1.  you can write a sql to get the out output an the then run the output to get the count for all tables . select ‘select count (*) as ‘||owner||’_’||table_name||’ from ‘ ||owner||’.’||table_name||’;’ from all_tables tables where…