Oracle Database&EBS General
-
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
-
Redo Transport Services fails with ORA-16198
I got this error message on 19c dataguard production database at alertlog. The primary alert log file showed: LGWR: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (16198)LGWR: Destination LOG_ARCHIVE_DEST_2 network reconnect abandonedFri Apr 3 02:00:36 2022Errors in file //bdump/.trc:ORA-16198: Timeout incurred on internal channel during remote archivalLGWR: Network asynch I/O wait error 16198 log 2 service ‘(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=)(INSTANCE_NAME=)(SERVER=dedicated)))’ Continue reading
HELIOS BLOG 