Posted by Mir Sayeed Hassan on June 18th, 2018
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 attempts in database, We can find out this...
Read more..
Posted in DBA Administration | Comments Off on Find the user failed login attempts in Oracle database 11gR2
Posted by Mir Sayeed Hassan on June 17th, 2018
Script to verify the database for Primary & standby
[oracle@Prim-DB ~]$ cd /home/oracle/scripts/
[oracle@Prim-DB scripts]$ vi dblogsummary.sql
!df -h
!free
!uptime
!last reboot
set linesize 500
col host_name format a40;
select INST_ID,instance_name,STARTUP_TIME,status,archiver from gv$instance;
select name,log_mode,protection_mode,...
Read more..
Posted in DBA Scripts | Comments Off on Script to verify the database for Primary & standby
Posted by Mir Sayeed Hassan on June 13th, 2018
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:
Read more..
Posted in DBA Administration | Comments Off on Deleting the SYS.AUD$ Table in Oracle Database
Posted by Mir Sayeed Hassan on May 20th, 2018
STOP & START THE SINGLE NODE RAC DATABASE
===========================
STOP THE SINGLE NODE RAC DATABASE
===========================
Check the status of the database.
[oracle@test-rac2 ~]$ !sq
SQL> select status from v$instance;
STATUS
------------
OPEN
Posted in RAC | Comments Off on STOP & START THE SINGLE NODE RAC DATABASE
Posted by Mir Sayeed Hassan on May 16th, 2018
ORA-09925: Unable to create audit trail file, Linux-x86_64 Error: 30: Read-only file system
I found this error in one of our production database
SQL> startup startup
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 30: Read-only file system
Additional information: 9925
Solution 1:
–...
Read more..
Posted in ORA-Error | Comments Off on ORA-09925: Unable to create audit trail file, Linux-x86_64 Error: 30: Read-only file system
Posted by Mir Sayeed Hassan on May 16th, 2018
Script to check the datafile size used in Oracle database
[oracle@testdb scripts]$ pwd
/home/oracle/scripts
[oracle@testdb scripts]$ cat checkdf.sql
SET PAUSE ON
SET PAUSE 'Press Return to Continue'
SET PAGESIZE 60
SET LINESIZE 300
COLUMN "Tablespace Name" FORMAT A20
COLUMN "File Name" FORMAT A80
SELECT...
Read more..
Posted in DBA Scripts | Comments Off on Script to check the datafile size used in Oracle database
