Techgoeasy

Here are the 4 Top and most common  OPATCH issues in Windows server Issue 1 OPatch cannot find a valid oraInst.loc file to locate Central Inventory. OPatch failed with error code = 104 Cause On UNIX-based systems, OPatch uses an oraInst.loc file to determine the location of the central inventory. On Windows, this is done by a registry entry instead: the key is Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\inst_loc. On … Continue reading Top and most common OPATCH issues in Windows server »

We often come across the error ORA-28000 the account is locked. Reasons This can happen due to multiple reasons a. DBA has purposely locked the account alter user <username> account lock; select status from dba_users where username=’&1′; b. Wrong password has been attempted many times resulting in locking. The number of FAILED_LOGIN_ATTEMPTS  can be found using the below query select profile from dba_users where username=’&1′; … Continue reading How to solve ORA-28000 the account is locked »

Recently I encountered a oracle table which has 50 column and I need to analyze the each column for the particular row. It was tough viewing those 50 columns in the rows, So I created below PLSQL block to convert the rows into column. This takes table name as the input and print one rows in column format set serveroutput on declare colname varchar2(100); sql_str … Continue reading How to converts rows into column in a table »

Last updated on March 9th, 2019 at 04:07 amWe can use RMAN to backup all the parts of the oracle database. RMAN backup command can be used backs up Oracle database files, copies of database files, archived logs, or backup sets. Here is the general syntax for RMAN backup command Syntax: BACKUP FULL Options BACKUP FULL AS (COPY | BACKUPSET) Options BACKUP INCREMENTAL LEVEL [=] … Continue reading RMAN Backup commands »

RMAN List backup is a useful command to list the backup taken in the system.It shows all the details about the backup taken,what time it was taken, location of the backup. LIST BACKUP List all the backup taken in the system RMAN> LIST BACKUP; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ——- —- — ———- ———– … Continue reading RMAN List backup commands »

All the below scripts are present in $AD_TOP/sql ADZDDBCC.sql This sql is for database compliance checker, shows violations of the database object development standards described later in this document. Warning: this script takes a long time to run. Usage sqlplus apps/<appspass> @$AD_TOP/sql/ADZDDBCC.sql ADZDSHOWED.sql This sql show database editions and current edition. Usage sqlplus apps/<appspass> @$AD_TOP/sql/ADZDSHOWED.sql Edition Name Type Status Current? ————— ——– ——– ——– ORA$BASE … Continue reading Useful Oracle provided sql scripts 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 »

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 »

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 »

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 »

SSH key pairs  can be used for secure login to Linux server with out prompting for password. Puttygen  is a very useful key generator which can be used to generate key pairs for login to Linux node on cloud or on premise using putty utility. It uses the private key in ppk format to login to Linux node About SSH Key pair SSH Key pair … Continue reading How to Use Puttygen on Windows for key generation »

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 »