Posted by Mir Sayeed Hassan on June 13th, 2018
Before deleting the SYS.AUD$ table, take the backup by using the exp utility
In Oracle 11g we cannot run expdp to export the SYS.AUD$ table, Use the exp utility
Create the directory in OS & DB Level:
Posted in DBA Administration | Comments Off on Deleting the SYS.AUD$ Table in Oracle Database
Posted by Mir Sayeed Hassan on May 20th, 2018
===========================
===========================
[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:
–...
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
Posted by Mir Sayeed Hassan on May 16th, 2018
[oracle@testdb scripts]$ pwd /home/oracle/scripts
[oracle@testdb scripts]$ cat checktbs.sql set linesize 180 set pagesize 30 select fs.tablespace_name "Tablespace", (df.totalspace - fs.freespace) "Used MB", fs.freespace "Free MB", df.totalspace...Read more..
Posted in DBA Scripts | Comments Off on Script to check the tablespace size used in Oracle database
Posted by Mir Sayeed Hassan on May 14th, 2018
Shutdown the RAC Database Manually
================================
The below scenario is tested in our test env, below are the steps as followed:
Check the status of database
[oracle@test-rac2 ~]$...Read more..
Posted in RAC | Comments Off on Shutdown and Startup the Oracle RAC Database Manually