You are currently browsing the category archive for the ‘Oracle Database&EBS General’ category.
In this post I will explain how We can install and use TFA. Oracle Trace File Analyzer (TFA) provides a number of diagnostic tools in a single bundle, making it easy to gather diagnostic information about the Oracle database and clusterware, which in turn helps with problem resolution when dealing with Oracle Support.
In many case Oracle will some output using this tool for your Service Requests.
First We need to download latest TFA version from Metalink. Please follow TFA Collector – TFA with Database Support Tools Bundle (Doc ID 1513912.1)
How we can check Our Dbs is running with spfile or pfile. Here is the some method to can find your file locations etc.
1. By using SqlPlus, Let us check your db started via spfile or pfile
$ sqlplus / as sysdba
Read the rest of this entry »
While you are trying to truncate table you can hit ORA-02266: error.
In this post I am going to make demo and share solution steps.
I assume that We have 2 tables. Test and Test2. Those table have relation between each other.
Let us try to truncate test table first
I faced with that errors our 12c database. With those errors MRP process has been stopped at standby database and GAP started to increased
Complete errors are:
Reading datafile '/xxx/datafile/ts_1.dbf' for corruption at rdba: 0x08d6e9fd (file 35, block 1501693) Reread (file 35, block 1501693) found same corrupt data (logically corrupt) Sat Jan 18 17:43:50 2020 ERROR: ORA-00756 detected lost write of a data block Slave exiting with ORA-756 exception Sat Jan 18 17:43:50 2020 Errors in file /u01/app/oracle/diag/rdbms/sid/sid/trace/sid_pr01_74757.trc: ORA-00756: recovery detected a lost write of a data block ORA-10567: Redo is inconsistent with data block (file# 35, block# 1501693, file offset is 3711934464 bytes) ORA-10564: tablespace TS ORA-01110: data file 35: '/xxx/datafile/ts_1' ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 102109 Sat Jan 18 17:43:50 2020 Recovery Slave PR01 previously exited with exception 756
Start with Oracle Database 12c says, Oracle said goodbye Database Console which came with Oracle 10gR1 Version
10g was used OC4J and 11g was used weblogic. Also We were using emctl/emca commands to manage those systems.
12c brings a new tool called Database Express.
The DB Express runs entirely with pl/sql code within the XDB schema. It’s XDB that leverages its features to enable a web-based console, and it’s embedded by default in the database.
If your export size volume is huge than you may need to split export files instead of a single FS. In this case, We need to use the multiple directories feature of EXPDP or IMPDP utility.
By using this feature, We can create multiple dump files in multiple directories and distribute our logical export to different directories on the operating system.
In my case, my DB version in 11.2.0.4 and my os is Linux 6
So here is the demo:
I faced with that error message our 12c exadata system. Our development team send that error message to dba team.
Complete error message is:
[Error] Execution (1: 1): ORA-29548: Java system class reported: release of classes.bin in the database does not match that of the oracle executable ORA-06512: at “MDSYS.SDO_JAVA_STP”, line 370 ORA-06512: at “MDSYS.SDO_UTIL”, line 3188 ORA-06512: at “MDSYS.SDO_UTIL”, line 321
I faced with that error while I was trying to take rman backup to our new NFS mount point.
The complete error message is:
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of crosscheck command on ORA_DISK_1 channel at 10/04/2019 20:14:34 ORA-19587: error occurred reading 512 bytes at block number 1 ORA-17500: ODM err:KGNFS READ FAIL:Permission denied ORA-27041: unable to open file SVR4 Error: 13: Permission denied Additional information: 7 ORA-17503: ksfdopn:6 Failed to open file /orabackup_nfs/SASKI_dbfull_20191003_8puddo78_1_1.rman ORA-17500: ODM err:KGNFS READ FAIL:Permission denied
I faced that warning message during my restore process from RAC Database with ASM that has been converted or restored to the Standalone Single Instance Non-ASM Database.
I also noticed RMAN is taking significant time than normal restore time.
From the RDBMS alert.log, it is showing continuous following messages.
ASMB started with pid=32, OS id=28124 WARNING: failed to start ASMB (connection failed) state=0x1 sid='' WARNING: ASMB exiting with error Starting background process ASMB
I faced with this error during trying to create second instance I hit below errors:
After investigate issue I have been found below explanation from this link
From link:
