Monday 16 July 2012

Oracle Tips


HOW TO FIND DATABASE IS 32 BIT OR 64 BIT


Login to command prompt using oracle user.

Issue the following command.

$  file    $ORACLE_HOME/bin/sqlplus
you should see output like
/u01/db/bin/sqlplus:  ELF 32-bit LSB executable 80386 Version 1, dynamically linked, not stripped
If your oracle is 32 bit you should see output like
oracle: ELF 32-bit MSB executable

ORA-19809: limit exceeded for recovery files

The error was showing during startup. After searching I found a solution which worked. I thought you might like to know it.


SQL> startup
ORACLE instance started.

Total System Global Area 2.5736E+10 bytes
Fixed Size                  2165616 bytes
Variable Size            2438657168 bytes
Database Buffers         2.3287E+10 bytes
Redo Buffers                8650752 bytes
Database mounted.
ORA-16038: log 3 sequence# 16828 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 3 thread 1: '/datafile/oracle/oradata/ULTIMUS/redo03.log'


SQL> alter system set db_recovery_file_dest_size=150G;

System altered.

SQL> shutdown immediate;
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.

Total System Global Area 2.5736E+10 bytes
Fixed Size                  2165616 bytes
Variable Size            2438657168 bytes
Database Buffers         2.3287E+10 bytes
Redo Buffers                8650752 bytes
Database mounted.
Database opened.

ORA-01653: unable to extend table string.string by string in tablespace string


ORA-01653: unable to extend table string.string by string in tablespace string

Cause: Failed to allocate an extent of the required number of blocks for a table segment in the tablespace indicated.
Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.
Alert.log:
ORA-1653: unable to extend table SYS.AUD$ by 128 in                 tablespace SYSTEM

Solution:
ALTER DATABASE DATAFILE '/oracle/oraic01/ic_cl_def_128k_01.dbf' RESIZE 1000M

No comments:

Post a Comment