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

Asmlib ASM:/opt/oracle/extapi/64/asm/orcl/1/libasm.so op asm_open error Operation not permitted

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

asmlib ASM:/opt/oracle/extapi/64/asm/orcl/1/libasm.so op asm_open error Operation not permitted


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

To prevent ASMLIB from discovering the same disk more than once it needs to be forced to look only at /dev/dm*  and ignore all /dev/sd* devices.

1. either edit the file /etc/sysconfig/oracleasm-_dev_oracleasm    and change the lines:

ORACLEASM_SCANORDER=""
ORACLEASM_SCANEXCLUDE=""
to

ORACLEASM_SCANORDER="dm"
ORACLEASM_SCANEXCLUDE="sd"
or alternatively run the following command (as user root)

/usr/sbin/oracleasm configure -i -e -u user -g group -o "dm" -x "sd"

2. stop & restart ASMLIB as user root using:

/usr/sbin/oracleasm exit
/usr/sbin/oracleasm init
/usr/sbin/oracleasm scandisks

3. restart CRS or reboot node

ORA-00214: control file control02 version 147396 inconsistent with file control01.ctl' version 147363

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

ORA-00214: control file '/u03/oradata/tstmdbch/control02.ctl' version 147396
inconsistent with file '/u02/oradata/tstmdbch/control01.ctl' version 147363





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

Shutdown the database .After changing the control files with the one with the highest version number .
I started the database and it opened.



 $  cp /u02/oradata/tstmdbch/control01.ctl /tmp/control01.ctl_old
 $  cp /u03/oradata/tstmdbch/control02.ctl /u02/oradata/tstmdbch/control01.ctl

Then start the database.

ORA-03113: end-of-file on communication channel

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

SQL> startup
ORACLE instance started.

Total System Global Area 2.6724E+10 bytes
Fixed Size                  2195216 bytes
Variable Size            4160749808 bytes
Database Buffers         2.2549E+10 bytes
Redo Buffers               12173312 bytes

ORA-03113: end-of-file on communication channel
Process ID: 3949
Session ID: 394 Serial number: 1


There is some error in alertlog like below:

SUCCESS: diskgroup DATAGRP was mounted
ERROR: failed to establish dependency between database NECO and diskgroup resource ora.DATAGRP.dg
USER (ospid: 3174): terminating the instance
System state dump requested by (instance=1, osid=3174), summary=[abnormal instance termination].
System State dumped to trace file /u01/app/oracle/diag/rdbms/neco/NECO/trace/CLDS_diag_3100.trc
Dumping diagnostic data in directory=[cdmp_20140723101552], requested by (instance=1, osid=3174), summary=[abnormal instance terminati

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

Disk corruption may cause this problem.ORA-03113: end-of-file on communication channel says
control file is corrupted.You have to create a new control file,then recover database.



controlfile createscript:
-------------------------
CREATE CONTROLFILE REUSE DATABASE "NECO" RESETLOGS  ARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 4672
LOGFILE
 GROUP 1 '+REDOGRP/NECO/onlinelog/group_1.256.839147011'  SIZE 50M,
 GROUP 2 '+REDOGRP/NECO/onlinelog/group_2.257.839147017'  SIZE 50M,
 GROUP 3 '+REDOGRP/NECO/onlinelog/group_3.258.839147023'  SIZE 50M,
 GROUP 4 '+REDOGRP/NECO/onlinelog/group_4.259.839147027'  SIZE 50M
-- STANDBY LOGFILE
DATAFILE
  '+DATAGRP/NECO/datafile/tallydata.368.838770799',
'+DATAGRP/NECO/datafile/tallydata.383.838817089',
'+DATAGRP/NECO/datafile/system.347.838758259',
'+DATAGRP/NECO/datafile/tallydata2.291.838895197',
'+DATAGRP/NECO/datafile/tallyindex.317.838735277',
'+DATAGRP/NECO/datafile/tallydata2.378.838790455',
'+DATAGRP/NECO/datafile/tallyindex.387.838829347',
'+DATAGRP/NECO/datafile/tallydata.306.838920789',
'+DATAGRP/NECO/datafile/tallydata.380.838804317',
'+DATAGRP/NECO/datafile/tallydata.311.838907659',
'+DATAGRP/NECO/datafile/tallydata.307.838916277',
'+DATAGRP/NECO/datafile/tallyindex.334.838749141',
'+DATAGRP/NECO/datafile/tallyindex.323.838739397',
'+DATAGRP/NECO/datafile/tallyindex.335.838750441',
'+DATAGRP/NECO/datafile/tallyindex.328.838743599',
'+DATAGRP/NECO/datafile/tallyindex.384.838821257',
'+DATAGRP/NECO/datafile/tallydata.350.838758689',
'+DATAGRP/NECO/datafile/tallydata.362.838766739',
'+DATAGRP/NECO/datafile/tallydata.330.838745965',
'+DATAGRP/NECO/datafile/tallydata.382.838812911',
'+DATAGRP/NECO/datafile/tallyindex.329.838745417',
'+DATAGRP/NECO/datafile/tallydata.357.838762425',
'+DATAGRP/NECO/datafile/tallydata.381.838808627',
'+DATAGRP/NECO/datafile/tallydata.360.838764305',
'+DATAGRP/NECO/datafile/tallydata.342.838755839',
'+DATAGRP/NECO/datafile/tallydata.370.838772947',
'+DATAGRP/NECO/datafile/tallydata.336.838751643',
'+DATAGRP/NECO/datafile/tallyindex.388.838832087',
'+REDOGRP/NECO/onlinelog/group_1.256.839147011',
'+REDOGRP/NECO/onlinelog/group_2.257.839147017',
'+REDOGRP/NECO/onlinelog/group_3.258.839147023',
'+REDOGRP/NECO/onlinelog/group_4.259.839147027',
'+DATAGRP/NECO/datafile/tallydata.368.838770799',
'+DATAGRP/NECO/datafile/tallydata.383.838817089',
'+DATAGRP/NECO/datafile/system.347.838758259',
'+DATAGRP/NECO/datafile/tallydata2.291.838895197',
'+DATAGRP/NECO/datafile/tallyindex.317.838735277',
'+DATAGRP/NECO/datafile/tallydata2.378.838790455',
'+DATAGRP/NECO/datafile/tallyindex.387.838829347',
'+DATAGRP/NECO/datafile/tallydata.306.838920789',
'+DATAGRP/NECO/datafile/tallydata.380.838804317',
'+DATAGRP/NECO/datafile/tallydata.311.838907659',
'+DATAGRP/NECO/datafile/tallydata.307.838916277',
'+DATAGRP/NECO/datafile/tallyindex.334.838749141',
'+DATAGRP/NECO/datafile/tallyindex.323.838739397',
'+DATAGRP/NECO/datafile/tallyindex.335.838750441',
'+DATAGRP/NECO/datafile/tallyindex.328.838743599',
'+DATAGRP/NECO/datafile/tallyindex.384.838821257',
'+DATAGRP/NECO/datafile/tallydata.350.838758689',
'+DATAGRP/NECO/datafile/tallydata.362.838766739',
'+DATAGRP/NECO/datafile/tallydata.330.838745965',
'+DATAGRP/NECO/datafile/tallydata.382.838812911',
'+DATAGRP/NECO/datafile/tallyindex.329.838745417',
'+DATAGRP/NECO/datafile/tallydata.357.838762425',
'+DATAGRP/NECO/datafile/tallydata.381.838808627',
'+DATAGRP/NECO/datafile/tallydata.360.838764305',
'+DATAGRP/NECO/datafile/tallydata.342.838755839',
'+DATAGRP/NECO/datafile/tallydata.370.838772947',
'+DATAGRP/NECO/datafile/tallydata.336.838751643',
'+DATAGRP/NECO/datafile/tallyindex.388.838832087',
'+DATAGRP/NECO/datafile/tallyindex.385.838823995',
'+DATAGRP/NECO/datafile/tallyindex.379.838796839',
'+DATAGRP/NECO/datafile/tallyindex.305.838925223',
'+DATAGRP/NECO/datafile/tallydata2.366.838769445',
'+DATAGRP/NECO/datafile/tallydata2.339.838753799',
'+DATAGRP/NECO/datafile/tallydata2.367.838770603',
'+DATAGRP/NECO/datafile/tallydata2.369.838771833',
'+DATAGRP/NECO/datafile/tallydata2.361.838765457',
'+DATAGRP/NECO/datafile/tallydata2.338.838752373',
'+DATAGRP/NECO/datafile/tallydata2.377.838786567',
'+DATAGRP/NECO/datafile/tallydata2.363.838766741',
'+DATAGRP/NECO/datafile/tallydata2.364.838768029',
'+DATAGRP/NECO/datafile/tallydata2.374.838780685',
'+DATAGRP/NECO/datafile/tallydata2.359.838764227',
'+DATAGRP/NECO/datafile/tallydata2.356.838761713',
'+DATAGRP/NECO/datafile/tallydata2.358.838762987',
'+DATAGRP/NECO/datafile/tallydata2.331.838747175',
'+DATAGRP/NECO/datafile/tallydata2.355.838760409',
'+DATAGRP/NECO/datafile/tallydata2.353.838759083',
'+DATAGRP/NECO/datafile/sysaux.346.838757989',
'+DATAGRP/NECO/datafile/tallyindex.376.838783507',
'+DATAGRP/NECO/datafile/tallydata.332.838747455',
'+DATAGRP/NECO/datafile/tallydata.371.838775063',
'+DATAGRP/NECO/datafile/tallydata.316.838899197',
'+DATAGRP/NECO/datafile/tallyindex.373.838777679',
'+DATAGRP/NECO/datafile/tallyindex.389.838834545',
'+DATAGRP/NECO/datafile/tallydata.375.838781803',
'+DATAGRP/NECO/datafile/tallydata.326.838743023',
'+DATAGRP/NECO/datafile/tallydata.337.838752037',
'+DATAGRP/NECO/datafile/tallydata.318.838735285',
'+DATAGRP/NECO/datafile/tallyindex.385.838823995',
'+DATAGRP/NECO/datafile/tallyindex.379.838796839',
'+DATAGRP/NECO/datafile/tallyindex.305.838925223',
'+DATAGRP/NECO/datafile/tallydata2.366.838769445',
'+DATAGRP/NECO/datafile/tallydata2.339.838753799',
'+DATAGRP/NECO/datafile/tallydata2.367.838770603',
'+DATAGRP/NECO/datafile/tallydata2.369.838771833',
'+DATAGRP/NECO/datafile/tallydata2.361.838765457',
'+DATAGRP/NECO/datafile/tallydata2.338.838752373',
'+DATAGRP/NECO/datafile/tallydata2.377.838786567',
'+DATAGRP/NECO/datafile/tallydata2.363.838766741',
'+DATAGRP/NECO/datafile/tallydata2.364.838768029',
'+DATAGRP/NECO/datafile/tallydata2.374.838780685',
'+DATAGRP/NECO/datafile/tallydata2.359.838764227',
'+DATAGRP/NECO/datafile/tallydata2.356.838761713',
'+DATAGRP/NECO/datafile/tallydata2.358.838762987',
'+DATAGRP/NECO/datafile/tallydata2.331.838747175',
'+DATAGRP/NECO/datafile/tallydata2.355.838760409',
'+DATAGRP/NECO/datafile/tallydata2.353.838759083',
'+DATAGRP/NECO/datafile/sysaux.346.838757989',
'+DATAGRP/NECO/datafile/tallyindex.376.838783507',
'+DATAGRP/NECO/datafile/tallydata.332.838747455',
'+DATAGRP/NECO/datafile/tallydata.371.838775063',
'+DATAGRP/NECO/datafile/tallydata.316.838899197',
'+DATAGRP/NECO/datafile/tallyindex.373.838777679',
'+DATAGRP/NECO/datafile/tallyindex.389.838834545',
'+DATAGRP/NECO/datafile/tallydata.375.838781803',
'+DATAGRP/NECO/datafile/tallydata.326.838743023',
'+DATAGRP/NECO/datafile/tallydata.337.838752037',
'+DATAGRP/NECO/datafile/tallydata.318.838735285',
'+DATAGRP/NECO/datafile/tallydata.372.838777337',
'+DATAGRP/NECO/datafile/tallydata.386.838826931',
'+DATAGRP/NECO/datafile/tallydata.324.838740235',
'+DATAGRP/NECO/datafile/tallydata.365.838768555',
'+DATAGRP/NECO/datafile/undotbs01.320.838737503',
'+DATAGRP/NECO/datafile/tallyindex.340.838755209',
'+DATAGRP/NECO/datafile/tallyindex.321.838737563',
'+DATAGRP/NECO/datafile/tallyindex.333.838748519',
'+DATAGRP/NECO/datafile/tallyindex.341.838755235',
'+DATAGRP/NECO/datafile/tallyindex.325.838741799',
'+DATAGRP/NECO/datafile/tallydata.310.838912207',
'+DATAGRP/NECO/datafile/tallydata.319.838735317',
'+DATAGRP/NECO/datafile/tallydata.322.838739287',
'+DATAGRP/NECO/datafile/tallydata.327.838743271',
'+DATAGRP/NECO/datafile/tallydata.354.838760067',
'+DATAGRP/NECO/datafile/users.349.838758669',
'+DATAGRP/NECO/datafile/users.348.838758485',
'+DATAGRP/NECO/datafile/users.352.838758961',
'+DATAGRP/NECO/datafile/users.345.838757925',
'+DATAGRP/NECO/datafile/users.351.838758821',
'+DATAGRP/NECO/datafile/sysaux.343.838757443',
'+DATAGRP/NECO/tempfile/tmp.302.839147045',
'+DATAGRP/NECO/datafile/system.344.838757777',
'+DATAGRP/NECO/tempfile/tmp.303.839147045',
'+DATAGRP/NECO/tempfile/tmp.304.839147045',
'+DATAGRP/NECO/datafile/tallydata.372.838777337',
'+DATAGRP/NECO/datafile/tallydata.386.838826931',
'+DATAGRP/NECO/datafile/tallydata.324.838740235',
'+DATAGRP/NECO/datafile/tallydata.365.838768555',
'+DATAGRP/NECO/datafile/undotbs01.320.838737503',
'+DATAGRP/NECO/datafile/tallyindex.340.838755209',
'+DATAGRP/NECO/datafile/tallyindex.321.838737563',
'+DATAGRP/NECO/datafile/tallyindex.333.838748519',
'+DATAGRP/NECO/datafile/tallyindex.341.838755235',
'+DATAGRP/NECO/datafile/tallyindex.325.838741799',
'+DATAGRP/NECO/datafile/tallydata.310.838912207',
'+DATAGRP/NECO/datafile/tallydata.319.838735317',
'+DATAGRP/NECO/datafile/tallydata.322.838739287',
'+DATAGRP/NECO/datafile/tallydata.327.838743271',
'+DATAGRP/NECO/datafile/tallydata.354.838760067',
'+DATAGRP/NECO/datafile/users.349.838758669',
'+DATAGRP/NECO/datafile/users.348.838758485',
'+DATAGRP/NECO/datafile/users.352.838758961',
'+DATAGRP/NECO/datafile/users.345.838757925',
'+DATAGRP/NECO/datafile/users.351.838758821',
'+DATAGRP/NECO/datafile/sysaux.343.838757443',
'+DATAGRP/NECO/tempfile/tmp.302.839147045',
'+DATAGRP/NECO/datafile/system.344.838757777',
'+DATAGRP/NECO/tempfile/tmp.303.839147045',
'+DATAGRP/NECO/tempfile/tmp.304.839147045',
'+DATA/NECO/datafile/users.305.809473127',
'+DATA/NECO/datafile/users.371.809473293',
'+DATA/NECO/datafile/users.353.809473459',
'+DATA/NECO/datafile/users.331.809472961',
'+DATA/NECO/datafile/users.326.809472415',
'+DATA/NECO/datafile/system.369.809472751',
'+DATA/NECO/datafile/system.327.809472579',
'+DATA/NECO/datafile/sysaux.355.809474375',
'+DATA/NECO/datafile/sysaux.354.809474607',
'+DATAGRP/NECO/datafile/tallydata2.271.836786191',
'+DATA/NECO/datafile/users.305.809473127',
'+DATA/NECO/datafile/users.371.809473293',
'+DATA/NECO/datafile/users.353.809473459',
'+DATA/NECO/datafile/users.331.809472961',
'+DATA/NECO/datafile/users.326.809472415',
'+DATA/NECO/datafile/system.369.809472751',
'+DATA/NECO/datafile/system.327.809472579',
'+DATA/NECO/datafile/sysaux.355.809474375',
'+DATA/NECO/datafile/sysaux.354.809474607',
'+DATAGRP/NECO/datafile/tallydata2.286.836787443',
'+DATA/NECO/datafile/tallydata2.363.809467175',
'+DATA/NECO/datafile/tallydata2.350.809470127',
'+DATA/NECO/datafile/tallydata2.315.809462873',
'+DATA/NECO/datafile/tallydata2.365.809467949',
'+DATA/NECO/datafile/tallydata2.311.809442363',
'+DATA/NECO/datafile/tallydata2.352.809469377',
'+DATA/NECO/datafile/tallydata2.290.809465579',
'+DATA/NECO/datafile/tallydata2.336.809476667',
'+DATA/NECO/datafile/tallydata2.281.809453891',
'+DATA/NECO/datafile/tallydata2.363.809467175',
'+DATA/NECO/datafile/tallydata2.350.809470127',
'+DATA/NECO/datafile/tallydata2.315.809462873',
'+DATA/NECO/datafile/tallydata2.365.809467949',
'+DATA/NECO/datafile/tallydata2.311.809442363',
'+DATA/NECO/datafile/tallydata2.352.809469377',
'+DATA/NECO/datafile/tallydata2.290.809465579',
'+DATA/NECO/datafile/tallydata2.336.809476667',
'+DATA/NECO/datafile/tallydata2.281.809453891',
'+DATA/NECO/datafile/tallydata2.272.809372123',
'+DATA/NECO/datafile/tallydata2.293.809466373',
'+DATA/NECO/datafile/tallydata2.356.809473615',
'+DATA/NECO/datafile/tallydata2.303.809454673',
'+DATA/NECO/datafile/tallydata2.287.809474821',
'+DATA/NECO/datafile/tallydata2.288.809468575',
'+DATA/NECO/datafile/tallydata2.338.809477163',
'+DATA/NECO/datafile/tallydata2.282.809416029',
'+DATA/NECO/datafile/tallydata2.351.809406465',
'+DATA/NECO/datafile/tallydata2.272.809372123',
'+DATA/NECO/datafile/tallydata2.293.809466373',
'+DATA/NECO/datafile/tallydata2.356.809473615',
'+DATA/NECO/datafile/tallydata2.303.809454673',
'+DATA/NECO/datafile/tallydata2.287.809474821',
'+DATA/NECO/datafile/tallydata2.288.809468575',
'+DATA/NECO/datafile/tallydata2.338.809477163',
'+DATA/NECO/datafile/tallydata2.282.809416029',
'+DATA/NECO/datafile/tallydata2.351.809406465',
'+DATAGRP/NECO/datafile/tallydata.302.836788737',
'+DATAGRP/NECO/datafile/tallydata.309.836789679',
'+DATA/NECO/datafile/tallydata.372.809392015',
'+DATA/NECO/datafile/tallydata.320.809385291',
'+DATA/NECO/datafile/tallydata.314.809379349',
'+DATA/NECO/datafile/tallydata.372.809392015',
'+DATA/NECO/datafile/tallydata.320.809385291',
'+DATA/NECO/datafile/tallydata.314.809379349',
'+DATA/NECO/datafile/tallydata.341.809377385',
'+DATA/NECO/datafile/tallydata.319.809375471',
'+DATA/NECO/datafile/tallydata.344.809408511',
'+DATA/NECO/datafile/tallydata.313.809446213',
'+DATA/NECO/datafile/tallydata.330.809425719',
'+DATA/NECO/datafile/tallydata.277.809417955',
'+DATA/NECO/datafile/tallydata.312.809447331',
'+DATA/NECO/datafile/tallydata.297.809459681',
'+DATA/NECO/datafile/tallydata.278.809470861',
'+DATA/NECO/datafile/tallydata.298.809410365',
'+DATA/NECO/datafile/tallydata.328.809412213',
'+DATA/NECO/datafile/tallydata.273.809423209',
'+DATA/NECO/datafile/tallydata.361.809387311',
'+DATA/NECO/datafile/tallydata.325.809383291',
'+DATA/NECO/datafile/tallydata.359.809389475',
'+DATA/NECO/datafile/tallydata.300.809394295',
'+DATA/NECO/datafile/tallydata.337.809381313',
'+DATA/NECO/datafile/tallydata.348.809396549',
'+DATA/NECO/datafile/tallydata.306.809428235',
'+DATA/NECO/datafile/tallydata.285.809398871',
'+DATA/NECO/datafile/tallydata.333.809437859',
'+DATA/NECO/datafile/tallydata.346.809448611',
'+DATA/NECO/datafile/tallydata.341.809377385',
'+DATA/NECO/datafile/tallydata.319.809375471',
'+DATA/NECO/datafile/tallydata.344.809408511',
'+DATA/NECO/datafile/tallydata.313.809446213',
'+DATA/NECO/datafile/tallydata.330.809425719',
'+DATA/NECO/datafile/tallydata.277.809417955',
'+DATA/NECO/datafile/tallydata.312.809447331',
'+DATA/NECO/datafile/tallydata.297.809459681',
'+DATA/NECO/datafile/tallydata.278.809470861',
'+DATA/NECO/datafile/tallydata.298.809410365',
'+DATA/NECO/datafile/tallydata.328.809412213',
'+DATA/NECO/datafile/tallydata.273.809423209',
'+DATA/NECO/datafile/tallydata.361.809387311',
'+DATA/NECO/datafile/tallydata.325.809383291',
'+DATA/NECO/datafile/tallydata.359.809389475',
'+DATA/NECO/datafile/tallydata.300.809394295',
'+DATA/NECO/datafile/tallydata.337.809381313',
'+DATA/NECO/datafile/tallydata.348.809396549',
'+DATA/NECO/datafile/tallydata.306.809428235',
'+DATA/NECO/datafile/tallydata.285.809398871',
'+DATA/NECO/datafile/tallydata.333.809437859',
'+DATA/NECO/datafile/tallydata.346.809448611',
'+DATA/NECO/datafile/tallydata.323.809451249',
'+DATA/NECO/datafile/tallydata.347.809400857',
'+DATA/NECO/datafile/tallydata.342.809402791',
'+DATA/NECO/datafile/tallydata.343.809404637',
'+DATA/NECO/datafile/tallydata.275.809414025',
'+DATA/NECO/datafile/tallydata.368.809476303',
'+DATA/NECO/datafile/tallydata.322.809476515',
'+DATAGRP/NECO/datafile/tallyindex.330.836792089',
'+DATA/NECO/datafile/tallydata.323.809451249',
'+DATA/NECO/datafile/tallydata.347.809400857',
'+DATA/NECO/datafile/tallydata.342.809402791',
'+DATA/NECO/datafile/tallydata.343.809404637',
'+DATA/NECO/datafile/tallydata.275.809414025',
'+DATA/NECO/datafile/tallydata.368.809476303',
'+DATA/NECO/datafile/tallydata.322.809476515',
'+DATA/NECO/datafile/tallyindex.283.809457563',
'+DATA/NECO/datafile/tallyindex.316.809443179',
'+DATA/NECO/datafile/tallyindex.284.809455409',
'+DATA/NECO/datafile/tallyindex.276.809456425',
'+DATA/NECO/datafile/tallyindex.310.809436189',
'+DATA/NECO/datafile/tallyindex.335.809427027',
'+DATA/NECO/datafile/tallyindex.274.809429529',
'+DATA/NECO/datafile/tallyindex.292.809373759',
'+DATA/NECO/datafile/tallyindex.362.809432081',
'+DATA/NECO/datafile/tallyindex.366.809443983',
'+DATA/NECO/datafile/tallyindex.329.809424359',
'+DATA/NECO/datafile/tallyindex.286.809421735',
'+DATA/NECO/datafile/tallyindex.299.809458645',
'+DATA/NECO/datafile/tallyindex.360.809449983',
'+DATA/NECO/datafile/tallyindex.308.809441313',
'+DATA/NECO/datafile/tallyindex.279.809460731',
'+DATA/NECO/datafile/tallyindex.345.809419871',
'+DATA/NECO/datafile/tallyindex.280.809430777',
'+DATA/NECO/datafile/tallyindex.283.809457563',
'+DATA/NECO/datafile/tallyindex.316.809443179',
'+DATA/NECO/datafile/tallyindex.284.809455409',
'+DATA/NECO/datafile/tallyindex.276.809456425',
'+DATA/NECO/datafile/tallyindex.310.809436189',
'+DATA/NECO/datafile/tallyindex.335.809427027',
'+DATA/NECO/datafile/tallyindex.274.809429529',
'+DATA/NECO/datafile/tallyindex.292.809373759',
'+DATA/NECO/datafile/tallyindex.362.809432081',
'+DATA/NECO/datafile/tallyindex.366.809443983',
'+DATA/NECO/datafile/tallyindex.329.809424359',
'+DATA/NECO/datafile/tallyindex.286.809421735',
'+DATA/NECO/datafile/tallyindex.299.809458645',
'+DATA/NECO/datafile/tallyindex.360.809449983',
'+DATA/NECO/datafile/tallyindex.308.809441313',
'+DATA/NECO/datafile/tallyindex.279.809460731',
'+DATA/NECO/datafile/tallyindex.345.809419871',
'+DATA/NECO/datafile/tallyindex.370.809452599',
'+DATA/NECO/datafile/tallyindex.296.809444939',
'+DATA/NECO/datafile/tallyindex.370.809452599',
'+DATA/NECO/datafile/tallyindex.296.809444939'
CHARACTER SET AL32UTF8
;

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

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

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


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

Recover database !!!!


Errors in file /u01/app/oracle/admin/tstdb/udump/tstmeddb_ora_14614724.trc:
ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [], [], [], []
Wed Jul 23 09:03:26 EEST 2014
Aborting crash recovery due to error 600
Wed Jul 23 09:03:26 EEST 2014
Errors in file /u01/app/oracle/admin/tstdb/udump/tstdb_ora_14614724.trc:
ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [], [], [], []

QL> startup mount;
ORACLE instance started.

Total System Global Area  935329792 bytes
Fixed Size                  2100784 bytes
Variable Size             578814416 bytes
Database Buffers          348127232 bytes
Redo Buffers                6287360 bytes
Database mounted.
SQL> recover database;
Media recovery complete.
SQL> alter database open;

Database altered.

ORA-19511: Error received from media manager layer, error text: lnm_index_cfx_connect retry failed

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

Starting backup at 19-JUL-2014 09:30:56
current log archived
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=1899 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: NMO v5.0.0.0
sent command to channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: starting archived log backup set
channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=27006 RECID=56462 STAMP=853298699
channel ORA_SBT_TAPE_1: starting piece 1 at 19-JUL-2014 09:31:00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03015: error occurred in stored script thqr20_backup_arch
RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 07/19/2014 09:32:35
ORA-19506: failed to create sequential file, name="thqr20_arch.a4pdp8uk_1_1", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text: lnm_index_cfx_connect retry failed.  See privious error messages. (3:3:11)

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

Check the nsr_client in your rman backup script

ORA-22992: cannot use LOB locators selected from remote tables

PROBLEM:
-----------------
ORA-22992: cannot use LOB locators selected from remote tables



You can insert to a remote table that has LOB column, but can not select that column.

There are two solutions:



SOLUTION 1:
--------------------
create or replace function GETBLOBVIADBLINK
( dblnk in varchar2
  ,tbl  in varchar2
  ,col  in varchar2
  ,rwid in urowid)
return blob
is
  retval blob;
  tmpraw raw(2000);
  tmplen number;
  tmpchk number;
  chksize number;
begin
  --preset vars
  chksize:=2000;
  dbms_lob.createtemporary (retval,true);
  execute immediate 'select dbms_lob.getlength@'||dblnk||' ('||col||') from '||tbl||'@'||dblnk||' where rowid=:rwid' into tmplen using rwid;
 
  -- precalc
  tmpchk:=floor(tmplen/chksize);

  -- applicate frist chunks
  for i in 0 .. tmpchk-1
  loop
    execute immediate 'select dbms_lob.substr@'||dblnk||'('||col||','||chksize||','||((i*chksize)+1)||') from '||tbl||'@'||dblnk||' where rowid=:rwid' into tmpraw using rwid;
    dbms_lob.append(retval,tmpraw);
  end loop;
 
  -- applicate last entry
  if (tmplen-(tmpchk*chksize)) > 0 then
    execute immediate 'select dbms_lob.substr@'||dblnk||'('||col||','||(tmplen-(tmpchk*chksize))||','||((tmpchk*chksize)+1)||') from '||tbl||'@'||dblnk||' where rowid=:rwid' into tmpraw using rwid;
    dbms_lob.append(retval,tmpraw);
  end if;
  return retval;
end;
/


CREATE OR REPLACE FORCE VIEW TESTVW1 (ID, MYLOB) AS
SELECT id
       ,getblobviadblink('ARCHIV','MYLOBTABLE','MYLOB',rowid) MYLOB
FROM  MYLOB@archiv;



SOLUTION 2
------------------
create global temporary table tmplob (tmplob blob) ON COMMIT PRESERVE ROWS;
create or replace function getblobviadblink2
( dblnk in varchar2
  ,tbl  in varchar2
  ,col  in varchar2
  ,rwid in urowid)
return blob
is
  PRAGMA AUTONOMOUS_TRANSACTION;
  retval blob;
begin

  execute immediate 'insert /*+ NOLOGGING */ into tmplob select '||col||' from '||tbl||'@'||dblnk||' where rowid=:rwid' using rwid;
  select tmplob into retval from tmplob;
  delete /*+ NOLOGGING */ from tmplob;
  commit;
  return retval;
end;
/

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

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


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



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

You have to drop UNDO tablespace then recreate it.


SQL>create pfile='/tmp/pfile' from spfile;

SQL> startup restrict pfile='/tmp/pfile';
ORACLE instance started.

Total System Global Area 1970864128 bytes
Fixed Size                  2183896 bytes
Variable Size            1543507240 bytes
Database Buffers          419430400 bytes
Redo Buffers                5742592 bytes
Database mounted.
Database opened.
SQL> select tablespace_name, status, segment_name from dba_rollback_segs where status != 'OFFLINE';

TABLESPACE_NAME                STATUS           SEGMENT_NAME
------------------------------ ---------------- ------------------------------
SYSTEM                         ONLINE           SYSTEM

SQL> select tablespace_name, status, segment_name from dba_rollback_segs
  2  ;

TABLESPACE_NAME                STATUS           SEGMENT_NAME
------------------------------ ---------------- ------------------------------
SYSTEM                         ONLINE           SYSTEM
UNDOTBS02                      OFFLINE          _SYSSMU27_3348079370$
UNDOTBS02                      OFFLINE          _SYSSMU26_2631850070$
UNDOTBS02                      OFFLINE          _SYSSMU25_2645117195$
UNDOTBS02                      OFFLINE          _SYSSMU24_1824861410$
UNDOTBS02                      OFFLINE          _SYSSMU23_1673528659$
UNDOTBS02                      OFFLINE          _SYSSMU22_999122355$
UNDOTBS02                      OFFLINE          _SYSSMU21_1258748744$
UNDOTBS02                      OFFLINE          _SYSSMU20_858158107$
UNDOTBS02                      OFFLINE          _SYSSMU19_3999658247$
UNDOTBS02                      OFFLINE          _SYSSMU18_2525182416$

11 rows selected.

SQL> create undo tablespace UNDOTBS1 datafile '/u02/oradata/NECODB1/NECODB1/undotbs01.dbf' size 2000M;(You created new undo tablespace)

Tablespace created.

SQL> drop tablespace UNDOTBS2  including contents and datafiles;(you have to drop old undo tablespace)

Tablespace dropped.




SQL> shu immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.

Total System Global Area 1970864128 bytes
Fixed Size                  2183896 bytes
Variable Size            1543507240 bytes
Database Buffers          419430400 bytes
Redo Buffers                5742592 bytes
SQL> shu abort;
ORACLE instance shut down.
SQL> create spfile from pfile='/tmp/pfile';

File created.

SQL> startup
ORACLE instance started.

Total System Global Area 1970864128 bytes
Fixed Size                  2183896 bytes
Variable Size            1543507240 bytes
Database Buffers          419430400 bytes
Redo Buffers                5742592 bytes
Database mounted.
Database opened.
SQL> shu abort;
ORACLE instance shut down.
SQL> startuo

SQL> startup mount;
ORACLE instance started.

Total System Global Area 1970864128 bytes
Fixed Size                  2183896 bytes
Variable Size            1543507240 bytes
Database Buffers          419430400 bytes
Redo Buffers                5742592 bytes
Database mounted.
SQL> alter system set undo_tablespace = 'UNDOTBS1 ' scope=spfile;

System altered.

SQL> alter database open;

Database altered.




Reference:
-----------
Step by step to resolve ORA-600 4194 4193 4197 on database crash (Doc ID 1428786.1)

ORA-00245: control file backup failed; target is likely on a local file system

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

executing command: SET COMMAND ID
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03015: error occurred in stored script cdtprod_backup_arch
RMAN-03002: failure of set command at 08/24/2014 21:38:42
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 08/24/2014 21:38:42
ORA-00245: control file backup failed; target is likely on a local file system





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

The controlfile is shared on RAC database and having the backup from anyone node to the shared mountpoint would meet the requirement.

configure snapshot controlfile name to '/<shared location>/snapcf_NEPRO0.f';


The reason for the error is clear ORA-00245 - in a RAC environment the location of the Snapshot Controlfile must be on a shared location.


Example:
-------

before
-------
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_NEPRO1.f'; # default


after:
-------

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA/NEPRO/snapcf_NEPRO1.f'; # default

Database Sysdate Isn't Increasing

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

If you have difference current_timestamp with sysdate My database sysdate is not working,not increasing.Sysdate doesn't change.


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

Check the parameter fixed_date.If you see any value,you have to reset parameter.


SQL>show parameter fixed_date

SQL>ALTER SYSTEM SET FIXED_DATE=NONE;




If the parameter also 'NONE'.

Check the timezone!!!!!

WHY ARE MY ORACLE JOBS NOT RUNNING

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

check the job_queue_process parameter,may be "0"

Then set the parameter

alter system set job_queue_processes=200;

This parameter dynamic,you don't need to restart the database

ORA-27206: requested file not found in media management catalog

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


RMAN-03002: failure of backup plus archivelog command at 06/05/2014 17:37:10

RMAN-03009: failure of backup command on ORA_SBT_TAPE_10 channel at 06/05/2014 15:33:00
ORA-19513: failed to identify sequential file
ORA-27206: requested file not found in media management catalog

Recovery Manager complete.


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


Full backup and archive backup started same time

Start again the full backup,it will finish successfully :)

ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist SVR4 Error:2:No such file directory

PROBLEM:
----------------
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
SVR4 Error:2:No such file directory


SOLUTION:
------------------
There is two probability:

1)The database is down

2)The listener has been restarted in another home

ora-20000 oru-10027 buffer overflow

Problem:
------------

ora-20000 oru-10027 buffer overflow


Solution:
------------
There is two solutions:

1. If you are working in SQL*PLUS prompt, type the following where

SET SERVEROUTPUT ON SIZE n

where n is an integer between 2,000 and 1,000,000.

SQL> SET SERVEROUTPUT ON SIZE 10000


2. If you are working in PL/SQL block type

DBMS_OUTPUT.ENABLE(n)

where n is an integer between 2,000 and 1,000,000.

DBMS_OUTPUT.ENABLE(10000);

WARNING OGG-01931 Oracle GoldenGate Manager for Oracle, mgr.prm: Datastore 'dirbdb' cannot be opened. Error 2 (No such file or directory)

Problem:
-----------

WARNING OGG-01931  Oracle GoldenGate Manager for Oracle, mgr.prm:  Datastore 'dirbdb' cannot be opened. Error 2 (No such file or directory)

Solution:
-----------

This is bug,Workaround is below.



#########################################################
WORK AROUND
-----------
cd $OGG_HOME

rm -rf dirbdp

ggsci>stop mgr

ggsci>create datastore

ggsci> start mgr
#########################################################






Reference:
--------------
How To Fix OGG-01934 Datastore repair failed, OGG-01931Datastore 'dirbdb' cannot be opened. Error 2 (No such file or directory) Errors when OGG Is Installed On Shared Disk? (Doc ID 1670885.1)

TNS:listener could not find available handler with matching protocol stack

Problem:
-----------
TNS:listener could not find available handler with matching protocol stack


Solution:
-----------
Your current process is max procecess.

You have to kill some session.

After you kill,sessions continue coming.If this case happen,

You can kill LOCAL=NO via awk.

After this issue completed.

bash$>ps -ef | grep LOCAL=NO | awk '{print "kill -9 " $2}' > kill.ksh

bash$>ksh kill.ksh

When you are available,you have to increase max processes parameter

SQL>alter system set processes=3000 scope=spfile;

Then you have to restart the database.Because this parameter is static.

Note:In my case processes parameter is 1500,so I should set bigger than 1500.

Pry and try :)

Probe job had unrecoverable failure(s), this job is being abandoned.

Problem:
-----------

Probe job had unrecoverable failure(s), this job is being abandoned.

Solution:
-----------

Sometimes if backup cartridge is busy this error will generate

In fact backup hasn't been started yet:)

Try again,it gets successfully:)

ORA-19706: invalid SCN

Problem:
-----------

select 1 from dual@NECODB;

ORA-19706: invalid SCN dblink

Solution:
-----------
alter system set "_external_scn_rejection_threshold_hours" = 24 scope=spfile;

Then restart the database.

ORA-01595: error freeing extent (3) of rollback segment

Problem:
------------

SMON: following errors trapped and ignored:
ORA-01595: error freeing extent (3) of rollback segment (198))
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [12], [2], [], [], [], [


Solution:
-----------
Adding more undo space should solve the problem.


Following link explain add undo tablespace:
-------------------------------------------

http://dbafix.blogspot.com.tr/2010/08/how-to-drop-and-recreate-undo.html

ORA-21561: OID generation failed

Problem:
-----------

ORA-21561: OID generation failed


Solution:
-----------


Check that there is client machine fully qualified name and short name in the client machine hosts file. If these are missing you’ll get ORA-21561 errors when trying to connect server.

old           /etc/hosts   file
-------------------------
127.0.0.1            localhost.localdomain      localhost

new           /etc/hosts   file
-------------------------

127.0.0.1            localhost.localdomain      localhost
10.160.116.10   dbachannel.oracle.com     dbachannel-----this line added

sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

Problem:
-----------


./sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory



Solution:
-----------


vi .bash_profile

export LD_LIBRARY_PATH=$ORACLE_HOME/lib

save and quit.

Then relogin

Problem will solve.

ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE

Problem:
----------


ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE

Solution:
--------


Your syntax is incorrect

Correct syntax is:


alter system set log_archive_dest_1='location=PATH' scope=SPFILE

ORA-39095: Dump file space has been exhausted : Unable to allocate 8192 bytes

Problem:
------------


ORA-39095: Dump file space has been exhausted: Unable to allocate 8192 bytes


Solution:
------------



1. Decrease your parallel number

Or:

2. Don't use PARALLEL clause.

LRM-00108: invalid positional parameter value 'sysdba'

Problem:
-----------

LRM-00108: invalid positional parameter value 'sysdba'


Solution:
-----------

You have to use below syntax:


expdp \'/ as sysdba\' 


example:


expdp \'/ as sysdba\' DIRECTORY= EXPDP_DIR DUMPFILE=NECO.dmp LOGFILE=expdpNECO.log schemas=NECO exclude=STATISTICS content=ALL parallel=8

ld.so.1: sqlplus: fatal: libsqlplus.so: open failed: No such file or directory

Problem:
--------

ld.so.1: sqlplus: fatal: libsqlplus.so: open failed: No such file or directory


Solution:
---------

Add following line in your .profile.

########################################
   
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
     
#########################################