Category Archives: Oracle

ORACLE TUTORIALS

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

  1. Oracle database
  2. Oracle sql/plsql
  3. Oracle application
  4. Weblogic
  5. Performance tuning.

These articles will be  really help in understanding the oracle products and getting started on Oracle system

How to use Putty for SSH

Putty is wonderful client to connect to Linux or Unix server easily. It has the option to connect using both telnet or ssh protocol. It has option of RAW ,serial ,RLogin also It is available for Windows 95, 98, XP, Vista,7 ,10 and It can downloaded from below link Download Putty here How to Setup Putty Client on Windows 1.Download consist of putty.exe executable. Save … Continue reading How to use Putty for SSH »

How to resolve ORA-29285: file write error

ORA-29285: file write error is one of the error which may get while doing file handling operation in oracle database   Reason and Resolutions for ORA-29285 File system where you are writing the file is full df -h /u500 /u500  100 0 declare fileHandler UTL_FILE.FILE_TYPE; begin fileHandler := UTL_FILE.FOPEN(‘/u500’, ‘tech’, ‘W’); UTL_FILE.PUT_LINE(fileHandler, ‘This is the file for test’); UTL_FILE.FCLOSE(fileHandler); end; / DECLARE * ERROR at … Continue reading How to resolve ORA-29285: file write error »

How to Solve ORA-29280: invalid directory path

ORA-29280: invalid directory path  is a common error when doing file handling operation in Oracle database Reason and Resolution for the error 1.This occur if the directory specified does not exists in utl_file_dir init.ora parameter sqlplus / as sysdba show parameter utl_file_dir /tmp, /usr/tmp/ SQL> declare F_LOG utl_file.file_type; begin F_LOG := utl_file.fopen(‘/u500′,’j’, ‘w’); end; / 2 3 4 5 6 declare * ERROR at line … Continue reading How to Solve ORA-29280: invalid directory path »

How to solve ORA-29283 : invalid file operation

ORA-29283 : invalid file operation is quite a common error. It happens mostly because of the two reasons The directory and file should have appropriate  permission at the OS level for the same user which started the Oracle database For example The directory does not exists on OS ls  /u555/app/oracle No such file or directory SQL> declare F_LOG utl_file.file_type; begin F_LOG := utl_file.fopen(‘/u555/app/oracle’,’k’, ‘w’); end; / … Continue reading How to solve ORA-29283 : invalid file operation »

Queries to check locks in oracle database

Below query to check locks in oracle database ( Single Instance) SELECT inst_id,DECODE(request,0,’Holder: ‘,’Waiter: ‘)||sid sess, id1, id2, lmode, request, type FROM V$LOCK WHERE (id1, id2, type) IN (SELECT id1, id2, type FROM V$LOCK WHERE request>0) ORDER BY id1, request ;   In case of RAC,below query is used check locks in oracle database SELECT inst_id,DECODE(request,0,’Holder: ‘,’Waiter: ‘)||sid sess, id1, id2, lmode, request, type FROM … Continue reading Queries to check locks in oracle database »

How to apply the technology patches to EBS R12.2

We already know the general practice to apply application patches to R12.2 through online patching Adop(Ad online patching utility) explained R12.2 R12.2 Online patching cycle Summary Let’s explore the steps on how to apply database patches , weblogic patches , 10.1.2 patches , web-tier patches  to the R12.2 tech stack. We can apply the same online patching cycle for the below technology patches a. Weblogic … Continue reading How to apply the technology patches to EBS R12.2 »

Cross Join in Oracle

A CROSS JOIN  in Oracle is a JOIN operation that produces the Cartesian product of two tables. i,e if one of the table is having 100 rows and another one 8 rows, then cross join will produce 800 rows Here table emp has 14 rows and second table as 1 rows,so total 14 rows are returned. we can create another example table check this So … Continue reading Cross Join in Oracle »

self join in oracle with examples

A self join is a join of table to  itself.. We can use the table multiple times .Each occurrence should have an alias name.Oracle database while executing the query join the table with itself and produce the result General  syntax select a.col1 ,b.col2  from mytable a,mytable b where <join condition> ; Some Self Join Example 1) Presentation of Hierarchical data We have a employee table … Continue reading self join in oracle with examples »

oracle join syntax examples

There are various joins in Oracle like inner join,left outer join,right outer join,full outer join,cross join. I will be giving oracle join syntax on each of them with example Inner Join syntax and Example Two tables examples and syntax SELECT EMP.EMPNO,EMP.ENAME, DEPT.DEPTNO,DEPT.DNAME FROM EMP , DEPT where EMP. DEPTNO= DEPT. DEPTNO; or ANSI syntax SELECT EMP.EMPNO,EMP.ENAME, DEPT.DEPTNO,DEPT.DNAME FROM EMP INNER JOIN DEPT on  EMP. DEPTNO= DEPT. DEPTNO; … Continue reading oracle join syntax examples »

How to create ,List and unzip Tar.gz file in Linux

The GNU tar command included with Linux distributions has integrated compression(.gz) .It can create a .tar archive and then compress it with gzip or bzip2 compression in a single command.  The resulting file is a .tar.gz file or .tar.bz2 file. we will learn about how to create ,List and unzip Tar.gz file in Linux How to create the tar.gz file It uses the extra letter z to … Continue reading How to create ,List and unzip Tar.gz file in Linux »