What is SQL? Relational Database Management system(RDBMS) contains many tables . These tables are the basic storage in Database. Tables contains the information about something in the real world for example customers ,employees ,dept Tables in the database contain zero to many rows. SQL which stands for “Structured Query Language” which is pronounced as “SQL” …
how to write sql queries Read More »
ORA-00257 is one of the commonest error in Oracle DBA life. He/She often has to deal with it.Oracle Database almost got frozen because of it and all transaction get stopped .Let us see how to deal with ORA-00257 error Error Message ORA-00257: archiver error. Connect internal only, until freed. As per The oerr ORA-00257 error …
ORA-00257: archiver error. Connect internal only, until freed. Read More »
ora-06512 is one of the common errors in PLSQL.In this post, we will see how do I fix ora-06512 error Description in Oracle database ORA-06512 in Oracle is one of the common errors seen in PLSQL programs in the Oracle database Here is what Oracle documentation says about this error Reference: Oracle documentation on 6512 …
In this article I will talk about Oracle RAC (Oracle Real application clusters) ORACLE RAC CONCEPTS AND FUNCTIONAL OVERVIEW RAC is the ability to have two or more instances connect to the same database. These instances reside on separate servers, thereby allowing each instance to make full use of the processing ability of each server. …
As per OERR,ORA-00911: invalid character Cause: identifiers may not start with any ASCII character other than letters and numbers. $#_ are also allowed after the first character. Identifiers enclosed by double quotes may contain any character other than a double quote. Alternative quotes (q’#…#’) cannot use spaces, tabs, or carriage returns as delimiters. For all …
ASM Disks The first task in building the ASM infrastructure is to discover and associate (adding) Oracle ASM disks under Oracle ASM management. This step is best done with the coordination of Storage and Systems administrators. The Storage administrator will identify a set of disks and create the appropriate LUNs from the storage array and …
