Create an alert of failed login attempt of users in Oracle database 11gR2 (11.2.0.4) [oracle@testdb ~]$ !sq sqlplus /as sysdba sys@TESTDB> select instance_name,status,version from v$instance; INSTANCE_NAME    STATUS       VERSION ———————————————————— testdb                          … Read more..

RMAN-04015: error setting target database character set to US7ASCII & ORA-06553 Database Status sys@TESTDB>select instance_name,status,version from v$instance; INSTANCE_NAME    STATUS       VERSION —————- ———— —————– testdb           OPEN         11.2.0.4.0 Error… Read more..

How to drop database manually without using DBCA 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 It’s recommended… Read more..

How to create a database manually in Oracle 11gR2 An Oracle database can be created either using manually or DBCA or at the time of installation of the Oracle software, the below given step by step process is to manually creation of database, Analyse the requirement of the database from the client size regarding the Read More

How to login another database user without knowing a password in Oracle database 11gR2 This operation can perform by DBA, if & only if it’s approved from higher management & it’s not a good practice to break the Oracle Security rule. Consider we want to perform the activity with different user but you don’t have Read More

How to login a database user without knowing a password in Oracle database 11gR2 This method also try to login into the MIR1 user without knowing the password, after completion of the task later we can restore the same password for MIR1. [oracle@testdb ~]$ !sq sqlplus / as sysdba sys@TESTDB> sho user USER is “SYS”