-
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
-
Oracle 23c? What happened 20c&22c
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 Continue reading
-
Oracle Autonomous Database When&Why?
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… Continue reading
-
How to clean up older records in AUD$ table
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… Continue reading
-
How to Disable Oracle Diagnostic Pack&Tuning Pack in Oracle Database
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… Continue reading
-
We talked about Data&Database and Data usage in Future
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. Continue reading
-
How to enable or disable EM express 12c
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 Continue reading
-
Move All table&index etc. to another tablespace by using script
You can find related script by below Enjoy!! Continue reading
-
How To Move All Schema Objects to a Different Tablespace
You may need to move some objects to another tablespace or you may need to move all objects to one new tablespace under schema I will share some sql statement to achieve this purpose. Here is the steps: Continue reading
-
How To Mount Cd-rom in OEL Linux
These days, CDs and DVDs are not popular. However, you still may need to use CD drive to able to insert a disc and mount it on Linux for your needs. In this post we will do it step by steps. Here are the our steps: Continue reading
AWARDED TOP 60 ORACLE BLOGS SINCE 2018
Recent Posts
- Most Common Oracle Wait Events
- Oracle Multitenant architecture at 26ai
- ORA-01555 vs ORA-01628
- RMAN in Oracle 19c vs 26ai — What Changed??
- Oracle AI Database 26ai — The Features That Will Change How You Build Applications?
CATEGORIES
- Cloud Computing Tutorials
- My Presentations
- Oracle Cloud Journey
- Oracle Database&EBS General
- Oracle E-Business Suite Release 11
- Oracle E-Business Suite Release 12
- Scripts for Oracle E-Business Suite
- Some other Oracle Products Installation
- Step by Step Oracle E-Business Suite Installation
- Video Tutorials
HELIOS BLOG 