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

PROBLEM:
__________

While creating controlfile in ASM,I hit this error below:

ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-00600: internal error code, arguments: [kccbcf_omf_reuse], [], [], [], [],
[], [], []




SOLUTION:
__________

Control_files parameter set incorrectly in the spfile / pfile.

 *.control_files='+TEST/necodev/controlfile/current.ctl'

Bug 4309649: is fixed in 11g

Workaround:

 Use Diskgroup name 'only' for control_files init.ora parameter if create controlfile fails.
    Set the control_file parameter in the Auxiliary database spfile or pfile to 'only' the ASM Diskgroup name.

    Example:

     *.control_files='+TEST'


Best tray :))

ORA-12705: Cannot access NLS data files or invalid environment specified

PROBLEM:
----------------

While connecting sqlplus we got this error.

bash$>sqlplus A/A@NECODB


ERROR
-----------

ORA-12705: Cannot access NLS data files or invalid environment specified



SOLUTION:
----------------

You have to check ORACLE_HOME enviroment in your profile.

When we check the our .profile ,hit this line below:

export ORACLE_HOME=u101/app/oracle/product/10.2.0/db_1

This path is incorrect./ is missing

Must be /u101/app/oracle/product/10.2.0/db_1

After we changed the .profile.

Sqlplus connected database successfully .


Pray & Tray :)

CRS-1714:Unable to discover any voting files, retrying discovery

PROBLEM:
----------------

[cssd(26226)]CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds; Details at (:CSSNM00070:) in /u01/app/11.2.0/grid/log/ndx1/cssd/ocssd.log
2014-09-02 11:42:11.636:


SOLUTION:
----------------


****************************
Check the disks owner.                 *
Disks owner must be oracle          *
****************************

RMAN-20001: target database not found in recovery catalog

PROBLEM:
----------------

RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

SOLUTION:
-----------------

connect catalog database and register database to catalog

RMAN>register database


RMAN-20002: target database already registered in recovery catalog

ORA-12537:TNS:Connection Closed

PROBLEM:
----------------

ORA-12537:TNS:Connection Closed


SOLUTION:
---------------

Check the location which is oracle installed.

In my case,oracle software installed /oracle and /oracle %100.

So hit an "max number of process exceed" error in alertlog.

ORA-600 kdsgrp1

PROBLEM:
------------

Causes and Solutions for ora-600 [kdsgrp1] (Doc ID 1332252.1)


SOLUTION:
----------------


alter system flush buffer_cache;

Analyze table scott.dept validate structure cascade online;

ORA-01499: table/index cross reference failure

PROBLEM:
---------------

ORA-01499: table/index cross reference failure



SOLUTION:
-------------
Drop indexes

analyze table

create indexes