-
ORA-12012: error on auto execute of job “SYS”.”ORA$AT_OS_OPT_SY_**”
I got this error at alertlog on Oracle 18c Database.Complete errors are: There is an error in the Oracle alert log file!\nORA-12012: error on auto execute of job “SYS”.”ORA$AT_OS_OPT_SY_111029″ORA-20001: Statistics Advisor: Invalid task name for the current userORA-06512: at “SYS.DBMS_STATS”, line 49565ORA-06512: at “SYS.DBMS_STATS_ADVISOR”, line 881ORA-06512: at “SYS.DBMS_STATS_INTERNAL”, line 21631ORA-06512: at “SYS.DBMS_STATS_INTERNAL”, line 23763ORA-06512: at… Continue reading
-
Alert Log Shows ‘ORA-12751: cpu time or run time policy violation’ on Oracle 12c
I faced with that error on 12c database. The following error appear in the alert log:ORA-12751: cpu time or run time policy violation MMON consumes more CPU due to the monitoring activity in 12.1.This can happen due to Adaptive Optimization, a new feature in 12c. Continue reading
-
ORA-04030: out of process memory when trying to allocate XXX bytes (kkoutlCreatePh, kkotrb : kkoabr)
I faced with that error on Oracle 11g. The alert log reports next error details: ORA-04030: out of process memory when trying to allocate XXX bytes (kkoutlCreatePh,apppred : kkotbalp) Continue reading
-
ORACLE 19C ENTERPRISE MANAGER DATABASE EXPRESS NOT WORKING!!
One of my customer is running on Oracle 19c. They want to use OEM for can see database usage by OEM. Most of customers are use se Enterprise Manager Database Express for performance monitoring, administrators jobs. If you are not able to access Enterprise Manager , it might be not configured yet or your wallet… Continue reading
-
ORA-00600: internal error code, arguments: [kcidr_io_check_common_6]
I face with that problem on one of my customer’s database. They called me for database not running and can not be up. Customer Db version is 12c and its running on Windows Server. When I try to open database it hit below errors and database instance became crash Continue reading
-
How to find bind variables for specific sql?
As you know bind variables usage is very important for Oracle performance. If application or user do not use bind variables then Oracle start to create execution plan for same sql for different values. Its mean that our database will have high hard parse values and use our system resource will be increase. Those topic… Continue reading
-
How To Use 10046 Trace for Performance issue
As a DBA we face a performance issue on our database. Mostly we hit query performance issues. We need to clarify to know about more details about query. Oracle provides to generate trace files which is called 10046 trace, If you want to generate the Session Tracing you have to follow these steps: Continue reading
-
OPW-00029 Password complexity failed in Oracle 18c
I got this error while I was triying to create a password file on Oracle 18c database, it initially failed by below error: OPW-00029: Password complexity failed for SYS user : Password must contain at least 8 characters. Here is the my orapwd syntax: [oracle@helios dbs]$ orapwd file=orapwcdb password=here_pass entries=5 force=Y Continue reading
-
How to export&import process on container database
In this post we will see how we can use export-import utility when container database involved. In our test case we have PROD and TEST server. Both database version is 19c, operating system is OEL 7.9 A. First steps is preparation for export process on Prod and Test database. Check schema size which will be… Continue reading
AWARDED TOP 60 ORACLE BLOGS SINCE 2018
Recent Posts
- Most Common Oracle Wait Events
- Oracle Multitenant architecture at 26ai
- ORA-01555 vs ORA-01628
- RMAN in Oracle 19c vs 26ai — What Changed??
- Oracle AI Database 26ai — The Features That Will Change How You Build Applications?
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 