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 »

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:

Yazının devamını oku »

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

Yazının devamını oku »

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.

  1. Check schema size which will be export from primary system

SELECT (Sum(bytes)/1024/1024) AS total_size_MB FROM dba_segments WHERE owner =’X’;

–500 GB

Yazının devamını oku »

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 abandoned

Fri Apr 3 02:00:36 2022
Errors in file //bdump/.trc:
ORA-16198: Timeout incurred on internal channel during remote archival
LGWR: 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)))’

Yazının devamını oku »

As you know Oracle has been chaned release name. In this post we talk about Oracle Realeases.

Before we start let use see current Oracle Database Realeases and Support Timelines

Let us start

Yazının devamını oku »

We started to heard about Oracle Autonomous Database since 2018. Now Autonomous Database concept is being asked me many times during 2021-2022 from our customers.

Today i want to talk about what Oracle Autonomous Database will bring new thing to our life?

Firs is first, What is Autonomous Database? Why we need it? What is the Unique functions? Why we choose it? Let us find out those question’s answers.

Yazının devamını oku »