-
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 » -
ORA-01950: No Privileges On Tablespace ‘USR_ABUZER’
ERROR :While creating a table got ORA-01950: no privileges on tablespace ‘USERS’. SQL> create table ABUZER.SAMPLE_TBL as select * from user_objects;…
Read More » -
ORA-32774: More Than One File Was Specified For Bigfile Tablespace
ERROR :ORA-32774: More Than One File Was Specified For Bigfile Tablespace SAMPLE : SQL> create bigfile tablespace MYBIGTS datafile ‘/oradata/ABUZERDB/bigts01.dbf’…
Read More » -
Oracle Hata Kodları
ORA-12638: credential retrieval failed tips
Soru : ORA-12638: credential retrieval failed tips hatası alıyorum. Cevap : sqlnet.ora içerisinde aşağıdaki değişikliği yapmanız gerekmektedir SQLNET.AUTHENTICATION_SERVICES= (NTS) yerine, …
Read More » -
Oracle Hata Kodları
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
Soru : ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired hatası alıyorum ne yapabilirim ? Cevp :…
Read More »