September, 2020

• 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 »

July, 2020

• 23 July

  ORA-19566: exceeded limit of 0 corrupt blocks for file during RMAN Backup

  

  Hi, Sometimes You can get ” ORA-19566: exceeded limit of 0 corrupt blocks for file  error ” during RMAN Backup .

  Read More »
• 14 July

  ORA-14257: cannot move a partition which is a composite partition | Move Table, Partition, Subpartitions to New Tablespace

  

  Hi, I got ” ORA-14257: cannot move a partition which is a composite partition ” error during table or partition moving.

  Read More »

June, 2020

• 27 June

  failed to start ASMB (connection failed) state=0x1 and WARNING: ASMB exiting with error and Starting background process ASMB

  

  Hi, When I create the new Standby Instance,  I saw” failed to start ASMB (connection failed) state=0x1 and WARNING: ASMB exiting with error and Starting background process ASMB ” lots …

  Read More »
• 25 June

  ORA-27301: OS failure message: No space left on device ORA-27302: failure occurred at: sskgpcreates ORA-27300: OS system dependent operation:semget failed with status: 28 ORA-27154: post/wait create failed

  

  Hi, When I startup the new Oracle Instance,  I got ” ORA-27301: OS failure message: No space left on device ORA-27302: failure occurred at: sskgpcreates ORA-27300: OS system dependent operation:semget …

  Read More »
• 22 June

  ORA-00304: requested INSTANCE_NUMBER is busy due to db_unique_name parameter and Startup Oracle Instance

  

  Hi, When I startup the new Oracle Instance,  I got ” ORA-00304: requested INSTANCE_NUMBER is busy ” error.

  Read More »