31 Useful adop (AD online patching ) command line for R12.2

Last updated on March 16th, 2019 at 08:21 am Get examples about adop adop -examples Get help about command line option for adop adop -help Typical online patching cycle: source <ebs_root>/EBSapps.env run adop phase=prepare adop phase=apply patches=123456 adop phase=finalize adop phase=cutover source <ebs_root>/EBSapps.env run adop phase=cleanup Run prepare phase adop phase=prepare Run apply phase adop phase=apply patches=12797970 Run Finalize phase adop phase=finalize Run Cutover phase … Continue reading 31 Useful adop (AD online patching ) command line for R12.2 »

How to generate ssh key pair on Unix using ssh-keygen

We can generate ssh key pair on Unix using ssh-keygen utility. This comes under openssh in all Unix flavour Run the ssh-keygen ssh-keygen -b 2048 -t rsa rsa : it is the algorithm for generating the public -private key pair 2048 : it is bit size ssh-keygen -b 2048 -t rsa Generating public/private rsa key pair. Enter file in which to save the key (“your_local_home”/.ssh/id_rsa): Enter passphrase … Continue reading How to generate ssh key pair on Unix using ssh-keygen »

How to create spfile from pfile

Last updated on March 8th, 2019 at 05:43 pmIn this post ,we would checking out various ways to create spfile from pfile in Oracle database. First of all lets check out the  description of both spfile and pfile What is pfile: Pfile is a Traditional plain-text parameter files and it do not let you make persistent changes to parameter values.So any alter system set parameter command … Continue reading How to create spfile from pfile »

How to login to Linux with SSH private key from window client

Last updated on March 8th, 2019 at 06:10 pmIn the previous we learn about how to generate ssh key pair from puttygen. Now we can use that ssh key pair to login to Linux with the putty client First we need to make sure ,the public keys is the copied to the linux box user $home/.ssh/authorized_keys. If you are doing this for cloud instance, cloud … Continue reading How to login to Linux with SSH private key from window client »

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 »

41 Useful SSH Putty commands to help you manage the VPS /Dedicated Server

These are 41 Most Useful SSH Putty commands to help you manage the VPS (Virtual Private server) or Dedicated Server. This should help you in daily work on  the server.  I have included command for all major Linux distribution like Cent-OS ,Ubuntu 1)How to connect to Server using putty Download Putty here a)Provide Hostname or IP address of the VPS or dedicated server b) Choose SSH … Continue reading 41 Useful SSH Putty commands to help you manage the VPS /Dedicated Server »

How to resolve ORA-29285: file write error

Last updated on April 4th, 2019 at 02:04 amORA-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 Unix /Linux 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 … Continue reading How to resolve ORA-29285: file write error »

How to Solve ORA-29280: invalid directory path

Last updated on April 4th, 2019 at 02:04 amORA-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 … Continue reading How to Solve ORA-29280: invalid directory path »

How to solve ORA-29283 : invalid file operation

Last updated on April 4th, 2019 at 02:03 amORA-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 … 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 »