A profile is a named set of the following password and resource limits: a.. Password aging and expirationb.. Password historyc.. Password complexity verificationd.. Account lockinge.. CPU timef.. Input/output (I/O) operationsg.. Idle timeh.. Connect timei.. Memory space (private SQL area for Shared Server only)j.. Concurrent sessions After a profile has been…

 exporting schema excluding some tables: To exclude table from EXPDP Backup. Let’s take a case, you have 100 tables in your schema and you want to export only 99 of them except two which are huge in size and already available at destination. Here, expdp exclude=table:”in\(‘EMP’\,’DEPT’\)” parameter is best for DBA .…

When ever you try to insert an ambersand ‘&’ into database, database tries to intract and get the values values from screen. in that case we can follow below steps create table test (name varchar2(35)); insert into test values (‘hello&world’); I tried the escape character ‘\’ but the system asks…

Auditing changes within the database are becoming more and more important. As well as auditing changes to data, auditing DDL changes can be just as critical. This allows the DBA to not only know what changes have been made but also what haven’t. Being able to see what changes have…

Find accounts unused for days                                                 Summary Here’s a script that shows accounts and number of days since last use. It assumes session auditing is enabled. SELECT RPAD(da.username, 12) “Username”, TRUNC(SYSDATE – MAX(da.TIMESTAMP)) “Days Inactive”, LPAD(du.account_status, 16) “Status”, LPAD(TO_CHAR(MAX(da.TIMESTAMP), ‘DD-MON-YYYY’), 16) “Last Login”FROM dba_users du, dba_audit_session da WHERE da.action_name LIKE ‘LOG%’–…

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…

 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…

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…

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…

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 ‘…