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