Let’s meet at Yalova University Simurg’24 Seminar!
Talip Hakan Ozturk's ORACLE BLOG
by taliphakanozturk
1M ago
..read more
Visit website
ORA-00333: redo log read error block 5869 count 275
Talip Hakan Ozturk's ORACLE BLOG
by taliphakanozturk
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
Visit website
Let’s meet at Sakarya University Oracle Career Seminar!
Talip Hakan Ozturk's ORACLE BLOG
by taliphakanozturk
4M ago
..read more
Visit website
How to Clone an Oracle Database Home?
Talip Hakan Ozturk's ORACLE BLOG
by taliphakanozturk
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
Visit website
Oracle Database 23ai is Available in the Cloud and as Free Developer Edition
Talip Hakan Ozturk's ORACLE BLOG
by taliphakanozturk
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
Visit website
Let’s meet at TROUG Ankara ORACLE Day!
Talip Hakan Ozturk's ORACLE BLOG
by taliphakanozturk
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
Visit website
Adaptive Cursor Sharing & Bind peeking in Oracle
Talip Hakan Ozturk's ORACLE BLOG
by taliphakanozturk
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
Visit website
RMAN Duplicate Failing with Transparent Data Encryption
Talip Hakan Ozturk's ORACLE BLOG
by taliphakanozturk
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
Visit website
How To Clean SYSAUX Tablespace? Purging data from WRI$_ADV_OBJECTS
Talip Hakan Ozturk's ORACLE BLOG
by taliphakanozturk
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
Visit website
Ora-04023 Reported while Accessing Valid Objects
Talip Hakan Ozturk's ORACLE BLOG
by taliphakanozturk
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
Visit website

Follow Talip Hakan Ozturk's ORACLE BLOG on FeedSpot

Continue with Google
Continue with Apple
OR