Database Support @ dbaspot.com

Oracle WebLogic Achieves World Record Result

by

Published on 06-21-2011 07:32 PM

Categories:

Tools

Oracle Corporation Announced today that its Fusion Middleware 11g Running on Cisco UCS delviered higest performance per core with SPECjEnterprise2010 benchmark beating IBM Websphere.

Speaking on the ocassion, Juan Loaiza, Senior vice president, ...

DBMS OUTPUT

Categories:

Development

DBMS_OUTPUT oracle package enables you to send output messages from various other PL/SQL program units like stored procedures, packages, triggers etc. DBMS_OUTPUT is primarily used for displaying messages or debug information from a PL/SQL ...

ORA-12638 Credential retrieval failed

by

oracle-dba

Published on 04-25-2011 11:37 AM

Categories:

Error

ORA-12638 Credential retrieval failed error is thrown when the authentication service fails to retrieve the required credentials of the user. ORA-12638 is a server side error and the user may not have too much control over resolving this error other ...

Database Monitoring Software

by

oracle-dba

Published on 04-24-2011 10:20 PM

Categories:

Tools

Database administrators are searching for that one tool that will make them productive and hands off of their day to day database management tasks. Oracle, SQL Server and other databases come with their own tool sets but the tools do not completely address ...

ORA-01555 : Snapshot Too Old in Oracle

by

oracle-dba

Published on 07-22-2007 04:23 AM

ORA-01555, Snapshot too old error in oracle indicates that something else other than your current process is creating the issue. Oracle typically creates a read consistent view of the table so that it looks the same at the start and end of a sql ...

ORA-01031 : Insufficient Privileges

by

oracle-dba

Published on 07-22-2007 04:09 AM

ORA-01031 is generated by oracle in most cases when the user lacks privileges to perform the particular operation. In generic cases, ORA-01031 error is thrown when the user is unable to create an object like table, view procedure etc., due to an incorrect ...

ORA-00936-Missing-Expression

by

oracle-dba

Published on 07-15-2007 05:44 AM

ORA-00936, ORA-936 is a generic error indicating a missing expression in the SQL statement that you have just executed. Most probably this error is indicating that you have either missed a , [ comma ] or the from clause or where clause or some ...

ORA-00918 : column ambiguously defined

by

oracle-dba

Published on 10-08-2006 02:28 AM

ORA-00918 also referred to as an ORA 918 is a common issue/error that occurs during the development of queries through joins of multiple tables and other issues listed below. Most of the time an Ora-00918 occurs due to the fact that a column with ...

ORA-00900 invalid SQL statement

by

oracle-dba

Published on 04-16-2006 12:10 AM

ORA-00900 invalid SQL statement

Cause: The statement is not recognized as a valid SQL statement. This error can occur if the Procedural Option is not installed and a SQL statement is issued that requires this option (for example, ...

ORA-12560 : TNS:protocol adapter error occurred

by

oracle-dba

Published on 04-05-2006 09:37 AM

ORA-12560 Oracle error indicates a high level error that may have happened in the oracle sqlnet or net8 transport layer. The actual error should be identified based on the other messages that oracle has displayed along with the ORA-12560 error ...

ORA-00600 : Known Issues and Solutions

by

oracle-dba

Published on 03-31-2006 08:34 AM

Categories:

Error

Oracle ORA-00600 is an issue faced by many oracle database administrators. In this FAQ,we tried to capture some of the known issues that we or our users have faced and reported on. Oracle ORA-00600 is a critical error in the oracle database and oracle ...

ORA-4031: Unable to allocate bytes of shared memory

by

oracle-dba

Published on 02-28-2006 01:56 PM

ORA-4031 is a very common error that many dba's face in their day to day activities. This error can commonly occur due to the SHARED POOL SIZE. This error can be due to an inadquate sizing of the SHARED POOL or due to fragmentation of the shared ...