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

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

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

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

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

Hello, The database has a program which performs a huge sort operation. This may cause the TEMP tablespace to grow and occupy most of the space on the file system. In this example, the report process may run once or twice a year and there is no need to maintain/keep a huge tempfile. The TEMP ..read more

Hello, In 2 node RAC cluster, below command shows the listeners are in INTERMEDIATE status. $crsctl stat res -t You can not query the status of listener also: The problem is caused by another listener defined statically in listener.ora, using the same port and IP is running from the RDBMS ORACLE_HOME, started manually causing the ..read more

Hello, Sometimes, in alert log we are getting below error: ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_43482" ORA-20001: Statistics Advisor: Invalid task name for the current user ORA-06512: at "SYS.DBMS_STATS", line 47207 ORA-06512: at "SYS.DBMS_STATS_ADVISOR", line 882 ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 20059 ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 22201 ORA-06512: at "SYS.DBMS_STATS", line 47197 Issue occurred ..read more

Hello, A redaction policy has been created on the table column that is referred in the the sub query of the failing CTAS (Insert from select) command as below.  insert into <Table name> select * from <Table with Redaction policy>; When you try to CTAS or insert from table ith redaction policy, you will get ORA-28081 error ..read more

Hello, Adding new disks to existing ASM diskgroups (Normal or High Redundancy) on ASM 12.1.0.2 release reports the following error. SQL> alter diskgroup DATA add failgroup FG1 disk ‘/dev/mapper/oracleasm/DATA10’ size 20489M failgroup FG2 disk ‘/dev/mapper/oracleasm/DATA11’ size 20489M; alter diskgroup DATA add failgroup FG1 disk ‘/dev/mapper/oracleasm/DATA10’ size 20489M failgroup FG2 disk ‘/dev/mapper/oracleasm/DATA11’ size 20489M * ERROR ..read more