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.
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)))’
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 »Auditing is the monitoring and collection of some user database actions and record these data in some tables. Auditing is always enabled. Oracle Database generates audit records during or after the execution phase of the audited SQL statements. But AUD$ table will growth and will impact the performance of database.
The AUD$ table is used for the database auditing purpose suc as:
CREATE SESSION,
LOGON, LOGOFF,
SELECT, INSERT, DELETE
When AUDIT_TRAIL is set to either DB or DB_EXTENDED value. From 11g forwards AUDIT_TRAIL is activated by default and it is set to DB.
We need to maintain AUD$. So let us see how we can achieve this. Here is the step by step actions
Yazının devamını oku »As you know both option must be use by Oracle licenses. Before we start we need to clarify some information.
Oracle Standard Edition or Standard Edition xx; there are no management packs. These can be purchased only with the Enterprise Edition, and they are also not a part of the Oracle Personal Edition. As i said before you need to license those option separately
Yazının devamını oku »I love to join some event if i had free time. One of my friend invited me to join their session to talk about What data is become important, what we do as a dba in future, what oracle do for future etc.
Yazının devamını oku »You may need to enable or disable EM express on 12c. Do not forget you still can use cent browser for java related screens
Here is the steps and controls
Yazının devamını oku »
Helios's Blog 