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

Yazının devamını oku »

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

Yazının devamını oku »

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

Yazının devamını oku »

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 »

You may need to change your database listener port. In this post we will do it together by following below steps

  1. Log in to the Linux operating system as the oracle user.
  2. Check the current listening status by using below command:
    lsnrctl status LISTENER

PS: On many system default listener name is LISTENER and default listener port is 1521 by default. You can check your listener name by using (ps -ef|grep tns) command

Yazının devamını oku »