25 Ağustos 2014 Pazartesi
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
Kaydol:
Kayıtlar (Atom)