Oracle apps adpatch fails
Many times , when applying patch using adpatch in oracle apps, the patch session session gets terminated because of network problems. The best way to continue the patch is to…
Read MoreFind the current patchset levels for products in Oracle Apps
To obtain the current patchset levels for each specific E-Business Suite functional product test the following steps: 1. Log into OAM. (Responsibility System Administrator,”Oracle Applications Manager”, menu “OAM Support Cart”)…
Read MoreQueries Related to Undo in Oracle
To find retention guarantee for undo tablespace select tablespace_name,status,contents,retention from dba_tablespaces where tablespace_name like ‘%UNDO%’; To find Undo Space Availability select a.tablespace_name, SIZEMB, USAGEMB, (SIZEMB – USAGEMB) FREEMB from (select…
Read MoreLocking and Disabling User Accounts in Linux
Locking and Disabling User Accounts in Linux 1. Locking the user account To lock a user account use the command usermod -L or passwd -l. Both the commands adds…
Read MoreSetup a password less SSH Connectivity Quickly on Linux
We can use ssh to connect between servers, but many times it is required to setup a password less connectivity between the servers. We can follow below steps to…
Read MoreRMAN Issues and Solutions – (ORA-00020) and (ORA-00245)
RMAN Issues and Solutions – (ORA-00020) and (ORA-00245) Error-1: RMAN failed to connect target database with ORA-00020: maximum number of processes (150) exceeded Solution: Here, we can see…
Read MoreError in `FNDLIBR’: double free or corruption (out) in Oracle Apps R12.1
Error in `FNDLIBR’: double free or corruption (out) In some concurrent programs, I was seeing the error as FNDLIBR corrupted. Other programs were working fine. This was observed in EBS…
Read MoreSQL Wise CPU Usage
SQL Wise CPU Usage select ss.username, se.SID, VALUE/100 cpu_usage_seconds from v$session ss, v$sesstat se, v$statname sn where se.STATISTIC# = sn.STATISTIC# and NAME like ‘%CPU used by this session%’ and se.SID…
Read MoreASM files db wise
ASM files db wise to see all list of files in db column path format a70 column file_type format a15 select concat(‘+’||gname, sys_connect_by_path(aname, ‘/’)) path, system_created, alias_directory, file_type from (…
Read MoreManually create database 12c -NON CDB
We are going to see about manual database creation on oracle 12c nonCDB When we get the request to create a database on a Linux server. The basic prerequisite we…
Read More