creating local repository yum install linux

Follow the below procedure

[root@ebs-app-xx-xx u01]# yum repolist

[root@ebs-app-xx-xx u01]# yum list installed | grep createrepo

createrepo.noarch                         0.9.9-28.el7             @anaconda/7.5

[root@ebs-app-xx-xx u01]# createrepo /u01/Packages/


[root@ebs-app-xx-xx u01]# cd /etc/yum.repos.d

[root@ebs-app-xx-xx yum.repos.d]# ls -tlr

total 4

-rw-r–r–. 1 root root 358 Nov  4 22:55 redhat.repo

Now, create custom repository

[root@ebs-app-xx-xx yum.repos.d]# cat custom.repo


name=Custom Repository





you can check how (more...)

Remove this file if there is no X server

Try to start VNC, you may get the below error


[root@fusiondev ~]# vncserver

Warning: is taken because of /tmp/.X1-lock
Remove this file if there is no X server

New ‘ (root)’ desktop is

Starting applications specified in /root/.vnc/xstartup
Log file is /root/.vnc/


Solution :

[root@fusiondev tmp]# rm -rf /tmp/.X1-lock

[root@fusiondev tmp]# rm -rf /tmp/.X11-unix/X1


REST API Record Type Example

Goal :

Multi data insert into table of EBS 12.1 or 12.2 Enviornment

Follow the procedure :

Steps 1:

Create a package using with record type


/* $Header: xxace_ap_restapi$ */
* This custom PL/SQL package can be used to load AP Invoices from restapi test.
* @rep:scope public
* @rep:product AP
* @rep:displayname AP Invoice Interface for restapi test

Master Note for Handling Oracle Database Corruption Issues

Very useful document


Master Note for Handling Oracle Database Corruption Issues (Doc ID 1088018.1)

Enable SOA Log for EBS 12.1 and 12.2

EBS 12.1


Add the lines



Bounce the

and then log file will generate $INST_TOP/soa/SOALog.log


EBS 12.2 :

How to Generate File ISGLog.log for SOAP Services in Release 12.2.X? (Doc ID 2008707.1)

Please be note, you need to see the logfile when the transaction are incoming to server




Database Security Assessment Tool

The Oracle Database Security Assessment Tool (DBSAT) analyzes database configurations, users, their entitlements, security policies and identifies where sensitive data resides to uncover security risks and improve the security posture of Oracle Databases within your organization.

You can use DBSAT report findings to:

  • Fix immediate short-term risks
  • Implement a comprehensive security strategy
  • Support your regulatory compliance program
  • Promote security best practices


Oracle Database Security Assessment Tool (DBSAT) (Doc ID 2138254.1)

Installation and test



Oracle is pleased to announce the availability of Oracle E-Business Suite 2018 innovations, which include Oracle E-Business Suite 12.2.8 and other 2018 updates delivered prior to 12.2.8

Refer  :,objectId:22957


ons port connection refused

When I try to open forms, I am getting the below issue


FRM-92102: A network error has occurred.
The Forms Client has attempted to reestablish its connection to the Server 1 time(s) without success.
Please check the network connection and try again later.

Java Exception:


So I checked the logfile in opmn.log, it shows

” [ons-connect] Connection e5e,,6265 connect (Connection refused) ‘

[appluat@ebsuat (more...) undefined reference to `__stack_chk_fail@GLIBC_2.4′

When we try to rebuild the forms or reports, you may get the below issues

“[appluat@ebsuat lib]$ make -f install
rm -f /u01/EBSUAT/apps/tech_st/10.1.2/lib//; \
rm -f /u01/EBSUAT/apps/tech_st/10.1.2/lib//
rm -f rwsutil.o rwspid.o ; \
/usr/bin/ar x /u01/EBSUAT/apps/tech_st/10.1.2/lib//librwu.a rwsutil.o rwspid.o ; \
(LD_OPTIONS=”-z muldefs”; \
/usr/bin/gcc -m32 -o /u01/EBSUAT/apps/tech_st/10.1.2/lib// -shared -L/u01/EBSUAT/apps/tech_st/10.1.2/lib/ -L/u01/EBSUAT/apps/tech_st/10.1.2/lib/stubs/ rwsutil.o rwspid. (more...)

OUI to the latest version on EBS 12.1.3

you must required to upgrade OUI to latest version on EBS Version while Deploying JRE native for Windows Client, Here If you need to execute runInstaller like below


./runInstaller -ignoreSysPrereqs -invPtrLoc /u01/EBSUAT/apps/tech_st/10.1.2/oraInst.loc