How to create directory in Oracle database 11gR2 The directories must be created if any of the external tables are used in database for any operation as example for expdp/impdp etc & this directory should be granted the object privilege as read & write, data dictionary view are all_directories/dba_directories. Database Status: sys@TESTDB>… Read more..

How to Kill Single & Multiple Sessions in Oracle Database 11gR2 To kill the Oracle session in a database, you should be careful with the consult team to kill the correct session as per there requirement. Database Status: sys@TESTDB> select instance_name,version,status from v$instance; INSTANCE_NAME VERSION … Read more..

Find the user failed login attempts in Oracle database 11gR2 The user is created with the default profile set in database & the FAILED_LOGIN_ATTEMPTS set to 10, In this case if you exceed the more than 10 failed login attempts, then your account will be locked Now verify the user with number of failed login Read More

Deleting the SYS.AUD$ Table in Oracle Database Find the below procedure: Before deleting the SYS.AUD$ table, take the backup by using the exp utility Note: In Oracle 11g we cannot run expdp to export the SYS.AUD$ table, Use the exp utility Create the directory in OS & DB Level:

Configure multiple IP Address with single default port 1521 sys@TESTDB> select INSTANCE_NAME,VERSION,STATUS from v$instance; INSTANCE_NAME    VERSION           STATUS —————- —————– ———— testdb           11.2.0.4.0        OPEN Configure the listener

Recycle bin concept in Oracle database 11gR2 Recycle bin is similar to windows recyclebin in Oracle database & here the entire drop object is stored in FLASHBACK Area As per my recycle bin its a virtual where all the dropped objects reside in it, It occupy the exact space as when they are created in Read More