Oracle Hata Kodları
-
ORA-08180: no snapshot found based on specified time
Oracle veri tabanında ” AS OF TIMESTAMP ” ile bir tabloda değişenleri görmek istiyorum fakat veri tabanı ” ORA-08180: no snapshot…
Read More » -
ORA-04036: PGA Memory Used By The Instance Exceeds PGA_AGGREGATE_LIMIT
Geçtiğimiz günlerde veri tabanı üzerinde bir upgrade işlemi gerçekleştirdik. Enteresan bir şekilde upgrade sonrası düzgün olarak çalışan bir süreç hatalı…
Read More » -
ORA-01665: control file is not a standby control file
Today , After restoring standby database from RMAN backup, got below error 🙁 What is Solution ? Firstly , I…
Read More » -
ORA-01555:Snapshot too old rollback segment number
ORA-01555: snapshot too old: rollback segment number string with name “string” too small. Cause: Rollback records needed by a reader…
Read More » -
ORA-01000: Maximum Open Cursors Exceeded
SELECT Max(a.value) AS highest_open_cur, p.value AS max_open_cur FROM v$sesstat a, v$statname b, v$parameter p WHERE a.statistic# = b.statistic# AND b.name…
Read More » -
ORA-00020: Maximum Number Of Processes Exceeded
When i tried to connect to database, i got the ORA-00020: maximum number of processes (%s) exceeded error. Even from…
Read More » -
ORA-24247: Network Access Denied By Access Control List (ACL)
ERROR :While sending mail using utl_mail or utl_stmp in oracle 11g, you may get access denied error: begin utl_mail.send(sender =>…
Read More » -
ORA-39358: Export Dump File Version Not Compatible
ERROR :While importing dump file, got error as ORA-39358: Export dump file version 12.2.0.1.0 not compatible with target version 11.2.0.4.0…
Read More » -
ORA-39095: Dump File Space Has Been Exhausted: Unable To Allocate
ERROR :While running data pump with filesize parameter, got below error $ expdp dumpfile=DBABUZER.dmp logfile=DBABUZER.log directory=DP_DIR filesize=500m full=y Starting "SYS"."SYS_EXPORT_FULL_01":…
Read More » -
ORA-28017: The Password File Is In The Legacy Format
PROBLEM:While granting sysdba privilege to an user, got below error. SQL> grant sysdba to ABUZER; * ERROR at line 1:…
Read More »