Oracle Database in Oracle Linux Cannot Start / Open

Today I mess around with the Oracle database that can not start and open. I get some error messages from various places such as alert.log, sqlplus, rman.

These errors are,

ORA-03110: end-of-file on communication channel
ORA-03135: connection lost contact
ORA-00845: MEMORY_TARGET not supported on this system
ORA-16038: log 3 sequence# 400 cannot be archived
ORA-19502: write error on file "", block number  (block size=)
ORA-00312: online log 3 thread 1: '/u01/app/oracle/oradata/ITCAPPS/redo03.log'
ORA-19816: WARNING: Files may exist in db_recovery_file_dest that are not known to database.
ORA-00257: archiver error. Connect internal only, until freed.

I have do this step :
1. replace the  current spfile with the old one
2. startup with pfile
3. restore and recover database using rman

But that no help at all.

And the real solution is to enlarge the capacity of the folder where the archivelog is

Advertisements

ORA-01122: database file 1 failed verification check

When database startup, it send this message to the console,

ORA-01122: database file 1 failed verification check
ORA-01110: data file 1:
‘D:\ORACLE\PRODUCT\10.2.0\ORADATA\ITCAPPS2\SYSTEM01.DBF’
ORA-01207: file is more recent than control file – old control file

To fix this, try

  1. alter database backup controlfile to trace;
  2. startup nomount;
  3. recover database using backup controlfile;
  4. alter database open;

Hope this will work ^_^

ORA-30371: column cannot define a level in more than one dimension

Cause

A column was used in the definition of a level after it had already been used to define a level in a different dimension.

Action

Reorganize dimension levels and hierarchies into a single dimension such that no column is used to define levels in different dimensions. There is no limit on the number of levels or hierarchies you can place in a dimension. A column can be used to define any number of levels provided all such levels are in the same dimension and provided no two levels contain identical sets of columns.

ORA-06550 – DBMS_SHARED_POOL

when i run DBMS_SHARED_POOL.KEEP, i got this error message

ORA-06550: line 2, column 4:
PLS-00201: identifier ‘DBMS_SHARED_POOL.KEEP’ must be declared

after i search net, the solution is to run the script dbmspool.sql located in ORACLE_HOME\RDBMS\admin as sysdba

ORA-14400: inserted partition key does not map to any partition

Cause:
An attempt was made to insert a record into, a Range or Composite Range object, with a concatenated partition key that is beyond the concatenated partition bound list of the last partition -OR- An attempt was made to insert a record into a List object with a partition key that did not match the literal values specified for any of the partitions.

Action:
Do not insert the key. Or, add a partition capable of accepting the key, Or add values matching the key to a partition specification.

ORA-01110: data file 1: ‘SYSTEM01.DBF’

The database is suddenly can not connect. I’ve tried using the command,
shutdown immediate;
startup mount;
alter database open resetlogs;

Then this error appears
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: ‘\SYSTEM01.DBF’

Second try,
SQL> alter database recover datafile ‘\SYSTEM01.DBF’
ERROR at line 1:
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

SQL> recover database until cancel using backup controlfile;
ORA-00279: change 302423545 generated at 01/14/2009 09:25:14 needed for thread 1
ORA-00289: suggestion : G:\ARCHIVELOGS\672825376_1_49174.ARC
ORA-00280: change 302423545 for thread 1 is in sequence #49174

Specify log: {=suggested | filename | AUTO | CANCEL}

The more I want to find the solution, the more errors occurred. So I took the decision to continue to seek solutions from the first error only (“ORA-01110: data file 1: ‘\SYSTEM01.DBF'”).

Finally, after googling everywhere, I found the command in RMAN,
RMAN TARGET USR/PW
RMAN > RESTORE DATABASE
RMAN > RECOVER DATABASE

Back to SQLPLUS, I run again alter database open, and error is gone. ^_^

ORA-08102: index key not found

I got this error message, ORA-08102: index key not found, obj# 211154, file 21, block 1194413 (2)

when i run

DELETE FROM STATEMENTS
WHERE ID = ‘9646’
AND ORG_ID =’204′
AND TYPE NOT IN (‘PLA’, ‘TRK’, ‘RO’, ‘WO’, ‘CLM’);

To fix this error, i rebuild all of the index.