People and Culture Blog

EBS–12.1.1 Installation.

EBS Installation 12.1.1   Step- Edit  Yum.repository  and keep ol6_latest and ol6_addon  ebabled=1 cd /etc/yum.repos.d yum install wget.x86_64 wget http://public-yum.oracle.com/public-yum-ol6.repo vi public-yum-ol6.repo ([ol6_latest] name=Oracle Linux $releasever Latest ($basearch) baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL6/latest/$basearch/ gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6 gpgcheck=1 enabled=1 [ol6_addons] name=Oracle…

Read More

EBS UPGRADE –12.1.1 TO 12.1.3 —

[applmgr@ebs applmgr]$ sqlplus apps/apps—connect to applmgr and apps/apps SQL*Plus: Release 10.1.0.5.0 – Production on Tue Mar 31 22:35:56 2020 Copyright (c) 1982, 2005, Oracle.  All rights reserved. Connected to: Oracle Database…

Read More

Upgrade excel4wands apps from 5 to 21.1

Follow these steps to perform an upgrade. 1. Confirm that both the Excel4apps and Excel4apps Reports Wand applications have been registered on you system. a. Log on to the Oracle…

Read More

Up-grading 12c to 19c

Steps For Upgrading Oracle Database To 19c Using DBUA Database  preinstall 19c 19c software install Pre-upgrade check Run the pre-upgrade fixup script Run utlrp.sql ( to compile invalid objects) Check database component status To enable restore , in case…

Read More

Kill inactive apex sessions in amazon RDS

set serveroutput on; begin for i in ( select sid, serial# from gv$session where status=’INACTIVE’ and type=’USER’ and program=’APEX Listener’ and last_call_et/60 > 5) loop dbms_output.put_line(‘begin’); dbms_output.put_line(‘rdsadmin.rdsadmin_util.kill(‘); dbms_output.put_line(‘sid =>’||i.sid||’,’); dbms_output.put_line(‘serial…

Read More

CLOUD EBS INSTALLTION

CLOUD EBS INSTALLTION   login as: opc Authenticating with public key “rsa-key-………” from agent Last login: Thu Jan  07:59:41 2020 from 103.57……129  [root@document ~]# df -h Filesystem Size Used Avail…

Read More

Query to find to Soft Parse and Hard Parse Ratio

select ‘Soft Parses ‘ “Ratio” ,round( ((select sum(value) from v$sysstat where name = ‘parse count (total)’) – (select sum(value) from v$sysstat where name = ‘parse count (hard)’)) /(select sum(value) from…

Read More

Autoconfig Error: adgentns.pl exiting with status 2 after Clone/Refresh Error: adgentns.pl exiting with status 2

Autoconfig Error: adgentns.pl exiting with status 2 after Clone/Refresh Error: adgentns.pl exiting with status 2 /u01/apps/apps_st/appl/ad/12.0.0/bin/adgentns.pl 2 No of scripts failed in CVM phase: 1 AutoConfig is exiting with status…

Read More

OPMNCTL startall Fails with “unexpected exit: status 4200”

While trying to start the opmnctl services in idm we are getting 4200 error code as below applmgr@*****:~ $ applmgr@*****:~ $ /*****/fmw/idm/instances/IDM_inst1/bin/opmnctl startall opmnctl startall: starting opmn and all managed…

Read More

Life At Doyensys – Uday Kumar Koneti

Employees are the backbone of an organisation. With the right people, a company can not only achieve its goals but also surpass them. We want to thank our employees and…

Read More