How to resolve ORA-00904: invalid identifier

Last updated on August 8th, 2018 at 05:24 amORA-00904: invalid identifier is one of the common error seen. You might get creating tables, selecting from tables and many more. It most happens because of the syntax issue. We have to be very careful with the syntax. The key is to remember syntax and write the code  correctly. You might want to check the Sql tutorials … Continue reading How to resolve ORA-00904: invalid identifier »

Awesome sed command in Linux/Unix with examples

sed command in unix example

Last updated on July 26th, 2018 at 05:33 pmIntroduction to sed command in Unix/Linux sed – Stream EDitor – works as a filter processing  input line by line. Sed reads one line at a time, chops off the terminating newline, puts what is left into the pattern space (buffer) where the sed script can process it (often using regular expressions), then if there anything to … Continue reading Awesome sed command in Linux/Unix with examples »

How to use Oracle SQL*Plus

Here in this post,I would be giving introduction to Oracle sqlplus  which is Oracle tools to connect to database  and how to download Oracle sqlplus Oracle SQL*Plus What is Oracle Sql*plus: 1) SQLPlus, widely used by DBAs and developers, is a powerful and straightforward tool from Oracle to interact with the database. 2) SQLPlus has its own formatting commands to make your queries look better, … Continue reading How to use Oracle SQL*Plus »

Useful Unix/Linux command for Oracle DBA

Last updated on June 21st, 2018 at 07:03 am Oracle DBA need to operate on Unix/Linux/Solaris/AIX Operating system. He has to locate various file, process, kill session ,clear directories, schedule cron and various other activities. Here in this article I am trying to give some Useful Unix command for Oracle DBA  to help them in day-to-day activities.These same commands are applicable for Linux also. Hope you … Continue reading Useful Unix/Linux command for Oracle DBA »

21 awk command examples in Unix/Linux

Last updated on July 26th, 2018 at 05:17 pmAwk is a powerful Linux command for processing text. Administrator & developer  often need to look for the pattern in the files and then process that text as per there requirement. Awk command comes quite handy for these types of task. It is very helpful for processing table i.e (rows and column) type of data in the … Continue reading 21 awk command examples in Unix/Linux »

how to write sql queries

Last updated on June 21st, 2018 at 05:59 pm 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 ,deptTables in the database contain zero to many rows. SQL which stands for “Structured Query Language” which is pronounced as “SQL” or “sequel … Continue reading how to write sql queries »

ORA-00257: archiver error. Connect internal only, until freed.

Last updated on July 13th, 2018 at 09:38 amORA-00257 is one of the commonest error in Oracle DBA life. He/She often has to deal with it.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 means ORA-00257: … Continue reading ORA-00257: archiver error. Connect internal only, until freed. »

How to resolve ORA-06512 at line num

Last updated on July 26th, 2018 at 09:31 amDescription of ORA-06512 ORA-06512  is one of the common error seen in PLSQL programs. Here is what documentation says about this error Reference :Oracle documentation Explanation of the ORA-06512 error: Error Ora-06512 means the backtrace message as the stack is being unwound by unhandled exceptions in your PLSQL code. This is a catch-all error for All PLSQL … Continue reading How to resolve ORA-06512 at line num »

Oracle Real Application Clusters( Oracle RAC)

Last updated on July 26th, 2018 at 08:04 am 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 … Continue reading Oracle Real Application Clusters( Oracle RAC) »

ORA-00911: invalid character Common Issues and Resolution

Last updated on July 26th, 2018 at 09:33 amAs 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 other contexts, … Continue reading ORA-00911: invalid character Common Issues and Resolution »