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…
Month: September 2016
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…
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-17500 to ORA-18000
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-17500 to ORA-18000 ORA-17500: ODM err:string Cause: An error returned by ODM library Action: Look at error message and take appropriate action or contact Oracle Support Services for further assistance ORA-17501: logical block size string is invalid Cause: logical block size for oracle files must be a multiple of the physical…
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-16800 to ORA-17000
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-16800 to ORA-17000 ORA-16800: redo transport service for a standby database incorrectly set to ALTERNATE Cause: The redo transport service for a standby database was set to ALTERNATE when no other destination is set to alternate to this destination. Action: Reenable the standby database or the entire configuration…
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-16600 to ORA-16800
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-16600 to ORA-16800 ORA-16600: not connected to target standby database for failover Cause: The failover command failed because the client was not connected to the target standby database. Action: Explicitly connect to the standby database to be failed over to and retry the failover command. ORA-16602: member must…