September, 2020

• 17 September

  ORA-00913: too many values

  

  Hi, I got ” ORA-00913: too many values ” error in Oracle.  

  Read More »
• 17 September

  No more data to read from socket | java.sql.sqlexception and java.sql.sqlrecoverableexception

  

  Hi, I got ” No more data to read from socket | java.sql.sqlexception and java.sql.sqlrecoverableexception ” error in Oracle.  

  Read More »
• 16 September

  ORA-00984: Column not Allowed Here

  

  Hi, I got ” ORA-00984: Column not Allowed Here ” error in Oracle.  

  Read More »
• 16 September

  ORA-00947: not enough values

  

  Hi, I got ” ORA-00947: not enough values ” error in Oracle.

  Read More »
• 15 September

  Alter System Flush Buffer Cache in Oracle

  

  Hi, I will explain Alter System Flush Buffer Cache in Oracle in this post.

  Read More »
• 15 September

  Alter System Flush Shared pool in Oracle

  

  I will explain Alter System Flush Shared pool in Oracle in this post.

  Read More »
• 15 September

  ORA-00942: table or view does not exist

  

  Hi, I got ” ORA-00942: table or view does not exist ” error in Oracle.

  Read More »
• 15 September

  PLS-00201: Identifier must be declared

  

  Hi, I got ” PLS-00201: Identifier must be declared ” error in Oracle.

  Read More »
• 15 September

  Fatal NI connect error 12170

  

  Hi, I got ” Fatal NI connect error 12170 ” error in Oracle.

  Read More »
• 14 September

  ORA-46952: standby database format mismatch for password file | Background Media Recovery process shutdown

  

  Hi, I got ” ORA-46952: standby database format mismatch for password file | Background Media Recovery process shutdown ” error in Oracle Dataguard.

  Read More »
• 14 September

  ORA-00904: invalid identifier

  

  Hi, I got ” ORA-00904: invalid identifier ” error in Oracle SQL.

  Read More »
• 14 September

  Error 1033 received logging on to the standby | orapwd and Password file

  

  I got ” Error 1033 received logging on to the standby ” error in Oracle Dataguard.

  Read More »
• 14 September

  ORA-00905: missing keyword

  

  Hi, I got ” ORA-00905: missing keyword ” error in Oracle SQL .

  Read More »
• 14 September

  ORA-00918: column ambiguously defined

  

  Hi, I got ” ORA-00918: column ambiguously defined ” error in Oracle SQL .

  Read More »
• 13 September

  ORA-01722: invalid number

  

  Hi, I got “ORA-01722 invalid number ” error in Oracle SQL .

  Read More »
• 12 September

  ORA-00979: not a GROUP BY expression

  

  Sometimes You can get ” ORA-00979: not a GROUP BY expression ” error.

  Read More »
• 12 September

  ORA-00907: missing right parenthesis

  

  Hi, I got ” ORA-00907: missing right parenthesis ” error in Oracle SQL ( Table create, DML and DDL operations ) .

  Read More »

August, 2020

• 27 August

  How to Add Datafile to Tablespace and Tablespaces Usage , Tablespace Size Check

  

  Hi, I will explain How to Add Datafile a Tablespace and Tablespaces Usage , Size Check in this post.

  Read More »
• 20 August

  ORA-01653: unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM , ORA-02002: error while writing to audit trail , ORA-00604: error occurred at recursive SQL level 1

  

  Hi, I got ” ORA-01653: unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM , ORA-02002: error while writing to audit trail , ORA-00604: error occurred at recursive SQL …

  Read More »
• 17 August

  ORA-48128: opening of a symbolic link is disallowed, ORA-39155: error expanding dump file name,ORA-19505: failed to identify file, ORA-39126: Worker unexpected fatal error in Oracle 19c

  

  Hi, I got ” ORA-48128: opening of a symbolic link is disallowed, ORA-39155: error expanding dump file name,ORA-19505: failed to identify file, ORA-39126: Worker unexpected fatal error ” error during …

  Read More »
• 13 August

  How to Check and Modify Default Attributes of Tables and Indexes Partitions (def_tablespace_name) in Oracle Database

  

  Hi, I will explain How to Check and Modify Default Attributes of Tables and Indexes Partitions in Oracle Database in this post.

  Read More »
• 12 August

  How to Create a New Agent Registration Password on Enterprise Manager Cloud Control 13c | Securing agent… Failed

  

  Hi, I got ” Securing agent… Failed  ” error starting Enterprise Manager Cloud Control 13c agent ( EM Agent ) .

  Read More »
• 11 August

  You (oracle) are not allowed to use this program (crontab) crontab -l crontab -e run because of /etc/cron.allow

  

  Hi, I got ” You (oracle) are not allowed to use this program (crontab) ” error during crontab -l run.

  Read More »
• 4 August

  ORA-01586: database must be mounted EXCLUSIVE and not open for this operation

  

  Hi, I got ” ORA-01586: database must be mounted EXCLUSIVE and not open for this operation ” error during drop database.

  Read More »
• 4 August

  ORA-02327: cannot create index on expression with datatype LOB | Move Lob Objects to New Tablespace using dba_lobs and dba_lob_partitions views

  

  Hi, I got ” ORA-02327: cannot create index on expression with datatype LOB ” error during table or partition moving.

  Read More »