Home

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 for a value of the…

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 been made to the database…

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%’– AND da.username NOT IN (‘SYS’,’SYSTEM’)…

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…