Monday, November 17, 2008

Error:

Error (ORACLE-25153): ORA-25153: Temporary Tablespace is Empty

Solution:

alter tablespace temp add tempfile '/u01/app/oradata/temp01.dbf' size 500m;

Thursday, August 7, 2008

DBVERIFY Error: DBV-00103: Specified BLOCKSIZE (2048) differs from actual (16384)

Error:

DBV-00103: Specified BLOCKSIZE (2048) differs from actual (16384)

Solution:

Instead of using,
$ dbv file= datafilenamestart=1 end=500 logfile=dbverify.log
use the below
$dbv file=datafilename blocksize=db_block_size

Thursday, July 17, 2008

ALTER SYSTEM SWITCH LOGFILE Statement hangs

ALTER SYSTEM SWITCH LOGFILE hangs:
Step 1: Login as sysdba.
Step 2: Enable log_archive_dest_state_1 Parameter.
SQL>alter system set log_archive_dest_state_1=enable scope=spfile;
System altered.
SQL> ALTER SYSTEM SWITCH LOGFILE;
System altered.