Posted by Mir Sayeed Hassan on February 19th, 2019
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..
Posted in DBA Scripts | Comments Off on Create an alert of failed login attempt of users in Oracle database 11gR2 (11.2.0.4)
Posted by Mir Sayeed Hassan on February 13th, 2019
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
Posted in ORA-Error | Comments Off on RMAN-04015: error setting target database character set to US7ASCII & ORA-06553
Posted by Mir Sayeed Hassan on February 10th, 2019
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
Posted in DBA Administration | Comments Off on How to drop database manually without using DBCA in Oracle database 11gR2
Posted by Mir Sayeed Hassan on February 10th, 2019
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 storage of db etc
Posted in DBA Administration | Comments Off on How to create a database manually in Oracle 11gR2
Posted by Mir Sayeed Hassan on February 5th, 2019
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 the password of that user,...
Read more..
Posted in Oracle SQL | Comments Off on How to login another database user without knowing a password in Oracle database 11gR2
Posted by Mir Sayeed Hassan on February 5th, 2019
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"
Read more..
Posted in Oracle SQL | Comments Off on How to login a database user without knowing a password in Oracle database 11gR2
