-
ORA-12012 Error on auto execute of job “SYS”.”ORA$AT_OS_OPT_SY
In Our 18.3 RAC database, I noticed that below error in alertlog file. Errors in file /u01/app/oracle/diag/rdbms/sid/instance1/trace/instance1_j002_11339.trc: ORA-12012: error on auto execute of job “ORACLE_OCM”.”MGMT_CONFIG_JOB_2_1″ ORA-29280: invalid directory path ORA-06512: at “ORACLE_OCM.MGMT_DB_LL_METRICS”, line 2436 ORA-06512: at line 1 Seed database was most likely not created right by package dbms_stats.init_package not being ran. Dbms_stats.init_package creates statistics… Continue reading
-
How to install Oracle Trace File Analyzer (TFA)
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… Continue reading
-
Where is my Spfile&My db use Spfile or Pfile
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 Continue reading
-
ORA-02266&ORA-02298 During Truncate Table
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 Continue reading
-
ORA-00756&ORA-10567 Errors at Standby Database
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… Continue reading
-
How to Enable 12c Enterprise Manager Database Express
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… Continue reading
-
Many Thanks for Attendees
I had session at Oracle Modern Cloud Day at 12 Now 2019 at 15:30 Pm in Turkey. We were talking about Oracle Cloud and Cloud technologies. Many thanks for attendees who joined my presentation. All agenda can be found at Oracle Cloud Day link Continue reading
-
How to use multiple paths during expdp& impdp
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… Continue reading
-
ORA-29548: Java system class reported
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”,… Continue reading
-
Getting ORA-19587&ORA-17500&ORA-2704 and SVR4 Error errors try to taking backup to NFS mount point
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… Continue reading
AWARDED TOP 60 ORACLE BLOGS SINCE 2018
Recent Posts
- Oracle CDB vs Non-CDB: A Future-Ready Database Architecture
- Hot Cloning of a PDB in Oracle Database
- Oracle + Artificial Intelligence = Smarter Database Management
- Understanding UNDO Tablespace in Oracle Database: Importance and Best Practices
- Fortifying Your Cloud: Understanding the OCI Zero Trust Landing Zone
CATEGORIES
- Cloud Computing Tutorials
- My Presentations
- Oracle Cloud Journey
- Oracle Database&EBS General
- Oracle E-Business Suite Release 11
- Oracle E-Business Suite Release 12
- Scripts for Oracle E-Business Suite
- Some other Oracle Products Installation
- Step by Step Oracle E-Business Suite Installation
- Video Tutorials
HELIOS BLOG 