Hi, I got ” ORA-00918: column ambiguously defined ” error in Oracle SQL .
Read More »ORA-ERRORS
ORA-01722: invalid number
Hi, I got “ORA-01722 invalid number ” error in Oracle SQL .
Read More »ORA-00979: not a GROUP BY expression
Sometimes You can get ” ORA-00979: not a GROUP BY expression ” error.
Read More »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 »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 »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 »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 »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 »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 »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 »
IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial