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 Or… Read more..

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..

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..

Script to check the tablespace size used in Oracle database [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..

Shutdown and Startup the Oracle RAC Database Manually ============================= 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..

ORA-19504/ORA-17502/ORA-15005 – RMAN Backup Failed to create the file in +ORADATA The below scenario occur in one of my RAC Production database. We would like to take the backup of the full database/incremental database by using the user defined location in +ORADATA [oracle(af2db2)@afcdb2]$ . oraenv ORACLE_SID = [afcdb2] ?… Read more..