Archives for ORACLE DBA
ORA-01031: insufficient privileges when connect as sysdba
Created new temporary tablespace: CREATE TEMPORARY TABLESPACE TEMP01 TEMPFILE ‘/u01/oracle/#8217; SIZE 2g; Make new temporary tablespace as default: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP01; Dropping old temporary tablespace, Which is…
LOGIN PAGE SHOWS BLANK IN Oracle Applications R12
I have installed 10gR2 on linux environment, When running DBCA it got filed with below error ORA-27125: unable to create shared memory segment SOLUTION: cd $ORACLE_HOME/bin mv oracle …
SIMPLE DATABASE CREATION
CREATION OF DATABASE IN COMMAND LINE: 1) Set Environment file: #su – oracle $pwd export ORACLE_SID=PROD export ORACLE_HOME=/u01/app/oracle/ export PATH=$ORACLE_HOME/bin:$PATH 2) Create Parameter file: $cd $ORACLE_HOME/dbs $ vi $ORACLE_HOME/ db_name…
Resolve archive gap between PRIMARY and STANDBY
A Physical Standby database synchs with Primary by continuous apply of archive logs from a Primary Database. When the logs are missing on standby is less than 10-15 numbers, We…
Resolve huge archive gap between PRIMARY and STANDBY
A Physical Standby database synchs with Primary by continuous apply of archive logs from a Primary Database. When the logs are missing on standby difference is huge (say more than…
RMAN : Perform Block Recovery
We can perform BLOCK RECOVERY with or without RMAN BACKUP, Here is the demonstration of block media recovery with HOT BACKUP and RMAN BACKUP as well. 1) Create tablespace, user…
TRACE IN ORACLE DATABASE
Current session trace: NORMAL TRACE: alter session set tracefile_identifer=’XXX’; — trace identifier alter session set sql_trace = true; FULL LEVEL TARCE with WAIT and BIND : alter session set tracefile_identifer=’XXX’;…
DATABASE SIZE (datafiles + tempfiles + redologfiles)
To get accurate size of the database, We have to combined the sizes of all datafiles, tempfiles and redologfiles. select round ((++)/1024/1024/1024,2) “DB_size_in_GB” from ( select sum(bytes) data_size from dba_data_files…
DATABASE HANGS
ERROR MESSAGE IN ALERTLOG FILE: ORACLE Instance PROD – Archival Error ORA-16038: log 4 sequence# 9961 cannot be archived ORA-19502: write error on file “”, block number (block size=) ORA-00312:…
RMAN COLD BACKUP AND RESTORE
Simple RMAN script to take cold database backup: For taking RMAN cold database backup, Database should be in mount status, Which can be noticed from below scipt. mkdir -p /BACKUP/PROD…