
Talip Hakan Ozturk's ORACLE BLOG
824 FOLLOWERS
I have fully dedicated to Oracle Database technologies like RAC, Data Guard, RMAN, ASM, Grid Control, Performance Tuning, and Security. I like to learn new technologies and teach others. I have presented at several University and Oracle user Group seminar and have an active Oracle blog to share knowledge and experiences. Blog by Talip Hakan Ozturk's.
Talip Hakan Ozturk's ORACLE BLOG
1M ago
Talip Hakan Ozturk's ORACLE BLOG
2M ago
Hello, A few days ago, something happened to me. Our database suddenly crashed and when I tried to open it, I saw that my redo log file had crashed. If database is not able to start after failed crash automatic recovery with error you will receive ORA-00333: redo log read error block xxxx count xxxx ..read more
Talip Hakan Ozturk's ORACLE BLOG
4M ago
Talip Hakan Ozturk's ORACLE BLOG
5M ago
Hello, In this blog post, I want to write about cloning an Oracle home. Cloning an Oracle home involves creating a copy of the Oracle home and then configuring it for a new environment. If you are performing multiple Oracle Database installations, then you may want to use cloning to create each Oracle home, because ..read more
Talip Hakan Ozturk's ORACLE BLOG
10M ago
Hello, Oracle Database 23ai is available in the cloud and as Free Developer Edition as of now. You can watch the announcement of Larry Ellison together with Juan Loiza EVP about Oracle’s Strategy for Data Management in 23ai. https://youtu.be/4yobT4rtmeo “Oracle Database 23ai is a game changer for enterprises worldwide, and because of the importance of ..read more
Talip Hakan Ozturk's ORACLE BLOG
11M ago
Date :25 April 2024 Address: ORACLE Ankara Office312 Vista Eskişehir Yolu 2176.Cadde No:9/7 Söğütözü Çankaya 06530 Ankara Agenda: 13:00 – 13:30 The Success Story of OCM and Oracle Certificates- Talip Hakan Öztürk, OCM, Oracle ACE Pro 13:30 – 14:00 Oracle Database 23c: 10 New Magic Features – Sevay Yılmaz, Database Operations Manager 14:00 ..read more
Talip Hakan Ozturk's ORACLE BLOG
11M ago
Hello, In this blog post, I want to demonstrate the concept of bind peeking. Firstly, Bind peeking was introduced in Oracle 9i. The query optimizer peeks at the values of userdefined bind variables on the first invocation of a cursor. This feature allows the optimizer to determine the selectivity of any WHERE clause condition. Up ..read more
Talip Hakan Ozturk's ORACLE BLOG
11M ago
Hello, RMAN Duplicate Failing with TDE “ORA-28365: wallet is not” open error. archived log file name=/u01/app/oracle/product/19.0.0/dbhome_1/dbs/arch2_1897_1160948353.dbf thread=2 sequence=0RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of recover command at 03/28/2024 11:12:41ORA-00283: recovery session canceled due to errorsRMAN-11003: failure during parse/execution of SQL statement: alter database recover lo ..read more
Talip Hakan Ozturk's ORACLE BLOG
11M ago
Hello, SYSAUX Tablespace grows rapidly and consumes more space. Querying V$SYSAUX_OCCUPANTS shows SM/ADVISOR on top. SQL> SET LINES 120SQL> COL OCCUPANT_NAME FORMAT A30SQL> SELECT OCCUPANT_NAME,SPACE_USAGE_KBYTES FROM V$SYSAUX_OCCUPANTS ORDER BY SPACE_USAGE_KBYTES DESC; And further querying DBA_SEGMENTS shows WRI$_ADV_OBJECTS consume more space in SYSAUX. SQL> COL SEGMENT_NAME FORMAT A30SQL> COL OWNER FORMAT A10SQL> COL TABLESPACE_NAME FORMAT A10SQL> ..read more
Talip Hakan Ozturk's ORACLE BLOG
11M ago
Hello, In this blog post, I will describe ORA-04023 error when you query a view as below. SQL> Select * from abone.ABONE_BILGILERI_VW; Select against a view fails with following error. ORA-04023: could not be validated or authorized When I check the referenced objects, all were valid in database.This is issue is due to a timestamp ..read more