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, I have do this step : 1. replace the  current spfile with the old one 2. startup with pfile 3. restore and recover database using [...]

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 alter database backup controlfile to trace; startup nomount; recover database using backup controlfile; alter database open; Hope [...]

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 [...]

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 [...]

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: [...]

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.

ORA-00600: internal error code, arguments: [kksfbc-reparse-infinite-loop]

Hey i got this error code when execute query on java form ORA-00600: internal error code, arguments: [kksfbc-reparse-infinite-loop], [0x290EB6C18], [], [], [], [], [], [] The solution is just simply re-compile source of the view that used.

ORA-09314: sltln: error translating logical name

Do anyone know how can this error means, how to prevent it ? This is the result if i search over internet, ORA-09314: sltln: error translating logical name Cause: Internal buffer may have overflowed Action: See OSD error accompanying this message After all, i restart oracle service to fix this. But that is not a [...]

database not open – redo log fail

database couldn’t open because i got the error, ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: ‘E:\REDO\REDO01_01.ILG’ ORA-00312: online log 1 thread 1: ‘H:\REDO\REDO01_02.ILG’ i search some explanation about the error, ora-00312: online log %s thread %s: ‘%s’ *Cause:  This message reports the filename for [...]

ORA-06553: PLS-382: expression is of wrong type

CREATE OR REPLACE FUNCTION GET_BOOL RETURN BOOLEAN IS BEGIN RETURN TRUE; END; SELECT GET_BOOL() FROM DUAL; ORA-06552: PL/SQL: Statement ignored ORA-06553: PLS-382: expression is of wrong type Cause : There is BOOLEAN datatype is supported by PL/SQL and NOT supported by SQL So you cannot use this function in a straight select statement. However, this [...]

ORA-00257: archiver error. Connect internal only, until freed.

ORA-00257: archiver error. Connect internal only, until freed. Cause: The archiver process received an error while trying to archive a redo log. If the problem is not resolved soon, the database will stop executing transactions. The most likely cause of this message is the destination device is out of space to store the redo log [...]

ORA-00600: internal error code, arguments: [19004], [], [], [], [], []

ORA-00600: internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string] Cause: This is the generic internal error number for Oracle program exceptions. This indicates that a process has encountered an exceptional condition. Action: Report as a bug – the first argument is the internal error number ————————————————————————— ORA-00600 internal error code, arguments: [...]

ORA-27101: shared memory realm does not exist

ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist ———————————————— Cause: Unable to locate shared memory realm Action: Verify that the realm is accessible Explanation: you could be receive ORA-27101 because you tried to modify the database parameters such as SGA_MAX_SIZE size. You can try to bring back the original parameters. C:\Documents and [...]