Error: Checkpoint not complete, Cannot Allocate New Log Warning Thread 1 cannot allocate new log, sequence 125487 Checkpoint not complete Solution: Checkpoint not complete messages are generated due to the logs are switching so fast that the checkpoint associated with the log switch isn’t complete. You should increase redo log file size and amount to…
Category: Databases
SQL Server 2012 AlwaysOn Availability Groups Insallation and Configuration
Always On Availability Group is a new feature in SQL Server Database with 2012 release. Before this feature, we was using database mirroring feature in SQL Server 2005. But, mirroring has some limitations and weaknesses. and mirroring feature will be disabled near future. AlwaysOn Availability Groups Features Multi or Single Database Failovers Multiple Secondaries Active…
Unknown variable default character set utf8 MySQL 5.5 or MariaDB 5.5
If you get an error like “Unknown variable default character set utf8” MySQL or MariaDB 5.5 in /var/log/mariadb/mariadb.log when I restart MySQL database, you can resolve this problem with change variable name. Error You can look for error /var/log/mariadb/mariadb.log /usr/libexec/mysqld: unknown variable ‘default-character-set=utf8’ Aborting Solution
Keep Table in Buffer Pool Oracle 11g
Oracle provides a feature to keep objects in the Buffer pool. This feature allows you to keep the frequently accessed table in memory itself which will provide the faster access of the table. The object will be kept under the KEEP pool and the purpose of the keep pool is to accommodate / cache the…
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-19700 to ORA-20000
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-19700 to ORA-20000 ORA-19700: device type exceeds maximum length of string Cause: The device type indicated is invalid. Action: Supply a correct device type and retry the allocation. ORA-19701: device name exceeds maximum length of string Cause: The device name indicated is invalid. Action: Supply a correct device name and retry the…
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-19500 to ORA-19700
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-19500 to ORA-19700 ORA-19500: device block size string is invalid Cause: the device block size returned by sequential I/O OSD is invalid Action: If the block size was set by using the PARMS option of the Recovery Manager ALLOCATE CHANNEL command, then the specified block size must be changed. If…
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-19200 to ORA-19400
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-19200 to ORA-19400 ORA-19200: Invalid column specification Cause: All input arguments must be valid columns Action: Specify a valid list of columns ORA-19201: Datatype not supported Cause: The particular datatype is not supported in the XMLGEN operator Action: Specify only supported datatypes as arguments to the XMLGEN operator ORA-19202: Error…
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-19000 to ORA-19200
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-19000 to ORA-19200 ORA-19000: missing RELATIONAL keyword Cause: The keyword RELATIONAL in the work OBJECT RELATIONAL is missing in the XMLTYPE storage clause specification. Action: Supply the RELATIONAL keyword in the storage clause ORA-19001: Invalid storage option specified Cause: An invalid storage option was specified for the XMLType. Action: Supply…
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-18200 to ORA-19000
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-18200 to ORA-19000 ORA-18201: The input MDX string is empty. Cause: The input MDX (MultiDimensional eXpression) string was empty. Action: Correct the input MDX (MultiDimensional eXpression) string. ORA-18202: MDX parser error at line string, column string: string. Cause: The input MDX (MultiDimensional eXpression) query had invalid syntax. Action: Correct the syntax error for…
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-18000 to ORA-18200
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-18000 to ORA-18200 ORA-18000: invalid outline name Cause: The parser detected a missing or invalid outline name Action: n/a ORA-18001: no options specified for ALTER OUTLINE Cause: The parser detected that no clause was specified on the command Our performance tests, which are not typical as they exercise all…