• Database Support

    Database Monitoring Software 

    by
    oracle-dba
    Published on 04-24-2011 10:20 PM
    Categories:
    1. 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 ...
    Read More Read More

    ORA-12638 Credential retrieval failed 

    by
    oracle-dba
    Published on 04-25-2011 11:37 AM
    Categories:
    1. 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 ...
    Read More Read More

    Oracle Acquires Pillar Data Systems 

    by
    oracle-dba
    Published on 06-30-2011 08:49 PM

    Oracle now has a complete storage offering after it acquired privately-held Storage Area Network (SAN) company Pillar Data Systems on Wednesday. Last year Oracle spent 7.5 billion in aquiring Sun Microsystems and the latest acquisition gives Oracle ...
    Read More Read More

    Oracle WebLogic Achieves World Record Result 

    by
    oracle-dba
    Published on 06-21-2011 07:32 PM
    Categories:
    1. 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, ...
    Read More Read More

    DBMS OUTPUT 

    Categories:
    1. 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 ...
    Read More Read More

    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 ...
    Read More Read More

    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 ...
    Read More Read More

    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 ...
    Read More Read More

    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 ...
    Read More Read More

    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, ...
    Read More Read More

    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 ...

    Read More Read More

    ORA-00600 : Known Issues and Solutions 

    by
    oracle-dba
    Published on 03-31-2006 08:34 AM
    Categories:
    1. 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 ...
    Read More Read More

    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 ...
    Read More Read More