Oracle is most widely used Oracle database in the world. It has the capacity to handle large database and high transaction
Here I am presenting the Oracle tutorials on Various Oracle products
These articles will be really help in understanding the oracle products and getting started on Oracle system
This is part of Oracle SQL tutorial and has good examples, explanation on single row functions in Oracle Sql Functions are programs that take zero or more arguments and return a single value. Functions can be single row ,multiple row functions We will be discussing here Single row functions in SQL What is single row …
Single row functions in Oracle sql Read More »
FNDCPASS FNDCPASS is an important utility in the Oracle EBS application and it is located in $FND_TOP/bin. It is used to change passwords for apps schema, oracle EBS schema password, and application user password change. $FNDCPASS FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS FNDCPASS apps/apps 0 Y system/manager ORACLE FNDCPASS apps/apps 0 Y system/manager USER …
Many times Oracle database get hangs due to locks or latching issue and Nobody can login to the system. It becomes critical and And Usually we do shutdown abort to immediately resolve the issue. But it is good to take system state dump/hanganalyze at 1 min interval to analyze the locking or latching issue afterwards …
Hanganalyze ,system state dump,v$wait_chains in Oracle Read More »
RAID stands for Redundant Array of Inexpensive Disks. Managing a large number of individual disk drives can be very difficult since you must balance the database files across all of these disk drives in order to spread out the I/O load. In order to simplify this task, provide for optimal performance, and provide a fault-tolerant …
What is RAID(Redundant Array of Inexpensive Disks) Read More »
ORA-00942 is one of the many errors which Oracle developer ,Oracle DBA often gets. Lets first look at the OERR output Cause: The Oracle table or Oracle view entered does not exist, a synonym that is not allowed here was used, or a view was referenced where a table is required. Existing user tables and views …
How to Solve ORA-00942 table or view does not exist Read More »
Description ORA-00936 : missing expression is one of the common error everybody working in Oracle SQL must have faced some time. This generally happens when you omit important thing in the Sql statement i.e you left out an important chunk of what you were trying to run Reference : Oracle documentation Cause of ORA-00936 : missing expression …
How to resolve the ORA-00936 missing expression Read More »
