Hi, Sometimes You can get ” ORA-19566: exceeded limit of 0 corrupt blocks for file error ” during RMAN Backup .
Read More »ORA-ERRORS
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 »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 »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 »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 »ORA-12804: parallel query server appears to have died with ORA-12801: error signaled in parallel query server
Hi, When I run the SQL, I got ” ORA-12804: parallel query server appears to have died with ORA-12801: error signaled in parallel query server ” error.
Read More »Alter session set current_schema for Setting Default Schema from Different Schema in Oracle
I will explain Alter session set current_schema for Switching to a Different Schema in Oracle in this post.
Read More »
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory with SP2-0667: Message file sp1.msb not found | Set Oracle Home SID in Windows and Linux
Hi, Sometimes You can get ” SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory with SP2-0667: Message file sp1<lang>.msb not found ” error.
Read More »PRCD-1229 : An attempt to access configuration of database was rejected because its version 18.0.0.0.0 differs from the program version 11.2.0.4.0. Instead run the program from 18c Home with PRCD-1027 : Failed to retrieve database MSDB
Hi, Sometimes You can get ” PRCD-1229 : An attempt to access configuration of database was rejected because its version 18.0.0.0.0 differs from the program version 11.2.0.4.0. Instead run the …
Read More »DIM-00014: Cannot open the Windows NT Service Control Manager, OPW-00001: Unable to open password-file
Hi, Sometimes You can get ” DIM-00014: Cannot open the Windows NT Service Control Manager, OPW-00001: Unable to open password-file ” error.
Read More »
IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial