I faced with that error during expdp&impdp process between 2 databases.
There was no any issue on expdp process. I copied those export files to new server. While I started to impdp command it fails those errors:
ORA-39097: Data Pump job encountered unexpected error -30094
ORA-39065: unexpected master process exception in DISPATCH
ORA-30094: failed to find the time zone data file for version 28 in $ORACLE_HOME/oracore/zoneinfo
It is sometimes necessary to upgrade the time zone file and timestamp with time zone (TSTZ) data in an Oracle database, for instance when you upgrade to a new version of the database or when the rules for Daylight Saving Time (DST) change.
Here is the our steps:
Yazının devamını oku »I faced with that issue on 12c database. Error message detail is:
TNS-00505: Operation timed out
Here is the solution:
To solve this error, follow below steps
I got this error at alertlog on Oracle 18c Database.
Complete errors are:
There is an error in the Oracle alert log file!\n
ORA-12012: error on auto execute of job “SYS”.”ORA$AT_OS_OPT_SY_111029″
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: at “SYS.DBMS_STATS”, line 49565
ORA-06512: at “SYS.DBMS_STATS_ADVISOR”, line 881
ORA-06512: at “SYS.DBMS_STATS_INTERNAL”, line 21631
ORA-06512: at “SYS.DBMS_STATS_INTERNAL”, line 23763
ORA-06512: at “SYS.DBMS_STATS”, line 49553
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.
Yazının devamını oku »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)
Yazının devamını oku »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 file has no permission of 600 or some other errors which located in log files.
PS: In this case related OEM already configured on database side.
Yazının devamını oku »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
Yazının devamını oku »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 one other topic for performance.
Yazının devamını oku »
Helios's Blog 