How to kill all the Oracle Session for specific user in Oracle Database 11gR2 Database Status: sys@TESTDB> select instance_name,status, version from V$instance; INSTANCE_NAME    STATUS       VERSION —————- ———— —————– testdb           OPEN         11.2.0.4.0 Check the… Read more..

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